DB Syntax Error when Navigating Throughout Spam Pages

  • tamar

    (@tamar)


    17 years, 2 months ago

    I just got this database error when going from page 15 of spam (for review) back to page 1.

    I have no spam right now to see if the error can be reproduced, but I figured I’d bring it to the attention of someone in case it helps with any code fixes. See the bolded text for the important stuff. 🙂

    Latest Spam

    These are the latest comments identified as spam by Akismet. If you see any mistakes, simply mark the comment as “not spam” and Akismet will learn from the submission. If you wish to recover a comment from spam, simply select the comment, and click Not Spam. After 15 days we clean out the junk for you.

    WordPress database 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 ‘-50, 0’ at line 1]
    SELECT * FROM wp_comments WHERE comment_approved = ‘spam’ ORDER BY comment_date DESC LIMIT -50, 0

    No results found.

    There are currently 730 comments identified as spam.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator Samuel Wood (Otto)

    (@otto42)

    WordPress.org Admin

    17 years, 2 months ago

    Clearly some kind of paging bug in Akismet. I’d send it along to the Akismet.com people via their webpage: http://akismet.com/contact/

    Also, 15 pages of spam? Yikes! I’d suggest installing Bad Behavior. That will help more than you think. It blocks the blatently obvious spam before it reaches Akismet. It also reduces the load on your site, since it prevents the spammers from ever hitting the page at all.

    Thread Starter tamar

    (@tamar)

    17 years, 2 months ago

    Hey Otto,

    Yeah, I suppose it is — I will pass it on.

    Thanks for the tip re: bad behavior; I didn’t know that such a thing existed 🙂

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘DB Syntax Error when Navigating Throughout Spam Pages’ is closed to new replies.

Tags