How come this transaction goes through?

Yii 1.1 General Discussion
1

I’m trying to get transactions to work properly without success.

The following is the code, one of the sql-statements is broken on purpose($sql2)

but why does $sql1 still insert?




		$conn = yii::app()->db;

		$transaction = $conn->beginTransaction();

		try 

		{

			$sql1 = "INSERT INTO tbl_test (Author, Comment)VALUES('TestAuthor','testComment')";

			$sql2 = "INSERT INTO tbl_test Comment VALUES('Comment')";

			

			$conn->createCommand($sql1)->execute();

			$conn->createCommand($sql2)->execute();

			

			$transaction->commit();

		}

		catch(Exception $e)

		{

			$transaction->rollBack();

		}
2

Are you sure that tbl_test is INNODB table? You code looks fine.

3

Thanks m8 that was it, for some reason MyISAM was the engine for that particular table.

4

i agreed to Ivica…code looks fine. please check your table options for table tbl_test.