We have not touched or altered our Google Sheet in any way for the last week. As of today, all google sheets that create rows of sortable data are showing blank and when attempting to reapply the sheet url or even create a new table altogether, it shows up as "no rows" found for the google sheet.
We have tried everything under the sun and believe this issue is within the plugin itself, which also hasn't been messed with from time of it working to time of error.
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.
You can change this over Plugins editor or over FTP. What you need to do is first deactivate our plugin and then access plugins editor. (When you hover on Plugins in admin menu you should see this option)
Then you will find our plugin on left side in select box and then click Select,
Then below that select box you will see Plugins files and there you need to find folder source and click on it and there you will find file class.wdttools.php and click on it.
On left side of the screen you are able to modify this file and there you need to scroll to the line of 205 and to add belot that line to add this
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);
and your code will look like this
after that below that area you will find button Update File and click on it to save changes
After that activate our plugin and your tables will work fine.
Hi affiliatecrypto,
Please follow instruction from above and your tables will work fine.
@Milan - I followed the steps to make the edit in the plugin editor and that worked. I must say it's a little scary to have to discover a bug like that on my own....the tables make up the bulk of the content on my site!
We have not touched or altered our Google Sheet in any way for the last week. As of today, all google sheets that create rows of sortable data are showing blank and when attempting to reapply the sheet url or even create a new table altogether, it shows up as "no rows" found for the google sheet.
We have tried everything under the sun and believe this issue is within the plugin itself, which also hasn't been messed with from time of it working to time of error.
Hi there,
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,
I'm not 100% sure how to go about finding line 205 and editing it with the new line of code as you suggested.
Same here, we haven't changed anything in the plugin settings, but all Google Spreadsheet tables show the same "no rows" error.
Hi DFSKarma,
You can change this over Plugins editor or over FTP. What you need to do is first deactivate our plugin and then access plugins editor. (When you hover on Plugins in admin menu you should see this option)
Then you will find our plugin on left side in select box and then click Select,
Then below that select box you will see Plugins files and there you need to find folder source and click on it and there you will find file class.wdttools.php and click on it.
On left side of the screen you are able to modify this file and there you need to scroll to the line of 205 and to add belot that line to add this
and your code will look like this
after that below that area you will find button Update File and click on it to save changes
After that activate our plugin and your tables will work fine.
Hi affiliatecrypto,
Please follow instruction from above and your tables will work fine.
Best regards.
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
Same error for me this morning. I have not changed anything with the setup in years.
@Milan - I followed the steps to make the edit in the plugin editor and that worked. I must say it's a little scary to have to discover a bug like that on my own....the tables make up the bulk of the content on my site!
Confirming the step by step process mentioned below did work.
THANKS!
Looks like the most recent update broke this again, so have had to redo this again.
Hi Ankit,
We are not sure why do you have issue with the latest version because contain same code like instructions in this ticket.
Everyone who update plugin on latest version fix issue with tables created from Google spreadsheet.
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