topas

Yes your script gave me the idea and the amount of data is small sized. ?? So i do it manually.

Thank you again!

Hey Ikki … i write out all entries (56 Pages á 30 Entries) and sum them up … i make new entries in wp_popularpostsdata with this data and the number of pageviews of each postid. I have 91 postID′s (my Blog exists since may … a new blog) and i made it in the last hour. Now the Data is ready, correct and live.

Thank′s for your great support!!! I hope this was the last time, i make you crazy with my Problems. ??

I′m happy that my Blog has only 56 Pages and not 500 … then your script will be the best solution.

The table wb_wpptemp now exists in my Database.

I′m not a coder or somebody like this, but this line of your script:
$wpdb->query(“CREATE TABLE wp_wpptemp ( UNIQUE KEY id (postid), postid int(10) NOT NULL, day datetime NOT NULL default ‘0000-00-00 00:00:00’, last_viewed datetime NOT NULL default ‘0000-00-00 00:00:00’, pageviews int(10) default 1 )”);

has been done.

You are great …. thanks … and Enjoy your meal ??

I made the force_upgrade but no changes …. You do not have sufficient permissions to access this page.

no … https://www.topasweb.de/wordpress/wp-admin/options-general.php?page=wordpress-popular-posts/recovery.php

this is my url

Edit: It′s a german Version of WP at the moment, i could change it to englisch if you want

Yes … https://www.myurl.de/wordpress/wp-admin/options-general.php?page=wordpress-popular-posts/recovery.php yes ??

The same message again:

You do not have sufficient permissions to access this page.

*grml* ??

Yes i have

The same message:

You do not have sufficient permissions to access this page.

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.

My wp_popularpostdata after upgrade:

wp_popularpostdata

last_viewed is new and all tables have no data

This is the first Page with the first entries.

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 ??

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.