When I try to install this, I get the following error:
Code:
Database error in vBulletin 3.8.2:
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 : Saturday, April 11th 2009 @ 10:08:24 PM
Error Date : Saturday, April 11th 2009 @ 10:08:25 PM
Script : http://www.christianfunforums.com/forums/admincp/plugin.php?do=productimport
Referrer : http://www.christianfunforums.com/forums/admincp/plugin.php?do=productadd
MySQL Version : 5.1.30
Ideas?