[Hostboard]

When modifying VB's advertising system the following DB error will occur during the save. Confirmed with Trevor via VB support ticket.

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 vb_templateedit AS t1 
LEFT JOIN vb_templateedit AS t1 ON (t1.varname=t1.varname AND t1.styleid=-2)
LEFT JOIN vb_templateedit AS t2 ON (t1.varname=t2.varname AND t2.styleid=37)
WHERE t1.styleid = -1;

MySQL Error : Not unique table/alias: 't1'
Error Number : 1066
Request Date : Thursday, March 1st 2012 @ 04:33:06 PM
Error Date : Thursday, March 1st 2012 @ 04:33:06 PM
Script : http://www.MyDomain.xxx/forums/admincp/ad.php?do=update
Referrer : http://www.MyDomain.xxx/forums/admin...l_below_navbar
IP Address : xx.xxx.xx.xxx
Username : UserName
Classname : vB_Database_MySQLi
MySQL Version : 5.1.41-3ubuntu12.10