hi guys, i get this Database error to my mail all the time and i do not know waht that meen, any help?
Database error in site
Query:
SELECT obj.*
FROM `sys_objects_categories` obj LEFT JOIN `sys_categories` tgs
ON obj.`ObjectName` = tgs.`Type` WHERE `tgs`.`Owner` != 0 AND tgs.`Status` = 'active' AND DATE(`tgs`.`Date`) = DATE('2010-5-1') GROUP BY obj.`ObjectName` ORDER BY obj.`ID`
Mysql error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
Found error in the file '/home/******/public_html/inc/classes/BxDolTags.php' at line 75.
Called 'db_res' function with erroneous argument #0.
Debug backtrace:
Array
(
[1] => Array
(
[file] => /home/*******/public_html/inc/classes/BxDolDb.php
[line] => 254
[function] => error
[class] => BxDolDb
[type] => ->
[object] => BxDolDb Object
(
[error_checking] => 1
[error_message] => Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
[host] => localhost
[port] =>
[socket] =>
[dbname] =>*************
[user] => *****
[password] => *****
[link] => Resource id #30
[current_res] =>
[current_arr_type] => 1
[oParams] => BxDolParams Object
(
[_oDb] => BxDolDb Object
*RECURSION*
[_oCache] => BxDolCacheFile Object
(
[sPath] => /home/******/public_html/cache/
[_error] =>
)
[_sCacheFile] => sys_options_0b9abf66f9bb9f8f1648d37956733eae.php
[_aParams] => [truncated]
[_error] =>
)
[oDbCacheObject] => BxDolCacheFile Object
(
[sPath] => /home/****5/public_html/cache/
[_error] =>
)
[_error] =>
)
[args] => Array
(
[0] => Database query error
[1] =>
[2] => SELECT obj.*
FROM `sys_objects_categories` obj LEFT JOIN `sys_categories` tgs
ON obj.`ObjectName` = tgs.`Type` WHERE `tgs`.`Owner` != 0 AND tgs.`Status` = 'active' AND DATE(`tgs`.`Date`) = DATE('2010-5-1') GROUP BY obj.`ObjectName` ORDER BY obj.`ID`
)
)
