Bug: You have an error in your SQL syntax

[richie0712]

Bug

Letzter Fehlerhafter Datenbankzugriff: SELECT b.rowid, b.dateo as do, b.datev as dv, b.amount, b.label, b.rappro, b.num_releve, b.num_chq, b.fk_type, b.fk_bordereau, ba.rowid as bankid, ba.ref as bankref, ba.label as banklabel, s.rowid as socid, s.nom as thirdparty FROM llx_bank_account as ba, llx_bank as b LEFT JOIN llx_bank_url as bu1 ON bu1.fk_bank = b.rowid AND bu1.type='company' LEFT JOIN llx_societe as s ON bu1.url_id = s.rowid LEFT JOIN llx_bank_url as bu2 ON bu2.fk_bank = b.rowid AND bu2.type='payment_vat' LEFT JOIN llx_tva as t ON bu2.url_id = t.rowid LEFT JOIN llx_bank_url as bu3 ON bu3.fk_bank = b.rowid AND bu3.type='payment_salary' LEFT JOIN llx_payment_salary as sal ON bu3.url_id = sal.rowid WHERE b.fk_account=1 AND b.fk_account = ba.rowid AND ba.entity IN (1) AND b.num_chq LIKE '%BadFirstParameterForGETPOST%' AND b.label LIKE '%BadFirstParameterForGETPOST%' AND b.amount = - AND b.amount = AND s.nom LIKE '%BadFirstParameterForGETPOST%' ORDER BY b.datev ASC, b.datec ASC
Rückgabewert des letzten fehlerhaften Datenbankzugriff: DB_ERROR_SYNTAX
Information zum letzten fehlerhaften Datenbankzugriff: 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 'AND b.amount = AND s.nom LIKE '%BadFirstParameterForGETPOST%' ORDER BY b.dat...' at line 1

Environment

• Version: 20.0.2
• OS: Linux
• Web server: LiteSpeed
• PHP: litespeed 7.4.33
• Database: MySQL or MariaDB 10.4.34-MariaDB-cll-lve
• URL(s): /firmen/index.php?mainmenu=home&leftmenu=home

Expected and actual behavior

[Verbose description]

Steps to reproduce the behavior

[Verbose description]

Attached files (Screenshots, screencasts, dolibarr.log, debugging information…)

[Files]

Report