Support » Plugin: TablePress » How to disable the cache?

  • Resolved Arkona

    (@arkona)


    Hello, Tobias!
    After upgrading WordPress to version 4.6 had a problem. Tables with the public side of the site is not updated. Update only after disabling the cache in the shortcode. Tables on the site a lot.
    How to disable the cache TablePress for all tables?

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

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    That would be really strange. I can’t imagine that this problem was caused by the update. I assume that something in the database is not working correctly.

    To turn off the TablePress caching in all tables at once, you can use the TablePress Extension https://tablepress.org/download/extension/tablepress-turn-off-output-caching.zip
    Just download, install, and activate this as a new plugin.

    Regards,
    Tobias

    The sequence is as follows:
    Updated WordPress to 4.6.
    I change the data in the table. For the administrator data are updated, and the public side of the site.
    I went to the site as a user without authorization. These date were old.
    I came in as an administrator. Clear Caches, caching plugins deactivated.
    The data in the table for the unauthorized user were old.
    The shortcode the table on the page included the line “cache_table_output =” false “”.
    The data in the table for the unauthorized user were new..
    Including caching plugins.
    The data in the table for the unauthorized user were new.
    What to do, what would understand the reason?

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    I assume that TablePress can not properly update the cached version of the table, so that always an old version is retrieved from the database.

    You could maybe check with phpMyAdmin or similar if you can run an “OPTIMIZE” or “REPAIR” query on the database tables.
    The alternative would be to use that Extension.

    Regards,
    Tobias

    Thanks for the help.
    I will try to make in free time.

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    no problem, you are very welcome! 🙂 Good to hear that this helped!

    Best wishes,
    Tobias

    Hi, I got the same problem on two of my sites. Change the table, preview as admin – everything ok. Opening the same page as normal visitor shows the old table data. I didn’t even know that there is a caching mechanism?! And I didn’t notice this problem in former versions of TP. How can I solve this?

    TIA
    Heiko

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi Heiko,

    yes, TablePress caches the generated HTML for each table in the wp_options table in the database. This way, the (sometimes) expensive operation of having to re-generate the cache can be avoided.
    I assume that you are affected by a similar database issue. To check if turning off the caching helps, can you please also modify the affected Shortcodes by adding the
    cache_table_output=false
    parameter?

    Regards,
    Tobias

    Hi,
    I have exactly the same problem since update to 4.6.1.
    Repairing and Optimizing does not change anything.
    Installing tablepress-turn-off-output-caching solves it.
    I think you should look into it.
    Best
    Hubert

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi Hubert,

    thanks for letting me know! Indeed, this looks like a more general database issue then…

    Regards,
    Tobias

    Why you create a plugin to disable the cache instead of adding some kind of setting? I haven’t checked the code of TablePress but that looks kinda lame.
    The cache doesnt work proprely sometimes…

    Just for curiosity.

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    adding a checkbox setting can really confuse the average user. I therefore like to follow the WordPress philosophy of “Decisions, not options.” here.

    Still, I want to offer the necessary flexibility, of course, which is why there’s this small plugin. Note that it’s very small, just a few lines. It will in no way harm.

    Regards,
    Tobias

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘How to disable the cache?’ is closed to new replies.