Cant upgrade from 3.7.4 to 3.8.0 (Database Error at end of Upgrade)

ShadowthaKilla

New Member
hey, ive been trying to upgrade from 3.7.4 to 3.8.0 and at the end of the upgrade process, it ends with a databse error in step 5 in the upgrade system

Database error in vBulletin 3.7.4:

Invalid SQL:

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

MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Saturday, January 17th 2009 @ 12:47:47 PM
Error Date : Saturday, January 17th 2009 @ 12:47:47 PM
Script : http://www.*****.net/forums/install/upgrade_380a2.php?step=5
Referrer : http://www.*****.net/forums/install/upgrade_380a2.php?step=4
IP Address : -----------
Username :
Classname : vB_Database
MySQL Version : 5.0.67-community

and vbulletin docent upgrades, it stays on 3.7.4, help!
 
Back
Top