The easy way is to just write PHP to go through all the posts and call wp_update_comment_count()
on each post ID.
Related Posts:
- What do these phpMyAdmin errors mean on my WordPress databaes?
- Allow variable amount of comments before pagination
- MySQL Query to Retrieve Category from wp_posts
- SQL Query for getting all posts in their latest revised state
- get comments and get posts in loop
- Manually delete post from database
- modify all posts of a category to “no comments allowed”
- How can I allow editors to leave comments on posts that have not yet been published?
- How to force update all posts after import
- One comment per user email per post
- Can’t show comments count per post outside loop
- Only display posts with comments
- Comments enabled, but disabled at the same time
- Comments not showing in custom post type – WordPress
- How to output comments number of a post per day?
- Enable commenting on front-end preview page for pending posts
- Hide comments awaiting moderation from user who submitted the comments
- Query All users that has post
- Can’t publish new posts
- Display posts with comments closed, with pagination?
- Why is WordPress redirecting users to random posts after commenting?
- How to get most recent commented post above new submitted post in WordPress?
- Reset/Reorder posts ID in the MySQL wp_posts table
- how to find user ids of all commenters in a post
- Diplay comment date on WP_Post_Comments_List_Table
- How do I find which articles are missing a featured image in The WordPress database?
- Posts vs. Pages
- How to allow logged in users to post anonymously
- wp_insert_post – duration
- Query get post,how to add comment box
- Enable Comments Box On Custom Post Type
- Turn On Comments On Custom Post Types in Directory Theme
- Emojis replaced by ‘?’ automatically
- Showing author page if user has no post
- Customizing Comments on Posts
- Custom order for Mysql array
- What do comments with […] mean?
- Remove a shortcode from all WordPress posts
- Internal post link creates comments on its own
- What happens if I delete all the rows that represents a post revision from the posts table into WordPress database?
- How to get posts and comments amount per hour, per year and per month?
- Show comment number per author per day
- Get all comments of author’s posts
- Delete post results in “Cannot delete or update a parent row: a foreign key constraint fails”
- SQL Command for restoring trashed comments
- How do you change the comment count in the back end posts list, to reflect unapproved comments, rather than all comments?
- Inner join overrides Advanced Custom Fields plugin’s get_field [closed]
- Hide comments and posts posted by other user
- Let both the admin and post author update comment meta
- update image path with words starting uppercase to lowercase chars
- How to style archive post titles… but only those posts who have comments?
- Database hacked – random posts are modified
- Need to change all links in page content but not in post content
- Can’t update WordPress Page if post_content is Empty
- Is it advisable to use $post->comment_count instead of get_comments_number( $post_id )
- Restore woocommerce orders
- How does WP decide how to display a page
- How to select particular month post from table and update the post status using MySQL?
- Display on page every post in blog WITH comments
- Showing recent post of category in page
- Can WordPress handle following functionalities?
- get last post’s link with SQL query
- How to get post id of last approved comment?
- query for filtering published posts?
- How to implement a WordPress comments function?
- Deleting post tags removes categories
- Return records between two meta datetimes saved as strings
- WP query taxonomy optimization
- Count the total views of all user posts published
- how to show comments only author which send own posts in wordpress
- Shortcode for Comments and Comment Boxes in Post Loop
- Merge get_comments & get_posts into a single query
- MYSQL: Create SQL query to search for string and replace
- Remove the URL author of post on all comments
- WordPress MySQL Search and replace with wildcard?
- WordPress weird behaviour on comments
- Comments are in database, don’t show up in WordPress backend or frontend
- No comments allowed
- Add postmeta to all blog posts
- ‘posts’ table should not store the absolute image path
- Dev and prod on the same database- dev version active for IOS
- SQL trigger failes with post_content
- How to enable comments meta box for other author posts?
- Comments as part of a post
- Some comment box wordpress in 1 post [closed]
- 3rd Party Login in wordpress
- SQL query to remove first image in all posts
- Apply comment to different post (not the current post) [duplicate]
- How can I get a comment ID on Submit?
- Delete junk text from all the post using my sql command
- Get first comment link on the post itself
- FIND and REPLACE wp_posts AND IGNORE custom post type mysql query
- Display the first post’s comments of category in comments.php template
- 2 tick boxes appearing below comments
- How to display a certain template element only for posts published within certain time range?
- How to create a post based on data in a table?
- How can I show the positive and negative comments for a same post separately?
- How does WordPress add the comments and comment form to posts
- Simple shortcode to check if a user has commented on a certain post
- Undefined Function Fatal Error with Shortcode [closed]