Holiday Notice – Support Unavailable on April 18 and April 21

We just wanted to let you know that our support team will be offline on Friday, April 18th (Good Friday) and Monday, April 21st (Easter Monday) due to the holidays.
We'll be back on Tuesday, ready to assist you!

In the meantime, if you need any help, feel free to:

Amelia YouTube Channel

wpDataTables YouTube Channel

Thank you for your understanding, and we wish you a wonderful holiday weekend!

Okay
  Public Ticket #2908281
editing MySQL tables
Closed

Comments

  • Daniel started the conversation
    November 3, 2021 at 8:29am

    I have successfully connected a MySQL database ("mileja_kuli") in wpDataTables. When trying to edit a row in my data table ('Kundenliste") using wpDataTables, I get a Syntax error:

    "Fehler! Beim Aktualisieren der Zeile ist ein Fehler aufgetreten! Fehler: 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 '; SET `Frau_id` = '2' , `Err_Termin` = '2020-07-01' , `ET_Bemerkung` = NULL , `D' at line 1"

    Through my hosting provider I am using MySQL-Version: 5.7 and have the option to upgrade to MariaDB 10.4.

    What could be the issue? MySQL-Version not compatible? Is it possible to see the MySQL statement that is being sent to the database?

    Thanks,

    Daniel

  • [deleted] replied
    November 4, 2021 at 6:30am

    Hi Daniel

    Thank you for reaching out to us.

    Can you please send us the original query used to create the table? For MySQL engine we are dynamically adding the accent grave ( ` ), so there’s no need to use it around the table name in the query. Also if you have a semicolon added in the table name for editing please remove it.

    If you can share any other screenshots or details about the issue that would be great.

  • Daniel replied
    November 4, 2021 at 6:52am

    Hi Blaženka,

    thank you for your quick response. I have sent you the respective query by e-mail to.

    Best,

    Daniel

  • [deleted] replied
    November 5, 2021 at 11:46am

    Hi Daniel

    Can you please create a view from this query and then create the table from the view and let me know if you still have the same issue. If you do please provide me a temporary WP-admin (administrator) user 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 parties. 

    You can write credentials here just check PRIVATE Reply so nobody can see them except us.


  • Daniel replied
    November 6, 2021 at 7:41pm

    Hi Blaženka,

    it is a simple "select * from table" query:

    Bildschirmfoto-2021-11-06-um-20.37.10.png


    it delivers the expected result:

    Bildschirmfoto-2021-11-06-um-20.37.20.png


    Now, if I try to edit one line (see last item "Notiz"):

    Bildschirmfoto-2021-11-06-um-20.37.41.png


    When I click "apply" or "OK", I get a syntax error:

    Bildschirmfoto-2021-11-06-um-20.37.48.png


    Best,

    Daniel


  •   Daniel replied privately
  • [deleted] replied
    November 9, 2021 at 6:04pm

    Hi Daniel

    Unfortunately I was not able to log in within the given time. Can you resend the login credentials? Can you please check the "id column for editing" it should be "nr" column.

  •   Daniel replied privately
  • Daniel replied
    November 9, 2021 at 6:51pm

    Hi Blazenka,

    it worked. I found the error.

    Thanks for your support.

    Best,

    Daniel

  • [deleted] replied
    November 13, 2021 at 2:18pm

    Hi Daniel

    Thank you for the update I'm glad to hear thatsmile.png

    If there is anything else we can assist you with please don't hesitate to open a new ticket.

    Have a wonderful day!