We've started receiving an error on our WPDatatables when we try to view them. Its the non-descriptive error that points me to http://datatables.net/tn/1
When I view that I see:
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1]
SELECT COUNT(*) as cnt_total FROM
{"draw":1,"recordsTotal":null,"recordsFiltered":"2","data":[["20","1","Mark","Angeli","February","12","2020","Friends of KMNBP","Other","","2","02/12/2020 08:05 PM"],["21","1","Mark","Angeli","February","8","2020","KMTC","Trail-Patrol","Cheatham Hill Road","3","02/12/2020 08:19 PM"]]}
However nothing has changed in my setup. This error started happening after a a recent update.
Thank you for your purchase, and sorry to hear you're experiencing issues.
Is SELECT COUNT the query you used to create a table, or is that generated by the plugin?
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party.
You can write credentials here just check Private Reply so nobody can see them except us.
Also, please make sure to tell me which table ID should I be looking for.
We've started receiving an error on our WPDatatables when we try to view them. Its the non-descriptive error that points me to http://datatables.net/tn/1
When I view that I see:
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1] SELECT COUNT(*) as cnt_total FROM
{"draw":1,"recordsTotal":null,"recordsFiltered":"2","data":[["20","1","Mark","Angeli","February","12","2020","Friends of KMNBP","Other","","2","02/12/2020 08:05 PM"],["21","1","Mark","Angeli","February","8","2020","KMTC","Trail-Patrol","Cheatham Hill Road","3","02/12/2020 08:19 PM"]]}
However nothing has changed in my setup. This error started happening after a a recent update.
Hello Mark
Thank you for your purchase, and sorry to hear you're experiencing issues.
Is SELECT COUNT the query you used to create a table, or is that generated by the plugin?
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party.
You can write credentials here just check Private Reply so nobody can see them except us.
Also, please make sure to tell me which table ID should I be looking for.
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