mysql error with 3.6.8

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 [DATE]1195900486[/DATE] at [TIME]1195900486[/TIME] ---------------

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!