I have wpDataTables linked to display some GoogleSheets. The tables no longer show the contents of the sheet, just the headings. When I try to save the setting in the table creator, I receive an error message saying that the "Table in the data source has no rows" even thought it does. I appended a screenshot of the error message below. Here's one of the tables: https://docs.google.com/spreadsheets/d/1981YoJsILMRe5LhDG7vhTG3vPZxbfmn5Uq5oBS8xrz0/edit#gid=2122967373 and the page that is is displayed on: https://www.bradfordairedaleac.org.uk/championships/winter/. The website did just transition to a new domain name and I transferred the license. Not sure if the move had anything to do with it. Thanks!
As far as I know, there have been none of those changes. Does the table need to be recreated in WordPress using wpDataTable or does the actual GoogleSheet need to be recreated? I tried creating a new wpDataTable using the same link and got the same response.
Hi there - I'm having the same problem. There's data in there, and it was working one day - not the next. No changes made. This is crucial to me running my website and I've lost customers over it. Can anyone help?????
After investigation, we found out that your link in converted in this after CURL call
<HTML>
<HEAD>
<TITLE>Temporary Redirect</TITLE>
</HEAD>
<BODY BGCOLOR="#FFFFFF" TEXT="#000000">
<H1>Temporary Redirect</H1>
The document has moved here https://doc-10-60-sheets.googleusercontent.com/pub/.....
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.
If this not help to all, please open separate private ticket with link of that Google sheet and temporary WP-LOGIN, so we can investigate.
I have wpDataTables linked to display some GoogleSheets. The tables no longer show the contents of the sheet, just the headings. When I try to save the setting in the table creator, I receive an error message saying that the "Table in the data source has no rows" even thought it does. I appended a screenshot of the error message below. Here's one of the tables: https://docs.google.com/spreadsheets/d/1981YoJsILMRe5LhDG7vhTG3vPZxbfmn5Uq5oBS8xrz0/edit#gid=2122967373 and the page that is is displayed on: https://www.bradfordairedaleac.org.uk/championships/winter/. The website did just transition to a new domain name and I transferred the license. Not sure if the move had anything to do with it. Thanks!
Hi Caleb,
Thank you for your purchase.
Sorry for late response.
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
We check you google sheet link, and we can see that is working fine.(attachment)
Can you please tell me did you change something in sheet after creating the table?
Please note: Once you create a table from a Google Spreadsheet, changes in the core file from which a table is created, like:
are highly not recommended, because the old table will not work, at the moment. If you make any of these changes, please recreate the table again.
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
As far as I know, there have been none of those changes. Does the table need to be recreated in WordPress using wpDataTable or does the actual GoogleSheet need to be recreated? I tried creating a new wpDataTable using the same link and got the same response.
I had same case with you. Looking for answers from team.
Regards,
Thien Nguyen
+1 Bump. We're having the same issue.
I'm having the same issue. Please resolve urgently.
Same issue, have tried recreating the Google Sheets table to no avail.
Hi there - I'm having the same problem. There's data in there, and it was working one day - not the next. No changes made. This is crucial to me running my website and I've lost customers over it. Can anyone help?????
Hi to all,
Thank you for reporting this.
After investigation, we found out that your link in converted in this after CURL call
<HTML> <HEAD> <TITLE>Temporary Redirect</TITLE> </HEAD> <BODY BGCOLOR="#FFFFFF" TEXT="#000000"> <H1>Temporary Redirect</H1> 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.
If this not help to all, please open separate private ticket with link of that Google sheet and temporary WP-LOGIN, so we can investigate.
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
I can confirm that adding the two lines of code works for me: https://www.bradfordairedaleac.org.uk/championships/summer/. Thanks Milan!
Will this fix make it into the next update of wpDataTables?
Hi there,
Yes this or corrected version of code(depends on testing) will be included in next update you don't have to worry about that.
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
Can you post a step by step on how to do this? I don't know where to find wp-content/plugins/wpdatatables/source/class.wdttools.php
For anyone who doesn't know what to do, head for Plugins then Plugin Editor, then use the menu on the right to get to the place described below.
Hi Ankit,
You can find it here
https://tmsplugins.ticksy.com/ticket/2450943/
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