Doctrine2 and Postgres : Invalid input syntax for boolean : ""

Question

    SQLSTATE[22P02]: Invalid text representation: 7 
    ERROR: invalid input syntax for type boolean: ""
    500 Internal Server Error - PDOException

It's the error message cause by Doctrine2 (2.2-DEV) and i'm afraid it's that bug which appeared again: http://www.doctrine-project.org/jira/browse/DDC-1394

The query which causes this error is as follows:

public function getFindAllNonOthersQueryBuilder()
{
    return $this
        ->createQueryBuilder('t')
        ->where('t.isOther = :isOther')
        ->setParameter('isOther', false);
}

The field isOther is mapped this way :

/**
 * @var boolean $isOther
 *
 * @ORM\Column(name="isOther", type="boolean")
 */
protected $isOther = false;

What's happening in here? I've checked the type in the postgres database and it's a boolean too

Karin van den Berg · Accepted Answer · 2013-04-03 11:44:07Z

8

I did some more googling as I have the same issue and I found the solution through the FOSMessageBundle, if you add '\PDO::PARAM_BOOL' to your setParameter it works, like so:

$qb->setParameter('isOther', false, \PDO::PARAM_BOOL);

answered Apr 3, 2013 at 11:44

Karin van den Berg

2013 silver badges4 bronze badges

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

Comments

Athlan · Accepted Answer · 2013-04-17 20:52:14Z

5

You have to use Literal expression. It is related with issue #DDC-1683

My sample code:

$q->andWhere($q->expr()->eq('item.published', $q->expr()->literal(true)));

answered Apr 17, 2013 at 20:52

Athlan

6,7194 gold badges43 silver badges58 bronze badges

Comments

Besnik · Accepted Answer · 2012-07-10 19:04:49Z

2

I had the same problem.

Solution: Use 0 instead of false:

...
->setParameter('isOther', 0);

answered Jul 10, 2012 at 19:04

Besnik

6,5581 gold badge33 silver badges34 bronze badges

1 Comment

sf_tristanb Over a year ago

Yeah, 'false' seems to be ok too but i wanna know WHY ?

Collectives™ on Stack Overflow

Doctrine2 and Postgres : Invalid input syntax for boolean : ""

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest