Upgrade problem [3.7.3 to 3.8.4] stop in step 5

[ayasystems]

Hi! I'm upgrading my forum from 3.7.3 to 3.8.4 In 5 step i get this error:

Database error in vBulletin 3.7.3:

Invalid SQL:

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

MySQL Error : Illegal mix of collations (latin1_spanish_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Thursday, September 10th 2009 @ 09:47:49 AM
Error Date : Thursday, September 10th 2009 @ 09:47:49 AM
Script : http://mydomain.com/install/upgrade_380a2.php?step=5
Referrer : http://mydomain.com/
IP Address : 88.2.244.100
Username :
Classname : vB_Database
MySQL Version : 5.0.81-community

What can i do to fix it?

Thank you very much!!!

[ayasystems]

Hi,

I'm viewing that new tables and fields has been created as latin1_swedish_ci but old field are latin1_spanish_ci.... Help please

[ayasystems]

I can continue with the upgrace process editing manualy afected tables in phpmyadmin panel control so I hope Know why have distint code page in tables. Finally i ended my upgrade process sucesfully


Best regards