Register Members List Search Today's Posts Mark Forums Read

 
 
Mod Options
  #1  
Old 21 Nov 2008, 11:35
PNEInvincibles PNEInvincibles is offline
 
Join Date: Oct 2008
Language issue when arcade is active

I have installed the arcade and everything is working fine.

However if I have the plugin active then every time a user tries to navigate the rest of the forum they get an error and I get the database error:

Originally Posted by Error Email View Post
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_german2_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Friday, November 21st 2008 @ 12:26:27 AM
Error Date : Friday, November 21st 2008 @ 12:26:28 AM
Script : http://www.pne-invincibles.co.uk/for...ead.php?t=6995
Referrer : http://www.pne-invincibles.co.uk/for...splay.php?f=43
IP Address : 83.231.209.130
Username : STRPNE
Classname : vb_database
MySQL Version : 5.0.67-log
I have seen it written on the add on thread that it requires a simple change in the tournaments table, but I can not find such a table

Any support would be greatfully recieved so I can turn the arcade back on
 


Similar Mod
Mod Developer Type Replies Last Post
Active users in ibproArcade on top of arcade 2.6.7a+ stangger5 vBulletin 3.7 Add-ons 18 08 Oct 2010 04:38
Users Active in ibproArcade on top of arcade stangger5 vBulletin 3.6 Add-ons 47 11 May 2008 00:54

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 10:25.

Layout Options | Width: Wide Color: