What version were you running before installing version 1.5.1?
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!
Thread Starter
topas
(@topas)
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.
Thread Starter
topas
(@topas)
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?
Thread Starter
topas
(@topas)
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?
Thread Starter
topas
(@topas)
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!
- Download the script here.
- Backup your database!
- Unzip the contents from update.zip into your desktop.
- Via FTP, upload upgrade.php to your wordpress-popular-posts folder (eg. http://yoursite.com/wp-content/plugins/wordpress-popular-posts).
- Log in into your wp-admin area, and type this URL into your address bar: http://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.
