How to disable the cache?

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?

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.

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

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

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.

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