maybe transaction bug !

[eluser]Henrik Pejer[/eluser]
Can you verify that this is a CI-bug and not a DB-bug? CI does not implement an internal transaction library or function: it simply uses the transaction capabilities of the database you are using. This means that CI does not analyze your queries and if something goes wrong, tries to restore the affected rows to its previous state.

If you want to double check: recreate the code without using CI, and see what happens.

Good luck!