Updates to TablesPress content not showing

Hi,

thanks for your question, and sorry for the trouble.

This might be related to TablePress’ own caching mechanism of rendered table HTML code. It will basically cache that for 12 hours in a transient in the wp_options database table.
Depending on some issues in the database, this cache might stall sometimes. You could therefore try clearing the cache manually, by deleting all entries in that database table that start with _transient_tablepress_c_ or _transient_timeout_tablepress_c_. Just be careful to NOT delete the tablepress_options and tablepress_tables entries.

Now, all this is only valid of static content in tables. If your tables have dynamic content (e.g. from using PHP code or other Shortcodes inside table cells), you might want to turn off the caching. You could do that on a per-table basis by extending the used Shortcode with another parameter:
[table id=123 cache_table_output=false /]
Alternatively, you could make this the global default (i.e. turn off the TablePress caching for all tables) by installing and activating the TablePress Extension from https://tablepress.org/download/extension/tablepress-turn-off-output-caching.zip as a plugin.

Regards,
Tobias

Hi,

I have just about the same problem but not quite.

Firstly I installed the plugin and installed the extension you mention. It had the effect of allowing one change and the cache locked again. Uninstalled it and used the Shortcode in the page again the same thing happened, one change and locked again. Removed the last space in the Shortcode, same thing happens.

Checking the database does not show any of the option names mentioned above, the only ones in the Db wp_options table are tablepress_plugin_options and tablepress_tables.

Any ideas?

Another strange thing happening.

I am working on site with four languages set and my default is English, it has now changed to French! the language plugin settings have not changed?

Update.

All my cache settings are disabled and the language issue is only happening when logged in to the back-end.

Hi,

I’m not sure about that language problem, but that definitely was not caused by TablePress. Can you please check what language is defined on the Settings screen of WordPress?

Regards,
Tobias

Language is a side issue I will sort that.

More importantly what about the cache issue?

Hi,

If the Extension is activated, TablePress does not use caching. Could there be local caches on your computer involved?
If possible, I’d like to take a direct look at this on your site. Could you therefore please get in touch via email (the address is in the main plugin file “tablepress.php”)? That way, I can investigate this directly. Thanks!

Regards,
Tobias

Sorry the site is on my dev server, no outside access allowed.

All caches are disable for this problem.

What about the Db problem.

Checking the database does not show any of the option names mentioned above, the only ones in the Db wp_options table are tablepress_plugin_options and tablepress_tables.

Thanks

Hi,

if there are no other entries in the wp_options database table, this confirms that the TablePress caching is turned off — unless maybe you are using a real object cache for WordPress transients.

What kind of content do you have in your tables? Just plain text that you typed in? Or maybe other dynamic stuff, like Shortcodes?

Regards,
Tobias

Nothing complicated Just plain text.

I like the functionality of this plugin and am testing it for use in an upcoming project.

Hi,

ok, then I simply can’t think of any potential reasons for this issue on your server ??
Without being able to take a direct look, there isn’t much that I can do here, I’m afraid.
Can you reproduce this on a second server, maybe?

Regards,
Tobias

Will have to get back to you on that.

A bit of info for the second server;
It will be using Lightspeed and Varnish any potential problems there?

Hi,

yes, please let me know how that goes.

Unfortunately, I don’t have personal experience with neither Lightspeed nor Varnish, sorry. I don’t think that those would directly influence TablePress however, as I would have received reports on this, otherwise, I’m pretty sure.

Regards,
Tobias

OK Tabias,

I’m pretty busy at the moment but will set up a clean WP site with just your plugin when I get a chance. Maybe something was interfering, let me see how that goes. It will be a few days before a can do this.

I’ll get back to then.

Thanks

Hi,

yes, that would be great. Thanks!

Best wishes,
Tobias