Error while upgrading from 3.7.5 -> 3.8.0

[citrix]

Hey Mates,
I just downloaded the final version of 3.8.0 and started the upgrade. Now when 3.8.0 Alpha 2 is completed I get this error :



Step 5) Upgrade to vBulletin 3.8.0 Alpha 2 Complete!

Database error in vBulletin 3.7.5:

Invalid SQL:

SELECT prefix.*, prefixpermission.usergroupid AS restriction
FROM vb_prefix AS prefix
LEFT JOIN vb_prefixpermission AS prefixpermission ON (prefix.prefixid = prefixpermission.prefixid)
ORDER BY prefix.displayorder;

MySQL Error : Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Thursday, January 8th 2009 @ 02:42:01 PM
Error Date : Thursday, January 8th 2009 @ 02:42:02 PM
Script : http://www.***************.de/install/upgrade_380a2.php?step=5
Referrer : http://www.**************.de/install/upgrade_380a2.php?step=4
IP Address : ------
Username :
Classname : vb_database
MySQL Version : 4.1.22-max-log

[Danial_Faster]

You need to change the tables that are latin1_general_ci to latin1_swedish_ci.

[t047554]

I have the same problem :(

I have change all the table from latin1_general_ci to latin1_swedish_ci but I still have the problem.

What can I do thanks

Rene

[t047554]

Ok I have find the problem ;)
The field prefixid in the table prefixpermission was still in latin1_general_ci :rolleyes: I changed it and it was ok
Regards
Rene