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
Database error in vBulletin 3.7.4:
SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.username)
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 : 22.214.171.124
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
No members have liked this post.