No announcement yet.

Problem with tempales (Ivalid SQL)

  • Filter
  • Time
  • Show
Clear All
new posts

  • Problem with tempales (Ivalid SQL)

    Hi! While trying to acces in the admincp to styles menu, I get the following error:

    Database error in vBulletin 3.8.7:

    Invalid SQL:

    SELECT t1.templateid AS templateid_1, t1.title ,
    t1.templateid AS templateid_1, t1.title AS title1, t1.styleid AS styleid_1
    FROM template AS t1
    LEFT JOIN template AS t1 ON (t1.title=t1.title AND t1.styleid=0-1)
    WHERE t1.styleid = -1
    ORDER BY t1.title;

    MySQL Error : Not unique table/alias: 't1'
    Error Number : 1066

    Could you help me?

  • #2
    Check your styles in the database and see if you have one that has a parentid of '0'. If you do, change it to: -1
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography

    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.