BC: Expected Doctrine\ORM\Query\Lexer::T_ALIASED_NAME, got 'Member' #5991

New Issue

Closed

opened 2026-01-22 15:24:13 +01:00 by admin · 9 comments

admin commented 2026-01-22 15:24:13 +01:00

Owner

Copy Link

Originally created by @caugner on GitHub (Jun 17, 2018).

Originally assigned to: @lcobucci on GitHub.

BC Break Report

Q	A
BC Break	yes
Version	2.6.1

Summary

I have an entity Member (with a field id), and determine the maximum id as follows:

<?php
$em->getRepository('Member')
   ->createQueryBuilder()
   ->select('MAX(m.id)')
   ->getQuery()
   ->getSingleScalarResult();

Previous behavior

It used to return the highest id (in 2.5.x).

Current behavior

This throws a QueryException now (in 2.6.1):

[Syntax Error] line 0, col 22: Error: Expected Doctrine\ORM\Query\Lexer::T_ALIASED_NAME, got 'Member'

#0 /path/to/app/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(452): Doctrine\ORM\Query\QueryException::syntaxError('line 0, col 22:...', Object(Doctrine\ORM\Query\QueryException))
#1 /path/to/app/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(309): Doctrine\ORM\Query\Parser->syntaxError('Doctrine\\ORM\\Qu...')
#2 /path/to/app/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(967): Doctrine\ORM\Query\Parser->match(100)
#3 /path/to/app/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1726): Doctrine\ORM\Query\Parser->AbstractSchemaName()
#4 /path/to/app/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1578): Doctrine\ORM\Query\Parser->RangeVariableDeclaration()
#5 /path/to/app/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1313): Doctrine\ORM\Query\Parser->IdentificationVariableDeclaration()
#6 /path/to/app/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(874): Doctrine\ORM\Query\Parser->FromClause()
#7 /path/to/app/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(843): Doctrine\ORM\Query\Parser->SelectStatement()
#8 /path/to/app/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(259): Doctrine\ORM\Query\Parser->QueryLanguage()
#9 /path/to/app/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(355): Doctrine\ORM\Query\Parser->getAST()
#10 /path/to/app/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(283): Doctrine\ORM\Query\Parser->parse()
#11 /path/to/app/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(295): Doctrine\ORM\Query->_parse()
#12 /path/to/app/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(957): Doctrine\ORM\Query->_doExecute()
#13 /path/to/app/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(912): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 4)
#14 /path/to/app/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(793): Doctrine\ORM\AbstractQuery->execute(NULL, 4)
#15 /path/to/app/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(821): Doctrine\ORM\AbstractQuery->getSingleResult(4)
#16 /path/to/app/public/test.php(11): Doctrine\ORM\AbstractQuery->getSingleScalarResult()
#17 {main}

How to reproduce

See code snippet above.

Originally created by @caugner on GitHub (Jun 17, 2018). Originally assigned to: @lcobucci on GitHub. ### BC Break Report | Q | A |------------ | ------ | BC Break | yes | Version | 2.6.1 #### Summary I have an entity `Member` (with a field `id`), and determine the maximum `id` as follows: ```php <?php $em->getRepository('Member') ->createQueryBuilder() ->select('MAX(m.id)') ->getQuery() ->getSingleScalarResult(); ``` #### Previous behavior It used to return the highest `id` (in 2.5.x). #### Current behavior This throws a `QueryException` now (in 2.6.1): > [Syntax Error] line 0, col 22: Error: Expected Doctrine\ORM\Query\Lexer::T_ALIASED_NAME, got 'Member' ``` #0 /path/to/app/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(452): Doctrine\ORM\Query\QueryException::syntaxError('line 0, col 22:...', Object(Doctrine\ORM\Query\QueryException)) #1 /path/to/app/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(309): Doctrine\ORM\Query\Parser->syntaxError('Doctrine\\ORM\\Qu...') #2 /path/to/app/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(967): Doctrine\ORM\Query\Parser->match(100) #3 /path/to/app/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1726): Doctrine\ORM\Query\Parser->AbstractSchemaName() #4 /path/to/app/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1578): Doctrine\ORM\Query\Parser->RangeVariableDeclaration() #5 /path/to/app/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1313): Doctrine\ORM\Query\Parser->IdentificationVariableDeclaration() #6 /path/to/app/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(874): Doctrine\ORM\Query\Parser->FromClause() #7 /path/to/app/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(843): Doctrine\ORM\Query\Parser->SelectStatement() #8 /path/to/app/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(259): Doctrine\ORM\Query\Parser->QueryLanguage() #9 /path/to/app/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(355): Doctrine\ORM\Query\Parser->getAST() #10 /path/to/app/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(283): Doctrine\ORM\Query\Parser->parse() #11 /path/to/app/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(295): Doctrine\ORM\Query->_parse() #12 /path/to/app/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(957): Doctrine\ORM\Query->_doExecute() #13 /path/to/app/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(912): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 4) #14 /path/to/app/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(793): Doctrine\ORM\AbstractQuery->execute(NULL, 4) #15 /path/to/app/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(821): Doctrine\ORM\AbstractQuery->getSingleResult(4) #16 /path/to/app/public/test.php(11): Doctrine\ORM\AbstractQuery->getSingleScalarResult() #17 {main} ``` #### How to reproduce See code snippet above.

