%totalcount% off for few posts

Only way to go about this is to adjust the cntaccess field in the “tptn_” tables of the database.

However, please be careful if you intend to do so. And, always backup before making any changes

Hi Ajay,

Can you elaborate a little more for me. What do you mean when you say “adjust” the cntaccess field ? As i see, this issue seems to have started as soon as i upgraded & have been wrong for all new posts. If there is no work around please let me know.

You can look at all new posts at https://www.mtbr.com/ under ALL tab !

thanks,
Sravanthi

Do you still have “(Visited %totalcount% times, %dailycount% visits today)” under Output options?

By adjust I mean you’ll need to edit the entries within your database via phpMyAdmin.

Do you think you can share the extract of the tptn_ tables in your database with me (no other tables needed).

Yes, i didn’t edit output options. It’s the same.

Also, can you define extract ? Do you need a copy of the entire table ?
Can you work with few entries ?

wp_top_ten_Daily table :

postnumber cntaccess dp_date
58158 1 2013-03-07
57861 1 2013-03-07
59703 1 2013-03-07
74552 1 2013-03-07
1269 1 2013-03-07
12218 1 2013-03-07
74552 1 2013-03-07
62694 1 2013-03-07
15197 1 2013-03-07
74782 1 2013-03-07
74552 1 2013-03-07
72384 1 2013-03-07
74782 1 2013-03-07
74552 1 2013-03-07
74782 1 2013-03-07
15197 1 2013-03-07

wp_top_ten table :

postnumber cntaccess
27269 11309
27263 226
27111 3633
27254 87
8908 1763
6 34508
9 3157
10 6921
11 978
12 1232
13 32215
15 18425
27 2001
28 1835
30 403
32 1331
33 12
35 1596
36 14
37 1235

All New/recent posts have (Visited 1 times, xxx visits today)

https://reviews.mtbr.com/cratoni-back-in-the-usa-with-all-new-rocket-mtb-helmet

Having the same issues on my website

Oyekd :

Check if wp_top_Ten & wp_top_ten_daily tables have primary key set. We had to manually create new tables ( that set primary key) and then transfer “good” data to new tables. The INSERT query won’t work if you don’t have primary key set for those tables.

INSERT INTO $table_name (postnumber, cntaccess) VALUES(‘$id’, ‘1’) ON DUPLICATE KEY UPDATE cntaccess= cntaccess+1

Thanks … done it …will observe and give feedback

Thanks Sravsk. Was this issue when you upgraded?

Yes, the plugin was working fine ( although we had severe page load/database issues) before the upgrade. I speculate the primary key somehow got messed up while upgrade & so had to re-do it manually.