We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

Okay
  Public Ticket #3588285
wpdatatables sql error
Closed

Comments

  • Alessandro Zicari started the conversation

    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...

  •  1,895
    Miloš replied

    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 | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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

  •  1,895
    Miloš replied

    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 | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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