[HELP] SQL error when deleting absolute discount

Using my Dolibarr
1

I am getting this error when attempting to delete an absolute discount that was incorrectly issued to a customer. I activated the debug logging, and the SQL command that triggers it is:

UPDATE llx_facture set paye=0, fk_statut=1 WHERE (type IN (2,3) AND rowid = 261

Which generates this error:
[DB_ERROR_SYNTAX] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘’ at line 1

I am running MariaDB 10.3.38 and Dolibarr 18.0.0 on Ubuntu 20.04.

2

Bumping this for visibility.

Anyone have any suggestions? I am stuck here.

3

Hello,

First thing to try is to update to v18.0.4