[PLEASE HELP]SQL error

[fifko]

Hello,


I am currently experiencing this kind of issue:


Database error in vBulletin 3.6.5:

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 (cp1250_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Date : Sunday, March 18th 2007 @ 03:32:17 PM
Script : http://idontgivea++++.eu/forum/showthread.php?p=884#post884
Referrer : http://idontgivea++++.eu/forum/index.php
IP Address : 15.195.185.77
Username : fifko
Classname : vb_database



Can somebody, please, tell me, what to do or how to solve this issue? I am really new to this... thanks.


EDIT: this error occurs when I try to read/write etc. any topic/post... It only happens when this game mode is enabled.

[fifko]

Please... anybody?

I really want to use this hack.

[MrZeropage]

seems to be something about the format in the DB ... no idea, any SQL-specialist here ?

[MrZeropage]

as temporary workaround, disable all postbit-information in the main settings...

[fifko]

Already managed to solve it...

I had to change the formatting of 'tournaments' table from cp1250 to latin1.

[MrZeropage]

what is the SQL-command for that ?

[WildSharky]

this would be nice to know seeing im getting the same thing here to..