Title: Comment counter problem Last modified: May 30, 2020 --- # Comment counter problem * Resolved [anthony750](https://wordpress.org/support/users/anthony750/) * (@anthony750) * [6 years ago](https://wordpress.org/support/topic/comment-counter-problem-2/) * Good morning, sir, * Following the new version of the extension (Thanks for your excellent work), a small bug appeared on our 2nd site. * Under the comment entry form a counter appears on the page (example : [LIEN WEBSITE](https://maghreb.airavis.net/renaissance-tlemcen-hotel/)) there are 2 comments but it is displayed 16 comments. I emptied the cache of the site … and nothing works. * Have you had this problem also on other sites ? * Thank you for your understanding * Yours sincerely, Viewing 11 replies - 1 through 11 (of 11 total) * Plugin Support [gVectors Support](https://wordpress.org/support/users/gvectorssupport/) * (@gvectorssupport) * [6 years ago](https://wordpress.org/support/topic/comment-counter-problem-2/#post-12920808) * Hi [@anthony750](https://wordpress.org/support/users/anthony750/), * Please execute this SQL in Hosting Service cPanel > phpMyAdmin database manager, navigate to SQL Tab. If your WordPress table prefix is not wp_ replace all wp_ prefixes in this code to your database table prefixes, if they are wp_ just use it as is: * `UPDATE wp_posts p SET p.comment_count = (SELECT COUNT(*) FROM wp_comments c WHERE c.comment_post_ID = p.ID AND c.comment_approved = 1)` - This reply was modified 6 years ago by [gVectors Support](https://wordpress.org/support/users/gvectorssupport/). - This reply was modified 6 years ago by [gVectors Support](https://wordpress.org/support/users/gvectorssupport/). - This reply was modified 6 years ago by [gVectors Support](https://wordpress.org/support/users/gvectorssupport/). * Thread Starter [anthony750](https://wordpress.org/support/users/anthony750/) * (@anthony750) * [6 years ago](https://wordpress.org/support/topic/comment-counter-problem-2/#post-12921605) * Good morning, sir, * I don’t understand it and it’s really very complicated for me. * I don’t understand that on the airavis.net platform works correctly but not on the maghreb.airavis.net platform. * Cordially, * Thread Starter [anthony750](https://wordpress.org/support/users/anthony750/) * (@anthony750) * [6 years ago](https://wordpress.org/support/topic/comment-counter-problem-2/#post-12967856) * Hello, * I did not get any feedback from you, neither by email, nor on the forum. and the problem of the counter on the site [WEBSITE](http://maghreb.airavis.net) still persists. * Can you try to fix it if I give you access to the CPANEL? * Waiting for your return, * Yours sincerely, * Plugin Author [gVectors Team](https://wordpress.org/support/users/gvectors-team/) * (@gvectors-team) * [6 years ago](https://wordpress.org/support/topic/comment-counter-problem-2/#post-12968914) * Hi [@anthony750](https://wordpress.org/support/users/anthony750/), It’s not necessary to provide cpanel access. Just let us know what email address you’ve contacted to and what is your email subject. - This reply was modified 6 years ago by [gVectors Team](https://wordpress.org/support/users/gvectors-team/). * Thread Starter [anthony750](https://wordpress.org/support/users/anthony750/) * (@anthony750) * [5 years, 12 months ago](https://wordpress.org/support/topic/comment-counter-problem-2/#post-12978208) * Hello, * Yes we sent a mail on May 25th at 15H05 with the subject “WPDISCUZ Help Request” but we don’t talk about this problem in the mail, we saw it afterwards. * Sincerely, * Plugin Author [gVectors Team](https://wordpress.org/support/users/gvectors-team/) * (@gvectors-team) * [5 years, 12 months ago](https://wordpress.org/support/topic/comment-counter-problem-2/#post-12978264) * Hi [@anthony750](https://wordpress.org/support/users/anthony750/), I’m sorry, but we can’t find it. Could you please resend it? * Thread Starter [anthony750](https://wordpress.org/support/users/anthony750/) * (@anthony750) * [5 years, 11 months ago](https://wordpress.org/support/topic/comment-counter-problem-2/#post-13030777) * Hello, * I forwarded the email to you today at 6:19 pm; * In the email I did not put the problem of the counter of the notices on the site airAvis Maghreb. * Waiting for your return, * Yours sincerely, - This reply was modified 5 years, 11 months ago by [anthony750](https://wordpress.org/support/users/anthony750/). * Thread Starter [anthony750](https://wordpress.org/support/users/anthony750/) * (@anthony750) * [5 years, 11 months ago](https://wordpress.org/support/topic/comment-counter-problem-2/#post-13090725) * Hello, * The problem persists and no response from you on the forum or by email. * We have 2 customer review platforms and therefore the comment extension is very important to us. * Would it be possible to have a return by mail but also a help concerning the problem of meter on the site airAvis Maghreb. * Waiting for your return, * Yours sincerely, * Plugin Support [gVectors Support](https://wordpress.org/support/users/gvectorssupport/) * (@gvectorssupport) * [5 years, 11 months ago](https://wordpress.org/support/topic/comment-counter-problem-2/#post-13095619) * Please leave the email subject here to allow us to easily find it. * Thread Starter [anthony750](https://wordpress.org/support/users/anthony750/) * (@anthony750) * [5 years, 11 months ago](https://wordpress.org/support/topic/comment-counter-problem-2/#post-13095906) * Hello, * Here is the subject of the email in French I just saw it ” Request help WPDISCUZ– Demande aide WPDISCUZ”. * Awaiting your return, * Yours sincerely, - This reply was modified 5 years, 11 months ago by [anthony750](https://wordpress.org/support/users/anthony750/). * Plugin Support [gVectors Support](https://wordpress.org/support/users/gvectorssupport/) * (@gvectorssupport) * [5 years, 11 months ago](https://wordpress.org/support/topic/comment-counter-problem-2/#post-13098831) * Hi [@anthony750](https://wordpress.org/support/users/anthony750/), * You have been answered via email. Viewing 11 replies - 1 through 11 (of 11 total) The topic ‘Comment counter problem’ is closed to new replies. * ![](https://ps.w.org/wpdiscuz/assets/icon-256x256.png?rev=1076265) * [Comments - wpDiscuz](https://wordpress.org/plugins/wpdiscuz/) * [Frequently Asked Questions](https://wordpress.org/plugins/wpdiscuz/#faq) * [Support Threads](https://wordpress.org/support/plugin/wpdiscuz/) * [Active Topics](https://wordpress.org/support/plugin/wpdiscuz/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/wpdiscuz/unresolved/) * [Reviews](https://wordpress.org/support/plugin/wpdiscuz/reviews/) * 11 replies * 3 participants * Last reply from: [gVectors Support](https://wordpress.org/support/users/gvectorssupport/) * Last activity: [5 years, 11 months ago](https://wordpress.org/support/topic/comment-counter-problem-2/#post-13098831) * Status: resolved