Plugin Author
Ajay
(@ajay)
Can you please explain by what you mean by restarts? Is it the Total Count?
Can you check if the PRIMARY KEY exists in the wp_top_ten table?
It resets the count.
How and where can I see this primary key?
This is an image with counts of post views now.
http://prntscr.com/k3spes
I’ll send you another one when you start counting again.
Plugin Author
Ajay
(@ajay)
Can you go to Top 10 > Tools > Merge Duplicates across blog IDs
You can also recreate the Primary Key there
https://ps.w.org/top-10/assets/screenshot-9.png?rev=1820156
Still giving an error. The counts always restart.
Top 10 plugin: http://prntscr.com/k40qg9
Jetpack: http://prntscr.com/k40r35
How to identify primary key in phpmyadmin?
Plugin Author
Ajay
(@ajay)
In phpMyAdmin, you should be able to see the primary key at the bottom when browsing the structure of wp_top_ten
Also, can you check if the table has duplicate entries for the wp_top_ten table for a post type?
I did not find the primary key. And I do not know if it’s duplicating because it’s not recording the views.
End of table wp_top_ten
http://prntscr.com/k4fmz0
There are two tables of the plugin: wp_top_ten and wp_top_ten_daily. That’s right?
http://prntscr.com/k4f7u2
Plugin Author
Ajay
(@ajay)
Yes that is correct – there are two tables – one for all-time and one for the day.
Can you check in “Estructura” and at the bottom you should see a section (sometimes hidden) where you have the primary keys.
One extreme option to do is to export the contents of both these tables via mySQL and then uninstall and reinstall Top 10. Make sure when you uninstall it, both tables are deleted from the database.
Hi, sorry for the delay. But that last solution did not work, can you tell me what else I can do?
Plugin Author
Ajay
(@ajay)
Did you try a complete delete and reinstall after exporting your data?
If you have the latest version of the plugin, you should be able to see the code to run in phpMyAdmin in your Top 10 > Tools page. Can you run these and try again.
Another option to debug is to export the contents of the wp_top_ten and the wp_top_ten_daily tables in mySQL. Then delete both the tables. The plugin should try to recreate the tables post which you can reinstall the data by importing the contents (not structure) in phpMyAdmin.
Also can you try using the other tracker within the Settings?
