In an invoice, I edit the item, when click update, the following error occurs,
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 ‘, localtax1_tx=0, localtax2_tx=0, localtax1_type=‘0’, localtax2_type=‘0’, qty=1,’ at line 1
System: CentOS8
PHP: 7
Dolibarr: 12.0.4
Hi,
Could you please upload the dolibarr.log ?
I found the error is here
2021-01-11 23:22:45 DEBUG 121.7.231.102 sql=UPDATE llx_facturedet SET description=’’, label=null, subprice=6.65301, remise_percent=0, fk_remise_except=null, vat_src_code = ‘’, tva_tx=7-, localtax1_tx=0, localtax2_tx=0, localtax1_type=‘0’, localtax2_type=‘0’, qty=1, date_start=null, date_end=null, product_type=1, info_bits=‘0’, special_code=‘0’, total_ht=6.65, total_tva=0.47, total_ttc=7.12, total_localtax1=0, total_localtax2=0, fk_product_fournisseur_price=null, buy_price_ht=‘0’, fk_parent_line=null, rang=12, situation_percent=100, fk_unit=NULL, fk_user_modif =3, multicurrency_subprice=5, multicurrency_total_ht=5, multicurrency_total_tva=0.35, multicurrency_total_ttc=5.35 WHERE rowid = 1357
2021-01-11 23:22:45 ERR 121.7.231.102 DoliDBMysqli::query SQL Error message: DB_ERROR_SYNTAX 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 ‘, localtax1_tx=0, localtax2_tx=0, localtax1_type=‘0’, localtax2_type=‘0’, qty=1,’ at line 1
My VAT is 7%, however in the SQL, it shows “7-”, I believe this is where the error lies.
