never use prepared statements inside a transaction, they are not working cause they are not bound to the transaction context