No announcement yet.

Odd DB Error, MYSQL Error 1054

  • Filter
  • Time
  • Show
Clear All
new posts

  • Odd DB Error, MYSQL Error 1054

    Can't tell if we're getting hacked or it's a bug, but after we banned a guy a couple of times whenever a regular user tries to click on a forum we get a screen that comes up stating:

    There seems to have been a slight problem with the Speeddensity 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.
    And when we look at the page source for that error page we find:

    Database error in vBulletin 3.0.7:

    Invalid SQL:
    SELECT COUNT(*) AS threads,
    SUM(IF(lastpost&gt;=1128187916 AND open&lt;&gt;10,1,0)) AS newthread
    FROM thread AS thread
    LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
    WHERE forumid = 2
    AND sticky = 0
    AND visible = 1
    AND postuserid NOT IN (KNIFESHOW)
    AND lastpost &gt;= 1125595960

    AND deletionlog.primaryid IS NULL

    mysql error: Unknown column 'KNIFESHOW' in 'where clause'

    mysql error number: 1054

    Date: Saturday 01st of October 2005 12:32:40 PM
    Username: Unregistered
    IP Address:
    Now, to me it seems obvious that the problem lies in the line
    AND postuserid NOT IN (KNIFESHOW)
    Where knifeshow is the part that shouldn't be there.

    But how do I fix this??? Where do I go to edit the file and take that (KNIFESHOW) text out?

    Thanks everyone!

  • #2
    Hi there,

    We can't know, as we never installed that hack for you.

    Upgrade to 3.0.9 or 3.5.0 as 3.0.7 has a security issue.


    • #3
      Remove KNIFESHOW from the Tachy Goes to Coventry setting and replace it with his userid.
      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.