admin added the BugInvalid labels 2026-01-22 15:24:13 +01:00

admin closed this issue 2026-01-22 15:24:13 +01:00

admin commented 2026-01-22 15:24:14 +01:00

Author

Owner

Copy Link

@Warxcell commented on GitHub (Aug 11, 2018):

Can you try following instead:

<?php $em->getRepository('Member') ->createQueryBuilder('m') ->select('MAX(m.id)') ->getQuery() ->getSingleScalarResult();

@Warxcell commented on GitHub (Aug 11, 2018): Can you try following instead: `<?php $em->getRepository('Member') ->createQueryBuilder('m') ->select('MAX(m.id)') ->getQuery() ->getSingleScalarResult(); `

admin commented 2026-01-22 15:24:14 +01:00

Author

Owner

Copy Link

@caugner commented on GitHub (Aug 12, 2018):

@Warxcell Thanks for your response. I can't spot a difference between your snippet and mine, could you elaborate on that?

@caugner commented on GitHub (Aug 12, 2018): @Warxcell Thanks for your response. I can't spot a difference between your snippet and mine, could you elaborate on that?

admin commented 2026-01-22 15:24:15 +01:00

Author

Owner

Copy Link

@Warxcell commented on GitHub (Aug 12, 2018):

@caugner Opps. Sorry, my wrong. I edited my response.

@Warxcell commented on GitHub (Aug 12, 2018): @caugner Opps. Sorry, my wrong. I edited my response.

admin commented 2026-01-22 15:24:15 +01:00

Author

Owner

Copy Link

@lcobucci commented on GitHub (Aug 12, 2018):

@caugner as pointed out by @Warxcell, the method EntityRepository#createQueryBuilder() requires an argument - which is not provided by your snippet. That argument is mandatory for a very long time.

Can you double check on your code if you're really not providing that argument? That's also supposed to raise a fatal error in PHP 7.1+ (it was a warning before).

@lcobucci commented on GitHub (Aug 12, 2018): @caugner as pointed out by @Warxcell, the method `EntityRepository#createQueryBuilder()` requires an argument - which is not provided by your snippet. That argument is mandatory for a very long time. Can you double check on your code if you're **really** not providing that argument? That's also supposed to raise a fatal error in PHP 7.1+ (it was a warning before).

admin commented 2026-01-22 15:24:15 +01:00

Author

Owner

Copy Link

@caugner commented on GitHub (Aug 12, 2018):

@lcobucci I was on PHP 7.1 when I updated from 2.5.1 to 2.6.1, and I'm pretty sure it neither raised a fatal error nor a warning (I have PHP error reporting via email that includes warnings); hence the BC Break Report.

As this issue has served its purpose though, I'm closing it now.

@Warxcell @lcobucci Thank you for explaining the reason for this exception.

