Upgrade to 3.0 – Lost data No data so far

Viewing 14 replies - 16 through 29 (of 29 total)
  • Plugin Author Hector Cabrera

    (@hcabrera)

    Hi jonsecu,

    Just read your comment and I’m a little confused. Honestly, I don’t understand what you tried to say hehe. Since that site’s in spanish language, I’m guessing you also speak it? How can I get in touch with you?

    Hi Héctor, first of all your plugin is amazing and for a long time works fine on my sites.

    But now i have the follow issue with him.

    My database crashes 1 week ago and after this the plugin never display the most popular posts, I verified every single piece of code on my site and seems right, your plugin to, however the tables of your plugin seems are not populating.

    I’ve tried to uninstall the plugin, erase the tables and install again, but not worked.
    And yes, I have a wp_head on header.

    My site is: https://www.fatosdesconhecidos.com.br/

    In my database are this two tables: wp_popularpostsdata and wp_popularpostssummary.

    Hope you can save my day.
    Best regards.

    – Godinho

    Plugin Author Hector Cabrera

    (@hcabrera)

    Hi Godinho,

    Are you using a caching plugin on your site, by any chance? If so please clear its cache, then WPP should start registering page views normally.

    Thanks man, it works.

    Hi Héctor,

    I have the same problem ‘Sorry. No data so far.’. I checked some things:

    – DB permissions ?
    – wp_head() in <head> of header ?
    – commented and view some posts ?

    But the plugin only shows and count the comments. What can I do?

    Thanks in advance.

    wpp_popularpostssummary was also missing in my database after the update to 3.0 but I can confirm that after running the queries above all time frames are working perfectly again.

    Thanks

    Hi Héctor,

    I have the same problem ‘Sorry. No data so far.’.
    In my database are this two tables: wp_popularpostsdata and wp_popularpostssummary only.
    and wp_head() in <head> of header ..

    *I don’t have any caching plugins installed

    Thanks

    Hi,

    I’m using this plugin for 2 months, all goes well.

    But today, it suddenly not working. It shows “sorry, no data” in 24hours, 7 days, 30 days and all-time

    I checked my databse, only have wp_popularpostssummary and wp_PopularPostsdata.
    I had wp_head() in my <head>

    Anything I can do to fix this?

    Hey all,

    apologies for hijacking the thread – hope that’s ok.

    I’ve just noticed I have the same problem as others, but I’ve only just noticed it and so it’s probably been like that for a while.

    when I try to look at the data for 24h, week etc, I get the ‘sorry, no data so far.

    I just checked my DB and I do have the wpp_popularpostssummary in my tables.

    The thing i’m not sure about is the “Also, does your theme have the wp_head() function on the <head> section?” – part.

    I have WP 4.0 installed with the Thesis 1.8.5 theme.

    Any help or assistance would be appreciated.
    my blog: https://www.unlimitedchoice.org

    Thanks.

    I’ve just noticed it’s been resolved so I’ll start a new thread.

    Thanks.

    Amit

    I’m having a similar problem after the update to 3.2.0.

    I have a widget set to show up to 5 posts from the last 30 days. It displayed 5 until the upgrade, now it only shows 3 posts.

    The problem seems to be in wordpress-popular-posts.php, line 1652:

    // ordered by views / avg
else {
  $from = "(SELECT postid, IFNULL(SUM(pageviews), 0) AS pageviews FROM {$prefix}summary WHERE last_viewed > DATE_SUB('{$now}', INTERVAL {$interval}) GROUP BY postid ORDER BY pageviews DESC {$limit}) v LEFT JOIN {$wpdb->posts} p ON v.postid = p.ID";

    The sub-select has {$limit}, limiting the sub-select results to 5. Then the outer select only returns 3 from this 5. If I remove {$limit} from the sub-select and add it to the outer query, it works as expected.

    Plugin Author Hector Cabrera

    (@hcabrera)

    Hi @timbonicus,

    Well, that is not really related to the topic of this thread but since we’re here let’s discuss it.

    I introduced that change with 3.2.0 looking to optimize the query. The general idea is to retrieve the top 10 viewed post IDs from the wp_popularpostssummary table and then join the result with the wp_posts table to get post title, post date, etc.

    What I don’t get from your comments is that the outer query returned 3 posts. Could you please share more details? For example, what options are enabled / disabled, filters used, etc.

    Thanks Héctor, sorry to hijack the topic.

    It appears that the “Post ID(s) to exclude” option is responsible for the mismatch. This gets applied in the outer where condition but not the sub-select. Some of the other exclusion conditions that get put into the where condition may be suspect as well (e.g. author).

    Plugin Author Hector Cabrera

    (@hcabrera)

    Ah, you may be right. I didn’t think of that. Damn. Well, for the time being I’ll just revert that change.

    Thanks for the insight!

Viewing 14 replies - 16 through 29 (of 29 total)
  • The topic ‘Upgrade to 3.0 – Lost data No data so far’ is closed to new replies.

Tags