when i try to edit or append new record in a table manual created or csv/xls imported on my separate db connection, this error appear always:
Error! There was an error trying to insert a new row! Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '00:59:00,'admin',2024-02-20 00:59:00,'1','1')' at line 1
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.
-
The bug happens when you make a Manual Table ( from scratch or imported from file) on an External DB which is not the WP DB.
Our developers already isolated the issue and they built a fix.
This fix should be added in our upcoming Update 6.2, which is scheduled for next week;
but I will see if I can provide you with the fix right now.
As soon as I check this with our developers, we will report back right away.
We made a fix with our Developers via a PHP file with edited code, which you can try on your Site right away, so you won't have to wait for the new Update.
Find this PHP file, via FTP or your Hosting's File Manager, in this path :
I am sending you the edited file as an attachment here, so first just move the original file anywhere, or rename it on the FTP, add any text at the end of the file name, like : wdt_ajax_actions_BACKUP.php
Then unzip this file I sent you, and upload it to your Plugin folder.
After that, go back to the WP-Admin and check again, the issue should be fixed.
Let me know how it goes.
If you still see any error, the issue still not fixed, we can remote in and try to debug it for you.
If that happens, please provide me a temporary WP-admin (administrator) user for your website where this happens,
as well as FTP credentials
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 parties.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
when i try to edit or append new record in a table manual created or csv/xls imported on my separate db connection, this error appear always:
Error! There was an error trying to insert a new row! Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '00:59:00,'admin',2024-02-20 00:59:00,'1','1')' at line 1
delete row it's only operation without error...
please help me...
Hi Alessandro,
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.
-
The bug happens when you make a Manual Table ( from scratch or imported from file) on an External DB which is not the WP DB.
Our developers already isolated the issue and they built a fix.
This fix should be added in our upcoming Update 6.2, which is scheduled for next week;
but I will see if I can provide you with the fix right now.
As soon as I check this with our developers, we will report back right away.
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 Alessandro,
We made a fix with our Developers via a PHP file with edited code, which you can try on your Site right away, so you won't have to wait for the new Update.
Find this PHP file, via FTP or your Hosting's File Manager, in this path :
..\wp-content\plugins\wpdatatables\controllers\wdt_ajax_actions.php
I am sending you the edited file as an attachment here, so first just move the original file anywhere, or rename it on the FTP, add any text at the end of the file name, like : wdt_ajax_actions_BACKUP.php
Then unzip this file I sent you, and upload it to your Plugin folder.
After that, go back to the WP-Admin and check again, the issue should be fixed.
Let me know how it goes.
If you still see any error, the issue still not fixed, we can remote in and try to debug it for you.
If that happens, please provide me a temporary WP-admin (administrator) user for your website where this happens,
as well as FTP credentials
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 parties.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
Attached files: wdt_ajax_actions.zip
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