I am moving my board to a new host and I get this error when I try to upgrade to VB 3.8.
Ive read up on the collation error from others but havn't found a concrete sollution.
Ive read up on the collation error from others but havn't found a concrete sollution.
Database error in vBulletin 3.7.4:
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 (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Friday, February 6th 2009 @ 10:51:54 PM
Error Date : Friday, February 6th 2009 @ 10:51:54 PM
Script :
Referrer :
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.67-community
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 (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Friday, February 6th 2009 @ 10:51:54 PM
Error Date : Friday, February 6th 2009 @ 10:51:54 PM
Script :
Referrer :
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.67-community
Comment