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....



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



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