@caugner commented on GitHub (Aug 12, 2018): @lcobucci I was on PHP 7.1 when I updated from 2.5.1 to 2.6.1, and I'm pretty sure it neither raised a fatal error nor a warning (I have PHP error reporting via email that includes warnings); hence the BC Break Report. As this issue has served its purpose though, I'm closing it now. @Warxcell @lcobucci Thank you for explaining the reason for this exception.

admin commented 2026-01-22 15:24:15 +01:00

Author

Owner

Copy Link

@lcobucci commented on GitHub (Aug 12, 2018):

@caugner glad it helped 👍

The fact that nothing was reported is quite disturbing and I'd recommend you to review your configuration - you can check PHP's behaviour here: https://3v4l.org/7rVFR.

@lcobucci commented on GitHub (Aug 12, 2018): @caugner glad it helped :+1: The fact that nothing was reported is quite disturbing and I'd recommend you to review your configuration - you can check PHP's behaviour here: https://3v4l.org/7rVFR.

admin commented 2026-01-22 15:24:15 +01:00

Author

Owner

Copy Link

@Limado commented on GitHub (May 31, 2020):

I'm having a similar issue.

My code:
$groups = $em->getRepository('Group')
->createQueryBuilder('g')
->where('g.users LIKE :myUserId')
->setParameter('myUserId', '%' . $user->getId() . '%')
->getQuery()
->getResult();

---

the error i'm getting :

Doctrine\ORM\Query\QueryException: [Syntax Error] line 0, col 14: Error: Expected Doctrine\ORM\Query\Lexer::T_ALIASED_NAME, got 'Group'

---

Tried 3 diferent way of building DQL, always getting same error.

_dql: "SELECT g FROM Group g WHERE g.users LIKE :myUserId"

@Limado commented on GitHub (May 31, 2020): I'm having a similar issue. My code: $groups = $em->getRepository('Group') ->createQueryBuilder('g') ->where('g.users LIKE :myUserId') ->setParameter('myUserId', '%' . $user->getId() . '%') ->getQuery() ->getResult(); **************************************************************************************************************** the error i'm getting : Doctrine\ORM\Query\QueryException: [Syntax Error] line 0, col 14: Error: Expected Doctrine\ORM\Query\Lexer::T_ALIASED_NAME, got 'Group' **************************************************************************************************************** Tried 3 diferent way of building DQL, always getting same error. _dql: "SELECT g FROM Group g WHERE g.users LIKE :myUserId"

admin commented 2026-01-22 15:24:16 +01:00

Author

Owner

Copy Link

@Warxcell commented on GitHub (May 31, 2020):

@Limado Don't use Group. It's reserved word.

@Warxcell commented on GitHub (May 31, 2020): @Limado Don't use Group. It's reserved word.

admin commented 2026-01-22 15:24:17 +01:00

Author

Owner

Copy Link

@yassineMessaoud9 commented on GitHub (Apr 10, 2022):

i the same error:
My code :
`
public function updateU($password,$email): ?Utilisateur
{
$qb = $this->getEntityManager()
->createQueryBuilder()
->update(Utilisateur::class,'u');
$qb
->where($qb->expr()->eq('u.motpasse',':password'))
->andWhere($qb->expr()->eq('u.email',':email'))
->setParameter('password',$password)
->setParameter('email',$email);

return $qb->getQuery()->getResult();  

}
`

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

@yassineMessaoud9 commented on GitHub (Apr 10, 2022): i the same error: My code : ` public function updateU($password,$email): ?Utilisateur { $qb = $this->getEntityManager() ->createQueryBuilder() ->update(Utilisateur::class,'u'); $qb ->where($qb->expr()->eq('u.motpasse',':password')) ->andWhere($qb->expr()->eq('u.email',':email')) ->setParameter('password',$password) ->setParameter('email',$email); return $qb->getQuery()->getResult(); } ` -------------------------------------------------- Error: `[Syntax Error] line 0, col 32: Error: Expected Doctrine\ORM\Query\Lexer::T_SET, got 'WHERE' `

Sign in to join this conversation.

No Branch/Tag Specified

Branches Tags

3.6.x

2.20.x

dependabot/github_actions/2.20.x/doctrine/dot-github/dot-github/workflows/composer-lint.yml-14.0.0

3.7.x

4.0.x

2.21.x

old-prototype-3.x

