Database query error

hi

I installed the new D7.0.4  and go to "Database tools" to uploaded the old DB i backup frome the D7.0.3 and i get this error in the email:

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` ORDER BY obj.`ID`

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/BxDolTags.php' at line 75.
Called 'db_res' function with erroneous argument #0.


Debug backtrace:

not clear on what you are stating here.

you installed 7.0.4, then you tried to load a backup of your 7.0.3 database?

that most likely is illegal (programmatic for dolphin)

the object would be to have 7.0.3 running, then using the 7.0.4 upgrade patch, upgrade your 7.0.3 version to 7.0.4. it seems you are trying to install 7.0.4, then load your 7.0.3 database. that is simply not going to work out.

this is what i do all the time when new D7 out...

but i will ty your suggestion.

i would say certainly the wrong approach.

the process should be layed out in a readme on the upgrade patch, and i cant imagine the method you are trying, as being one of the steps.

because file structure and database structure are subject to change from release to release, this is the reason for the upgrade patch with instructions. going against that process in most cases will only create situations you would prefer to stay away from.

Well, as you can see from the error message you are checking two fields (obj.`ObjectName` = tgs.`Type`) if they have equal values, but the colaltions are different. Make both utf8_general_ci or utf8_unicode_ci.

absolutely agree!

I have  a php scrip   to convert all database

inser this  on  the  root destination  like  convert.php

<?php

$db = mysql_connect('localhost','database user','Password');

if(!$db) echo "Cannot connect to the database - incorrect details";

mysql_select_db('Databasename'); $result=mysql_query('show tables');

while($tables = mysql_fetch_array($result)) {

foreach ($tables as $key => $value) {

mysql_query("ALTER TABLE $value COLLATE utf8_general_ci");

}}

echo "The collation of your database has been successfully changed!";

?>

Yes it's a good idea, but boonex's team should check each tables and make the same charset in all tables

but  is  realy creasy  to get  the collations error  on the database between utf8_general_ci and  utf8_unicode_ci.

in the forum you  cant finde more than one time   this error

as I know this trouble was fixed in 7.0.4