vb 4.1.11, TMS installed
got this error while trying to import the product.xml:
****************************************
Database error in vBulletin 4.1.11:
Invalid SQL:
SELECT t1.templateeditid AS templateeditid_1, t1.varname ,
t1.templateeditid AS templateeditid_1, t1.styleid AS styleid_1 ,
t2.templateeditid AS templateeditid_2, t2.styleid AS styleid_2
FROM templateedit AS t1
LEFT JOIN templateedit AS t1 ON (t1.varname=t1.varname AND t1.styleid=-2)
LEFT JOIN templateedit AS t2 ON (t1.varname=t2.varname AND t2.styleid=2)
WHERE t1.styleid = -1;
MySQL Error : Not unique table/alias: 't1'
Error Number : 1066
Request Date : Sunday, March 4th 2012 @ 05:22:15 PM
Error Date : Sunday, March 4th 2012 @ 05:22:15 PM
Script :
http://***/***/admincp/plugin.php?do=productimport
Referrer :
http://***/***/admincp/plugin.php?do=productadd
IP Address : ***
Username : ***
Classname : vB_Database
MySQL Version : 5.5.20
is there a way we can fix it? cause i really like a lot your hack!!