Forum Illegal mix of collations error

[محروم.كوم]

Having tried to upgrade my forum from 3.8.2 to 4.0.3, I encountered an Illegal mix of collations error.

After submitting a support ticket I got an answer that set me on the right track.

Using phpMyAdmin I changed the collation value of database, tables and fields. First to latin1_danish_ci, where I was unable to change 2 fields due to error messages, and then to latin1_swedish_ci. Having changed all I could see to swedish, I was able to proceed with my install, which was stuck on upgrade400a1.php?step=9, for quite a while.

However, on finalupgrade.php?step=5 i encounter a similar error repeatedly, even though I have checked each table 3 or 4 times to se if any field still is set to danish.

This is the most recent error I get:

-----

Database error in vBulletin 4.0.3:


Invalid SQL:

SELECT MIN(nextrun) AS nextrun
FROM tf_cron AS cron

LEFT JOIN tf_product AS product ON (cron.product = product.productid)
WHERE cron.active = 1
AND (product.productid IS NULL OR product.active = 1);

MySQL Error : Illegal mix of collations (latin1_danish_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Thursday, May 13th 2010 @ 1212 AM
Error Date : Thursday, May 13th 2010 @ 1214 AM
Script : [forum URL]/install/finalupgrade.php?step=5
Referrer : [forum URL]/install/finalupgrade.php?step=4&startat=60
IP Address : [IP address]
Username :
Classname : vB_Database_MySQLi
MySQL Version : 5.0.87-community

-----

I still can't find any fields set to latin1_danish_ci anywhere. Is there an SQL query I can use to locate such fields, if extant? __DEFINE_LIKE_SHARE__