WordPress.org

1. mrkryptic
   Member
   Posted 5 years 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?

2. mrkryptic
   Member
   Posted 5 years ago #

   bump

3. JohannaDC
   Member
   Posted 5 years 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.

Topic Closed

This topic has been closed to new replies.