Database error in vBulletin 3.6.8

[wafa]

 
Invalid SQL:
 
                  SELECT cron.*
                  FROM cron AS cron
                  LEFT JOIN product AS product ON (cron.product = product.productid)
                  WHERE cron.nextrun <= 1204144978 AND cron.active = 1
                        AND (product.productid IS NULL OR product.active = 1)
                  ORDER BY cron.nextrun
                  LIMIT 1;
 
MySQL Error  : Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Date         : Wednesday, February 27th 2008 @ 11:43:02 PM
Script       : http://www.mysite.com/vb/cron.php?&rand=829670
Referrer     : http://www.mysite.com/vb/showthread.php?p=8196
IP Address   : 0.0.0.0
Username     : &#1590;يف
Classname    : vB_Database 

What this mean I got alot on my email like this message

[Jake Bunce]

As the error says, there is an illegal mix of collations in your database. Tip #5 in this thread explains how to set the collations in your database:

http://www.vbulletin.com/forum/showthread.php?t=259250

If you need to change every single collation in the database then I recommend you empty the database and set just the collation of the database itself. Then when you run the installation again all of the new tables should use the new collation of the database.

[wafa]

thanks jake ..

If I do upgrade my vB , won't solve this pro !

cuz I don't know how to deal with database

[Jake Bunce]

An upgrade won't fix it. You have to use phpmyadmin as described in that thread.