[Videx]

Over the weekend I changed every single table to latin1_swedish_ci manually. The db is set to latin1_swedish_ci. So why am I still getting the same error?

Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT templateid, searchstrregex, replacestr
FROM templateedit AS templateedit
INNER JOIN templateeditlocation AS templateeditlocation ON (templateeditlocation.varname=templateedit.varname )
INNER JOIN template AS template ON (template.title=templateeditlocation.template)
LEFT JOIN style AS style ON (style.styleid=template.styleid AND FIND_IN_SET(templateedit.templateeditid, style.templateeditlist))
LEFT JOIN product AS product ON (product.productid=templateeditlocation.product)
WHERE (NOT ISNULL(style.styleid) OR (templateedit.styleid=-1 AND template.styleid=-1))
AND (product.active=1 OR templateeditlocation.product='vbulletin')
AND templateedit.active = 1
AND template.title IN ('footer')

ORDER BY searchorder ASC;

MySQL Error : Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Monday, February 23rd 2009 @ 11:01:11 PM
Error Date : Monday, February 23rd 2009 @ 11:01:12 PM
Script : admincp/plugin.php?do=productimport
Referrer : admincp/plugin.php?do=productadd
Classname : vB_Database
MySQL Version : 4.1.22-standard-log