Hello every body ,,
I noticed that alot of people had the (Illegal mix of collations) problem ( me too ) ,
so here is the right way to fix it ,,,
# first we have to know which Tables we have to work on it ,, in the message we can see
[ LEFT JOIN product AS product ON (cron.product = product.productid)
WHERE cron.nextrun <= 1154876909 AND cron.active = 1
AND (product.productid IS NULL OR product.active = 1)
ORDER BY cron.nextrun ] ,,,
and change the collations from ( latin1_general_ci ) to ( latin1_swedish_ci )
so we will go to Table Product and i think Table productcode & productdependency & Plugin too (*this an example*),,
then follow the pics
Regards,
Mohamed Ashraf
I noticed that alot of people had the (Illegal mix of collations) problem ( me too ) ,
Code:
Database error in vBulletin 3.6.0:Invalid SQL: SELECT cron.* FROM cron AS cron LEFT JOIN product AS product ON (cron.product = product.productid) WHERE cron.nextrun <= 1154876909 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_swedish_ci,IMPLICIT) and(latin1_general_ci,IMPLICIT) for operation '='Error Number : 1267 Date : Sunday, August 6th 2006 @ 06:08:29 PM Script : [URL="http://xxxxxxxxx/vb/cron.php?&rand=732223"][COLOR=#0000ff]http://xxxxxxxxx/vb/cron.php?&rand=732223[/COLOR][/URL] Referrer : [URL="http://xxxxxxxxx/vb/forumdisplay.php?f=25"][COLOR=#0000ff]http://xxxxxxxxx/vb/forumdisplay.php?f=25[/COLOR][/URL] IP Address : xx.xxx.xxx.xxx Username : Classname : vb_database
# first we have to know which Tables we have to work on it ,, in the message we can see
[ LEFT JOIN product AS product ON (cron.product = product.productid)
WHERE cron.nextrun <= 1154876909 AND cron.active = 1
AND (product.productid IS NULL OR product.active = 1)
ORDER BY cron.nextrun ] ,,,
and change the collations from ( latin1_general_ci ) to ( latin1_swedish_ci )
so we will go to Table Product and i think Table productcode & productdependency & Plugin too (*this an example*),,
then follow the pics
********************************************
********************************************
********************************************
********************************************
But remember this was only an example you have to figure which table you have to change its CollationRegards,
Mohamed Ashraf
Comment