mysql error with 3.6.8

[unknownkind]

Any help? Anyway to fix this constant error...?


Database error in vBulletin 3.6.8:

Invalid SQL:

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

MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Date : Saturday, November 24th 2007 @ 05:01:52 AM
Referrer :
Username : Unregistered
Classname : vB_Database


--------------- Added 1195900486 at 1195900486 ---------------

Well will a little searching I believe I solved my problem and I hope I can help anyone else who has this same problem.

You need to enter your PhpMyAdmin. Most likely through cpanel.
Then find these sql tables

*_games_cats
*_games_champs
*_games_league
*_games_list
*_games_savedGames
*_games_scores
*_games_session
*_games_settings
*_tournaments
*_tournament_players
*_tournament_players_statut

And change all the collations from latin1_swedish_ci to latin1_general_ci

Hope that helps!