Title: [Plugin: WordPress Popular Posts] Data Reset after Update Last modified: August 19, 2016 --- # [Plugin: WordPress Popular Posts] Data Reset after Update * [topas](https://wordpress.org/support/users/topas/) * (@topas) * [16 years, 10 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-data-reset-after-update/) * I updated WordPress Popular Post but now all stats are reseted. I have two tables in my Database: wp_popularpostsdata and wp_popularpostsdata_backup but i don´ t know how to get the old stats for my blog. All Blogentries now have 1 Pageview. Viewing 15 replies - 1 through 15 (of 55 total) 1 [2](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-data-reset-after-update/page/2/?output_format=md) [3](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-data-reset-after-update/page/3/?output_format=md) [4](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-data-reset-after-update/page/4/?output_format=md) [→](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-data-reset-after-update/page/2/?output_format=md) * [Héctor Cabrera](https://wordpress.org/support/users/ikki24/) * (@ikki24) * [16 years, 10 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-data-reset-after-update/#post-1145676) * What version were you running before installing version 1.5.1? * Thread Starter [topas](https://wordpress.org/support/users/topas/) * (@topas) * [16 years, 10 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-data-reset-after-update/#post-1145697) * 1.4.6 * [Héctor Cabrera](https://wordpress.org/support/users/ikki24/) * (@ikki24) * [16 years, 10 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-data-reset-after-update/#post-1145709) * 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](https://wordpress.org/support/users/topas/) * (@topas) * [16 years, 10 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-data-reset-after-update/#post-1145715) * 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. * [Héctor Cabrera](https://wordpress.org/support/users/ikki24/) * (@ikki24) * [16 years, 10 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-data-reset-after-update/#post-1145743) * 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](https://wordpress.org/support/users/topas/) * (@topas) * [16 years, 10 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-data-reset-after-update/#post-1145754) * 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 🙂 * [Héctor Cabrera](https://wordpress.org/support/users/ikki24/) * (@ikki24) * [16 years, 10 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-data-reset-after-update/#post-1145868) * Hi topas, * Can you please show me a screenshot of your wp_popularpostsdata_backup table? * Thread Starter [topas](https://wordpress.org/support/users/topas/) * (@topas) * [16 years, 10 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-data-reset-after-update/#post-1145877) * This is the first Page with the first entries. * [lanz](https://wordpress.org/support/users/lanz/) * (@lanz) * [16 years, 10 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-data-reset-after-update/#post-1145882) * 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. * [insultcomicdog](https://wordpress.org/support/users/insultcomicdog/) * (@insultcomicdog) * [16 years, 10 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-data-reset-after-update/#post-1145889) * 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? * [Héctor Cabrera](https://wordpress.org/support/users/ikki24/) * (@ikki24) * [16 years, 10 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-data-reset-after-update/#post-1145890) * 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](https://wordpress.org/support/users/insultcomicdog/): can you please send me a screenshot of what your wp_popularpostdata (the one created by the upgrade) looks like? * Thread Starter [topas](https://wordpress.org/support/users/topas/) * (@topas) * [16 years, 10 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-data-reset-after-update/#post-1145895) * My wp_popularpostdata after upgrade: * [wp_popularpostdata](http://www.topasweb.de/DB2.jpg) * last_viewed is new and all tables have no data * [colinabsolutely](https://wordpress.org/support/users/colinabsolutely/) * (@colinabsolutely) * [16 years, 10 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-data-reset-after-update/#post-1145910) * I’m having similar trouble. The backup table is there, and the new table (wp_popularpostdata) contains 0 records. Thanks in advance for help * [Héctor Cabrera](https://wordpress.org/support/users/ikki24/) * (@ikki24) * [16 years, 10 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-data-reset-after-update/#post-1145923) * 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](http://www.2shared.com/file/6769728/9ed77cba/upgrade.html). 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. [http://yoursite.com/wp-content/plugins/wordpress-popular-posts](http://yoursite.com/wp-content/plugins/wordpress-popular-posts)). 5. 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](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! * [Héctor Cabrera](https://wordpress.org/support/users/ikki24/) * (@ikki24) * [16 years, 10 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-data-reset-after-update/#post-1145924) * Sorry, double post by error. Viewing 15 replies - 1 through 15 (of 55 total) 1 [2](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-data-reset-after-update/page/2/?output_format=md) [3](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-data-reset-after-update/page/3/?output_format=md) [4](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-data-reset-after-update/page/4/?output_format=md) [→](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-data-reset-after-update/page/2/?output_format=md) The topic ‘[Plugin: WordPress Popular Posts] Data Reset after Update’ is closed to new replies. * 55 replies * 9 participants * Last reply from: [Héctor Cabrera](https://wordpress.org/support/users/ikki24/) * Last activity: [16 years, 2 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-data-reset-after-update/page/4/#post-1146134) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics