Title: Cache does not expire. Bug?
Last modified: December 31, 2017

---

# Cache does not expire. Bug?

 *  Resolved [pxforti](https://wordpress.org/support/users/pxforti/)
 * (@pxforti)
 * [8 years, 5 months ago](https://wordpress.org/support/topic/cache-does-not-expire-bug/)
 * 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](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fcache-does-not-expire-bug%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [8 years, 5 months ago](https://wordpress.org/support/topic/cache-does-not-expire-bug/#post-9831497)
 * 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](https://i.imgur.com/Bt4BtkZ.png),
   whereas [mine looks like this](https://i.imgur.com/wXEgO9F.png).
 * 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](https://wordpress.org/support/users/pxforti/)
 * (@pxforti)
 * [8 years, 5 months ago](https://wordpress.org/support/topic/cache-does-not-expire-bug/#post-9838224)
 * 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.

 * ![](https://s.w.org/plugins/geopattern-icon/inline-google-spreadsheet-viewer.
   svg)
 * [Inline Google Spreadsheet Viewer](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/)
 * [Active Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [pxforti](https://wordpress.org/support/users/pxforti/)
 * Last activity: [8 years, 5 months ago](https://wordpress.org/support/topic/cache-does-not-expire-bug/#post-9838224)
 * Status: resolved