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 hrm_value_id = '18' WHERE hrm_object_id = '9' AND hrm_property_id = '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.