Database error in ‏

Hello, Everyone

can some one tell me why im getting this all the time to my email  and how I can this fix

so i don't get no mpre email report about this databased error

-----------------------------------------------------------------------------------------------------------------------------------

Database error in

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-6-15') GROUP BY obj.`ObjectName`

Mysql error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='

Found error in the file '/home1/mydatabased/public_html/mysite/inc/classes/BxDolCategories.php' at line 156.
Called 'db_res' function with erroneous argument #0.


Debug backtrace:

Array
(
[1] => Array
(
[file] => /home1/mydatabased/public_html/mysite/inc/classes/BxDolDb.php
[line] => 236
[function] => error
[class] => BxDolDb
[object] => BxDolDb Object
(
[error_checking] => 1
[host] => localhost
[port] =>
[socket] =>
[dbname] =>Hello_World
[user] => This_is_Secret
[password] => Sorry
[link] => Resource id #30
[current_res] =>
[current_arr_type] => 1
[oParams] => BxDolParams Object
(
[_oDb] => BxDolDb Object
*RECURSION*
[_oCache] => BxDolCacheFile Object
(
[sPath] => /home/mydatabased/public_html/mysite/cache/
[_error] =>
)

---------------------------------------------------------------------------------------------------------------------------------------

Thank's a lot for reading my post and helping me

A shot in the dark would be to look at your categories. Did you happen to add any around the same time this error started, like one called "tgs"?

what is the error here zarcon in lost man

This appears to be a easy one to fix.

There is a mismatch in collation type between those 2 database tables. I don't know how it happend but i can tell you how to fix it.

In phpMyAdmin select  table `sys_objects_categories` then click on operations in the top menu. From there the Collation needs to be set to utf8_general_ci if it is not.

Then do the same thing to table sys_categories.

Both of those tables need to be set to Collation type utf8_general_ci. One of them is not.

Then check the fields in those tables as well. Any that have a Collation set will need to be changed to utf8_general_ci if they are not. Do not set a Collation on any field that does not current have Collation set. Only fix that ones that have the wrong Collation

my Collation say utf8_unicode_ci  >>>> change to utf8_general_ci

later im going to see if this databased error is fix

Thank's guy

Im still getting database error

take a look here

Thats the sys_objects_catagories. Now what about the sys_catagories? Both tables need to be the same.

Also what about the fields in the table?