Cache does not expire. Bug?

  • Resolved pxforti

    (@pxforti)


    6 years, 11 months ago

    I am displaying sheets in WordPress using the following code:
    [gdoc class="grooming" datatables_info="false" datatables_searching="false" datatables_paging="false" datatables_ordering="false" key="https://docs.google.com/spreadsheets/d/1H_7xZktbJttXtxdfFrE9x9um-GFclrBIEq-ohZVyaIQ/edit?usp=sharing" query="select A,B,D,E,F WHERE C = 'Sherman Park' ORDER BY A DESC LIMIT 1 label A 'Updated', D 'Skate', E 'Classic', F 'Comments' "]

    There are 8 different queries based on a select where the column is C. All of the areas , except “Sherman Park”, update when new data is added to the sheet.

    All content is stored in a single sheet, but I display different data based on the C column. The data should show the line for C with the lastest date. All of this works. When a new line is added to the sheet, via google forms, the data updates to the latest line for column C.

    However, for one area, Sherman Park, the data doesn’t update. In fact, it shows data that is no longer in the sheet. I deleted the old data to see if it would update, but it didn’t; Sherman Park continues to show data from 11/21/17.

    You mentioned in a support response that the cache is stored in WordPress transients. I searched the site’s WordPress database and did not find the old data.

    The only way I can get the “Sherman Park” data to update is to use use_cache=”no”.

    But I don’t understand why only one of the eight will not update?

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Meitar

    (@meitar)

    It’s not clear to me what you are expecting to happen, but I don’t get the same result that you do. Your output looks like this, whereas mine looks like this.

    My suggestion to you is to clear your WordPress database of transients. I’m only guessing here, though. To clear all WordPress transients this plugin uses, the following SQL query can be executed:

    DELETE from wp_options WHERE option_name LIKE '_transient_gdoc%';

    You may not have found the data in the database directly because it is base 64 encoded (to properly ASCII-encode various character sets); a simple string search won’t find it.

    Thread Starter pxforti

    (@pxforti)

    Hi. Thanks for the response and for the sql query.

    It appears that the gdoc transient for Sherman Park somehow failed to update or expire when new data was added for Sherman Park. After using use_cache=”no”, and then removing use_cache=”no”, the Sherman Park data now updates when new data is added.

    If it happens again, I’ll delete all gdoc transients.

    Thanks again for your help.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Cache does not expire. Bug?’ is closed to new replies.