SQL Error messages?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • whitey10tc
    Senior Member
    • Jan 2011
    • 415
    • 4.0.x

    [Forum] SQL Error messages?

    After upgrading from 4.1.7 to 4.1.11 we are receiving this message when saving styles, saving styles order, when saving plugins, pretty much when saving anything.
    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=122)
    WHERE t1.styleid = -1;

    MySQL Error : Not unique table/alias: 't1'
    Error Number : 1066
    Request Date : Monday, March 12th 2012 @ 01:45:09 AM
    Error Date : Monday, March 12th 2012 @ 01:45:09 AM
    Script : http://cdmagurus.com/forum/admincp/t...o=displayorder
    Referrer : http://cdmagurus.com/forum/admincp/t....php?do=modify
    IP Address :
    Username : whitey10tc
    Classname : vB_Database
    MySQL Version : 5.1.56-log
    Also having reports of users receiving invalid security token messages using IE browser.
    www.cdmagurus.com
    www.cellphone-gurus.com
  • Zachery
    Former vBulletin Support
    • Jul 2002
    • 59097

    #2
    You have a third party addon making your life hard. Disable them.

    Comment

    Related Topics

    Collapse

    Working...