Latest update “Sorry, no data available”

  • Resolved Madera

    (@maderacity)


    6 years, 7 months ago

    Today I noticed that my “Most Requested” page was no longer working. Though I could see that data was still being tracked properly, the front end display just showed “Sorry. No data available”

    I tried deleting the plugin (latest version) and doing a fresh install, but this did not correct the issue, though it seemed to be tracking data fine (according to the plugin settings page).

    Logging into phpmyadmin, I see issues with the following tables: 

    wp_popularpostsdata
wp_popularpostssummary

    Deleting the plugin and installing version 4.1.0 appears to work fine, in terms of showing popular pages on the front-end (using shortcodes). Though I still show the following warnings in phpmyadmin:

    Warning in ./libraries/sql.lib.php#613
 count(): Parameter must be an array or an object that implements Countable

Backtrace

./libraries/sql.lib.php#2128: PMA_isRememberSortingOrder(array)
./libraries/sql.lib.php#2079: PMA_executeQueryAndGetQueryResponse(
array,
boolean true,
string 'com',
string 'wp_popularpostssummary',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM <code>wp_popularpostssummary</code>',
NULL,
NULL,
)
./sql.php#221: PMA_executeQueryAndSendQueryResponse(
array,
boolean true,
string 'com',
string 'wp_popularpostssummary',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM <code>wp_popularpostssummary</code>',
NULL,
NULL,
)

    Any advice on how to resolve would be much appreciated.

    • This topic was modified 6 years, 7 months ago by Madera. Reason: added info

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

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

    (@hcabrera)

    Hey @maderacity,

    Just checked your Most Requested page and the plugin seems to be working normally.

    Regarding the error message you’re seeing in phpmyadmin, it doesn’t seem directly related to the plugin: phpmyadmin – count(): Parameter must be an array or an object that implements Countable.

    Thread Starter Madera

    (@maderacity)

    @hector

    I installed the older version of the plugin (4.1.0) and it began working again.

    Thread Starter Madera

    (@maderacity)

    @hcabrera – thanks for pointing out that link. I updated phpmyadmin and those warnings are now gone. I went ahead and updated WPP again to see if it was still having trouble, unfortunately it is.

    “Sorry. No data so far.”

    I have no caching plugin installed… considering 4.1.0 works great, what has changed that may have caused this? I will leave v4.1.1 up for a while so you may take a look.

    4.1.1
If you’re using a caching plugin, flushing its cache right after installing / upgrading to this version is highly recommended.

Improves compatibility with Cloudflare’s Rocket Loader.
Code cleanup.
Fixes a minor bug (plugin returning the wrong excerpt when a translation plugin is used).
Bumps minimum required PHP version to 5.3.
    Plugin Author Hector Cabrera

    (@hcabrera)

    Hey @maderacity,

    I don’t see anything in the changelog from 4.1.1 that could break your page. All changes, with the exception of “Bumps minimum required PHP version to 5.3.”, are minor changes that should be harmless.

    Let’s go with the basics. Please:

    1. Enable WordPress’ debug log and share any warning / error messages you may find in there (upload it to pastebin.com, don’t share it here).
    2. Go to Settings > WordPress Popular Posts.
    3. Add &tab=debug to the address bar of your browser and hit enter.
    4. Share the contents of your Debug screen here.
    Thread Starter Madera

    (@maderacity)

    @hcabrera

    Pastebin of WP Debug Log: https://pastebin.com/gY4dXEPk
    Pastebin of WPP Debug: https://pastebin.com/i6qkuWfu

    Plugin Author Hector Cabrera

    (@hcabrera)

    Thanks!

    Alright, next:

    1. Disable all plugins, except for WPP.
    2. Go back to your “Most Requested” page. Is the issue still present? If the answer is no, then proceed to the next step.
    3. Enable one of the other plugins and go back to step 2.

    If one of your plugins is the cause of the issue, please let me know which one so I can try to replicate the issue.

    If the problem persists even with all of the other plugins disabled, we’ll try something else.

    Thread Starter Madera

    (@maderacity)

    @hcabrera

    Even with all plugins disabled (except WPP):

    “Sorry. No data so far” with the latest version of WPP. Tried switching themes to Twenty Seventeen, the issue persists ??

    Thank for all of your help with this by the way!

    • This reply was modified 6 years, 7 months ago by Madera.
    Plugin Author Hector Cabrera

    (@hcabrera)

    Damn. Alright, please get in touch with me. Let’s continue this over e-mail.

    And don’t mention it ??

    Thread Starter Madera

    (@maderacity)

    Done. Thanks again ??

    Plugin Author Hector Cabrera

    (@hcabrera)

    For those of you folks stumbling into this topic in the future: the issue was that the OP was using a shortcode to list the most popular pages of their site. On version 4.0.13 (the one they were using before upgrading), if you don’t specify the post type (eg. [wpp post_type="page"]) the shortcode will by default retrieve popular posts & pages (which did the work for the OP).

    After version 4.1.0 (I think), the default post type of the shortcode was changed to just post, and since OP’s site is listing pages only the shortcode returned an empty list (didn’t find any popular “posts”), hence the “Sorry, no data so far” message.

    The solution: use the post_type parameter to set the desired post type to display if it’s not post.

    [wpp post_type="page" range="last30days"]

    I’m glad it was an easy fix, and thankful to the OP for being so cooperative!

    Thread Starter Madera

    (@maderacity)

    For anyone wondering, thanks to some insanely great support, Hector discovered that we needed to modify our shortcode to include the parameter:

    post_type="page"

    The plugin is called “WordPress Popular Posts”, but the way our website is set up, we only used it to display our most popular pages. A change introduced in versions >4.0.13 changed a default behavior that required a need to modify our shortcode parameters to continue using the plugin in the way that we do.

    Thanks again for all your help, Hector. You are the MAN!

    Hector beat me to laying out the conclusion, check out his post above. ??

    • This reply was modified 6 years, 7 months ago by Madera. Reason: beat me to it
    • This reply was modified 6 years, 7 months ago by Madera.
Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Latest update “Sorry, no data available”’ is closed to new replies.