problem with admin index file

[Ninth Dimension]

Hi. I've just upgraded my forum from 3.5.3 to 3.6.8, it all appears to have worked as it should, but when I log into the admin section, the main panel on the right shows the following error message

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT adminmessage.adminmessageid
FROM vb3_adminmessage AS adminmessage
INNER JOIN vb3_adminlog AS adminlog ON (adminlog.script = adminmessage.script AND adminlog.action = adminmessage.action)
WHERE adminmessage.status = 'undone'
AND adminmessage.script <> ''
AND adminlog.dateline > adminmessage.dateline
GROUP BY adminmessage.adminmessageid;

MySQL Error : Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Date : Saturday, August 18th 2007 @ 11:45:53 AM
Script : http://arathor.net/admincp/index.php?do=home
Referrer : http://arathor.net/admincp/index.php?do=nav
IP Address : 86.134.211.171
Username : Deus
Classname : vb_database

Does anyone have any ideas on how to fix this? Thank you :)

[Dismounted]

It seems that the upgrade has caused the table collations to reset, you should change them back to whichever one you had.

[Ninth Dimension]

I've noticed that most of the tables are set to latin1_general_ci, with a few here and there set to latin1_swedish_ci. Does it matter which they are?

I went into the one set to swedish and set all the fields within it to swedish (they were general before), and it seems to have fixed the problem, but as above, should they all be the same, all across the board?

[Dismounted]

Yes, they should be consistent across the database.

[Ninth Dimension]

Damn... Looks like I've got my work cut out for me changing them all then... I don't supose there is a quick and easy way of doing it automatically is there?

[Marco van Herwaarden]

You can use the attached file to ensure that all collations are the same. Upload to AdminCP and point your browser to the script.

Make sure to have a good backup before changing anything!!!!!

PS The reason you have different collations is probably that you moved servers at some time or upgrade MySQL. vBulletin always creates tables using the default collation as set in MySQL config.