Error You have an error in your SQL syntax

Using my Dolibarr
1

1235/5000
Greetings, I’m working with a special module of Dolibarr 3.0.9,
I have already create the Data Record menu (for Payroll),
which I get by calling the create () function from card.php to class.php
(both created from the skeletons folder).

But when it comes to working with the Data Update menu, I try to do the same procedure,
obviously calling the function update (), which shows me the following warning:

"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 ‘’ at line 1 "

  1. at first glance it looks like syntax error, but my SQL file has no errors
    (if it had not done the CRUD).
  2. Investigating a little, lai that it could be that in the funtion update () they are not arriving
    the values ​​are getting empty, remove the NOT NULL from all the fields in the database
    and remains the same.
  3. reading more I saw that there are versions of SQL that vary the assignments of engines,
    and try changing the ENGINE = InnoDB; by TYPE = InnoDB; But it does not work
  4. I have done several CRUDs with key fields, no key fields, changing data types, and nothing …

I need some solution or suggestion please …

I need some solution or suggestion please …

Pièces jointes :

3

Spam: Metabase is not relevant here.

This old post is talking about version 3.0.9 - first serious advice would be to backup and update the installation.