Announcement

Collapse
No announcement yet.

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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #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


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

      Comment


      • #4
        any reply ?

        Comment


        • #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...
          X