db error while upgrade (You have an error in your SQL syntax;)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • zodehala
    Senior Member
    • Aug 2005
    • 419
    • 3.5.x

    db error while upgrade (You have an error in your SQL syntax;)

    Code:
    Database error in vBulletin 3.7.1:
    
    Invalid SQL:
    
    				SELECT title, template, templatetype
    				FROM template
    				WHERE templateid IN ()
    					AND (templatetype <> 'template' OR title IN('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('editor_jsoptions_font', 'ed' at line 3
    Error Number  : 1064
    Request Date  : Wednesday, June 4th 2008 @ 08:42:33 PM
    Error Date    : Wednesday, June 4th 2008 @ 08:42:37 PM
    Script        : http://localhost/forum/install/finalupgrade.php?step=4
    Referrer      : 
    IP Address    : 127.0.0.1
    Username      : 
    Classname     : vB_Database
    MySQL Version : 5.0.51
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    Reupload the original 3.7.1 files an make sure that version 3.7. shows in the upper right hand corner of that page.
    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.


    Comment

    • zodehala
      Senior Member
      • Aug 2005
      • 419
      • 3.5.x

      #3
      already 3.7.1 and no hack/plug-in
      Last edited by zodehala; Thu 5 Jun '08, 11:16am.

      Comment

      • zodehala
        Senior Member
        • Aug 2005
        • 419
        • 3.5.x

        #4
        any reply ?

        Comment

        • Steve Machol
          Former Customer Support Manager
          • Jul 2000
          • 154488

          #5
          It's not possible to get that error with the original vB files and templates, and no add-ons. Try again.
          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.


          Comment

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