As previously announced via banners and our newsletters, support is no longer available through this platform.
For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.
You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.
Paid customers: Please log in to your store account for support.
Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com
I am running into an issue with the Auto-Cache feature. I am using Google Sheets and Google API to integrate with WPDataTables on a Bluehost WordPress site.
I have too many tables so that the burst limit is being reached when the cron job runs for the cache update to check for changes. By my math I can only run 20 tables at a time. I have tried writing some scripts manually to create something that batches 20 at a time and cycles through but so far have not found any success.
Is there any suggestions on how to be able to use the Auto Cache feature to check if any of my tables have changed but not get the Too Many Requests error (obviously without adding an expense of upgrading Google API as I am dong this as a hobby/non-profit and not a business).
Hi Kenneth,
The best/easiest way to solve this situation, is to remove the Google API key from our Plugin settings, but keep using the "Auto Update Cache" method.
This way, you will avoid having the API limit reached, and our tables will keep functioning the same way as before.
The only downside of this is, all your Google Sheets have to be published, so you can't use private ones.
That being said, nobody will be able to 'access' any of your Sheets from our tables on front-end, so in that regard, security is not an issue.
You can see more details explained and multiple methods to solve the 'too many requests' from Google API on this article.
Let me know if you have any questions.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
ok thank you.
Do I still need to do a Cron Job for the cache to update if a change is made to the Sheet, or is that all handled in the ~15 minute refresh discussed in the article?