I had a bad timing issue here. I deleted my alias on my mail server by accident two weeks ago.
Now, I have a serendipity blog, which is configured to display captchas on comments after 0 days and to moderate comments after 30 days. Well, it seems two weeks ago one of my blog posts became 30 days old.
So, now I have thousands of comments waiting for moderation for the post in question. How can I delete them? Walking through hundeds of pages is not a solution, so far I deleted 20 pages of comments, but that's just a few of them. Displaying all of them on one page, of course, doesn't work, because it displays a blank page.
How can I delete the comments posted on this post that are currently waiting for moderation?
Warning to everyone: Never ever use the 'automatically moderate' misfeature.
How can I delete comments?
I use "automatically moderate", although I combine it with a few other things. I find that requiring a link to my blog filters a lot of trackback spam. Wordfilters for drug names catch a lot, too. Rejecting for too many links catches a couple.
I'm experimenting with Akismet, and it seems like a good solution.
Meanwhile: you can use "invert selections" to check all the unchecked comments on a page, then delete them. Two total clicks per page. I find this useful for mass-deleting spam. You could delete 20 pages in less than 5 minutes, even checking them closely for the possible one valuable comment.
Blank page: this indicates a PHP error. Check your CGI error logs. Judging from the circumstances, you overran your alloted memory. This can be usually be changed in php.ini, although providers' methods vary.
I'm experimenting with Akismet, and it seems like a good solution.
Meanwhile: you can use "invert selections" to check all the unchecked comments on a page, then delete them. Two total clicks per page. I find this useful for mass-deleting spam. You could delete 20 pages in less than 5 minutes, even checking them closely for the possible one valuable comment.
Blank page: this indicates a PHP error. Check your CGI error logs. Judging from the circumstances, you overran your alloted memory. This can be usually be changed in php.ini, although providers' methods vary.
Yep, of course, but I didn't want to try what will happen if I actually raised the limit. I did. Wasn't very funny. Firefox didn't like the page, and I had to wait 15 minutes for the script to "reverse the selection". Then the deletion failed with an invalid referer error, so the waiting was in vain.
However, I did
And now I don't have all these comments. 
However, I did
Code: Select all
delete from s_comments where status='pending' and entry_id=33;