INSERT INTO sale (SELECT saleid, group_id, custid, sale_reduce_status, caddid, uid, storeid, pmode, oid, orderid, billid, rbillid, cdate, bill_saleprice, bill_taxableamt, bill_gstamt, toprice, netqty, netsprice, empid, gift, ecomm, txnno, cshamt, crdamt, wallet_type, wallet_amt, cheque_no, cheque_date, actual_cash, cshreturn, creditamt, pamt, voucher, voucheramt, voucherno, creditnote, curdate, ctime, icouponid, rcouponred, rcouponamt, schqty, schdis, schamt, rpointdisc, stchnetamt, bstucount, delvdte, redyon, trailon, billdisc, billdiscper, sessid, nettax, bill_type, gst_type, execu_tax, saleto, vech_id, site_id, challan_stus, challan_id, sadd, site_km, taxtype, finace_com, finace_amt, txn_chrg_per, txn_chrg, file_charge, credit_finane, recv_finace_amt, finance_settle, settle_date, s_type, return_saleid, edit_status, round_off, refcustid, refpoint, sale_col1, sale_col2, sale_col3, sale_col4, sale_col5, sale_col6, sale_col7, sale_col8, sale_col9, sale_col10, sale_col11, btype, bill_tdisc, bill_tdiscper, extra_tdisc, extra_tdiscper, point_tdisc, discount_bill, mem_card, loc_id, cust_type, totbox, totpacket, totpiece, bill_status, bank_id, channel_name, cpoint_type, cpoint, rpoint, rpoint_val, sync_status, sync_saleid, sync_pid, wallet_json, sale_mode, dispatch_mode, courier_id, docket_num, order_status, refpoint_sat_status, refpoint_sat_date, pur_locid, hstatus, huid, oth_toamount, oth_tonettax, oth_tonetamt, bill_cessamt FROM `trigger_sale` where saleid='' )<hr>trigger sale ErrorColumn count doesn't match value count at row 1