Please help me, I urgently need this issue fixed/help to figure out what is causing it.
I have been trying to create a table for the last 2 weeks and have been facing the same problem every time. I start making a table, like usual, like the ones I have previously made, and usually almost complete it. The table comes from Google Sheets, and I have other functional tables from Google sheets.
Eventually, at some point the table does not save anymore, and just have an infinite load with the circle.
If I exit out at this point, when I return back to the table, it has all the rows I have made no longer visible on the front end visible, and many of my edits are gone. At this point the table also does not display in the front end. You can see from my screenshots that the rows I set to not display on the front end are now appearing, but there is no data in them. When I try to make changes to see if I can fix this from the WPDataTables backend, I am unable to save anything, so nothing works, as it just loads for hours.
I made a duplicate table before the issue happened, so that I could try to use that one instead, if it broke again, however, the datatable in the duplicate also broke. So possibly it is something from Google sheets?
I have tried disabling the plugin, and purging all site caches.
I urgently need this fixed, as we need this datatable for when we make our site live. I am getting very frustrated, as I have made the table several times, and while it works for a while eventually this issue happens. So far it has not happened to any of the other datatables I have created.
Please see attached screenshots. In the next private message I am sending web login credentials .
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
I can see the last two tables on the back end, i presume these are tables 25 and 27 ( Copy), right?
If i try to connect the same source Google Spreadsheet to our Sandbox Site, and try to create a new table connected to the Sheet, i am getting this error in the console ( The same error shows on your site)
Uncaught TypeError: Cannot set properties of undefined (setting '_DT_CellIndex')
The "Cannot set property '_DT_CellIndex' of undefined" error,
when it happens to existing tables that were previously working - this usually occurs when there are some changes in the source file (Google Spreadsheet) like:
Changing the column’s name,
Changing the column’s order,
Deleting the column, and
Adding a new column.
If one of these changes was made, the table will have to be recreated again.
But i can see this error when we try to make a new table, as well.
As you said - it is just spinning the "loader" and we got the said error in the console.
Also, if you have some links in the spreadsheet, and they are missing a closing quote ( " ) or something like that.
The issue is in the file somewhere, we just need to find it.
Despite best efforts, i am not able to isolate if it is some kind of formatting, or an issue with a value in any cell,
i also tried to unformat the data by copying values in my new Spreadsheet, but same error happens;
so i escalated this with our 2nd level Team, they will help me investigate it further.
Thanks for the response, I am going through the file now to check for " on links, and other formatting issues. No other changes in the source file have been made.
Thank you for escalating, and I hope to hear from you soon.
After scanning the file, I found one cell that was missing a closing quote and the table seems to be working after I added it. Happy that it was such a simple fix. ]
Hi there,
Please help me, I urgently need this issue fixed/help to figure out what is causing it.
I have been trying to create a table for the last 2 weeks and have been facing the same problem every time. I start making a table, like usual, like the ones I have previously made, and usually almost complete it. The table comes from Google Sheets, and I have other functional tables from Google sheets.
Eventually, at some point the table does not save anymore, and just have an infinite load with the circle.
If I exit out at this point, when I return back to the table, it has all the rows I have made no longer visible on the front end visible, and many of my edits are gone. At this point the table also does not display in the front end. You can see from my screenshots that the rows I set to not display on the front end are now appearing, but there is no data in them. When I try to make changes to see if I can fix this from the WPDataTables backend, I am unable to save anything, so nothing works, as it just loads for hours.
I made a duplicate table before the issue happened, so that I could try to use that one instead, if it broke again, however, the datatable in the duplicate also broke. So possibly it is something from Google sheets?
I have tried disabling the plugin, and purging all site caches.
I urgently need this fixed, as we need this datatable for when we make our site live. I am getting very frustrated, as I have made the table several times, and while it works for a while eventually this issue happens. So far it has not happened to any of the other datatables I have created.
Please see attached screenshots. In the next private message I am sending web login credentials .
Hopefully you can help soon,
Sam
Attached files: Screenshot 2023-01-25 at 18.16.53.png
Screenshot 2023-01-25 at 18.25.07.png
Screenshot 2023-01-25 at 18.25.15.png
Hi, Sam
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
I can see the last two tables on the back end, i presume these are tables 25 and 27 ( Copy), right?
If i try to connect the same source Google Spreadsheet to our Sandbox Site, and try to create a new table connected to the Sheet, i am getting this error in the console ( The same error shows on your site)
Uncaught TypeError: Cannot set properties of undefined (setting '_DT_CellIndex')
The "Cannot set property '_DT_CellIndex' of undefined" error,
when it happens to existing tables that were previously working - this usually occurs when there are some changes in the source file (Google Spreadsheet) like:
If one of these changes was made, the table will have to be recreated again.
But i can see this error when we try to make a new table, as well.
As you said - it is just spinning the "loader" and we got the said error in the console.
Also, if you have some links in the spreadsheet, and they are missing a closing quote ( " ) or something like that.
The issue is in the file somewhere, we just need to find it.
Despite best efforts, i am not able to isolate if it is some kind of formatting, or an issue with a value in any cell,
i also tried to unformat the data by copying values in my new Spreadsheet, but same error happens;
so i escalated this with our 2nd level Team, they will help me investigate it further.
We will report back as quickly as possible.
Thank you for your patience.
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
Hi Milos,
Thanks for the response, I am going through the file now to check for " on links, and other formatting issues. No other changes in the source file have been made.
Thank you for escalating, and I hope to hear from you soon.
Sam
Hi Milos,
After scanning the file, I found one cell that was missing a closing quote and the table seems to be working after I added it. Happy that it was such a simple fix. ]
Thanks for your time,
Sam