Doctrine 1
  1. Doctrine 1
  2. DC-145

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

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Critical Critical
    • Resolution: Fixed
    • Affects Version/s: 1.0.13, 1.1.4
    • Fix Version/s: 1.0.14, 1.1.6, 1.2.0-BETA3
    • Component/s: Query
    • Labels:
      None

      Description

        Activity

        Hide
        Simon Gow added a comment -

        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);

        Show
        Simon Gow added a comment - 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);
        Hide
        Eugeniy Belyaev added a comment -

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

        Show
        Eugeniy Belyaev added a comment - I think it's critical, isn't it?
        Hide
        Eugeniy Belyaev added a comment -

        This bug affects sympal too

        Show
        Eugeniy Belyaev added a comment - This bug affects sympal too
        Hide
        Etienne VOILLIOT added a comment -

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

        Show
        Etienne VOILLIOT added a comment - Some informations to solve the problem : $this->getParams($params) merge arrays, and values are duplicated
        Hide
        Jonathan H. Wage added a comment -

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

        Show
        Jonathan H. Wage added a comment - This was already fixed in all versions in SVN. The fix will be in the next scheduled releases.

          People

          • Assignee:
            Guilherme Blanco
            Reporter:
            Amir W
          • Votes:
            8 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: