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?
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.
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.
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.
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
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.
Hi Blaženka,
thank you for your quick response. I have sent you the respective query by e-mail to.
Best,
Daniel
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.
Hi Blaženka,
it is a simple "select * from table" query:
it delivers the expected result:
Now, if I try to edit one line (see last item "Notiz"):
When I click "apply" or "OK", I get a syntax error:
Best,
Daniel
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.
Hi Blazenka,
it worked. I found the error.
Thanks for your support.
Best,
Daniel
Hi Daniel
Thank you for the update I'm glad to hear that
If there is anything else we can assist you with please don't hesitate to open a new ticket.
Have a wonderful day!