[Scape-Server]

I get an error whenever you view or post a thread. The thread will still post but (obviously) you cannot view it.

Database error in vBulletin 3.7.0 Beta 2:

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         : Tuesday, December 18th 2007 @ 04:01:03 AM
Script       : http://scape-server.org/showthread.php?p=542
Referrer     : http://scape-server.org/forums.php
IP Address   : 86.129.198.101
Username     : James
Classname    : vB_Database

??

EDIT:

I fixed this! In phpMyAdmin i changed the champion field's collation from latin1_swedish_ci to atin1_general_ci.

You might want to fix this