Symfony2 error Expected end of string

Question

Trying to run a query with symfony and I get this error:

[Syntax Error] line 0, col 83: Error: Expected end of string, got 'username'

This code throws that error:

$query = $em->createQuery(
            'SELECT username
            FROM BLOGBlogBundle:user
            WHERE username= :usrname'
        )->setParameter('usrname', $usr);
        $products = $query->getResult();

What am I doing wrong?

Ken Hannel · Accepted Answer · 2013-07-16 19:17:12Z

8

Seems to work when you add in the alias

$query = $em->createQuery('
            SELECT u.username
            FROM BLOGBlogBundle:user u
            WHERE u.username = :usrname')
    ->setParameter('usrname', $usr);

$products = $query->getResult();

answered Jul 16, 2013 at 19:17

Ken Hannel

2,75820 silver badges20 bronze badges

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

1 Comment

John Cartwright Over a year ago

You always need to define an alias.

Shahzaib Hayat Khan · Accepted Answer · 2017-11-13 06:28:10Z

0

What worked for me is using Exp with ->set() like $qb->expr()

$qb = $this->em->createQueryBuilder();
$q = $qb->update('models\User', 'u')
        ->set('u.username', $qb->expr()->literal($username))
        ->set('u.email', $qb->expr()->literal($email))
        ->where('u.id = ?1')
        ->setParameter(1, $editId)
        ->getQuery();
$p = $q->execute();

answered Nov 13, 2017 at 6:28

Shahzaib Hayat Khan

1,00114 silver badges17 bronze badges

Collectives™ on Stack Overflow

Symfony2 error Expected end of string

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related