update revenue set revname="",revshortname="",taxstruct="",billgroup="",refid="",revnature="",linkoutlet="",active="",caarr="",caer="",capr="",atcfar="",modifiedby="",modifiedon=now() where clientid="" and revid="" and id=Transaction failed: 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