totalcount not updating

I just took a look and it seems that now for every page visit there is one new entry in the wp_top_ten table as opposed to be before there was 1 entry per post where the visits was the total count.

What’s your site URL?

Also, what are you seeing the wp_top_ten table when there is a visit? This should record the post ID along with the hit and increment the count for the same post every time it is refreshed.

The site is internal so I can’t share the url but every time there is a visit, there is another entry added in the top_ten table with the same post id and a value of 1 for the count. For now as a workaround we added SUM() to the column name query in the plugin code so it sums up the entries but that’s a workaround we’d like to not use. I understand after looking at the code that on duplicate key it’s suppose to increment the count but it looks like it’s not seeing a duplicate key and just adding a new entry into the table.

There might be something wrong with the install as the plugin only adds a new entry if a post ID isn’t already there.

You can use the Top 10 > Tools to recreate the tables.

Alternatively, if you’re okay to lose the data for now, I’d suggest uninstalling the plugin and also deleting the wp_top_ten and wp_top_ten daily tables.

Ok, we’ll take a look. We definitely can’t lose years of data but we’ll look to recreating the tables. Thank you.

You can backup the counts from the Tools page before making any changes.

And, of course backup your wp_top_ten and wp_top_ten_daily tables directly before making any changes as an additional backup.

The recreating tables option in the settings page attempts to backup counts before making any changes, but as always I recommend backing up databases before any changes to them.