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 10th 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


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