[JonnyThunder]

He means whenever he installs the product (using the XML file)

I get the same thing and have no other modifications installed.

Database error in vBulletin 4.0.1:

Invalid SQL:

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

MySQL Error   : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_german2_ci,IMPLICIT) for operation '='
Error Number  : 1267
Request Date  : Thursday, February 4th 2010 @ 09:23:20 AM
Error Date    : Thursday, February 4th 2010 @ 09:23:20 AM
Classname     : vB_Database
MySQL Version : 5.0.85-community

I started a new thread with this issue, here.