Trying to prepopulate values

  • Resolved alob87

    (@alob87)


    8 years, 7 months ago

    I’ve installed the plugin and have edited the popularpostsdata table with values from google analytics, however, these values aren’t reflected in the stats view. Is there anyway to edit the table so the values are read by the plugin?

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Hector Cabrera

    (@hcabrera)

    8 years, 7 months ago

    It is being read by the plugin, check the Hall of Fame tab and you’ll see your data there.

    The chart above displays data from a separate table called [your-database-prefix-here]_popularpostssummary (which I should probably rename now to _popularpostslog for clarity). You’ll have to populate that one as well.

    Thread Starter alob87

    (@alob87)

    8 years, 7 months ago

    I updated both tables but still can’t see any data in my “most viewed” graph. I do however see the Hall of Fame stats.

    Plugin Author Hector Cabrera

    (@hcabrera)

    8 years, 7 months ago

    Hard to tell what might be happening without more details (eg. how did you populate each table? What do you see in the Stats section? PHP version? Et cetera.)

    Thread Starter alob87

    (@alob87)

    8 years, 7 months ago

    I have a production and staging version of the same WP site, I exported the two tables from production using PHPmyadmin and imported them to staging using the same. Nothing in the Stats section shows any data except for Hall of Fame and I can confirm both tables have data.

    I don’t have any log limits or or cache set in the WPP settings. I also used the settings to delete the tables and now only my Hall of Fame shows data, new views are not reflected in “Most Viewed”, regardless of the time frame selected.

    PHP version is: 5.4.45
    using Plesk
    WordPress 4.8.2 using a custom theme

    Plugin Author Hector Cabrera

    (@hcabrera)

    8 years, 7 months ago

    Ok:

    • Are the two databases in sync? (Same core WordPress tables, same data in them, etc). Otherwise the queries might not get results if the post IDs aren’t exactly the same as those in the wp_posts table.
    • None of the sites (production and staging) is showing statistics?
    • Please share screenshots of the summary table.
    Thread Starter alob87

    (@alob87)

    8 years, 7 months ago

    The issue is fixed, I:

    1. Cleared both the cache and data tables using the plugin settings
    2. Deactivated the plugin
    3. Deleted the tables using phpMyAdmin
    4. Imported the tables from production using phpMyAdmin
    5. Re-activated the plugin

      6. After that I was able to see data in all Stats views. I was also able to edit the tables from phpMyAdmin and see the changes reflected in my Stats views.

      Thank you very much for the support.

    Plugin Author Hector Cabrera

    (@hcabrera)

    8 years, 7 months ago

    How odd. Anyways, glad to know you got it working 🙂

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Trying to prepopulate values’ is closed to new replies.