3.6.2

3.6.1

3.6.0

2.20.9

3.5.8

3.5.7

3.5.6

3.5.5

2.20.8

3.5.4

3.5.3

2.20.7

3.5.2

2.20.6

3.5.1

3.5.0

3.4.4

3.4.3

3.4.2

2.20.5

3.4.1

3.4.0

3.3.4

2.20.4

3.3.3

2.20.3

3.3.2

2.20.2

3.3.1

2.20.1

3.3.0

3.2.3

2.20.0

2.19.8

3.2.2

2.19.7

3.2.1

2.19.6

3.2.0

3.1.4

3.1.3

2.19.5

3.1.2

2.19.4

3.1.1

2.19.3

2.19.2

2.19.1

3.1.0

2.19.0

3.0.3

2.18.3

3.0.2

2.18.2

3.0.1

2.18.1

3.0.0

2.18.0

2.17.5

3.0.0-RC1

2.17.4

2.17.3

2.17.2

2.17.1

3.0.0-beta2

2.17.0

2.16.3

3.0.0-beta1

2.16.2

2.16.1

2.16.0

2.15.5

2.15.4

2.15.3

2.15.2

2.15.1

2.15.0

2.14.3

2.14.2

2.14.1

2.14.0

2.13.5

2.13.4

2.13.3

2.13.2

2.13.1

2.13.0

2.12.4

2.12.3

2.12.2

2.12.1

2.12.0

2.11.3

2.11.2

2.11.1

2.11.0

2.10.5

2.10.4

2.10.3

2.10.2

2.10.1

2.10.0

2.9.6

2.9.5

2.9.4

2.9.3

2.9.2

2.9.1

2.9.0

2.8.5

2.8.4

2.8.3

2.8.2

2.8.1

2.8.0

2.7.5

2.7.4

v2.7.3

v2.7.2

v2.7.1

v2.7.0

v2.6.6

v2.6.5

v2.6.4

v2.6.3

v2.6.2

v2.6.1

v2.6.0

v2.5.14

v2.5.13

v2.5.12

v2.5.11

v2.5.10

v2.5.9

v2.5.8

v2.5.7

v2.5.6

v2.5.5

v2.5.4

v2.5.3

v2.5.2

v2.4.8

v2.5.1

v2.5.0

v2.5.0-RC2

v2.5.0-RC1

v2.5.0-beta1

v2.5.0-alpha2

v2.5.0-alpha1

v2.4.7

v2.4.6

v2.4.5

v2.4.4

v2.4.3

v2.3.6

v2.4.2

2.3.5

v2.4.1

v2.4.0

2.4.0-RC2

2.4.0-RC1

2.4.0-BETA2

2.3.4

2.3.3

2.4.0-BETA1

2.3.2

2.3.1

2.3.0

2.3.0-RC4

2.3.0-RC3

2.3.0-RC2

2.2.3

2.3.0-RC1

2.3.0-BETA1

2.1.7

2.2.2

2.2.1

2.1.6

2.2.0

2.2.0-RC1

2.2.0-BETA2

2.2.0-BETA1

2.1.5

2.1.4

2.1.3

2.1.2

2.1.1

2.0.7

2.1.0

2.1.0RC3

2.1.0RC2

2.1.0RC1

2.0.6

2.1.0BETA1

2.0.5

2.0.4

2.0.3

2.0.2

2.0.1

2.0.0

2.0.0RC2

2.0.0RC1

2.0.0-BETA4

2.0.0-BETA3

2.0.0-BETA2

2.0.0-BETA1

Labels

Clear labels

BC Break

Bug

Can't Fix

Deprecation

Documentation

DQL

Duplicate

Failing Test

Hacktoberfest

Improvement

Improvement

Incomplete

Invalid

Missing Tests

New Feature

PR Created

pull-request

Mirrored from GitHub Pull Request

Question

Regression

Status: Waiting feedback

Waiting feedback

WIP

Won't Fix

No Label Bug Invalid

Milestone

No items

No Milestone

Projects

Clear projects

No project

Assignees

Clear assignees

admin

No Assignees

1 Participants

Notifications

Subscribe

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: doctrine/archived-orm#5991