WordPress.org

Ready to get started?Download WordPress

Forums

WordPress Popular Posts
Sorry, no data so far (16 posts)

  1. svehex
    Member
    Posted 2 years ago #

    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.

    http://wordpress.org/extend/plugins/wordpress-popular-posts/

  2. Héctor Cabrera
    Member
    Plugin Author

    Posted 2 years ago #

    Hi svehex,

    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?

  3. jbisenius
    Member
    Posted 2 years ago #

    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!

    bisi

  4. Héctor Cabrera
    Member
    Plugin Author

    Posted 2 years ago #

    jbisenius,

    What version of WordPress Popular Posts are you running now?

  5. jbisenius
    Member
    Posted 2 years ago #

    Hello again,

    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!

    bisi

  6. Héctor Cabrera
    Member
    Plugin Author

    Posted 2 years ago #

    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.

  7. jbisenius
    Member
    Posted 2 years ago #

    Yes. The sites where it is set up is http://www.cij.lu and cartejeunes.lu

    The screenshots are:
    http://cij.lu/wp-content/uploads/screenshot01.jpg
    http://cij.lu/wp-content/uploads/Screenshot03.png
    and here: http://cij.lu/wp-content/uploads/Screenshot02.png

    Thanks again for your time!

    bisi

  8. Héctor Cabrera
    Member
    Plugin Author

    Posted 2 years ago #

    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!

  9. BjoernNoel
    Member
    Posted 2 years ago #

    Dear Héctor,

    I got exactly the same issue with the latest version of WordPress.

    Kind regards
    Bjoern

  10. Héctor Cabrera
    Member
    Plugin Author

    Posted 2 years ago #

    Hi Bjoern,

    Can you please check that the wp_head() tag is present on your theme's header? If so, follow the instructions above.

  11. BjoernNoel
    Member
    Posted 2 years ago #

    Dear Héctor,

    wp_head() tag is present.
    I just dropped you a screenshot.

    Best
    Bjoern

  12. svehex
    Member
    Posted 2 years ago #

    It's been the same all along. The tables are missing. I assume I should reinstall the plugin?

  13. jbisenius
    Member
    Posted 2 years ago #

    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!

  14. Héctor Cabrera
    Member
    Plugin Author

    Posted 2 years ago #

    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.

  15. svehex
    Member
    Posted 2 years ago #

    Upgrading didn't help. I had to remove the plugin and install the latest version before the tables showed up.

  16. Héctor Cabrera
    Member
    Plugin Author

    Posted 2 years ago #

    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!

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic