Deactivate all the comment related plugins. Does the error persist?
yes, with no comment related plug-ins it still fails.
and every post has this at the bottom of the email
Approve it: http://www.wolfcat.com.au/randomrants/wp-admin/comment.php?action=mac&c=0
Delete it: http://www.wolfcat.com.au/randomrants/wp-admin/comment.php?action=cdc&c=0
Spam it: http://www.wolfcat.com.au/randomrants/wp-admin/comment.php?action=cdc&dt=spam&c=0
Currently 0 comments are waiting for approval. Please visit the moderation panel:
http://www.wolfcat.com.au/randomrants/wp-admin/edit-comments.php?comment_status=moderated
so there are no posts in the queue according to the system… and I have tried entering posts via firefox (both as a moderator and not), ie and chrome… and they are all the same…
even tried changing the to address for wordpress emails to one account on the same domain, and to my gmail account… same email comes through every time.
Hmmm… all those zero IDs seem to signal there is something wrong with the comments table in the DB: it should increment automatically the ID #s but it doesn’t.
Unfortunately, I am not a coder, so I have no idea how to check the DB, but I remember similar issues with posts (having 0 ID) and the solution was to fix the table’s characteristics.
Yes… had a look at the database dbWebAdmin and made comment_ID autoIndex again… (which for some reason it had decided to stop,….) and things seem to be back in order..
Solution was
goto WebAdmin, database..
then the SQL was….
ALTER TABLE wp_comments CHANGE comment_ID comment_ID BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT
(@wolfcat)
17 years, 8 months ago
I have a major issue that the same comment keeps appearing in my inbound email, but the comment has no id to delete it.
Even if I enter a new comment, the old comment appears in the email notification. I have checked the database via my hosting and can not see this particular entry either to delete it from the database.
If I mark it as spam/approve or delete it as soon as I come back to the comments section this one post appears again. So nothing new is getting through at all.
So needless to say this is a little beyond frustrating…