0

I tried to execute some custom queries using DB::execute() function by passing query as a parameter to this function - update query on existing table. Before running this query I checked the connection object like this $connection = DB::getConnection(); and it returned a connection identifier. Then while executing query it returned bool true from execute function, though changes were not there in database table fields. Also if I pass query with wrong syntax, it is giving error.

Is there any rollback process going on in background with update query statement in ActiveCollab? If yes how to stop this rollback to avoid the changes done by my update query ?

Could anyone tell me what could be the issue here ?

Jayesh Ambali
  • 211
  • 6
  • 24

1 Answers1

1

All uncommitted transactions are automatically rolled back on script shutdown so you need to make sure that you are committing transactions that you opened:

try {
  DB::beginWork();

  // Do something

  DB::commit();
} catch(Exception $e) {
  DB::rollback();
  throw $e;
}

or:

DB::transact(function() {
  // Do something
});

If you are within a nested transaction and outer transactions gets rolled back, your updates will be rolled back as well.

Ilija
  • 4,105
  • 4
  • 32
  • 46
  • Thanks @ llija. When I tried to select some fields in project table using select query. All of the fields I tried to select became empty. In fact 4 fields I added to projects table in addition to custom fields provided by aC and problem is with these fields. What could be the issue here ? Or is there any alternative way to do select query ? – Jayesh Ambali Oct 09 '13 at 13:23
  • When you execute a select query, do you get any exception? – Ilija Oct 09 '13 at 14:57
  • I configured the issue as I was doing another update on the constructor and that caused the clearing issue. :) – Jayesh Ambali Oct 10 '13 at 08:46