I've created a table named 'HrmObjectPropertyValue' with MySQL which contains field "modified-at" that trigger now() each time the table is updated. I try to execute the following query:
UPDATE HrmObjectPropertyValue SET hrmvalueid = '18' WHERE hrmobjectid = '9' AND hrmpropertyid = '11'
It never works, the table not updated and the "modified-at" field also not automatically trigger though it returns success. However, it works well if i try to execute the query by using the lower database layer with \Phalcon\Db\Adapter\Pdo\Mysql.