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