update outlet set outletname="",outshortname="",outlettype="",billroundoff="",appguestcharge="",appmiscesales="",valetaccept="",acceptcharge="",exclprntprgm="",exclprntprgmmisc="",uniquesrno="",tipsguest="",minibar="",laundry="",active="",dispseqno="",modifiedby="",modifiedon=now() where clientid="" and outletid="" 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