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.
[Plugin: Wordpress Popular Posts] Data Reset after Update (51 posts)
-
Topas
Posted 4 months ago # -
Ikki24
Posted 4 months ago #What version were you running before installing version 1.5.1?
-
Posted 4 months ago #1.4.6
-
Posted 4 months ago #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!
-
Posted 4 months ago #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.
-
Posted 4 months ago #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.
-
Posted 4 months ago #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 :-)
-
Posted 4 months ago #Hi topas,
Can you please show me a screenshot of your wp_popularpostsdata_backup table?
-
Posted 4 months ago # -
lanz
Posted 4 months ago #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
Posted 4 months ago #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?
-
Posted 4 months ago #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?
-
Posted 4 months ago #My wp_popularpostdata after upgrade:
last_viewed is new and all tables have no data
-
colinabsolutely
Posted 4 months ago #I'm having similar trouble. The backup table is there, and the new table (wp_popularpostdata) contains 0 records. Thanks in advance for help
-
Posted 4 months ago #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!
-
Posted 4 months ago #Sorry, double post by error.
-
Posted 4 months ago #I get a message like:
Access denied
P.S. Wordpress Version 2.8.2 atm.
EDIT:
In the English Version i get this message:
You do not have sufficient permissions to access this page.
-
Posted 4 months ago #Must be a new feature on Wordpress 2.8. Please rename upgrade.php to something else, upload it to your server and run the script again!
Edit: here's the file again. Follow the instructions as described above, and run the script using this url:
-
Posted 4 months ago #The same message:
You do not have sufficient permissions to access this page.
-
Posted 4 months ago #I think that is due to Wordpress user permissions. Do you have admin access to your blog, Topas?
-
Posted 4 months ago #Yes i have
-
Posted 4 months ago #Rename upgrade.php to something else (eg. recovery.php) and try running the script again.
-
Posted 4 months ago #The same message again:
You do not have sufficient permissions to access this page.
*grml* ;-)
-
Posted 4 months ago # -
Posted 4 months ago # -
Posted 4 months ago #That domain is parked, is that your url?
-
Posted 4 months ago #this is my url
Edit: It´s a german Version of WP at the moment, i could change it to englisch if you want
-
Posted 4 months ago # -
Posted 4 months ago #I made the force_upgrade but no changes .... You do not have sufficient permissions to access this page.
-
Posted 4 months ago #I have lost all ideas for now... I'll come back after lunch (hopefully with a fresher brain) and try to help you out with this.
Reply »
You must log in to post.
