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.
You are right and unfortunately our developers are still not able to improve that specific issue.
It only happens for server-side processing tables when you have caching active on the page.
but in a scenario like that, you can make a new SQL Query based table from the same data which is stored in a Manual Table,
by checking the MySQL Table name inside the Editing settings,
then make an SQL Query like : SELECT * FROM TableName. ( of course, you can change the Query if you just wish to pull specific columns only)
For any SQL Query based Table which has less than 2 thousand rows, you will be able to toggle server-side processing in the Data Source settings.
Our developers are intensively working to resolve this issue, as soon as possible. I can't say an ETA on it, unfortunately.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
-
For the time being, the only solution will be either to disable caching only for pages where you have the tables, or perhaps disable caching entirely, if possible.
Most caching Plugins have the option to add URL's that will be excluded, so if possible, see if you can add the Pages with tables there, and that should solve it for now.
Or you can try disabling server-side processing in your Table, for SQL tables it is under the Data source settings.
It can be toggled for tables under 2 thousand rows.
Let me know if that helps and if you have any questions. Thank you
Yes, our management and the developers definitely have an improvement planned on that front, we just can't say exactly what it will be at this time, but they are doing their best to come up with a valid improvement and to work on it as soon as possible.
We will close this ticket, but please don't hesitate to open new ones if anything else comes up.
Hi,
I think I had discussed this before, but I wanted to check-in and see if there were any updates on caching with server-side tables using SQL queries.
It would be great if the plugin supported a scheduled job to poll the query and cache it.
Currently, caching via Cloudflare WAF breaks all pages with tables on them.
“DataTables warning: table id=table_1 – Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1”
As soon as I create a bypass rule for all pages with tables, they begin working.
Hello,
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.
You are right and unfortunately our developers are still not able to improve that specific issue.
It only happens for server-side processing tables when you have caching active on the page.
For the Manual Tables, it is not possible to disable server-side processing,
but in a scenario like that, you can make a new SQL Query based table from the same data which is stored in a Manual Table,
by checking the MySQL Table name inside the Editing settings,
then make an SQL Query like : SELECT * FROM TableName. ( of course, you can change the Query if you just wish to pull specific columns only)
For any SQL Query based Table which has less than 2 thousand rows, you will be able to toggle server-side processing in the Data Source settings.
Our developers are intensively working to resolve this issue, as soon as possible. I can't say an ETA on it, unfortunately.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
-
For the time being, the only solution will be either to disable caching only for pages where you have the tables, or perhaps disable caching entirely, if possible.
Most caching Plugins have the option to add URL's that will be excluded, so if possible, see if you can add the Pages with tables there, and that should solve it for now.
Or you can try disabling server-side processing in your Table, for SQL tables it is under the Data source settings.
It can be toggled for tables under 2 thousand rows.
Let me know if that helps and if you have any questions. Thank you
Kind Regards,
Miloš Jovanović
[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
Okay, that's what we're currently doing since some tables are > 2000 records.
Just wanted to check-in and see if anything was in the works to handle that. It sounds like it's planned, which is fine.
We can close this request.
Hi William,
No problem at all, we are happy to advise.
Yes, our management and the developers definitely have an improvement planned on that front, we just can't say exactly what it will be at this time, but they are doing their best to come up with a valid improvement and to work on it as soon as possible.
We will close this ticket, but please don't hesitate to open new ones if anything else comes up.
Thanks.
Kind Regards,
Miloš Jovanović
[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