Why save()/update() doesn't save and returns no error

Question

Why save()/update() doesn't save and returns no error

marcelopiomsf Aug '15

Created Aug '15	Last Reply Aug '15	Replies 3	Views 1399	Votes 0

marcelopiomsf 2.5k

Aug '15

Hey guys,

I'm trying to update my table with save() or update() but something is wrong. Everytime that I send a post request with the new information that I want to update in my database, a JSON response is sent back to my brownser but this JSON response should just be sent when the update is sucessful and on my case nothing is changing on my database. Why save() is returning true? *My table has a primary key

Here is my code:

if ($this->request->isPost()) {
$jsonParsed = $this->request->getJsonRawBody();
    $this->view->disable();
    $users->user_id = $auth["user_id"];
    $users->user_username = $jsonParsed->username;

    if ( $users->save() == false ) {

            foreach ($users->getMessages() as $message) {

                echo $message->getMessage();

            }

    } else {

            $array = array("resposta" => "ok");

            $response = new \Phalcon\Http\Response();
            $response->setHeader("Content-Type", "application/json");
            $response->setContent(json_encode($array));
            $response->send();

        }
}

Soheil Samadzadeh · Answer 1 · 2015-08-11T04:06:02-07:00

If you use metadataCache service in you DI, and have change any table fileds after that, make sure to remove cache folder (or just user's table cache file) before runnig your code.

marcelopiomsf · Answer 2 · 2015-08-11T10:26:14-07:00

Actually I don't use metadataCache in my DI. But anyway I cleaned cache and still not working.

Thank you

Soheil Samadzadeh · Answer 3 · 2015-08-11T14:07:57-07:00

Log the queries with Event Manager and see what is happening under the hood...


// Listen all the database events
$eventManager->attach('db', function ($event, $connection) {
    if ($event->getType() == 'afterQuery') {
        echo $connection->getSQLStatement();
    }
});

Dylan Anderson · Answer 4 · 2015-08-12T15:45:02-07:00

Typically in cases like this, I would put an exit("Test") line in after if ( $users->save() == false ) {, to see if that condition was actually being met