Description:
Hi,
I have create a one table ,insert function only execute properly but not working delete and update ..
How to solve this problem ..
pls help me . My Id is karthik_mca07@hotmail.com
How to repeat:
This is the table :
DROP TABLE IF EXISTS `acc_transactions_cr`;
CREATE TABLE `acc_transactions_cr` (
`cmp_id` varchar(10) NOT NULL,
`branch_id` varchar(10) NOT NULL,
`serial_no` int(11) NOT NULL,
`l_id` int(4) NOT NULL,
`g_id` int(4) NOT NULL,
`voucher_id` int(10) unsigned NOT NULL DEFAULT '0',
`voucher_type` varchar(15) NOT NULL,
`voucher_date` date DEFAULT NULL,
`millisec` longtext NOT NULL,
`increment` char(1) NOT NULL,
`sub_serial` char(1) NOT NULL,
`request_id` varchar(20) DEFAULT NULL,
`consignment_year` varchar(4) DEFAULT NULL,
`consignment_type` varchar(4) DEFAULT NULL,
`consignment_id` int(1) DEFAULT NULL,
`exbond_id` int(11) DEFAULT NULL,
`invoice_no` varchar(20) DEFAULT NULL,
`invoice_date` date DEFAULT NULL,
`profile_type` varchar(20) DEFAULT NULL,
`profile_id` varchar(20) DEFAULT NULL,
`desc_trans` varchar(70) DEFAULT NULL,
`mode_of_payment` varchar(20) DEFAULT NULL,
`bank_name` varchar(45) DEFAULT NULL,
`cheque_dd_no` varchar(45) DEFAULT NULL,
`cheque_dd_date` date DEFAULT NULL,
`dr_cr` char(2) NOT NULL,
`amount_transaction` double NOT NULL,
`tr_wise` int(1) DEFAULT NULL,
`against_status` char(2) NOT NULL,
`against_vid` varchar(15) NOT NULL,
`financial_year` varchar(4) NOT NULL,
`pending_voucher` char(1) NOT NULL,
`invoice_valid_lock` char(1) NOT NULL DEFAULT 'n',
`bsr_lock` char(1) NOT NULL,
`cancel_code` char(1) DEFAULT NULL,
`cancel_desc` varchar(70) DEFAULT NULL,
`lock_acc_trans_cr` char(1) NOT NULL,
`flag_acc_trans_cr` char(1) NOT NULL,
`fu_varchar1` varchar(25) DEFAULT NULL,
`fu_varchar2` varchar(25) DEFAULT NULL,
`fu_varchar3` varchar(25) DEFAULT NULL,
`fu_lock1` char(1) DEFAULT NULL,
`fu_lock2` char(1) DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`created_on` datetime DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
`modified_on` datetime DEFAULT NULL,
PRIMARY KEY (`cmp_id`,`branch_id`,`serial_no`,`l_id`,`voucher_id`,`voucher_type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Error is : wait lock process running...
Its take more time but coudn't execute the delete query
Suggested fix:
Error is : wait lock process running...
Its take more time but coudn't execute the delete query