mysql error will pay if you help

[Caos]

ok im got this db problem it shows this...how do i fix it?

Database error in vBulletin 3.8.1:

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
Request Date  : Saturday, April 11th 2009 @ 04:32:58 AM
Error Date    : Saturday, April 11th 2009 @ 04:32:58 AM
Script        : XXXXXX/vb/showthread.php?p=1255
Referrer      : XXXXX/vb/index.php
IP Address    : XXXXXXXXXXXX
Username      : XXXXX
Classname     : vB_Database
MySQL Version : 5.0.67-community

 

[Error 404]

For such a thread name, wont help you

 

[Caos]

oh k well do you know how to fix my problem?

 

[k_hunter]

Try disabling forum tournaments and see if it helps.

 

[Ab.Nath]

Disable Forum Tournaments
Disable ipb Arcade
Repair Database
Optimise and Repair Table

and then see else install a earlier backup

 

[Caos]

sure..isnt nothing to do with the actual database?

 

[Caos]

wait tournemnts...then how do i make them work??

 

[k_hunter]

If you won't get database errors after disabling forum tournaments, then the problem is with that mod, try reinstalling it.

 

[Regati]

As error says - you have a mix of collations (latin1_swedish_ci, latin1_general_ci).
Convert your tables and rows in database all in same collation

 

[bluescorpion]

This is a pretty well know problem. If you go into your phpMyAdmin and check the collation column on your tables, you will see that they are not all the same and they need to be as of 3.8.1.

See Details HERE


1. Open your database in phpmyadmin and scroll down to the 'tournaments' table.
2. Make sure the collation column says 'latin1_swedish_ci' (if it doesn't click the tick box and go to the Operations page, change it to 'latin1_swedish_ci' and save).
3. Open the table so it displays the fields (scroll down the left navigation and click 'tournaments') and make sure all the required collations are 'latin1_swedish_ci'
If any are not 'latin1_swedish_ci' click on the change button and change them accordingly and save.

 

[bluescorpion]

ok im got this db problem it shows this...how do i fix it?

Database error in vBulletin 3.8.1:

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
Request Date  : Saturday, April 11th 2009 @ 04:32:58 AM
Error Date    : Saturday, April 11th 2009 @ 04:32:58 AM
Script        : XXXXXX/vb/showthread.php?p=1255
Referrer      : XXXXX/vb/index.php
IP Address    : XXXXXXXXXXXX
Username      : XXXXX
Classname     : vB_Database
MySQL Version : 5.0.67-community

Did this problem here solved?