Database error in vBulletin 3.7.3:
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 (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Wednesday, April 22nd 2009 @ 04:04:50 PM
Error Date : Wednesday, April 22nd 2009 @ 04:04:51 PM
Script :
http://ultra-forum.ath.cx/test/admin...=productimport
Referrer :
http://ultra-forum.ath.cx/test/admin...?do=productadd
IP Address : 192.168.1.33
Username : STR1KE
Classname : vB_Database
MySQL Version : 5.0.51b-community-nt