Solved thread

This post is marked as solved. If you think the information contained on this thread must be part of the official documentation, please contribute submitting a pull request to its repository.

Updating a row

Hi again,

At the moment I'm trying to update a row specially whenever a user last visits but everytime I keep getting errors saying few fields like email and usermae are required. My function which updates looks like this

$userId = 46;
$userModel = new User();
$userModel->user_id = $userId;
$userModel->last_login = time();

Any help would be appreciated.


You should do a search for the user, then assign the values as the table fields, is an example.

        $user = Users::findFirstById($id);
        if (!$user) {
            $this->flash->error("User was not found");
            return $this->dispatcher->forward(array(
                'action' => 'index'
        if ($this->request->isPost()) {
                    'name' => $this->request->getPost('name', 'striptags'),
                    'username' => $this->request->getPost('username', 'striptags'),
                    'email' => $this->request->getPost('email', 'email'),
                    'profilesId' => $this->request->getPost('profilesId', 'int'),
                    'active' => $this->request->getPost('active')
                if (!$user->save()) {
                } else {
                    $this->flash->success("User was updated successfully");
        $this->view->user = $user;
        $this->view->form = new UsersForm($user, array(
            'edit' => true


Thanks! That did the job :)