Yet another No data problem

  • Resolved rambletype

    (@rambletype)


    7 years ago

    I’m also getting the “Sorry. No data so far.” error on this site:
    https://www.adventure-journal.com/2017/11/rocky-mountain-national-park-ready-closeup/

    Debug tab gives this:
    PHP version: 7.0.23

    PHP extensions: Core, date, libxml, openssl, pcre, sqlite3, zlib, apcu, bcmath, bz2, calendar, ctype, curl, dom, hash, fileinfo, filter, ftp, gd, gettext, gmp, SPL, iconv, imagick, session, json, ldap, mbstring, mcrypt, standard, mysqlnd, OAuth, odbc, mysqli, PDO, pdo_mysql, pdo_pgsql, pdo_sqlite, pgsql, Phar, apm, redis, Reflection, imap, shmop, SimpleXML, soap, sockets, exif, tokenizer, wddx, xml, xmlreader, xmlwriter, xsl, zip, cgi-fcgi, Zend OPcache

    Database version: 10.0.23-MariaDB-log

    InnoDB availability: DEFAULT

    WordPress version: 4.8.3

    Multisite: No

    Active plugins: Advanced Custom Fields PRO 5.5.9, Akismet Anti-Spam 4.0, Artbees Themes Captcha 1.0, Blackhole for Bad Bots 1.7.1, Canonical Seo WordPress Plugin 2.1, Contact Form 7 4.9, Duplicate Post 3.2, Edit Flow 0.8.2, FV Player 6.3.6, Go Live Update URLS 4.1.4, Google Analytics Dashboard for WP (GADWP) 5.1.2, Imsanity 2.3.9, Monarch Plugin 1.3.2, NextScripts: SNAP Pro Upgrade Helper 1.4.4, NextScripts: Social Networks Auto-Poster 4.0.7, OptinMonster API 1.2.2, Pantheon Migration 1.48, Polldaddy Polls & Ratings 2.0.34, Post Duplicator 2.20, Q2W3 Fixed Widget 5.0.4, Really Simple CAPTCHA 2.0.1, Redirection 2.8.1, Remove WooCommerce Password Strength 1.0, Show Current Template 0.3.0, Smart Offers 3.2.8, Users Insights 3.1.1, WooCommerce 2.6.14, WooCommerce – ShipStation Integration 4.1.7, WooCommerce Email Test 1.8, WooCommerce jQuery Cookie Fix 1.0, WooCommerce Quantity Increment 1.1.0, WooCommerce Remove Variation “From: $XX” Price 1.0, WooCommerce Stripe Gateway 3.0.7, WooCommerce Subscribe to Newsletter 2.3.7, WooCommerce Subscriptions 2.1.3, WooCommerce Subscriptions CSV Importer and Exporter 2.0-beta, WooCommerce Table Rate Shipping 3.0.2, WordPress Popular Posts 4.0.11, WP-Optimize 2.1.1, WPBakery Visual Composer (Modified Version) 5.0.2, WP Migrate DB Pro 1.8, WP Migrate DB Pro Media Files 1.4.8, WP Missed Schedule 2014.1231.2016.7, WP RSS Images 1.1, Yoast SEO 5.7.1

    Theme: Jupiter Child Theme (5.0.10) by Your name here

    The page I need help with: [log in to see the link]

Viewing 14 replies - 1 through 14 (of 14 total)
  • Thread Starter rambletype

    (@rambletype)

    Here’s a screenshot of my wp_popularpostssummary:
    https://www.adventure-journal.com/wp-content/uploads/2017/11/screen-shot-2017-11-06-at-11.00.01-am.jpg

    Plugin Author Hector Cabrera

    (@hcabrera)

    Hey @rambletype!

    Here’s a screenshot of my wp_popularpostssummary:
    https://www.adventure-journal.com/wp-content/uploads/2017/11/screen-shot-2017-11-06-at-11.00.01-am.jpg

    It seems WPP was unable to complete the upgrade process, or else the structure of your summary table would look a little bit different ??

    I’m going to push a new update in a moment which I believe should fix that problem. If after upgrading to 4.0.12 you’re still having issues with WPP please leave a comment here and I’ll take another look, alright?

    Thread Starter rambletype

    (@rambletype)

    Thanks!!

    Plugin Author Hector Cabrera

    (@hcabrera)

    Done! Please update once you get the notification and let me know if you have any problems with the plugin ??

    Thread Starter rambletype

    (@rambletype)

    No luck–still not showing anything.

    Thread Starter rambletype

    (@rambletype)

    https://www.adventure-journal.com/wp-content/uploads/2017/11/screen-shot-2017-11-06-at-12.41.25-pm.jpg

    Plugin Author Hector Cabrera

    (@hcabrera)

    How odd. Let’s try the manual way then:

    1. Log in to your hosting’s control panel.
    2. If you don’t have a recent backup of your site (files, database) now would be a good chance to get one.
    3. Go to phpmyadmin (or whatever your hosting uses to let you manage the database) and run the following queries: 
      ALTER TABLE wp_popularpostsdata ALTER COLUMN day DROP DEFAULT;
ALTER TABLE wp_popularpostsdata ALTER COLUMN last_viewed DROP DEFAULT;
ALTER TABLE wp_popularpostssummary CHANGE last_viewed view_datetime datetime NOT NULL, ADD KEY view_datetime (view_datetime);
ALTER TABLE wp_popularpostssummary ALTER COLUMN view_date DROP DEFAULT;
ALTER TABLE wp_popularpostssummary DROP INDEX ID_date, DROP INDEX last_viewed;

    Please let me know how it goes.

    Thread Starter rambletype

    (@rambletype)

    I’m getting a key error on the posts summary table. Can you give me the correct create table syntax for that table? I’ll just re-create it

    Plugin Author Hector Cabrera

    (@hcabrera)

    Try this:

    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,
 view_datetime datetime NOT NULL,
 PRIMARY KEY (ID),
 KEY postid (postid),
 KEY view_date (view_date),
 KEY view_datetime (view_datetime)
) ENGINE=InnoDB;
    Thread Starter rambletype

    (@rambletype)

    That worked!

    youdidnt

    (@youdidnt)

    Hey it doesn’t work. It just randomly stopd count viewers.

    View post on imgur.com


    Your fix tips didn’t work for me.
    “ALTER TABLE wp_popularpostssummary CHANGE last_viewed view_datetime datetime NOT NULL, ADD KEY view_datetime (view_datetime)”
    #1054 – unknown column ‘last_viewed’ in wp_popularpostssummary
    My Plugins: Advanced Ads, Fast Velocity Minify, Nginx Cache, OneSignal Push Notifications, SSL Insecure Content Fixer, WP Fastest Cache, Yoast SEO

    • This reply was modified 7 years ago by youdidnt.
    Plugin Author Hector Cabrera

    (@hcabrera)

    Hi @youdidnt,

    Yours isn’t necessarily the same problem the OP had, so please:

    1. Open a new topic, and
    2. Share as much details as you can (your site’s URL, plugin version, PHP version, active plugins, etc) so I can help you out.

    Hey @hcabrera
    I don’t want to share public any details about my website (too sensitive). It’s possible to contact with you via email?
    It still didn’t count viewers.

    Plugin Author Hector Cabrera

    (@hcabrera)

    Hey @youdidnt,

    Use the contact form on my website (see profile) to get in touch with me.

Viewing 14 replies - 1 through 14 (of 14 total)
  • The topic ‘Yet another No data problem’ is closed to new replies.