SQL error browsing posts after install

[JonnyThunder]

Hello,

I'm running VB 4.01 with no mods. When I install the arcade as per instructions, I get the following SQL error when I try to view any thread....

Database error in vBulletin 4.0.1:

Invalid SQL:

SELECT t.champion, u.userid FROM vb_tournaments AS t
LEFT JOIN vb_user AS u ON (t.champion = u.username)
WHERE champion<>'';

MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_german2_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Thursday, February 4th 2010 @ 09:23:20 AM
Error Date : Thursday, February 4th 2010 @ 09:23:20 AM
Classname : vB_Database
MySQL Version : 5.0.85-community

Is anyone else getting this? The only way I can stop it happening is to uninstall the arcade software.

[Digital Jedi]

I'm not too familiar with this kind of error, but see if you can glean anything form this thread. Could be a MySQL issue, or could just be something unique to your installation: http://www.vbulletin.com/forum/showthread.php?124003-Problem-when-searching-FAQs

[JonnyThunder]

Thanks for that - it put me on the right track. For those of you having a similar issue, this was the quickest and easiest way I found to fix the issue.....

1. Log on to your PHPMyAdmin panel and find out what your VB database tables have as their Collation.

2. Go to Operations tab and change the default Collation to match the ones your tables have (from above)

3. UNINSTALL the arcade software

4. REINSTALL the arcade software. This will recreate all the tables with the new default Collation and should fix the problem.

Peace out homeys,

JT