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

Possible to give some more information? Code you're using to produce the error. We need to be able to produce the issue with some code in order to fix it. If you could make a test case that will help us. Otherwise it is very difficult to fix an issue blindly Thanks. Something that also helps is singling out the revision that caused the problem.

I've discovered the same issue, with the symfony doctrine plugin Revision 23394. I just updated to the latest version and a "andWhereNotIn" clause which worked perfectly before is now failing -

$q->andWhereNotIn('hr.providerid', $ignoreProviderIds);

where $ignoreProviderIds = array('51', '31');

The stack trace is making it look like it's repeating the parameters somehow? Note the "'51', '31', '51', '31'" line below...

1. at ()
   in SF_ROOT_DIR/plugins/sfDoctrinePlugin/lib/doctrine/Doctrine/Connection.php line 1086 ...

1083.
1084. $name = 'Doctrine_Connection_' . $this->driverName . '_Exception';
1085.
1086. $exc = new $name($e->getMessage(), (int) $e->getCode());
1087. if ( ! isset($e->errorInfo) || ! is_array($e->errorInfo))

1. at Doctrine_Connection->rethrowException(object('PDOException'), object('Doctrine_Connection_Statement'))
   in SF_ROOT_DIR/plugins/sfDoctrinePlugin/lib/doctrine/Doctrine/Connection/Statement.php line 253 ...

250. } catch (Doctrine_Adapter_Exception $e)

252.
253. $this->_conn->rethrowException($e, $this);
254.
255. return false;
256. }

1. at Doctrine_Connection_Statement->execute(array('51', '31', '51', '31'))
   in SF_ROOT_DIR/plugins/sfDoctrinePlugin/lib/doctrine/Doctrine/Connection.php line 1014 ...

1011. try {
1012. if ( ! empty($params))

else

975. }
976. } else

979. } else

1035. } else {
1036. $stmt = $this->_execute($params);
1037.
1038. if (is_integer($stmt)) {
1039. $result = $stmt;

1. at Doctrine_Query_Abstract->execute()
   in SF_ROOT_DIR/apps/frontend/modules/common/actions/components.class.php line 1129 ...

Here's a diff of the changes that seem to be problematic:

sfDoctrinePlugin/lib/doctrine/Doctrine/Query.php

< * $Id: Query.php 6564 2009-10-23 18:21:16Z jwage $
—
> * $Id: Query.php 6407 2009-09-24 21:38:36Z guilhermeblanco $
329,330d328
< } else if ( ! ($this->_conn->getAttribute(Doctrine::ATTR_PORTABILITY) & Doctrine::PORTABILITY_EXPR)){
< return $dqlAlias;
1155c1153
< $list = $this->_conn->execute($subquery, $this->getParams($params))->fetchAll(Doctrine::FETCH_COLUMN);
—
> $list = $this->_conn->execute($subquery, $params)->fetchAll(Doctrine::FETCH_COLUMN);

The problem comes from what Bill Hunt says.
Tha fact is that parameters ($params) are duplicated by function getParams($params).

I also encouter it and it's really blocking (as exception is thrown, failing page to display).

The most "funny" things it does not always happen (even though I have it through sfDoctrinePager).
But clearly, I encountered it on parts of code I have not changed since months.

For me it happens when I'm trying to 'limit' the query. Query is complicated and contains joins, 'where' conditions, grouping and 'havings'.
And now it fails with duplicating bound params. Right after last subversion update and only when 'limiting'.

Oh. Forgot to say - I'm using 1.0 version (which comes with symfony 1.2)

As a temporary fix, I've downgraded the file in question on my site until the bug is patched. This may help some of you:

svn update -r 6407 symfony/plugins/sfDoctrinePlugin/lib/doctrine/Doctrine/Query.php

You may need to modify your path to suit your own needs, of course.

same problems since I have updated, yesterday (11/05).
I observe in the stack trace a parameters duplication, with a special effect when parameter value is zero (see "array(0, )") :

at Doctrine_Connection->execute('SELECT DISTINCT c3.id FROM contact c3 LEFT JOIN adresse_contact a2 ON c3.id = a2.contact_id LEFT JOIN etablissement e3 ON a2.etablissement_id = e3.id LEFT JOIN centre c4 ON a2.centre_id = c4.id LEFT JOIN email_contact e4 ON c3.id = e4.contact_id WHERE c3.non_valide = ? ORDER BY c3.nom, c3.prenom, c3.id LIMIT 16', array(0, ))
in SF_ROOT_DIR\lib\vendor\symfony\lib\plugins\sfDoctrinePlugin\lib\vendor\doctrine\Doctrine\Query.php line 1155

I just add this comment to say - like Eugeniy- I'm using 1.0.13 version (Revision: 6645) wich comes with symfony 1.2.9DEV

I've got the same problem, which seems to only affect the query when a limit is applied. (same reasons as above).

I'd probably revert the revision, but specifically you can fix it with

in Query.php 1155 removing $this->getParams($params) to $params

$list = $this->_conn->execute($subquery, $params)->fetchAll(Doctrine::FETCH_COLUMN);

and moving $q = $this->getCountQuery();

from 1930 to 1937 after $params = $this->_conn->convertBooleans($params);

I think it's critical, isn't it?

This bug affects sympal too

Some informations to solve the problem : $this->getParams($params) merge arrays, and values are duplicated

This was already fixed in all versions in SVN. The fix will be in the next scheduled releases.