Akismet Bug

tags: image · software

Estimated reading time is 1 minute.

I started to get a lot of spam comments, and yesterday I installed Askimet. This morning, I found a bug in Askimet. Don’t you just love to start a day with a bug? :)

This is bug report I sent.

I think I found a bug.

I have WordPress 2.1 and Akismet 2.0.

At “/wp-admin/edit-comments.php?page=akismet-admin” page (Comments > Akismet Spam) I have 51 spam comment, just enough for two pages.

There I can click “2” or “Next Page »” link that leads me to “wp-admin/edit-comments.php?page=akismet-admin&apage=2” page.

There are links “« Previous Page” and “1” that lead to “wp-admin/edit-comments.php?page=akismet-admin&apage=” page (please notice that the number “1” is missing at the end of the url).

At that page I get this error message:

“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”

I guess that is because I am at page “[…]&apage=” and it should be “[…]&apage=1” (again, the number “1” is missing at the end of the url).

Links “2” or “Next Page »” point to “[…]&apage=2” and links “« Previous Page” and “1” point to “[…]&apage=” instead of “[…]&apage=1” (once more, just to be sure, the number “1” is missing at the end of the url).

Feedback

Thank you for reading. If you want to stay in touch please use the feed or send me an email.