Code:
Database error in vBulletin 3.7.3:
Invalid SQL:
SELECT prefix.*, prefixpermission.usergroupid AS restriction
FROM forumprefixset AS forumprefixset
INNER JOIN prefixset AS prefixset ON (prefixset.prefixsetid = forumprefixset.prefixsetid)
INNER JOIN prefix AS prefix ON (prefix.prefixsetid = prefixset.prefixsetid)
LEFT JOIN prefixpermission AS prefixpermission ON (prefix.prefixid = prefixpermission.prefixid)
WHERE forumprefixset.forumid = 7
ORDER BY prefixset.displayorder, prefix.displayorder;
MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Friday, February 6th 2009 @ 11:31:23 PM
Error Date : Friday, February 6th 2009 @ 11:31:23 PM
Script : ______________________
Referrer : ______________________________
IP Address : 0000000000
Username : Admin
Classname : vB_Database
MySQL Version : 5.0.67-community
show this error if im make new thread
how to fix it please help me