Database Error

[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

[MrZeropage]

check your database's collations, one is "general" and one "swedish"

[Nkay]

So how do you ACTUALLY fix it? :S

[foxfirediego]

wondering the same!

[MrZeropage]

badly nobody having such DB-problem and solving it posts the solution here :(

[foxfirediego]

i have changed my collation from swedish to general and solved the problem! :)

[memomemo]

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

[erdiyilmaz]

i'm aLso taking this error : (
__________

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_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Date : Wednesday, September 26th 2007 @ 06:21:58 AM
Script : http://forum.*****.com/showthread.php?t=3785
Referrer :
IP Address : 66.249.72.177
Username : Kayitsiz
Classname : vB_Database

[memomemo]

Kardeş sanırım T?rk?e google ?zerinde ararsan illegal mix diye baya bir forum ?ıkıyor bu sorun ?zerine. Sanırım derdini ??zebilirsin :)

[MortysTW]

Kardeş sanırım T?rk?e google ?zerinde ararsan illegal mix diye baya bir forum ?ıkıyor bu sorun ?zerine. Sanırım derdini ??zebilirsin :)

Was this the solution?

[erdiyilmaz]

Was this the solution?

no no, he said that, i had to search @ googLe, search for "illegal mix"

: (

[MortysTW]

no no, he said that, i had to search @ googLe, search for "illegal mix"

: (

Since you can understand english, have you tried switching everything to ENGLISH mode to see what happens?

That might help with troubleshooting if you can close up a few loose ends of this strange issue.