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_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Monday, January 26th 2009 @ 10:41:48 PM
Error Date : Monday, January 26th 2009 @ 10:41:48 PM
Script : SITE
Referrer : SITE
IP Address : IP
Username :
Classname : vB_Database
MySQL Version : 5.0.67-community-log
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_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Monday, January 26th 2009 @ 10:41:48 PM
Error Date : Monday, January 26th 2009 @ 10:41:48 PM
Script : SITE
Referrer : SITE
IP Address : IP
Username :
Classname : vB_Database
MySQL Version : 5.0.67-community-log
ok so im just doing a upgrade and i ge this error...i look on here, and i see this error all over the place for upgrades to 3.8.0 but there is no clear answer on how to fix this problem. i dont understand what i need to do to upgrade without the error. can someone please explain how to get the upgrade done by fixing this error. i read the the post by steve, but i have no idea what this means...
someone help me out here...first time EVER ive had a problem upgrading any forum with this software, cant believe in 2009 im running into my first vbulletin conflict.
Comment