Shortcode, query… no longer working with Redis

  • Resolved ukutabs

    (@ukutabs)


    1 year, 7 months ago

    Hi there.

    I am on the latest version of the plugin (3.3.0) and have been using it in conjunction with Object Cache Pro (redis caching) successfully for years now.

    There have been some improvements to the Object Cache Pro plugin and going from 1.17 to 1.19, Top10 appears to be no longer compatible.

    I have reached out to Till (the developer of Object Cache Pro) and the response was:

    I’d suggest opening a forum support request with them, they might need to update their plugin to use WordPress function instead of SQL queries.

    For years I have been using shortcodes in the theme files like this:

    echo do_shortcode('[tptn_list limit="99" daily_range="1" daily="1"]');

    This no longer works, and also this:

    <?php if ( function_exists( 'tptn_show_pop_posts' ) ) { tptn_show_pop_posts(); } ?>

    Does not seem to work. Clearing all caches results in nothing as well. The posts are however still being tracked as I can see the daily popular lists in the admin dashboard backend. But not showing in the frontend.

    Any help would be greatly appreciated as the Top Views section is a very useful and popular one on the site an is now empty.

    https://ukutabs.com/top-99-ukulele-songs/by-views/all-time/

    Thank you very much in advance.

    Kind regards,

    Jonas.

    • This topic was modified 1 year, 7 months ago by ukutabs.
    • This topic was modified 1 year, 7 months ago by ukutabs.
    • This topic was modified 1 year, 7 months ago by ukutabs.
    • This topic was modified 1 year, 7 months ago by ukutabs.
Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Author Ajay

    (@ajay)

    The plugin uses WP_Query behind the scenes to pull the top posts out.

    Can you install Query Monitor and visit the page with the top posts and check the query or if there are any errors with Top 10?

    Also, does it work when you disable Object Cache Pro? It’s a paid plugin. So unfortunately I’m not able to test it myself.

    Thread Starter ukutabs

    (@ukutabs)

    Hi Ajay,

    I already appreciate you taking the time to respond immensely. Loyal user of the plugin for years. Thank you for that!

    It does indeed work when I disable it. It took a bit of trial and error disabling and enabling a few days ago, but Object Cache Pro seems to be the culprit. Once disabled, they immediately show up.

    There does appear to be an error using query monitor to troubleshoot:

    Unknown column 'visits' in 'order clause

    Seen this error before and perhaps an idea how to fix this?

    Thank you!

    Kind regards,

    Jonas.

    Plugin Author Ajay

    (@ajay)

    Thank you for being a long term user. It’s always great to know that as a plugin dev.

    On the error, it seems like OCP is stripping out the fields to only pull out the ID and nothing else. Visits is a field that is also pulled out from the database at the same time.

    Are you able to check the same query when you have OCP disabled? I believe it should work fine.

    If so, are you able to flag this to the support to ask them if there is a workaround? I think I might have a solution as well. Are you in a position to test a beta version if I spin it up?

    Thread Starter ukutabs

    (@ukutabs)

    It is a bit difficult to disable it now since it is the busiest time of the week and the site is relying quite heavily on object caching. I might be able to do it on Monday morning (it is Sunday evening now here).

    As of now I still have Top10 running to keep tracking, but there is no output. So for now I have nothing to loose and definitely would be willing to try a beta version!

    edit: Will definitely forward this to Till (OCP dev) as well.

    • This reply was modified 1 year, 7 months ago by ukutabs.
    Plugin Author Ajay

    (@ajay)

    Here’s the beta as well if you’d like to try it. I’ve changed the orderby clause to directly use the field instead of visits.

    https://github.com/WebberZone/top-10/releases/tag/v3.3.1-beta2

    Also, does it work when you disable Object Cache Pro? It’s a paid plugin. So unfortunately I’m not able to test it myself.

    You can use Redis Object Cache, it’s also a persistent object cache for WordPress.

    Plugin Author Ajay

    (@ajay)

    @tillkruess

    Thanks. I’ll check it out. Need to run redis on my server which I don’t have currently.

    In terms of the fields, by any chance does this override the posts_fields?

    Thread Starter ukutabs

    (@ukutabs)

    @ajay Just installed the beta, it works perfectly again! Wow, thank you so much. Just sent you a small donation for your help, it’s the least I can do.

    @ajay & @tillkruess You are one of the reasons why I love WordPress this much. Giving true personal support, really trying to help, and on a Sunday. Thank you.

    Plugin Author Ajay

    (@ajay)

    @ukutabs Thank you for confirming, your kind words and your donation! I’ll push this through into the final v3.3.1 release. I have two more changes to make.

    ?????

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Shortcode, query… no longer working with Redis’ is closed to new replies.