Phalcon - Raw Query Insert Syntax error

Question

I've got the following INSERT code :

$reservationSuccess = $app->modelsManager->executeQuery( 
    "INSERT INTO MastersReservedTime (master_id, service_id, date, time, desc)
     VALUES (:master_id:, :service_id:, :date:, :time:, :desc:)",
    array(
        'master_id' => $OrderCommit->master_id,
        'service_id' => $oneService -> service_id,
        'date' => $OrderCommit->date,
        'time' => $startTime,
        'desc' => $desc
    )
);

And this code generates the following error message :

PHP Fatal error: Uncaught exception 'Phalcon\Mvc\Model\Exception' with message 'Syntax error, unexpected token DESC, near to ')\r\n VALUES (:master_id:, :service_id:, :date:, :time:, :desc:)', when parsing: INSERT INTO MastersReservedTime (master_id, service_id, date, time, desc)\r\n VALUES (:master_id:, :service_id:, :date:, :time:, :desc:) (209)' in /var/www/api/v1.0/index.php:1827\nStack trace:\n#0 [internal function]: Phalcon\Mvc\Model\Query->parse()\n#1 [internal function]: Phalcon\Mvc\Model\Query->execute()\n#2 /var/www/api/v1.0/index.php(1827): Phalcon\Mvc\Model\Manager->executeQuery('INSERT INTO Mas...', Array)\n#3 [internal function]: {closure}()\n#4 /var/www/api/v1.0/index.php(1961): Phalcon\Mvc\Micro->handle()\n#5 {main}\n thrown in /var/www/api/v1.0/index.php on line 1827

What could cause the problem? Thanks in advance!

score 4 · Accepted Answer · answered Aug 03 '16 at 11:44

Desc is MySQL reserved word. You have to escape reserved words when you are using Raw queries. To escape them in PHQL you have to wrap them in square brackets [].

Rewriting your query like this will work:

INSERT INTO MastersReservedTime (master_id, service_id, date, time, [desc])
VALUES (:master_id:, :service_id:, :date:, :time:, :desc:)

Note the [desc] above.

Info from the docs: https://docs.phalconphp.com/en/latest/reference/phql.html#escaping-reserved-words

yep, that's it! Низкий поклон, до земли! – Nikita Semenov Aug 03 '16 at 11:48 — Nikita Semenov, Aug 03 '16 at 11:48

score 1 · Answer 2 · answered Aug 03 '16 at 11:40

1

Please, try use `desc` instead desc.

answered Aug 03 '16 at 11:40

Lakremon

787
1
8
26

INSERT INTO MastersReservedTime (master_id, service_id, date, time, 'desc') - didn't help*( now error : Uncaught exception 'Phalcon\\Mvc\\Model\\Exception' with message 'Syntax error, unexpected token STRING(desc), near to ') VALUES (:master_id:, :service_id:, :date:, :time:, :desc:)', when parsing: INSERT INTO MastersReservedTime (master_id, service_id, date, time, 'desc') – Nikita Semenov Aug 03 '16 at 11:43
nono, not ', use \` - it below escape button on your keybord. – Lakremon Aug 03 '16 at 11:45

score 1 · Answer 3 · answered Aug 03 '16 at 11:46

1

I think you got problem because you are using reserved words. Best solution it is add some prefix for columns.

answered Aug 03 '16 at 11:46

Danila Ganchar

10,266
13
49
75

Phalcon - Raw Query Insert Syntax error

3 Answers3