Version: , by Cust0ms
Developer Last Online: Feb 2011
Version: Unknown
Rating:
Released: 07-29-2008
Last Update: Never
Installs: 0
No support by the author.
Hello,
When ibProArcade is enabled I receive database error when I try open any thread:
Code:
Database error in vBulletin 3.7.2:
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 (latin2_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Monday, July 28th 2008 @ 04:44:52 PM
Error Date : Monday, July 28th 2008 @ 04:44:52 PM
Script : http://myboard.nl/showthread.php?p=6577662
Referrer : http://myboard.nl/index.php
IP Address : xx.xx.xx.xx
Username : Kayyn
Classname : vB_Database
MySQL Version : 4.1.10-standard-log
This is really nice mod and I would like to use it... Please, help me. What can I do?
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
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.
I Do It
all character and text tables Are 'latin1_swedish_ci' (url_discut,Champion,creat Tables) And So tournaments .
int Tables Are Not 'latin1_swedish_ci' An I Couldnt Change Them .
When ibProArcade is enabled I receive database error when I try open any thread:
Code:
Database error in vBulletin 3.7.4:
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 : Monday, January 12th 2009 @ 07:22:22 PM
Error Date : Monday, January 12th 2009 @ 07:22:22 PM
Script : http://irantrack.com/Forum/showthread.php?t=8328
Referrer : http://www.irantrack.com/Forum/
IP Address : 91.98.87.165
Username : Hamid.Park
Classname : vB_Database
MySQL Version : 5.0.45-log
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.
That should fix it.
Thank you very very much for the golden instructions.
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.