Getting mysql error

[ExTincTi0N]

Okay when I try to import the tms product I am getting a mysql error.

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_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Tuesday, September 23rd 2008 @ 08:40:09 PM
Error Date : Tuesday, September 23rd 2008 @ 08:40:10 PM
Script : http://artisticslurpee.com/admincp/plugin.php?do=productimport
Referrer : http://artisticslurpee.com/admincp/plugin.php?do=productadd
IP Address : 71.51.108.63
Username : .RevO
Classname : vB_Database
MySQL Version : 5.0.51a-community

Whats the problem?

[calorie]

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

Please see http://www.vbulletin.com/forum/showpost.php?p=1510890&postcount=2

[Marco van Herwaarden]

Actually as this happens during installtion of a modification, you should ask in the modification thread so the author can provide a solution.