Model update problem

Question

Model update problem

Karol Marcinkiewicz Jul '13

Created Jul '13	Last Reply Jul '13	Replies 2	Views 1028	Votes 1

Karol Marcinkiewicz 40.8k

Jul '13

Hi, I have got problem with update model

$robot = Robots::findFirst("id=7");
$robot->color = "blue";
$robot->update();

I got PDOException: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens What could make this error ?

#0  PDOStatement->execute()
#1  Phalcon\Db\Adapter\Pdo->executePrepared(Object(PDOStatement), Array(20), Array(20))
#2  Phalcon\Db\Adapter\Pdo->execute(UPDATE `****` SET `****` = ?, `****` = ?, `****` = ?, `****` = ?, `****` = ?, `****` = ?, `****` = ?, `***` = ?, `****` = ?, `****` = ?, `****` = ?, `****` = ?, `****` = ?, `****` = ?, `****` = ?, `****` = ?, `****` = ?, `****` = ?, `***` = ? WHERE 0, Array(20), Array(20))
#3  Phalcon\Db\Adapter->update(****, Array(19), Array(19), Array([conditions] => 1, [bind] => Array([0] => 17), [bindTypes] => 0), Array(19))
#4  Phalcon\Mvc\Model->_doLowUpdate(Object(Phalcon\Mvc\Model\MetaData\Memory), Object(Phalcon\Db\Adapter\Pdo\Mysql), rozliczenia)
#5  Phalcon\Mvc\Model->save()
#6  Phalcon\Mvc\Model->update()

1

Phalcon · Answer 1 · 2013-07-02T13:45:20-07:00

Phalcon
98.9k

Jul '13

Does the mapped table have a primary key?

Karol Marcinkiewicz · Answer 2 · 2013-07-02T13:53:46-07:00

Yes, table have got primary key id, and when i print_r($robot->toArray()); I can fetch record, but can't update it, can't save it.

Phalcon · Answer 3 · 2013-07-02T14:02:28-07:00

Can you please create a gist like this one: https://gist.github.com/phalcon/5610396, with the coding that are falling?

Karol Marcinkiewicz · Answer 4 · 2013-07-02T21:49:43-07:00

Karol Marcinkiewicz
40.8k

Jul '13

I will create it later. Maybe I find solution.