WordPress.org

Ready to get started?Download WordPress

Forums

WP-Table Reloaded
[resolved] Caching problem? (10 posts)

  1. JezF
    Member
    Posted 1 year ago #

    Hi Tobias,

    I am using a number of tables to display sailing holiday prices for 1 week and 2 week trips, with and without flights. For each country, a single table is used, shown on the 1 week page with the two week price columns hidden, and on the 2 week page with 1 week price columns hidden. You can see an example here:

    http://www.sailingchoices.com

    I update the pages every few weeks, and upload a new csv file to replace the old data in each table.

    I've found a couple of 1 week price pages where 2 week prices are appearing (there may be more). I turned off the cache pages flag and the problem seemed to correct itself.

    The table sizes are already stretching things a bit (I really need to move to server side processing but I would need to contract out this work as it's beyond me - if you or someone you can recommend wishes to earn some money, please PM me to discuss).

    In view of the sizes, caching would seem to be a good idea, but not if it results in wrong prices! So the questions are:

    1) Am I right that this is a caching issue?

    2) When is the cache generated/regenerated? I don't want two week prices showing where they should be one week, but I wouldn't want old prices showing instead of the latest ones either. Is there a way to force refresh the cache when I upload a new csv file to ensure the right prices appear on the right pages, and that the latest data displays?

    Many thanks for your advice in anticipation.

    http://wordpress.org/extend/plugins/wp-table-reloaded/

  2. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    Hi,

    thanks for your post, and sorry for the troule!

    Yes, it is very likely that this is caused by the table caching. The reason is that the caching only checks the table ID, but not the hidden columns (i.e. the Shortcode parameters) when retrieving a page from the cache. Due to that, both Shortcodes will show the same table. The cache duration is 12 hours, if I remember correctly. And it is refreshed whenever a table is modified.

    Now, the fix should be easy: Just switch from WP-Table Reloaded to TablePress, which is the official successor of WP-Table Reloaded. More more information please see http://tobias.baethge.com/2013/01/tablepress-replaces-wp-table-reloaded/
    TablePress also has caching built-in, but uses a better method when loading something from the cache: Instead of just using the table ID, it will use all Shortcode parameters, so that all different Shortcodes will use a different version from the cache, as they should.

    Regards,
    Tobias

  3. JezF
    Member
    Posted 1 year ago #

    Hi Tobias,

    Wow, thanks for the super rapid response (and a great plugin too - no apologies needed)!

    I think the refresh may not be working quite that frequently - at least one of the tables affected was last updated over a week ago.

    I had been looking at updating to Tablepress as I guess this may also help the response times?

    My nervousness about Tablepress is my tables use a number of extensions from Datatables.net, for filtering, selective column sorting etc. I was pretty pleased I managed to get these working as I'm not very technical. Are these easy to migrate? Your migration notes seem to suggest some care is needed and with it being the height of the holiday booking season I'm very short of time.

    Also can I carry on using the existing tables until I have the Tablepress versions ready?

    Thanks again - funds are a bit tight whilst I get my new business up and running but a donation will be with you as soon as I can. Great to have such superb support - I've only paid for one plugin for my site and the authors of that one haven't bothered to respond to my support request in 2 weeks. You're a star.

  4. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    Hi,

    thanks for the nice words, and for wanting to donate! I really appreciate it!

    I'm not sure what's wrong with the refresh not working, but disabling the caching in WP-Table Reloaded should fix this. Are you maybe using another caching plugin, like W3 Total Cache or WP Supercache? Then the caches of those plugins would need to be refreshed as well, of course. (This is another feature that TablePress does automatically, by the way :-) )

    Yes, updating to TablePress is recommended, and it should bring better response times (not just from the caching, but because it's faster overall).

    Those extra DataTables extension could indeed mean a little bit more work during the migration. Can you maybe explain a bit more how you added those? Via WP-Table Reloaded Extensions, or by adding the JavaScript code in a custom way?
    If it's via a WP-Table Reloaded Extension, some places in the PHP code might need adjustments (like new names for filter hooks). If you added the JS in a custom way, you should only have to adjust the table's HTML IDs in the JS code.

    You can keep the WP-Table Reloaded tables, but unfortunately, you can't have both plugins activated at the same time. As soon as TablePress is activated, it takes command of the [table /] Shortcode, so that WP-Table Reloaded is no longer responsible for printing tables to the page.
    However, as soon as TablePress is deactivated again, WP-Table Reloaded takes over again, just as before. Thus, you might want to do the migration at a time when there only a few visitors on your site.

    Regards,
    Tobias

  5. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    Hi,

    me again:
    I just checked your link from above, and for that table, I could identify two DataTables Extensions, the ColumnFilterWidgets and the Sorting JS plugins.
    Both are actually easier to use in TablePress than in WP-Table Reloaded, as I have put them in to "TablePress Extensions:
    http://tablepress.org/extensions/datatables-columnfilterwidgets/
    http://tablepress.org/extensions/datatables-sorting-plugins/

    Regards,
    Tobias

  6. JezF
    Member
    Posted 1 year ago #

    Hi Tobias,

    Oh deep joy, another all night WordPress session by the sounds of it!!

    I've no other caching plugins in use but sounds like moving to Tablepress is the best route anyway.

    For info, the tables are called using hide_column and column-widths parameters in the short code. There's a bit of Custom CSS in the plugin options page box (to centre some of the data in the columns) and then in the Custom Commands box at the foot of each table there is something like this:

    "sDom": 'W<"clear">lfrtip', "oColumnFilterWidgets": { "sSeparator": "\\s*,+\\s*", "aiExclude": [ 6,9,10,11]},"aoColumnDefs": [ { "bSortable": true, "aTargets": [ 3,4,8,9,10] }, { "bSortable": false, "aTargets": [ "_all" ] }, { "sType": "currency_sorting", "aTargets": [ 9,10 ] } ]

    I appreciate your new extensions may be quicker once I have understood how to use them, but is there still a Custom Commands box for each table? (because nothing is as fast to an idiot like me as a copy and paste)!!

  7. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    Hi,

    no, don't worry, it shouldn't take an all night session! :-)

    Yes, moving to TablePress is the best way to go, as you will have to do it sooner or later anyway.

    The hide_columns and column_widths Shortcode parameters will continue to work, as will the "Custom CSS". (Note though, that TablePress has a new default styling.) The "Custom Commands" will be migrated automatically as well (unless you are on a WP Multisite installation, but I doubt that).
    The ColumnFilterWidgets might even continue to work, depending on how you've set it up. You might still want to switch to the Extension, which basically handles this with another Shortcode parameter, instead of the error-prone "Custom Commands" field.
    The currency sorting will not work with that exact code, but that should be an easy fix after the regular stuff is migrated.

    I suggest that you give the migration a quick try. Remember: As soon as you deactivate TablePress, WP-Table Reloaded will take over again just as before.

    Regards,
    Tobias

  8. JezF
    Member
    Posted 1 year ago #

    Hi,

    No, I'm not multisite - one is quite enough! I have got 40 tables on my site though (told you I like your plugin)!!

    Anyway, I will have a go in the next few days - sounds like I might need some help with the currency sorting.

    Question is, will Tablepress be fast enough to enable me to rejoin some of the tables I had to split - I found a limit of around 2000 rows a bit restricting!!

    I'll let you know how it goes. Thanks again.

  9. JezF
    Member
    Posted 1 year ago #

    A contribution for your good work this afternoon just sent. More once the business gets going!

  10. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    Hi,

    40 tables shouldn't be a problem.
    Also, that limit of 2000 rows (which technically is not a limit in TablePress, but more the result of the combination of server and coding issues) should no longer be a factor. TablePress is much better suited to handle these (although the editing experience might not always be faster).

    The currency sorting should just require that mentioned TablePress Extension, without further work. If it's not working out of the box after the migration, I'll gladly help in getting it to work.

    And thanks for your contribution, I really appreciate that!

    Best wishes,
    Tobias

    (P.S.: I'll go ahead and close this thread as resolved, as we've identified the cause of the problem in WP-Table Reloaded. If you have trouble with TablePress after the migration, please open a new thread at http://wordpress.org/support/plugin/tablepress Thanks!)

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic