[Forum] vBulletin Database Error - MySQL Syntax Missing

[TXGunTalk]

Database error in vBulletin 4.0.0: Invalid SQL: SELECT thread.threadid, thread.title FROM thread AS thread WHERE forumid = 32 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 I've been getting these emails with regularity ever since my upgrade to 4.0. I need to know the value that is missing. AND lastpost > (What value goes here?)

[TXGunTalk]

I don't understand why this damn post won't format. It wouldn't even let me use half the buttons on the WYSIWYG editor.

[Paul M]

You need to post the whole error message as it shows what script etc was being run.

[TXGunTalk]

You need to post the whole error message as it shows what script etc was being run.

The entire emailed script is posted above, just it's not formatted. Copy and paste seems to jack it up. Database Error in vBulletin 4.0.0: Invalid SQL: SELECT thread.threadid, thread.title FROM thread AS thread WHERE forumid=9 AND visible=1 AND open 10 AND lastpost > ORDER BY lastpost LIMIT 1; MySQL Error: You have an error in your MySQL 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. I typed it out ... hopefully it's more legible. The offending script varies by the error, and always contains a thread's URL with "-next-thread.html" at the end of it.

[TXGunTalk]

I give up being able to write out a legible response ... For some reason or another the text just gets rammed together

[TXGunTalk]

The offending script varies by the error, and always contains a thread's URL with "-next-thread.html" at the end of it.

[Trevor Hannant]

Try wrapping the error on [code][/code] tags

[TXGunTalk]

Database error in vBulletin 4.0.0:

Invalid SQL:

        SELECT thread.threadid, thread.title
            
        FROM thread AS thread
        
        WHERE forumid = 12
            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  : Tuesday, January 12th 2010 @ 04:36:33 PM
Error Date    : Tuesday, January 12th 2010 @ 04:36:33 PM
Script        : http://www.texasguntalk.com/forums/gear-accessories-sponsored-gun-works/11774-new-texas-holster-maker-next-thread.html
Referrer      : 
IP Address    : 87.250.xxx.xxx
Username      : Unregistered
Classname     : vB_Database
MySQL Version :

Evidently the Quick Reply was the problem. I "went advanced" and it displays properly.

[TXGunTalk]

Bump.

[Paul M]

Does it happen in 4.0.1 ?

[TXGunTalk]

I'm updating it to 4.0.1 later tonight.

[InfoAddict]

I get the same - 4.0.1

   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 :

[samii]

is it same error, i got this error while upgrading

Database error in vBulletin 3.8.4:

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

[bitterwaitress]

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.

[anv2010]

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