At least 10 tables on our site with origins from Google Sheets have suddenly failed for no reason that I can determine. On our site the tables say No data available in table. On the back end when I try to refresh, it says "This data source has no rows" – I'm using the correct link for these tables (the one in the browser, not the pop up) and the Sheets files haven't even been modified. I attached a link where one of the tables isn't working. I am transitioning some of the files to Excel but some of these are updated daily and I need the Google Sheets functionality. Any ideas?
RedirectsFor security reasons, content returned by the Content service isn't served from script.google.com, but instead redirected to a one-time URL at script.googleusercontent.com. This means that if you use the Content service to return data to another application, you must ensure that the HTTP client is configured to follow redirects.
What you can try is to add this code in file wp-content/plugins/wpdatatables/source/class.wdttools.php around line 205 you will find this
curl_setopt($ch, CURLOPT_REFERER, site_url());
and below that add this code
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);
so your code will look like this
We need to test more but for now it is working in all test cases and it will be included in next update.
Is there an ETA on that formal release for this fix for the plugin? I'm trying to figure out if my developer is going to go ahead and need to make the manual fix until the official fix.
Can I please confirm what the current version is that contains the fix? My plugin is not indicating an update is available. Via WP plugin menu, shows this -> Version 2.6.1 | By TMS-Plugins
Please download the full version from the email you received when you purchased the plugin (some hostings treat it as Spam, so please check your Spam folder as well). Also, you received an email with credentials for our store https://store.tms-plugins.com/login where you can download the full version fom.
My suggestion is to update the plugin manually by following these steps:
1.) Download zip from our store or from the email you received when you purchased the plugin
2.) Use FTP to open /yourwordpressfolder/wp-content/plugins
3.) Delete existing wpdatatables folder.
4.) Upload the previously downloaded wpdatatables folder through FTP into "plugins" folder (unzip it)
5.) Go to WP-admin panel, open Plugins section.
6.) Deactivate wpDataTables Plugin, and then activate it again.
If you are on hosting where you are not allowed to access your FTP, then follow these instructions:
Please note that, before deleting the plugin from the Plugins page, it is recommended to enable the option "Prevent deleting tables in database" in main settings of the plugin if you want to keep your tables after deletion from the Plugins page. If you uncheck this option, all your tables will be deleted and you will need to create them again.
1.) Download zip from our store or from the email you received when you purchased the plugin
2.) Delete wpDataTables plugin from WordPress' Plugins page
3) Click on Add new in top left of your Plugins page
4) Click on Upload plugin in top left of your Plugins page
5.) Choose the previously downloaded wpdatatables.zip file
6.) When uploading is done, please Activate wpDataTables plugin
7.) Clear server and browser cache.
Please note that our plugin is around 14 MB in size, so if you are not able to upload it through WordPress plugins page, you will need to increase the following:
upload_max_file size,
post_max_size,
max_execution_time
You should be able to find these values in your php.ini file or on your hosting panel. If you can't find it yourself please ask your hosting provider to provide it.
I have 3.0.3 installed (I only bought and installed the plugin yesterday) and have made sure my Google Sheet is public, but I'm getting "Table in data source has no rows" every time I try and create a table from Google Sheets.
At least 10 tables on our site with origins from Google Sheets have suddenly failed for no reason that I can determine. On our site the tables say No data available in table. On the back end when I try to refresh, it says "This data source has no rows" – I'm using the correct link for these tables (the one in the browser, not the pop up) and the Sheets files haven't even been modified. I attached a link where one of the tables isn't working. I am transitioning some of the files to Excel but some of these are updated daily and I need the Google Sheets functionality. Any ideas?
Hi Chris,
Thank you for reporting this.
After investigation, we found out that your link in converted in this after CURL call
Temporary RedirectTemporary Redirect The document has moved here https://doc-10-60-sheets.googleusercontent.com/pub/.....
The described behavior is a feature:
https://developers.google.com/apps-script/guides/content#redirects
What you can try is to add this code in file wp-content/plugins/wpdatatables/source/class.wdttools.php around line 205 you will find this
and below that add this code
so your code will look like this
We need to test more but for now it is working in all test cases and it will be included in next update.
Sorry for inconvenience,
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Milan – that seems to have worked, thank you very much!
Chris
Milan,
Is there an ETA on that formal release for this fix for the plugin? I'm trying to figure out if my developer is going to go ahead and need to make the manual fix until the official fix.
Thanks!
Ryan
Hello Ryan
A new update has been released today.
Please update the plugin, and the issue will be resolved.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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
Can I please confirm what the current version is that contains the fix? My plugin is not indicating an update is available. Via WP plugin menu, shows this -> Version 2.6.1 | By TMS-Plugins
9/7/2020
WP Plugin Website indicates version is ->
Therefore I am unsure which is correct. Can you please advise. The version I have continues to have the 'no data' issue.
I have not tried to insert that code yet, wanted to verify I have the current version.
Cheers
Cam
Hello Cameron
The issue has been fixed with the new update.
Please download the full version from the email you received when you purchased the plugin (some hostings treat it as Spam, so please check your Spam folder as well). Also, you received an email with credentials for our store https://store.tms-plugins.com/login where you can download the full version fom.
My suggestion is to update the plugin manually by following these steps:
1.) Download zip from our store or from the email you received when you purchased the plugin
2.) Use FTP to open /yourwordpressfolder/wp-content/plugins
3.) Delete existing wpdatatables folder.
4.) Upload the previously downloaded wpdatatables folder through FTP into "plugins" folder (unzip it)
5.) Go to WP-admin panel, open Plugins section.
6.) Deactivate wpDataTables Plugin, and then activate it again.
7.) Clear server and browser cache
____________________________________________________________________________________________
If you are on hosting where you are not allowed to access your FTP, then follow these instructions:
Please note that, before deleting the plugin from the Plugins page, it is recommended to enable the option "Prevent deleting tables in database" in main settings of the plugin if you want to keep your tables after deletion from the Plugins page. If you uncheck this option, all your tables will be deleted and you will need to create them again.
1.) Download zip from our store or from the email you received when you purchased the plugin
2.) Delete wpDataTables plugin from WordPress' Plugins page
3) Click on Add new in top left of your Plugins page
4) Click on Upload plugin in top left of your Plugins page
5.) Choose the previously downloaded wpdatatables.zip file
6.) When uploading is done, please Activate wpDataTables plugin
7.) Clear server and browser cache.
Please note that our plugin is around 14 MB in size, so if you are not able to upload it through WordPress plugins page, you will need to increase the following:
upload_max_file size,
post_max_size,
max_execution_time
You should be able to find these values in your php.ini file or on your hosting panel. If you can't find it yourself please ask your hosting provider to provide it.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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
I'm having the same problem where Google Sheets files worked just fine and all of a sudden there's no data in the WordPress page.
What's going on?
Hi Damian
Please update the plugin to v3.0.1, as suggested to Cameron and Ryan, and the issue should be resolved.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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
can confirm, the update fixes the issue, apologies I should have replied back to say that. I did a manual update and all worked correctly after that.
Thanks Aleksander!
: )
You're welcome Cameron
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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
Hi
I have 3.0.3 installed (I only bought and installed the plugin yesterday) and have made sure my Google Sheet is public, but I'm getting "Table in data source has no rows" every time I try and create a table from Google Sheets.
Ian
Hello Ian
Please open a new ticket in regard to this issue, and provide me the link to the file there, so I can check it out.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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