Announcement

Collapse
No announcement yet.

MySQL Error

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

  • MySQL Error

    I woke to find this error in my mailbox.

    Any ideas what it means ? AFAIK the forum is running fine.

    Thanks


    Database error in vBulletin 2.2.6:

    Invalid SQL: SELECT announcementid,startdate,title,user.username,user.userid,user.usertitle,user.customtitle
    FROM announcement
    LEFT JOIN user
    ON user.userid=announcement.userid
    WHERE startdate<=1029541295 AND enddate>=1029541295
    AN (forumid='25' OR forumid='7' OR forumid='-1')
    ORDER BY startdate DESC
    LIMIT 1
    mysql error: You have an error in your SQL syntax near 'AN (forumid='25' OR forumid='7' OR forumid='-1')
    ' at line 6

    mysql error number: 1064

    Date: Friday 16th of August 2002 04:41:35 PM
    Script:
    Referer:
    Hungry ?

  • #2
    What was the url of the script that was running it?

    Its odd that its just AN and not AND which is causing the error.
    Scott MacVicar

    My Blog | Twitter

    Comment


    • #3
      http://www.mydomain.com/forums/forum...php?forumid=25 (which incidentally is a hidden forum for everyone but mods, super mods and admin)

      was the script

      http://www.mydomain.com/forums/index.php?

      was the referer.

      Thanks
      Last edited by bahbah; Sat 17th Aug '02, 3:42am.
      Hungry ?

      Comment


      • #4
        btw I have no hacks at all and haven't used any
        Hungry ?

        Comment


        • #5
          has the problem occured again when viewing that forum?
          Scott MacVicar

          My Blog | Twitter

          Comment


          • #6
            My apologies that forumid is not the private forum I thought it was.

            Viewing this forum is fine. It doesn't bring up any error.

            Likewise I can also post and reply/close and delete in this forum without any error.

            Odd !
            Hungry ?

            Comment

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