Upgrade v2.6.7a+ crashes Threads

Originally Posted by MrZeropage

updated to v2.6.7a+ which just included PHP4-compatibility again
nothing else changed, so everybody using PHP5 can keep v2.6.7+

Get this Error after a clean install at every Thread:

Datenbankfehler in vBulletin 3.7.0:

Invalid SQL:

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

MySQL-Fehler : Illegal mix of collations (latin1_german1_ci,IMPLICIT) and (latin1_german2_ci,IMPLICIT) for operation '='
Fehler-Nr. : 1267
Fehler-Zeit : Wednesday, 07.05.2008 @ 19:21:44
Datum : Wednesday, 07.05.2008 @ 19:21:45
Skript : http://www.XXXXX.de/forum/showthread...=12402&page=13
Referrer : http://www.XXXXX.de/forum/
IP-Adresse : 83.135.XXX.XXX
Benutzername : XXXXX
Klassenname : vB_Database_MySQLi
MySQL-Version : 5.0.51

MySQL-Version : 5.0.51 and PHP 5

[redlabour]

Originally Posted by MrZeropage

Do you want me to install it on your forum ?

Then I need AdminCP+FTP access via PM ...


btw: why don't you use support in german on vbGO ?

1. No - the Problem is that i have to close the Forum at this Time and i am very busy at the Moment.

2. No special Reason - using vb.org now for Years.

[MrZeropage]

Ask Andreas @vbGO and he surely has the correct SQL-command to fix this ...

[redlabour]

http://www.vbulletin-germany.org/showthread.php?t=3746

--------------- Added [DATE]1211236884[/DATE] at [TIME]1211236884[/TIME] ---------------

Solution :

ALTER TABLE `vb3_tournaments` CHANGE `champion` `champion` TEXT CHARACTER SET latin1 COLLATE latin1_german2_ci NOT NULL