Cannot update values in database

Question

Cannot update values in database

demoniqus Mar '14

Created Mar '14	Last Reply Mar '14	Replies 3	Views 1596	Votes 0

demoniqus 3.0k

Mar '14

Hi! I have a problem updating some values in database... I have the table Tasks and the table Users. Field userId in the table Tasks is foreign key to the table Users. When I try to update a value in this field nothing happens - value does not change:

$task = Tasks::findFirst('id=' . $taskId);
$task->userId = $newUserId;
$task->save();
$updatedTask = Tasks::findFirst('id=' . $task->id);
echo $updatedTask->userId; /*In this point I get old value*/

Then I tried to do it using modelsManager->createQuery() - in this case also nothing happened. Only when I used db->query() then values were updated.

Please explain to me why it happens and how I can address this problem.

demoniqus
3.0k

Accepted
answer

Mar '14

Hi! I found the problem. Previous developer made compound primary key in the table Tasks - this key include the field userId. Therefore Phalcon didn't update this field. More if userId would be changed all fields couldn't be updated The problem is resolved - compound primary key

TheCodeAssassin · Answer 1 · 2014-03-13T23:48:57-07:00

Updating foreign key values usually doesn't work. Try this:

    $disableFk = new \Phalcon\MVC\Model\Query('SET foreign_key_checks = 0;');
    $disableFk->execute();

    // update your userId now

    $enableFk = new \Phalcon\MVC\Model\Query('SET foreign_key_checks = 1;');
    $enableFk->execute();

It is, ofcourse a better idea to use createQuery, but i just wanted to point you in the right direction.

Dylan Anderson · Answer 2 · 2014-03-14T14:06:08-07:00

Just as a sidenote, you don't need to specify "id =" when using findFirst(). Assuming you've set id as the table's primary key, this should work:

$task = Tasks::findFirst($taskId);

If the only argument to findFirst() is an integer, it assumes that integer should map to a primary key value.

Calin Rada · Answer 3 · 2014-03-17T03:18:13-07:00

$user = User::findFirstById($your_new_user_id);

$task = Tasks::findFirstById($taskId);
$task->user = $user;
$task->update();

// This should work without querying again
echo $task->getUserId();