rameshfaj Posted October 20, 2007 Share Posted October 20, 2007 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? Quote Link to comment https://forums.phpfreaks.com/topic/74104-error-1196-warning-some-non-transactional-changed-tables-couldnt-be-rolled-ba/ Share on other sites More sharing options...
fenway Posted October 22, 2007 Share Posted October 22, 2007 Sounds like you have some non-InnoDB tables in there too... Quote Link to comment https://forums.phpfreaks.com/topic/74104-error-1196-warning-some-non-transactional-changed-tables-couldnt-be-rolled-ba/#findComment-375174 Share on other sites More sharing options...
rameshfaj Posted October 25, 2007 Author Share Posted October 25, 2007 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. Quote Link to comment https://forums.phpfreaks.com/topic/74104-error-1196-warning-some-non-transactional-changed-tables-couldnt-be-rolled-ba/#findComment-377994 Share on other sites More sharing options...
fenway Posted October 25, 2007 Share Posted October 25, 2007 Ask for SHOW CREATE TABLE and make sure that you're right. Quote Link to comment https://forums.phpfreaks.com/topic/74104-error-1196-warning-some-non-transactional-changed-tables-couldnt-be-rolled-ba/#findComment-378043 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.