sql error when i try to post a thread

[VBUsers]

this is the error i get


Database error in vBulletin 3.8.1:

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 = 17
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 : Wednesday, March 11th 2009 @ 12:39:47 AM
Error Date : Wednesday, March 11th 2009 @ 12:39:47 AM
Script : http://www.*******.com/newthread.php?do=newthread&f=17
Referrer : http://www.*******.net/staff-lounge-f17.html
IP Address : *******
Username : Steve
Classname : vb_database
MySQL Version : 4.1.22-standard

[TigerC10]

http://www.vbulletin.com/forum/showthread.php?t=195137

Basically, you must have used a 3rd party tool to do database maintenance/restoration at some point, because your tables are set to different language character sets. Ultimately you're going to need to make sure that your tables are set to the latin1_general_ci collalation setting. One of them, somewhere (like maybe prefixset) is set to latin1_swedish_ci by mistake.

[VBUsers]

thanks and i appreciate it. i got it fixed.