Yii2: update field Error Unknown column with query builder

Question

I have database table 'cat_ralation'

CREATE TABLE IF NOT EXISTS `cat_relation` (
`id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
`cat_id` int(11) NOT NULL,
`obj_id` int(11) NOT NULL,
`obj_type` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

insert data

id = 1,
cat_id = 2,
obj_id = 3,
obj_type = product

Qyery builder

Yii::$app->db
   ->createCommand()
   ->update('cat_relation',['cat_id'=>3], 'obj_id = 3 AND obj_type = product')
   ->execute();

error

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'product' in 'where clause'
The SQL being executed was: UPDATE `cat_relation` SET `cat_id`=2 WHERE obj_id = 4 AND obj_type = product

I don't know nothing about pyyaml but shouldn't you quote `product` in quotes like `"product"` or `\'product\'`? — Cliff Burton, Apr 17 '16 at 15:49
Where is the relation to PyYAML? I don't see any YAML in your examples. What is your actual question? — Anthon, Apr 17 '16 at 17:55

score 0 · Answer 1 · answered Apr 18 '16 at 03:42

0

make it like

Yii::$app->db
   ->createCommand()
   ->update('cat_relation',['cat_id'=>3], "obj_id = 3 AND obj_type = 'product'")
   ->execute();

answered Apr 18 '16 at 03:42

Midhun

3,850
1
23
26

Yii2: update field Error Unknown column with query builder

1 Answers1