[Videx]

Done, but I still get an error:

Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT plugin.*,
IF(product.productid IS NULL, 0, 1) AS foundproduct,
IF(plugin.product = 'vbulletin', 1, product.active) AS productactive
FROM plugin AS plugin
LEFT JOIN product AS product ON(product.productid = plugin.product)
WHERE plugin.active = 1
AND plugin.phpcode <> ''
ORDER BY plugin.executionorder ASC;

MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='

Worse, when I checked my inbox a whole slew of cron errors were there, so I've set product.productid back to general:

Invalid SQL:

SELECT cron.*
FROM cron AS cron
LEFT JOIN product AS product ON (cron.product = product.productid)
WHERE cron.nextrun <= 1235509743 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 '='

I wonder if I shouldn't be thinking more in terms of converting this entire db to something? But what? And how?