Sravsk

Hi there, sorry couldn’t reply earlier.
Yes, the plugin seems to be working as expected. I tried testing across all browsers on dev and staging environments.
I know this might be out of context, but do you know how to get this working with pure html, css and javascript/jquery ? I am trying to have a sticky sidebar ad on non-WP platform as well.

thank you for all your help!

Hello there,

Updated the plugin but the issue still persist. Can you please take another look ?

Sure, sounds good.

Yes, i was able to figure it out. The problem was the total count & daily count were displaying same number

(Visited 1,752 times, 1,752 visits today)

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.

Never mind, i figured it out.

Daily Popular should contain views of how many days? had to be set to 0.

thanks!

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

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

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

Can some one please help me with this ?