Error 1267

[Danny-E]

Database error in vBulletin 4.1.10:

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 = 53
ORDER BY prefixset.displayorder, prefix.displayorder;

MySQL Error : Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Tuesday, February 21st 2012 @ 04:32:02 PM
Error Date : Tuesday, February 21st 2012 @ 04:32:02 PM
Script : http://xxxxxxx/newthread.php?do=newthread&f=53
Referrer : http://xxxxxxx/forumdisplay.php?53-Staff-Lounge
IP Address : xxxxx
Username : DannyE
Classname : vB_Database
MySQL Version : 5.0.95

I've upgraded from vBulletin 3 to 4.1.10 and get the following error when trying to create new threads, also when trying to moderate posts/threads. And probably other places too but havent had the chance to check everything yet.


How to I fix this?

Thank you