%totalcount% off for few posts

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 http://www.mtbr.com/ under ALL tab !

thanks,
Sravanthi

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)

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

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