Database error when trying to see a thread..

Hello, I installed ibProArcade v2.6.8+, and now when I try to see a thread i get this Database error:

Database error in vBulletin 3.8.0:

Invalid SQL:

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

MySQL Error : Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Tuesday, January 27th 2009 @ 04:29:02 AM
Error Date : Tuesday, January 27th 2009 @ 04:29:02 AM
Script : http:// myforumlink .com/showthread.php?t=540
Referrer : http:// myforumlink .com/index.php
IP Address : xxxxxxxxx
Username : xxxxxxxxxxx
Classname : vB_Database
MySQL Version : 5.0.67-community

I don't know what that means.. it is possible that it can the my forum database collation ? my forum collation is latin1_general_ci ..

Thanks in Advance.

[vbplusme]

Out of curiosity, did you post this on the support site? Seems like they have dealt with this problem in the past and may already have solved it. Just a suggestion. I just saw this thread for example: http://www.vbulletin.com/forum/showthread.php?p=1686859

[Lautaro]

I didn't edit the default collation, so what could be the problem?

- sry for my ignorance, but i don't know too much about mysql / phpmyadmin / databases

[vbplusme]

Coincidentally, I got this same error just today upgrading to 3.8.1. For me, if meant that I had some tables defined as latin1_swedish and some defined as latin1_general.

I actually want my database to suppose UTF8 rather than latin1 as my site serves an international community so I had to dump the database, delete it from my server and recreate it with the default collation I want. In the dump file, I need to do a global search and replace for latin1 and changed it to utf8, then I imported it to the new database and every thing was cleanly defined as UTF8 which is what I want. THEN, the upgrade worked correctly.

So, you can check this out yourself with phpmyadmin. check the collation column in your database. You will find some of them are different from the default.

You probably didn't but some hack you installed may have. this one likely "I installed ibProArcade v2.6.8+," I think the problem can be caused from using different versions of MySQL on multiple servers which is what I did. I moved from a mysql 4.X to a mysql 5.X and the defaults were set differently so when the hack created a new table it got defined with a different collation.

I am not sure you can change individual tables, i.e. dump it, delete it, reimport with the correct collation but you might want to try it.

HTH

[Lautaro]

Hello, look, as i said I don't know how to do this things, if you could show me with images step by step how to do it i would appreciate it a lot. I really want the Arcade fixed in my forum, but I don't want to mess up my database.

thank you.

EDIT:

This is how the tables of my database looks, some are in latin1_swedish_ci and some in latin1_general_ci .. what should i do????

image: ( full database tables displayed here 868 * 4911 px image )
http://www.img.gamezeventos.com/view...phpmyadmin.gif

[Gemma]

<a href="https://vborg.vbsupport.ru/showpost.php?p=1586822&postcount=4" target="_blank">https://vborg.vbsupport.ru/showp...22&postcount=4</a>