Re: Records missing after insert

[Paul Nair]

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!