Error message (sometimes only)

  • Time
  • Show
Clear All
new posts
  • apfparadise
    • Jan 2005
    • 67
    • 3.6.x

    Error message (sometimes only)

    When a user clicks on "new posts" from the navbar, there is an error. URL for the site is: Aquatic Photography Forum

    here is a message I get at my "technical Staff" address:


    There seems to have been a slight problem with the Aquatic Photography Forum database.
    Please try again by pressing the refresh button in your browser.

    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

    We apologise for any inconvenience.

    Database error in vBulletin 3.0.4:

    Invalid SQL:
    SELECT post.pagetext AS preview,
    thread.threadid, thread.threadid AS postid, thread.title AS threadtitle, thread.iconid AS threadiconid,
    thread.replycount, IF(thread.views=0, thread.replycount+1, thread.views) as views, thread.sticky,
    thread.pollid,, thread.lastpost AS postdateline,
    thread.lastpost, thread.lastposter, thread.attach, thread.postusername, thread.forumid, thread.threaddesc
    user.userid AS postuserid
    , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
    FROM thread AS thread
    LEFT JOIN user AS user ON(user.userid = thread.postuserid)
    LEFT JOIN subscribethread AS subscribethread
    ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 2)
    LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
    WHERE thread.threadid IN
    (9, 3)
    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 '.userid AS postuserid
    , NOT ISNULL(subscribethread.subscrib

    mysql error number: 1064

    Date: Saturday 08th of January 2005 01:14:39 PM
    Username: Jay Luto
    Last edited by apfparadise; Sat 8 Jan '05, 10:37am. Reason: add info
  • Floris
    Senior Member
    • Dec 2001
    • 37767

    First off, there is a security issue with 3.0.4 - please upgrade to 3.0.5 as soon as possible. Upgrading by overwriting these files and running upgrade.php will most certainly also fix the issue you have.

    If you don't want to upgrade, at least patch your forum (see announcment for details on init.php & private.php) and upload the search.php from the 3.0.4 zip file.


    • apfparadise
      • Jan 2005
      • 67
      • 3.6.x

      Thanks for your help. The board is heavily moded so it's difficult to upgrade. I did patch the init file, it's up to date. Will re-uploading the 3.04 seach.php help? I did not do anything to it. I dont remember any mods that did either.


      • Steve Machol
        Former Customer Support Manager
        • Jul 2000
        • 154488

        Yes, try reuploading the original search.php file.

        Also note that we cannot provide official support for hacked forums so if you still have this problem, try asking over at for help.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography

        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        • apfparadise
          • Jan 2005
          • 67
          • 3.6.x

          thanks, steve fixed!!!