update companyprofile set compstatus="",compapprove="",blacklisted="",compname="",comptype="",compota="",comparr="",compbillingname="",compshortname="",compaddr1="",compaddr2="",compaddr3="",compcity="",compstate="",compzip="",compcountry="",compphone1="",compfax="",compphone2="",compwebsite="",compemail="",compcontacttitle="",compcontactfirst="",compcontactlast="",compcontactdesig="",compcontactmob="",compremarks="",compmarketseg="",compbusssource="",compguesttype="",compbillinginstr="",compgueststat="",comppaymentmode="",compreservmode="",compvatno="",compsubledgctrlacc="",compcreditdays="",compcreditlimit="",comptaxcategory="",compvatregno="",complinkacc="",modifiedby="",modifiedon=now() where clientid="" and compid="" 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