[memomemo]

Originally Posted by giovannicosta

How can I fix this error:

Database error in vBulletin 3.6.7:

Invalid SQL:

SELECT t.champion, u.userid FROM vb_tournaments AS t
LEFT JOIN vb_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, May 19th 2007 @ 07:39:21 AM
Script : http://www.computerforumz.org/showthread.php?p=14170
Referrer : http://www.computerforumz.org/index.php
IP Address : 172.159.225.161
Username : giovanni
Classname : vb_database

Open php.ini

Find :

error_reporting = E_ALL & ~E_NOTICE
or
error_reporting = E_ALL & ~E_NOTICE | E_STRICT
or
e.g error_reporting

change :

error_reporting = E_ALL