Transactions not work ?

[eluser]sotoz[/eluser]
Hello.

When you are calling the rollback function you have not started any query to rollback. When you call the controller's insert function you do one connection to the database and try to insert something (I bet the insert isn't working either without the commit) but the query doesn't "stay in memory" so you can rollback it anytime by calling a different controller function.

You have to choose to rollback or commit a query at the runtime of the function you do the insert/update whatever.