Ok i installed ipbroarcade WITCH I BOUGHT.

Then i install it upload files Then RIGHT when i Upload the xml file i go to a thread and i get this error-

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT t.champion, u.userid FROM forumstournaments AS t
LEFT JOIN forumsuser AS u ON (t.champion = u.username)
WHERE champion<>'';

MySQL Error : Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Username : RPG
Classname : vB_Database_MySQLi

Then when i remove XML file my site works fine? WTF

Help <3

U bought ibproarcade? i was under the impression it was free

__________________

i mean the copyright thing

can i have a link to your forum?

__________________

d2xp.com

plz help me

4 letter domain, not bad

Anyway the issue is you have two different types of collations. Which shouldn't really happen. You need to change the collation of your forumstournaments table.

Run this query after re-installing IBPro:
and it *should* work

hmm k i re-installed it w/o using the mysql query and now al my forum skins images r gone it's like a plain skin now lol.

wow sumhow it deleted my images folder LOL sad

D2XP - Powered by vBulletin works fine for me...

really? lol well im not sure how to run the mysql query.. i ran in in phpmyadmin i only had to this phpmyadmin stuff only couple times im not really famaliar with it

think u can giv me a lil more explanation of were to run that query @?

tHanks sir Rogersnm