MySQL Error

  • Time
  • Show
Clear All
new posts
  • Robert Fogt
    Senior Member
    • Nov 2005
    • 102

    MySQL Error

    I have received several errors while modifying the styles. I successfully made several changes, then checked the box to revert back to default but it refused to work and gave me the error message below. I tried it several times and I get the same error each time.

    Database error in vBulletin 3.5.1:

    Invalid SQL:

    SELECT templateid, title, template, template_un, styleid, templatetype
    FROM template
    WHERE templateid IN()
    AND (templatetype <> 'template' OR title IN ('header', 'footer', 'headinclude', 'editor_jsoptions_font', 'editor_jsoptions_size', 'editor_styles_button_normal', 'editor_styles_button_hover', 'editor_styles_button_down', 'editor_styles_button_selected', 'editor_styles_menu_normal', 'editor_styles_menu_hover', 'editor_styles_menu_down', 'editor_styles_popup_down'));

    MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')
    AND (templatetype <> 'template' OR title IN ('header', 'fo
    Error Number : 1064
    Date : Friday, December 2nd 2005 @ 07:58:14 AM
    Script :
    Referrer :
    IP Address :
    Username : Robert Fogt
    Classname : vb_database
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    SQL Syntax errors are almost always related to modified code. To troubleshoot this, the first thing you need to do is remove any hacks or plugins, then see if you still have this problem.

    If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

    Next, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it. Do you have the same problem?
    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.


    • Robert Fogt
      Senior Member
      • Nov 2005
      • 102

      This is a brand new install. I just bought the software a couple days ago and there have been no changes, or additions, or modifications to it at all.

      The only thing I have been doing is changing the various permissions in the admin area.


      • Robert Fogt
        Senior Member
        • Nov 2005
        • 102

        It seems to be working OK now. I tried again and it works.

        The only thing I can think of is it took a minute to load the color picker for the Main CSS settings page and I may have been clicking too soon. Once the page fully loaded and I submitted, it no longer showed errors.


        • Robert Fogt
          Senior Member
          • Nov 2005
          • 102

          BTW, is that valid SQL? Or is there an error in the SQL statement?


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