Note: this document was updated on Friday, June 26 at 3:02pm to include a note about a temporary fix that was put in place
Note: this document was updated on Friday, June 26 at 12:17pm to include new workaround instructions
It was brought to our attention recently that several wpDataTables that were using Google Sheets as its source were no longer displaying data even though the source tables were still working correctly. Tables using other sources (CSV, for example) appear to be displaying as expected.
Users experiencing this issue will notice that their tables are displaying a note on the page that says “No data available in table” and/or an error message within wpDataTables that says “Table in data source has no rows.”
What We Know
We do not believe this is an issue directly with the plugin itself, as we have not updated it since April and these tables were working as of last week. No other recent changes to the service appear to have had an affect on tables, but we will continue to investigate.
It is possible that the issue is related to an update that Google made to Google Sheets. In that case, the plugin vendor, TMS-Plugins, will likely follow up with a bug fix and we will roll out the update as soon as it is available.
Update: We believe the vendor is already aware of this issue and is working on a fix, per this article.
We have identified one fix that seems to be working for most users. For this, you will need to create an entirely new Google Sheet and copy/paste the info from the old sheet. Publish that new sheet to the web, then update your existing wpDataTables table to read from that new source. It is highly recommended that you attempt this approach for any tables that are high visibility/high priority for your users.
Update (6/26 – 12:17pm): We have heard that the workaround previously reported is not working for several users now. Therefore, we suggest using a different data source, as is outlined in instructional steps in this KB doc: Table Display Issues for Sites Using wpDataTables with Google Sheets
Update (6/26 – 3:02pm): A code update has been added to the vendor plugin files to temporarily fix this issue while we wait for the plugin vendor to push out a more formal update. If your site is still experiencing the issue, please try clearing your browser cache and refreshing the page. If the problem persists, we may need to manually clear your site cache for you. For this, please send an email to firstname.lastname@example.org and request a manual cache clear of your site.
We apologize for this inconvenience and continue to work towards a solution. If you need further assistance please don’t hesitate to reach out to us.