Announcement

Collapse
No announcement yet.

vBulletin Database Error - MySQL Syntax Missing

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

  • Visualbrother
    replied
    Had the same problem with a clean install, but it has vbSEO installed, when turned off the error is gone, so perhaps it is not a mySQL problem but a re-write problem.

    update:

    Set the VB friendly url's to: Standard URLs and turned off Enforce Canonical URL for Registered Users

    Stuff used:

    vb 4.03 + vbSEO 3.5.0

    After this I can not replicated the error anymore
    Last edited by Visualbrother; Sun 18 Apr '10, 3:21pm. Reason: updated and seem to have solved my problem

    Leave a comment:


  • mhme
    replied
    This problem because of error in sql syntax: " AND lastpost > "
    There is no number after ">" !

    This is occurred on "Next Thread" link when current thread is last one.
    I have this problem too. it seams there is a bug.

    Leave a comment:


  • TXGunTalk
    replied
    There's been several re-writes ... 4.0.0 --> 4.0.1 --> 4.0.2 ... and neither have remedied the issue.

    Leave a comment:


  • Trevor Hannant
    replied
    Try

    - re-downloading the package from the members area
    - deleting all vBulletin files
    - uploading the package to your server again (ensure that all non-image files are uploaded in ASCII format)
    - disable all modifications/plugins/products (except vB Blog and vB CMS if installed)

    Do you still get the error?

    Leave a comment:


  • Gil
    replied
    Same error

    I have also got this error since a clean installl of vB 4.0

    Code:
    Database error in vBulletin 4.0.0:
    Invalid SQL:
     
                   SELECT thread.threadid, thread.title
                   FROM vb4_thread AS thread
                   WHERE forumid = 82
                           AND visible = 1
                           AND open <> 10
                           AND postuserid NOT IN (274)
                   AND lastpost >
                   ORDER BY lastpost
                   LIMIT 1;
     
    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 'ORDER BY lastpost
                   LIMIT 1' at line 11
    
    Error Number  : 1064
    Request Date  : Sunday, February 14th 2010 @ 07:22:58 PM
    Error Date    : Sunday, February 14th 2010 @ 07:22:58 PM
    Script        : [URL]http://www.masscops.com/court-procedure/1782-evidence-next-thread.html[/URL]
    Referrer      :
    IP Address    : 77.88.42.26
    Username      : Unregistered
    Classname     : vB_Database
    MySQL Version :

    Leave a comment:


  • TXGunTalk
    replied
    Originally posted by Trevor Hannant View Post
    http://www.vbulletin.com/forum/proje...?issueid=34851

    This may be because of an upload error. Try re-uploading the files again ensuring that all files are overwritten completely. It may be worth looking at completely deleting all vBulletin files from your server then uploading them from scratch (except install/install.php). If you do this, then make sure you also rename config.php.new to config.php and re-enter the relevant information into that file.
    I re-uploaded everything in the 4.0.0 to 4.0.1 Fix and neither the update nor the overwrite has fixed the issue.

    Any ideas?

    Leave a comment:


  • bitterwaitress
    replied
    I don't know if this is helpful, but here is the error I've been getting:

    Code:
    Database error in vBulletin 4.0.0:
    
    Invalid SQL:
    
    				SELECT thread.threadid
    				FROM xxxxxxxxxx AS thread
    				
    				WHERE thread.forumid IN()
    					AND thread.lastpost >= 1263632120
    					AND thread.open <> 10
    				ORDER BY thread.lastpost desc
    				LIMIT 75;
    
    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 thread.lastpost >= 1263632120
    					AND thread.open <> 10
    				ORDER' at line 4
    Error Number *: 1064
    Request Date *: Sunday, January 17th 2010 @ 02:55:20 AM
    Error Date ***: Sunday, January 17th 2010 @ 02:55:20 AM
    Script *******: http://bitterwaitress.com/forums/search.php?do=getdaily&contenttype=vBForum_Post
    Referrer *****: http://bitterwaitress.com/forums/blog.php
    IP Address ***: xx.xxx.xxx.x
    Username *****: Unregistered
    Classname ****: vB_Database
    MySQL Version :
    and it stopped happening after I disabled searching forums and blogs and viewing attachments for Unregistered users.

    (All my errors were Unregistered users)


    eta: this was my first and only ever installation of this database
    Last edited by bitterwaitress; Sun 17 Jan '10, 2:47pm. Reason: additional info

    Leave a comment:


  • Trevor Hannant
    replied
    http://www.vbulletin.com/forum/proje...?issueid=34851

    This may be because of an upload error. Try re-uploading the files again ensuring that all files are overwritten completely. It may be worth looking at completely deleting all vBulletin files from your server then uploading them from scratch (except install/install.php). If you do this, then make sure you also rename config.php.new to config.php and re-enter the relevant information into that file.

    Leave a comment:


  • anv2010
    replied
    I've a similar error, but upon an attempt to download a file from within a forum thread. Please see the bug report here: http://www.vbulletin.com/forum/proje...?issueid=35344

    Leave a comment:


  • bitterwaitress
    replied
    I get this about twenty times a day. (4.0.0.) I've also noted that I see threads containing quoted threads, but the originals are missing.

    Leave a comment:


  • samii
    replied
    is it same error, i got this error while upgrading

    Database error in vBulletin 3.8.4:

    Code:
    Invalid SQL:
    UPDATE user SET options = options |;
    
    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 '' at line 1
    Error Number  : 1064
    Request Date  : Friday, January 15th 2010 @ 06:03:23 PM
    Error Date    : Friday, January 15th 2010 @ 06:03:23 PM
    Script        : [URL]http://www.mysite.com/testsuite/install/upgrade_400a1.php?step=5[/URL]
    Referrer      : [URL]http://www.mysite.com/testsuite/install/upgrade_400a1.php?step=4[/URL]
    IP Address    : 67.172.17.56
    Username      : 
    Classname     : vB_Database
    MySQL Version : 5.0.81-community-log

    Leave a comment:


  • InfoAddict
    replied
    I get the same - 4.0.1

    Code:
       Database error in vBulletin 4.0.1:
       
      Invalid SQL:
       
                                      SELECT thread.threadid, thread.title
                                                      
                                      FROM vb3_thread AS thread
                                      
                                      WHERE forumid = 61
                                                      AND visible = 1
                                                      AND open <> 10
                                                      
                                                      
                                      AND lastpost > 
                                      ORDER BY lastpost
                                      LIMIT 1;
       
      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 'ORDER BY lastpost
                                      LIMIT 1' at line 11
      Error Number  : 1064
      Request Date  : Saturday, January 16th 2010 @ 09:16:52 AM
      Error Date    : Saturday, January 16th 2010 @ 09:16:52 AM
      Script        : [URL]http://gamers-underground.com/clan-gu/32310-star-trek-online-beta-character-contact-list-next-thread.html[/URL]
      Referrer      : [URL]http://gamers-underground.com/clan-gu/32310-star-trek-online-beta-character-contact-list.html[/URL]
      IP Address    : x.x.x.x
      Username      : Unregistered
      Classname     : vB_Database
      MySQL Version :

    Leave a comment:


  • TXGunTalk
    replied
    I'm updating it to 4.0.1 later tonight.

    Leave a comment:


  • Paul M
    replied
    Does it happen in 4.0.1 ?

    Leave a comment:


  • TXGunTalk
    replied
    Bump.

    Leave a comment:

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