Doctrine - Symfony query error

Question

I do have an error and I don't know how to fix it.

$query = $entityManager->createQuery("UPDATE AppBundle:ChangeAPI SET `key`='asd123' WHERE `id` = 1");
$query->execute();

My AppBundle:ChangeAPI

/**
 * @ORM\Entity
 * @ORM\Table(name="api")
 */
 class ChangeAPI
 {
     /**
      * @ORM\Column(type="integer")
      * @ORM\Id
      * @ORM\GeneratedValue(strategy="AUTO")
      */
     protected $id;

     /**
      * The date on which the shipment has been created
      *
      * @ORM\Column(type="string", name="key")
      */
     protected $key;

     /** Creates a new standard ride */
     function __construct()
     {
     }
 }

And this is my error result:

[Syntax Error] line 0, col 31: Error: Expected Doctrine\ORM\Query\Lexer::T_SET, got '`'
QueryException: [Syntax Error] line 0, col 31: Error: Expected Doctrine\ORM\Query\Lexer::T_SET, got '`'
QueryException: UPDATE AppBundle:ChangeAPI SET `key`='asd123' WHERE `id` = 1

Can someone help me? Thanks.

Should not it be AppBundle.ChangeAPI instead of AppBundle:ChangeAPI? — Sougata Bose
– Sougata Bose, Commented Mar 22, 2017 at 13:26
@Matteo. If i don't use ` without, this will be the error: [Syntax Error] line 0, col 31: Error: Expected Doctrine\ORM\Query\Lexer::T_SET, got 'key — Colar Paul
– Colar Paul, Commented Mar 22, 2017 at 13:33

Palethorn · Accepted Answer · 2017-03-22 14:03:19Z

6

Why not use query builder:

$entityManager->createQueryBuilder()
    ->update('AppBundle:ChangeAPI', 'c')
    ->set('c.key', ':key')
    ->where('c.id = :id')
    ->setParameter('key', 'asd123')
    ->setParameter('id', 1)
    ->getQuery()
    ->execute();

Full reference http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/reference/query-builder.html

edited Mar 22, 2017 at 14:03

answered Mar 22, 2017 at 13:32

Palethorn

3771 silver badge12 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Colar Paul Over a year ago

[Syntax Error] line 0, col 57: Error: Expected =, <, <=, <>, >, >=, !=, got 'AND'

Palethorn Over a year ago

Edited sample. Where accepts parameters in a different way.

Colar Paul Over a year ago

I've tried but.. An exception occurred while executing 'UPDATE api SET key = ? WHERE id = ?' with params ["asd123", 1]: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'key = 'asd123' WHERE id = 1' at line 1

Colar Paul Over a year ago

I have more then 1 update queries, but i dont understand why this is not working, and the rest works !

Palethorn Over a year ago

Is your key column a string?

|

Matteo · Accepted Answer · 2017-03-22 13:48:55Z

2

Try using an alias:

$query = $entityManager->createQuery("UPDATE AppBundle:ChangeAPI c SET c.key='asd123' WHERE c.id = 1");
$query->execute();

Hope this help

answered Mar 22, 2017 at 13:48

Matteo

39.8k11 gold badges110 silver badges129 bronze badges

Comments

Robert · Accepted Answer · 2017-03-22 13:33:58Z

1

It's not MySQL query it's DQL query, therefore, don't use "`" character for name of cells.

$query = $entityManager->createQuery("UPDATE AppBundle:ChangeAPI SET key='asd123' WHERE id = 1");

answered Mar 22, 2017 at 13:33

Robert

20.3k6 gold badges58 silver badges85 bronze badges

1 Comment

Colar Paul Over a year ago

[Syntax Error] line 0, col 31: Error: Expected Doctrine\ORM\Query\Lexer::T_SET, got 'key'

Ollie in PGH · Accepted Answer · 2017-03-22 13:57:49Z

0

I guess you could create a query for this through Doctrine. Another way would be to change these in your normal controller methods.

In your controller:

/**
 * @Route("/edit/{id}"), name="app_edit_API")
 * @param ChangeAPI
 */
public function editAPIAction(ChangeAPI $changeAPI)
{
     $changeAPI->setKey('asd123');
     $this->getDoctrine()->getManager()->flush();
}

Are you using a form or is this maybe a command? If so then Palethorn's answer above is a better alternative.

answered Mar 22, 2017 at 13:57

Ollie in PGH

2,6392 gold badges18 silver badges19 bronze badges

Collectives™ on Stack Overflow

Doctrine - Symfony query error

4 Answers 4

8 Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

8 Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related