MySQL Forums
Forum List  »  PHP

Re: Records missing after insert
Posted by: Paul Nair
Date: April 19, 2013 02:51PM

Thanks for the replies. I eventually got to the bottom of it. It was indeed an auto-rollback, from a transaction that was started in a stored procedure but never committed. I guess because the transaction was started in a procedure instead of by PDO's beginTransaction method, PDO didn't know about it so was returning false when I checked using inTransaction. I think it's a bit rubbish though that MySQL made no mention of the rollback in the query or error logs!

Options: ReplyQuote

Written By
April 18, 2013 04:32PM
Re: Records missing after insert
April 19, 2013 02:51PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.