Fixing pending comments issue

WordPress comments are very reliable and it is very rare that you’ll ever see this issue on your site. But just like with all technology, things sometimes fail and then you need to debug and correct them. I searched internet and found nothing. Hopefully, some of you will find this post useful. So, one day all of a sudden I find that I have 24 pending comments in my WordPress admin dashboard comments panel and when I click on pending comments link it shows no comments. I realised that people were commenting but getting the error.   comments not saved
So, first I tried to optimise database which did not work. Then I started debugging code, the error message appears from wp-includes/comments.php which runs the function wp_new_comment which runs the function wp_insert_comment  which runs $wpdb->insert in wp-includes/wp-db.php which runs the function _insert_replace_helper and in this function I got the generated sql file. I printed the sql query [ print_r($this->prepare( $sql, $values ) ) ] and ran the query directly in the database. Then I found that the query was running but the comment_ID was generated as 0. So, it was a database issue, when I edited the structure of the wp_comments table, I found that comment_ID was neither set as primary key, not it was set on auto increment mode. The fix was to remove all the comments with comment_ID as 0 and then setting the comment_ID as primary key and auto-increment. Finally comments were back on my site.

6 comments

  1. Vinicius says:

    Is it possible to make a free course for logged members, but charge only if students want the certificate? Im already aware about the addon for variable pricing of courses, but Id like to keep the students in the same flow. Not buying the same course in a charged version again.

  2. Hello baby!

  3. sm says:

    Thankyou. It worked.

  4. Imran says:

    It worked

  5. Imran says:

    yes it worked for me as well.

Leave a Reply

%d bloggers like this: