Akismet MySQL error

  • mrkryptic

    (@mrkryptic)


    19 years, 2 months ago

    I dont know if this just my blog, but today I was checking the spam list. I went to page 2 and then page 1, and I got a mysql error:

    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

    It loads up this url when I go to previous page:
    <<my blog>>/wp-admin/edit-comments.php?page=akismet-admin&apage=

    It doesnt include page=1 when I press previous page.

    Is it me, or is this a bug?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter mrkryptic

    (@mrkryptic)

    19 years, 2 months ago

    bump

    johannadc

    (@johannadc)

    19 years, 2 months ago

    I’m having a similar problem. When anyone tried to post a comment on my blog, they’d get a page of SQL errors instead of being able to post. Additionally, I’m getting comment notification email that request moderation, but the comment doesn’t exist (all the fields are empty).

    I solved it brute-force method by commenting out the line in the Akismet plugin code that reads ” $wpdb->query(“DELETE FROM $wpdb->comments WHERE DATE_SUB(‘$now_gmt’, INTERVAL 15 DAY) > comment_date_gmt AND comment_approved = ‘spam'”);”

    I picked that line because it was the first one that appeared on the error page. But I know that’s not the best idea. I hope others more knowledgeable know what’s going on.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Akismet MySQL error’ is closed to new replies.

Tags