more DB error after new installing D7.0.1

Again the problem with the DB geting error like this:

 

 

 

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' 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 '/home/*****/public_html/inc/classes/BxDolCategories.php' at line 156.

Called 'db_res' function with erroneous argument #0.

 

Quote · 17 May 2010

It would appear that you need to change the databases' collation to something other than what is currently set. I believe the one you want is utf8_general_ci. Anyways, it would seem there's a mixture of the two in your database, which needs to be resolved (and can be via phpMyAdmin).

BoonEx Certified Host: Zarconia.net - Fully Supported Shared and Dedicated for Dolphin
Quote · 17 May 2010

 

It would appear that you need to change the databases' collation to something other than what is currently set. I believe the one you want is utf8_general_ci. Anyways, it would seem there's a mixture of the two in your database, which needs to be resolved (and can be via phpMyAdmin).

 

hi Magnussoft
could you tell me where in the phpMyAdmin i sould go and changeing this?

i'm use in Hebrew lang in my site to.

Thank you

Quote · 17 May 2010

 

It would appear that you need to change the databases' collation to something other than what is currently set. I believe the one you want is utf8_general_ci. Anyways, it would seem there's a mixture of the two in your database, which needs to be resolved (and can be via phpMyAdmin).

 

I solved another problem - oki doki :)

i'm going to be Professional in phpMyAdmin whit all this error LOL.

i just go to phpMyAdmin and sys_categories then i Change it from utf8_unicode_ci to utf8_general_ci and the site up :)

Thank you

Quote · 17 May 2010
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.