[help]Mysql error

[AThomas]

I installed this and it wont work, when enabled, all i get on site is a mysql error about tournaments, and cant see any posts on site,disabled, and admins can play fine.Saw a post with this error and it said to change language, didnt help,Reinstalled 4 times, same error,Anyone?


Database error in vBulletin 3.6.8:

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
Date : Saturday, February 9th 2008 @ 02:08:28 PM
Script : http://***************/showthread.php?p=18
Referrer : http://****************/index.php?

[MrZeropage]

execute this query:

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

[AThomas]

worked like a charm, thanks for such a fast reply,and the arcade