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
and vbulletin docent upgrades, it stays on 3.7.4, help!
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!