Upgrade to 3.0 – Lost data No data so far

Viewing 15 replies - 1 through 15 (of 29 total)
  • Thread Starter TRDK29

    (@trdk29)

    If I change the view to “All-time” than PP do show up with data – in the widget. An it seems as it would count correctly – but only i “All-time” – no data in 24 hours etc.

    Plugin Author Hector Cabrera

    (@hcabrera)

    Hi TRDK29,

    Don’t worry, your data is not lost.

    Please answer the following:

    1. What version of the WPP plugin did you have before upgrading?
    2. Can you please check that the wpp_popularpostssummary table exists on your database?

    Also, does your theme have the wp_head() function on the <head> section?

    Thread Starter TRDK29

    (@trdk29)

    WP 3.9.1 and before upgrading the last version of your plugin.

    Before update I had 23 tables and still have 23 tables. There is no wpp_popularpostssummary table in the database

    I have:
    – wp_popularpostsdata
    – wp_popularpostsdatacache

    but no

    wpp_popularpostssummary

    Thread Starter TRDK29

    (@trdk29)

    …. and the version changes the the very nice layout that I had (Use custom HTML Markup)

    Plugin Author Hector Cabrera

    (@hcabrera)

    How odd. There should be a new DB table – that’s why the plugin is displaying “Sorry, no data so far”, the migration process didn’t occur or failed for some reason.

    In the meanwhile, you can either downgrade to 2.3.7, or run the following queries manually via phpmyadmin to create the new table and migrate the data:

    CREATE TABLE wp_popularpostssummary (
    ID bigint(20) NOT NULL AUTO_INCREMENT,
    postid bigint(20) NOT NULL,
    pageviews bigint(20) NOT NULL DEFAULT 1,
    view_date date NOT NULL DEFAULT '0000-00-00',
    last_viewed datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY  (ID),
    UNIQUE KEY ID_date (postid,view_date),
    KEY postid (postid),
    KEY last_viewed (last_viewed)
);

INSERT INTO wp_popularpostssummary (postid, pageviews, view_date, last_viewed)
SELECT id, pageviews, day_no_time, day
FROM wp_popularpostsdatacache
GROUP BY day_no_time, id
ORDER BY day_no_time DESC;

RENAME TABLE wp_popularpostsdatacache TO wp_popularpostsdatacache_backup;

    …. and the version changes the the very nice layout that I had (Use custom HTML Markup)

    This should not have happened. Are you sure the custom HTML has been changed and that it’s not a CSS issue?

    Thread Starter TRDK29

    (@trdk29)

    …. and than what? Upgrade to 3.0 again?

    Plugin Author Hector Cabrera

    (@hcabrera)

    If you run the queries, you don’t need to downgrade to 2.3.7.

    Edit: just tested downgrading to 2.3.7 and then ran the regular plugin upgrade, and for me the tables were created successfully. Can you please check that your database user has permissions to create / edit tables?

    Thread Starter TRDK29

    (@trdk29)

    I never had problems with creating tables (I am the owner of the site)

    Thread Starter TRDK29

    (@trdk29)

    AND:

    – Why do the plugin change the layout of the very nice layout that I had (Use custom HTML Markup)?

    Plugin Author Hector Cabrera

    (@hcabrera)

    As I said on my previous reply above: are you sure that the Custom HTML markup was changed, and that it’s not a CSS issue?

    I’m asking this because every time the plugin is updated, every file will be overwritten – including the wpp.css stylesheet, as stated on the FAQ:

    Each time WordPress Popular Posts is updated the wpp.css stylesheet gets reset and I lose all changes I made to it. How can I keep my custom CSS?
    Copy your modified wpp.css file to your theme’s folder, otherwise my plugin will use the one bundled with it by default.

    If this is not the case and your custom HTML markup was indeed modified, please confirm.

    Thread Starter TRDK29

    (@trdk29)

    I did get some support so it works again.

    Plugin Author Hector Cabrera

    (@hcabrera)

    Alright then, I’m marking this as resolved if it’s OK with you.

    Please, don’t hesitate to contact me again if you need help.

    I have the same problem…

    Although after the update to version 3.0 the plugin worked perfectly, today the 24 hours tab shows “Sorry. No data so far.”

    All the three tables wp_popularpostsdata, wp_popularpostsdatacache and wpp_popularpostssummary are exist in my database.

    Any ideas to fix the issue?

    Thanks in advacnce

    Plugin Author Hector Cabrera

    (@hcabrera)

    Hi drteddy,

    Sounds like a different issue for me. From the FAQ:

    I’m getting “Sorry. No data so far”. What’s up with that?
    There are a number of reasons that might explain why you are seeing this message: no one has seen or commented on your posts/pages since WordPress Popular Posts activation, you should give it some time; your current theme does not have the wp_head() tag in its <head> section, required by my plugin to keep track of what your visitors are viewing on your site; WordPress Popular Posts was unable to create the necessary DB tables to work, make sure your hosting has granted you permission to create / update / modify tables in the database.

    Could you please check that the wp_head() template tag is on your theme’s header.php?

    Hi… i just installed your plugin and worked well on my localhost theme, however, when I uploaded the “sorry no data to display appears”. I checked and the 3 plugin tables were created. On the dashboard I can see info from 7 days, 30 days and all the time, but no 24 hours. If I place it as a widget it works as well, but when I call it from my theme on the online version it does not work. I call it like this:

    <?php
    if (function_exists(‘wpp_get_views’))
    echo wpp_get_mostpopular(“cat=10”);
    ?>

    I generate the cat id with php from a query… i know this works well because it uses this same id to create the css class name and this works fine.

    I am using version 3.0.3 with wordpress 3.9.1, the site is at https://www.defotografosyfotos.com. The plugin has been running for one week now. Can you help me out please? I?l appreciate it a lot! Thanks…

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

Tags