Error 1196 :Warning: Some non-transactional changed tables couldn't be rolled ba

[rameshfaj]

Hi frens!

I am using the EasyPHP1-7 that supports PHP and Mysql version 4.0.15.

When I use the concept of transaction in the connection,it generates the error:

 

Error 1196 :Warning: Some non-transactional changed tables couldn't be rolled back

 

Doesn't the EasyPHP1-7 supports for InnoDB tables?When I created the tables with InnoDB type using query itself also,it gives such an error.

Can anyone help me whats the problem?

[fenway]

Sounds like you have some non-InnoDB tables in there too...

[rameshfaj]

Thanks for ur answer but I have also inserted the type as InnoDB in the query which created the table,but the error was still produced. Have I done any mistakes,or can u show me some simple else methods? I am really annoyed with this problem.

[fenway]

Ask for SHOW CREATE TABLE and make sure that you're right.