Syntax Error: line 0, col 81: Error: Expected Literal, got 'NULL'
13,975
When you check for NULL value the expression should be
->andWhere('r.lang IS NULL')
![Victor Bocharsky](https://i.stack.imgur.com/rRqO1.jpg?s=256&g=1)
Comments
-
Victor Bocharsky almost 2 years
I got an error
[Syntax Error] line 0, col 81: Error: Expected Literal, got 'NULL'
when I try to execute query via query builder$qb = $this->createQueryBuilder('r') ->select('r') ->where('r.query = :query') ->setParameter('query', $query) ->andWhere('r.lang = NULL') ; return $qb->getQuery()->getOneOrNullResult();
r.lang
field is defined as:/** * @var integer * * @ORM\ManyToOne(targetEntity="\BW\LocalizationBundle\Entity\Lang") * @ORM\JoinColumn(name="lang_id", referencedColumnName="id") */ private $lang;
Help to solve error, please