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

  • Steve Machol
    replied
    It's not possible to get that error with the original vB files and templates, and no add-ons. Try again.

    Leave a comment:


  • zodehala
    replied
    any reply ?

    Leave a comment:


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

    Leave a comment:


  • Steve Machol
    replied
    Reupload the original 3.7.1 files an make sure that version 3.7. shows in the upper right hand corner of that page.

    Leave a comment:


  • 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
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X