MySQLdb._exceptions.OperationalError: (1054, 'Unknown error 1054')

Question

1.when I'm updating I get this error

try:
            cur=db.cursor()
            print("update cur",cur)
            cur.execute('''UPDATE ast_details SET Asset_ID=%s,Make=%s,Model_No=%s,Serial_No=%s,
                    Purchased_Date=%s,Expired_Date=%s,Purchased_From=%s,Vendor_Name=%s,
                    Cost=%s,Laptop_Age=%s,Allocated_User=%s,
                    Allocated_Date=%s,Emp_ID=%s,Return_Date=%s where S.no=%s''',(ast_id,make,m_no,s_no,purch_dte,exp_dte,purch_frm,vndr_nme,cost,lap_age,alloc_usr,alloc_dte,emp_id,rtrn_dte,txtwhere))
        except mdb.MySQLError as e:
            print(e)

This is not enough to answer the question, update this in except block ``from traceback import format_exc;print(format_exc())`` and provide full stack trace. — sushanth, Jun 06 '20 at 04:59
Please provide a [*reproducible* example](https://stackoverflow.com/help/minimal-reproducible-example). What is you question? — max, Jun 06 '20 at 06:16

score 0 · Answer 1 · answered Jun 06 '20 at 05:05

I got solution I chnaged all column names with tild symbol it works fine for me

cur.execute('''UPDATE `ast_details` SET `Asset_ID`=%s,`Make`=%s,`Model_No`=%s,`Serial_No`=%s,
                    `Purchased_Date`=%s,`Expired_Date`=%s,`Purchased_From`=%s,`Vendor_Name`=%s,
                    `Cost`=%s,`Laptop_Age`=%s,`Allocated_User`=%s,
                    `Allocated_Date`=%s,`Emp_ID`=%s,`Return_Date`=%s WHERE `S.no`=%s''',(ast_id,make,m_no,s_no,purch_dte,exp_dte,purch_frm,vndr_nme,cost,lap_age,alloc_usr,alloc_dte,emp_id,rtrn_dte,txtwhere,))

MySQLdb._exceptions.OperationalError: (1054, 'Unknown error 1054')

1 Answers1