Database error when installed and viewing a thread.

[Whatsoever]

Ok i have installed the IbProArcade now. I am happy that i did it because v3Arcade wasn't that good... I re-installed it and removed v3arcade from my website. But the problem is when i enable the product i get this error in every thread i watch.

Database error in vBulletin 3.6.8:

Invalid SQL:

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

MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Date : Saturday, October 6th 2007 @ 07:06:42 AM
Script : http://whatsoeverforum.com/showthread.php?p=27312
Referrer : http://whatsoeverforum.com/
IP Address : 87.64.129.154
Username : Drake
Classname : vB_Database

Does anyone have any idea what this is and how i can solve it because i want to play on my arcade again... Thanks :)

[Whatsoever]

Anyone? I kinda want to start the arcade. I have seen the problem in the database but don't know what to do to fix it....

[MrZeropage]

Sorry, I don't know, too

any mySQL specialist here ?

[Whatsoever]

Never mind, i got to work anyways. Just had to replace the swedish to general and fixed

[MrZeropage]

how exactly did you do that ?

[Whatsoever]

Well it was pretty simple. I went into phpMyAdmin and went to the locations below:

whatsosvervb_tournaments
whatsosvervb_user

I noticed that in the table tournaments the collations where set to latin1_swedish_ci and in the user table it was latin1_general_ci.

So i just went to the tournaments table again and change the latin1_swedish_ci to latin1_general_ci after i clicked the edit button of the query.

I hope you understand.

Whatsoever