sql error when i try to post a thread

[VBUsers]

this is the error i get


Database error in vBulletin 3.8.1:

PHP Code:

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.