• Hi I’ve encountered some problems when updating a table frequently. It’s a timetable for a school so the table gets updated daily. But sometimes the changes aren’t visible for regular users. When I’m logged in I see the updated table. But when I log out it’s stops at a certain row (6) and the last row / rows aren’t visible. I’ve fixed it by changing the ID multiple times. I suspect it has something to do with caching..

    https://ww.wp.xz.cn/plugins/tablepress/

Viewing 13 replies - 1 through 13 (of 13 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi,

    thanks for your question, and sorry for the trouble.

    This indeed sounds as if something is wrong with the caching. It could e.g. be possible that something is corrupted in the database table. Could you therefore maybe try to “Repair” and “Optimize” the wp_options database table, e.g. with a tool like phpMyAdmin?

    We could also simply turn off the caching for this table, by changing the Shortcode on the page to

    [table id=1 cache_table_output=false /]

    Regards,
    Tobias

    Hi Tobias,
    I am having the same issue and glad I came across this post! Is there a way to globally disable table output caching? We have 100+ tables so this would be most helpful in my situation.

    Thanks,
    Shawn

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi Shawn,

    yes, that’s possible, e.g. by installing and activating the TablePress Extension from https://tablepress.org/downloads/extensions/tablepress-turn-off-output-caching.zip as a new WordPress plugin.

    Regards,
    Tobias

    Hi Tobias,

    I have implemented both of the suggestions above. First the additional string to the shortcode. It did not work. Then I installed the extension. It still did not work.

    We use W3 Total Cache.

    Thank you for your time,

    Rob

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi Rob,

    thanks for your post, and sorry for the trouble.

    What exactly does not work? What’s the problem you are facing?

    Regards,
    Tobias

    When I delete a row in a table it remains visible on our live site.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi,

    thanks for the clarification. This does indeed mean that there’s some sort of caching going on. Does this happen to all users (logged-in and not logged-in)? Can you maybe clear the caches of all relevant plugins (especially W3 Total Cache)?

    Regards,
    Tobias

    It happens to all users.

    We use the plugin within a widget so it is seen on multiple pages. It displays a schedule that is update several times a day. Hence, why seeing an old one is not ideal.

    I can clear caches. Do you think that is prudent to do several times a day when we update the TablePress?

    I really appreciate your time,

    Rob

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi Rob,

    yes, please try clearing the caches. That way, we can find out if this is really the issue.

    TablePress actually contains a routine to flush the caches of some popular plugins, but it might not be clearing all relevant ones here.

    Regards,
    Tobias

    Good day, Tobias.

    I flushed the cache (purge all caches).

    Then I updated the table.

    I opened our site in FF, IE and Chrome. Saw an older version of the table in all three.

    What do you think this means?

    Rob

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi Rob,

    even with the TablePress Extension to turn off the internal caching that I mentioned above?

    Regards,
    Tobias

    Yes.

    I do have cache_table_output=false added to my short code and the extension running. Could one be cancelling the other? Should the shortcode be set to “true?”

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi,

    no, they are not cancelling each other, and false is the correct value. With that, the table will be re-rendered every time, with the same data that is shown on the “Edit” screen.
    If possible, I’d like to take a direct look at this on your site. Could you therefore please create a temporary admin account for me and send me the details via email (the address is in the main plugin file “tablepress.php”)? That way, I can investigate this directly. Thanks!

    Regards,
    Tobias

Viewing 13 replies - 1 through 13 (of 13 total)

The topic ‘Tablepress table cache / updating problem’ is closed to new replies.