[Jdm Ej1 Coupe]

Originally Posted by Jdm Ej1 Coupe

I tried to install this on 3.6.4 and everything was well except I did not have the arcade in the admin cp and when ever anyone on my site tried to use any of the normal links on the navbar of the site they got an error message like this

Database error in vBulletin 3.6.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
Date : Monday, December 3rd 2007 @ 06:45:00 PM
Script : http://www.jdmcoupecouncil.com/forum...ad.php?p=87297
Referrer : http://www.jdmcoupecouncil.com/forum/index.php
IP Address :
Username :
Classname : vB_Database

I had to remove it from the site so it could work like it did before. I would like to install this on my site can anyone tell me what I am doing wrong?
Thanks

can anyone help out with this?

since no one helped me out with this I had to uninstall it!