SELECT t.champion, u.userid FROM tournaments

Hello,

I have installed ibProArcade on a newly upgraded 3.7. It seems to work, but when I go to read a thread I get:

Database error in vBulletin 3.7.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  : Monday, May 5th 2008 @ 10:19:08 AM
Error Date    : Monday, May 5th 2008 @ 10:19:08 AM
Script        : xxx
Referrer      : hxxx
IP Address    : my ip
Username      : admin
Classname     : vb_database
MySQL Version : 4.1.22-standard-log

[MrZeropage]

try to run this query:

ALTER TABLE `tournaments` CHANGE `champion` `champion` TEXT CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL

[PET]

I manualy edited them in phpMyAdmin.

[redlabour]

Does not work....now every Thread is blank if Arcade is active.

@PET - use Threadtitles that are useful at the Searchfunction.

[russbo]

OK, how do we fix this now?

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

I've searched everywhere, and just cannot find the answer.

Most of my vbulletin tables are "latin swedish" for some reason. But there are some other tables that are latin general; all the other mods and hacks work except this one.

--------------- Added [DATE]1210414215[/DATE] at [TIME]1210414215[/TIME] ---------------

OK, think I fixed it.

Went into PHPMYADMIN, into the Tournaments table, and made that table, and all the relevant tables within that, "latin-swedish". Not sure if being "swedish" or "general" makes a difference, but it works as long as they're all the same. Couldn't get it to work at first, didn't change the tables within Tournaments.