[Plugin: WordPress Popular Posts] Data Reset after Update

What version were you running before installing version 1.5.1?

1.4.6

How odd. I suspect this has something to do with your host as I just upgraded to 1.5.1 and didn’t lose my stats. Can you please tell me what’s your MySQL version?

Thanks in advance for your help!

MySQL Version: 4.0.24

Sorry, my englisch is not the best … i try to do my best to give you the Informations.

The wp_popularpostsdata has no entries. So i have no data. I import the Data from the wp_popularpostsdata_backup to the wp_popularpostsdata and now all Posts have 1 Pageview.

Topas, just out of curiosity, please try this: deactivate the plugin and reactivate it again. Next, check phpmyadmin to see if the table wp_popularpostsdata has been populated with the right data.

How can I explain it in English …. hmmm …

1. 4 1/2 hours ago I updated your Plugin. My old Data was saved at wp_popularpostsdata_backup and wp_popularpostsdata was empty

2. Sorry, no Data so far. I deactivate and reactivate, nothing happened -> Sorry, no data so far

3. I import the data from wp_popularpostsdata_backup to wp_popularpostsdata and every Post now have 1 Pageview

4. Every Post have alot of entries in Database. Every Pageview have it′s own entry. My first Post have e.g. 10 Database entries. Every Entry have in the Pageview Table the Number 1. If i change this 1 to another number e.g. 10 … the plugin write out this Number in the widget

5. I delete the wp_popularpostsdata table and i install the plugin new … now i have a clear wp_popularpostsdata with no data

6. I deactivate and reactivate and nothing happened … no data so far

I hope you know what i have done ??

Thanks for your Help ??

Hi topas,

Can you please show me a screenshot of your wp_popularpostsdata_backup table?

This is the first Page with the first entries.

Hi Ikki24,
I got the same problem as well. The data has been reset
My SQL version is 5.0.51a
Before I update to 1.5.1, I got 1.4.6 running well.

Please help. I know nothing about SQL. However,
table in wp_popularpostsdata_backup is still there.
Appreciate your help.

Hi Ikki24,

So my data was reset as well…I can see my backup table still there? Can you walk you walk us through a restore process?

Yes, WPP creates a backup table right before upgrading so your data is still there. I’m still thinking of a way to make it simple for you guys to restore your data.

@insultcomicdog: can you please send me a screenshot of what your wp_popularpostdata (the one created by the upgrade) looks like?

My wp_popularpostdata after upgrade:

wp_popularpostdata

last_viewed is new and all tables have no data

I’m having similar trouble. The backup table is there, and the new table (wp_popularpostdata) contains 0 records. Thanks in advance for help

OK guys, I created a little script to help you restore the data from wp_popularpostsdata_backup. Please read carefully and follow the instructions described below:

Warning: I strongly advise to backup your database before doing this! Also, this script does no validations – it will just attempt to recover the data from wp_popularpostsdata_backup, so try this under your responsibility!

1. Download the script here.
2. Backup your database!
3. Unzip the contents from update.zip into your desktop.
4. Via FTP, upload upgrade.php to your wordpress-popular-posts folder (eg. https://yoursite.com/wp-content/plugins/wordpress-popular-posts).
5. Log in into your wp-admin area, and type this URL into your address bar: https://yoursite.com/wp-admin/options-general.php?page=wordpress-popular-posts/upgrade.php (please replace yoursite.com with your actual url!) to run the script.

Again, I cannot guarantee that this will work for everybody as this is only a experimental script. If you run into any problems while running it please let me know.

Good luck!

Sorry, double post by error.