MySQL Error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Markro
    Senior Member
    • Jun 2004
    • 105
    • 3.0.3

    MySQL Error

    Hello, I keep getting emailed this SQL error, anyone know whats causing it?

    Code:
    Database error in vBulletin 3.0.3:
    
    Invalid SQL:
                            SELECT *
                            FROM mailqueue
                            ORDER BY mailqueueid DESC
                            LIMIT 10
    
     mysql error:
  • Scott MacVicar
    Former vBulletin Developer
    • Dec 2000
    • 13286

    #2
    Whats the mysql error message.
    Scott MacVicar

    My Blog | Twitter

    Comment

    • Markro
      Senior Member
      • Jun 2004
      • 105
      • 3.0.3

      #3
      This is the whole email:

      Code:
      Database error in vBulletin 3.0.3:
      
      Invalid SQL:
                              SELECT *
                              FROM mailqueue
                              ORDER BY mailqueueid DESC
                              LIMIT 10
      mysql error:
      
      mysql error number:
      
      Date: Saturday 20th of May 2006 10:19:53 PM
      Script: http://www.xx.com/showthread.php?t=2000[URL="http://routerforums.com/showthread.php?t=2720"][/URL]
      Referer:
      Username: XXX
      IP Address: x.x.x.x.x[URL="http://24.76.114.224/"][/URL]

      Comment

      • Scott MacVicar
        Former vBulletin Developer
        • Dec 2000
        • 13286

        #4
        Its missing some vital information such as an actual error number and message which is odd.

        Is this a recent thing or been happening for a while?
        Scott MacVicar

        My Blog | Twitter

        Comment

        • Markro
          Senior Member
          • Jun 2004
          • 105
          • 3.0.3

          #5
          It's fairly recent I believe... umm, well.. thats the exact information that vBulletin sent me. What exactly does this mean:
          Code:
                                SELECT *
                                  FROM mailqueue
                                  ORDER BY mailqueueid DESC
                                  LIMIT 10
          It must mean something......

          Comment

          • Colin F
            Senior Member
            • May 2004
            • 17689

            #6
            That's the query that's being run, but there doesn't seem to be anything wrong with that.
            Best Regards
            Colin Frei

            Please don't contact me per PM.

            Comment

            • Markro
              Senior Member
              • Jun 2004
              • 105
              • 3.0.3

              #7
              Okay.. well, everything works properly.

              Thanks fellas.

              Comment

              • Scott MacVicar
                Former vBulletin Developer
                • Dec 2000
                • 13286

                #8
                What version of PHP are you running?
                Scott MacVicar

                My Blog | Twitter

                Comment

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