Symfony2 - Invalid parameter number

Question

I have this error:

Invalid parameter number: number of bound variables does not match number of tokens

When I'm trying to get getAllOrders() in my Repository:

public function allOrdersQB()
{
    return $this->createQueryBuilder('o')
        ->andWhere('o.state != :canceled')
        ->andWhere('o.state != :receipt_complete')
        ->setParameters(array(
        'receipt_complete' => 'receipt_complete',
        'canceled' => 'canceled',
    ));
}

public function getAllOrders()
{
    return $this->allOrdersQB()
        ->andWhere('o.stateCorp = :stateCorp')
        ->setParameters(array(
            'stateCorp' => 0,
        ))
        ->getQuery()->getResult();
}

I don't understand because I have set all the parameters.

What did I do wrong?

Matteo · Accepted Answer · 2016-11-18 15:37:40Z

2

The setParameters method reset all previous parameters, so you could use the simple setParameter call (see in the source code here), as example:

public function allOrdersQB()
{
    return $this->createQueryBuilder('o')
        ->andWhere('o.state != :canceled')
        ->andWhere('o.state != :receipt_complete')
        ->setParameter('receipt_complete', 'receipt_complete')
        ->setParameter('canceled', 'canceled')
}

public function getAllOrders()
{
    return $this->allOrdersQB()
        ->andWhere('o.stateCorp = :stateCorp')
        ->setParameter('stateCorp', 0)
        ->getQuery()->getResult();
}

Hope this help

edited Nov 18, 2016 at 15:37

answered Nov 18, 2016 at 15:06

Matteo

39.8k11 gold badges110 silver badges129 bronze badges

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

2 Comments

Bobo Over a year ago

remove : in setParameter() function. Only setParameter('canceled', 'canceled')

Kevin Over a year ago

It's ok with setPameter, I just had to resolve the same problem in another method

Collectives™ on Stack Overflow

Symfony2 - Invalid parameter number

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related