Plugin Author
Ajay
(@ajay)
nocotytato, that sounds strange indeed. the way the plugin works is that it is one record per day in the tptn total table and the one record per hit in the daily table.
In my new site it’s one record per post in the total table and one record per post per day in the daily table… In which table should it be one record per hit?
Plugin Author
Ajay
(@ajay)
wp_top_ten should have the one record per post
wp_top_ten_daily should have one record per combination of post+date.
SO it’s OK on the small site. On the bigger one something went wrong. What would you advice me? Should I reinstall top10? Is there something, I should check?
Plugin Author
Ajay
(@ajay)
By Big site you mean your original site?
It could be that the upgrade failed. Can you tell me what columns do you have in the 2 tables of the site?
Sure ๐
postnumber,cntaccess,dp_date in wp_top_ten_daily
postnumber,cntaccess in wp_top_ten
exactly the same as on the other site…
Plugin Author
Ajay
(@ajay)
So, the upgrade was fine. Ok, can I take a look at your sites so that I can try debugging what I can by loading pages / counts.
Sure,
The bigger one is http://nocotytato.org.pl
The smaller one is http://mateusz24.eu
How can I help with debugging? What do you need from my side?
Plugin Author
Ajay
(@ajay)
Yes, that’s right. However, it works like you see becouse I made some midifications to the php files. On the one displaying TopTen counters it used to work that way, that the daily (which is 7 days curently) counter increased and the total counter not. First I used to enter few times a day into the MySql interface and run a query, which summed entries in the tabels to make it like it should be:
wp_top_ten should have the one record per post
wp_top_ten_daily should have one record per combination of post+date.
After i modified the sql queries in php files, is started to sum betwen the database and display, so it’s fine. Almost. n the backend I still see the total display not summed. So i need to run the query manually sometimes to have proper data. Otherwise I would have alwas something like Total / Today’s Views – 1/35. And the second would grow after each view, but the total would be still 1.
In other words… the problem is with the counter, which I didn’t touch. I did touch the display mechanism, which was easier for me to understand. Do you think, I should try to remove Top Ten (after backing up data) and install it once again? Could it help somehow?
Post Scriptum.
The other site (the smaller) is quite new and there’s no reason to show views (as almost nobody visits it). I’ll let Top Ten display stats, when I’ll get some more readers. But I can make some observations on how the plugin works, as it’s collecting data all the tmie ๐
Plugin Author
Ajay
(@ajay)
Can you backing up the db, doing the uninstall and delete from within WP and reinstall.
Just the two tables? Sure I’ll do this evening and let you know ๐
Plugin Author
Ajay
(@ajay)
You’ll need to do the Delete Plugin from within WP Dashboard for a clean uninstall.
I suggest backing up the whole DB
Incredibile… ๐
I backed up tables (I do a full backup of DB every day, so I did not special now) removed plugin (deleting files), installed plugin again, imported data to tables, saved settings of plugin (they were still there from some cache I think. And… Now it looks like it worked fine. We’ll see, what will happen with other plugins ๐ But for the moment it’s like a miracle…
