[Plugin: WordPress Popular Posts] Sorry, no data so far
I get “Sorry, no data so far” in all tabs, even though everything is as it should be, including the wp_head tag. The plugin has been active for a couple of weeks, so something should be showing.
It’s been like that since you installed the plugin, or just in the past few days? Can you check that the tables wp_popularpostsdata and wp_popularpostsdatacache are installed in your database?
Hello Héctor and svehex,
I had the plugin doing ok, just before a serious server crash, where I lost all of my installs… so I redid the whole thing, but no matter what I try now, I cannot seem to get it to record visits?
The two fields are in the database, and are being populated. It is a multisite install.
Any suggestions? Thanks!
What version of WordPress Popular Posts are you running now?
It’s version 2.2.1 actually… I added the line the other user suggested last week, and that didn’t do it either… and it has all in all been running and recording for 2 weeks I’d say… logged in and not logged in…
Thanks for the help!
Ok, to summarize: tables are there in your database and are being populated, still you keep getting “Sorry no data so far”? Am I right?
Can you please share a screenshot of your settings so I can test them here? Also, if possible, please post your site’s URL so I can take a look at your theme’s code.
Just checked your site, everything looks in place so let’s try something else. Please, open wordpress-popular-posts.php using a text editor such as Notepad or Dreamweaver, find this code (around line 624):
//echo "SELECT $wpdb->posts.ID, $wpdb->posts.post_title $fields FROM $wpdb->posts $join WHERE $wpdb->posts.post_status = 'publish' AND $wpdb->posts.post_password = '' AND $range $force_pv $nopages $exclude GROUP BY $wpdb->posts.ID ORDER BY $sortby DESC LIMIT " . $instance['limit'];
… and uncomment it:
echo "SELECT $wpdb->posts.ID, $wpdb->posts.post_title $fields FROM $wpdb->posts $join WHERE $wpdb->posts.post_status = 'publish' AND $wpdb->posts.post_password = '' AND $range $force_pv $nopages $exclude GROUP BY $wpdb->posts.ID ORDER BY $sortby DESC LIMIT " . $instance['limit'];
Save changes. Then, a line of code should show on your homepage, right before the “Sorry, no data so far” text. Get a screenshot of that and email it to me: hcabrerab at gmail so I can see the output. Oh, remember to comment back that line of code as well!
I got exactly the same issue with the latest version of WordPress.
Can you please check that the wp_head() tag is present on your theme’s header? If so, follow the instructions above.
wp_head() tag is present.
I just dropped you a screenshot.
It’s been the same all along. The tables are missing. I assume I should reinstall the plugin?
Actually, for me it all seems to be working now. The error was numbers per plugin in the database tables that WP Multisite created, it seems.
I am quite sure this is what I did to make it work. I installed the plugin in Network Admin, then activated the plugin in each site, and then Network activated it. It works now. For all of them… (cij.lu etc)
Could well be it only all along had to be network activated though…
Thanks for your help Hector, and hope this can help the others that are still struggling!
Thanks for posting, jbisenius! I’m sure that others will appreciate the info!
@svehex: in your case, upgrading to the latest version should be enough to create the tables for you since my plugin checks for the existance of these on activation, and if found missing it’ll try to create them. Give that a try and let me know.
Upgrading didn’t help. I had to remove the plugin and install the latest version before the tables showed up.
I see. Probably just by deactivating and reactivating the plugin it would have worked as well. I thought that on upgrade WordPress would do that automatically but it appears that it doesn’t.
Anyways, good to know that everything’s doing good now!
- The topic ‘[Plugin: WordPress Popular Posts] Sorry, no data so far’ is closed to new replies.