Re: Can't execute the given command because you have active locked tables or an active transaction

2009-12-30 Thread Miguel Angel Nieto
Hi, > I am getting "Can't execute the given command because you have active locked > tables or an active transaction" error when I am trying to truncate table. I > am unable to understand the error as when I am using the mysql query browser > then the same command is

Can't execute the given command because you have active locked tables or an active transaction

2009-12-30 Thread Manasi Save
Hi All,I am getting "Can't execute the given command because you have active locked tables or an active transaction" error when I am trying to truncate table. I am unable to understand the error as when I am using the mysql query browser then the same command is working fine but whe

Can't execute the given command because you have active locked tables or an active transaction

2004-07-06 Thread Michele Nicosia
Hi all, i have a problem with a db innoDB 4.0.20 server. The error 'Can't execute the given command because you have active locked tables or an active transaction' happens on the second truncate (the fist table trucante correctly) of a db composed by three tables, without any fo