hack4lk

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

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.

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.

gabrieljones, thanks for the hack….it worked perfectly and saved me tons of time!