Fixing pending comments issue

General

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.

Film & Game Releases: Week of May 3
Tuesday April 30, 2019

CHECK OUT OUR LIST OF MOVIE RELEASES FOR THE WEEK OF May 3, 2019! From The Intruder to UglyDolls, here is a schedule of the films and games coming out soon! Film Release Schedule El Chicano Synopsis from The NumbersWhen L.A.P.D. Detective Diego Hernandez is assigned a career-making case investigating a vicious cartel, he uncovers […]

The post Film & Game Releases: Week of May 3 appeared first on Dua xe moto.

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.

Entertainment Business Instructor Spotlight
Monday May 13, 2019

Winner of the 2019 Cynopsis PR Campaign at the Short Form Film Festival We’d like to send a heartfelt congratulations to one of our Entertainment Business instructors, Pam Newton, who wrote and published her first book A Candle for My Mother. The novel chronicles the journey of her mother’s desire to see the world while […]

The post Entertainment Business Instructor Spotlight appeared first on Dua xe moto.

I realised that people were commenting but getting the error.
 

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.

Q-Learning Agents, Part 3
Friday October 05, 2018

A Q-Table greatly simplified the challenge of helping a computer agent “learn” to solve an environment. Unfortunately, this particular approach doesn’t scale well to the kinds of applications I would like to create. To help overcome this next hurdle, we will raise the complexity a bit more as the Frozen Lake environment is approached again, […]

The post Q-Learning Agents, Part 3 appeared first on Dua xe moto.

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.

The post Fixing pending comments issue appeared first on VibeThemes.