I can't update records. I either get errors or I fill colums up with nulls on a new record (how does that even happen using update?).
So can someone PLEASE tell me how to perform an update with partial data without having a nightmare:
If I have the following in my database
id 3
status "old_status"
desc "this is a description"
year "2014"
Why won't $this->update(array("id" => 3, "status" => "new_status"))
give me:
id 3
status "new_status"
desc "this is a description"
year "2014"
at the end?
I've tried whitelist and $this->useDynamicUpdate(true);
and setting allow nulls in mysql and
\Phalcon\Mvc\Model::setup([
'notNullValidations' => false
]);
and various combinations but no joy.