CDbMigration::update does not work inside foreach loop

yii,sql-update,database-migration,yii-migrations

I don't think you are providing the criteria parameter properly @ array('id = '.$menuId) . You should use a string if you want to send it like that, putting it in an array presumes you are mapping out the conditions in a key => value pair. Also you should be...

CDbCommand::createCommand() returns zero affected rows inside migration

sql,yii,database-migration,rows-affected,yii-migrations

CDbCommand::execute returns the row Count from underlying PDO interface, PDOstatement::rowCount only returns the row count of the last statement. I had tested this within migration to be sure that migrate script is not running any other commands for cleanup etc, this is not the case, I am able to get...