error with ib pro arcade ( all )

F

Fanshop

New Member
Hi, i have a sql eror when i installed ib pro arcade ( all versions) :
Code: 
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, February 27th 2008 @ 01:33:00 PM
Script        : http://myweb.info/v4/showthread.php?p=1
Referrer      : http://myweb.info/v4/index.php
IP Address    : my_ip
Username      : username
Classname     : vB_Database

its on vbulletin 3.7 beta 5
The error r when i try write or read a post
some idea what can i do ?
 
go in to phpmyadmin and look for this table: tournaments. I'm not sure what you're prefix is. Assuming vb_tournaments.

Then edit that table. You should see under collation: latin1_general_ci

Using the pulldown to change it, select: latin1_swedish_ci

That'll fix that problem. I had the same problem. I think after you fix that one, you'll have one more to fix and it'll be the same process.
 
You must log in or register to reply here.
Back
Top