I just installed this and I'm getting a lot of SQL errors. Here is the one I get if I try to uninstall TMS:
Code:
Database error in vBulletin 3.7.0:
Invalid SQL:
SELECT templateid, searchstrregex, replacestr
FROM vb3_templateedit AS templateedit
INNER JOIN vb3_templateeditlocation AS templateeditlocation ON (templateeditlocation.varname=templateedit.varname)
INNER JOIN vb3_template AS template ON (template.title=templateeditlocation.template)
LEFT JOIN vb3_style AS style ON (style.styleid=template.styleid AND FIND_IN_SET(templateedit.templateeditid, style.templateeditlist))
LEFT JOIN vb3_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
ORDER BY searchorder ASC;
MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Saturday, May 10th 2008 @ 11:06:14 PM
Error Date : Saturday, May 10th 2008 @ 11:06:14 PM
Script : http://www.tenstones.net/forums/admincp/plugin.php?do=productkill
Referrer : http://www.tenstones.net/forums/admincp/plugin.php?do=productdelete&productid=tms&s=
IP Address : 65.25.2.41
Username : Bob
Classname : vB_Database
MySQL Version : 4.1.22-standard