Announcement

Collapse
No announcement yet.

vBulletin Database Error - MySQL Syntax Missing

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

  • [Forum] vBulletin Database Error - MySQL Syntax Missing

    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?)
    Last edited by TXGunTalk; Sun 10 Jan '10, 4:41pm.

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

    Comment


    • #3
      You need to post the whole error message as it shows what script etc was being run.
      Baby, I was born this way

      Comment


      • #4
        Originally posted by Paul M View Post
        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.

        Comment


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

          Comment


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

            Comment


            • #7
              Try wrapping the error on [code][/code] tags
              Vote for:

              - *Admin Settable Paid Subscription Reminder Timeframe*
              -
              *PM - Add ability to reply to originator only*
              - Add Admin ability to auto-subscribe users to specific channel(s)
              - "Quick Route" Interface...

              Comment


              • #8
                Code:
                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.

                Comment


                • #9
                  Bump.

                  Comment


                  • #10
                    Does it happen in 4.0.1 ?
                    Baby, I was born this way

                    Comment


                    • #11
                      I'm updating it to 4.0.1 later tonight.

                      Comment


                      • #12
                        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        : http://gamers-underground.com/clan-g...xt-thread.html
                          Referrer      : http://gamers-underground.com/clan-g...tact-list.html
                          IP Address    : x.x.x.x
                          Username      : Unregistered
                          Classname     : vB_Database
                          MySQL Version :

                        Comment


                        • #13
                          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        : http://www.mysite.com/testsuite/inst...0a1.php?step=5
                          Referrer      : http://www.mysite.com/testsuite/inst...0a1.php?step=4
                          IP Address    : 67.172.17.56
                          Username      : 
                          Classname     : vB_Database
                          MySQL Version : 5.0.81-community-log

                          Comment


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

                            Comment


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

                              Comment

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