Comments STUCK – same comment in que

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: https://www.wolfcat.com.au/randomrants/wp-admin/comment.php?action=mac&c=0
Delete it: https://www.wolfcat.com.au/randomrants/wp-admin/comment.php?action=cdc&c=0
Spam it: https://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:
https://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