{"issue":{"milestone":null,"user":{"login":"dzsii","id":19735,"url":"https://api.github.com/users/dzsii","avatar_url":"https://secure.gravatar.com/avatar/e285978e79f3c9e1d9450168f77687b3?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"e285978e79f3c9e1d9450168f77687b3"},"title":"[sortable] Error when removing entity","created_at":"2011-11-27T17:44:57Z","labels":[],"updated_at":"2011-12-19T15:28:26Z","state":"open","id":2361126,"pull_request":{"patch_url":null,"html_url":null,"diff_url":null},"html_url":"https://github.com/l3pp4rd/DoctrineExtensions/issues/197","closed_at":null,"body":"I have class table inheritance between two classes and sortable extension on the child class.\r\n\r\nWhen I try to remove an entity, i got the following exception from Doctrine (2.1.4):\r\n\r\nUncaught exception: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens\r\nThe exception was thrown on line: 707 in /usr/local/pear/share/pear/Doctrine/DBAL/Connection.php\r\n#0 /usr/local/pear/share/pear/Doctrine/DBAL/Connection.php(707): PDOStatement->execute()\r\n#1 /usr/local/pear/share/pear/Doctrine/ORM/Query/Exec/MultiTableUpdateExecutor.php(162): Doctrine\\DBAL\\Connection->executeUpdate('INSERT INTO Com...', Array, Array)\r\n#2 /usr/local/pear/share/pear/Doctrine/ORM/Query.php(249): Doctrine\\ORM\\Query\\Exec\\MultiTableUpdateExecutor->execute(Object(Doctrine\\DBAL\\Connection), Array, Array)\r\n#3 /usr/local/pear/share/pear/Doctrine/ORM/AbstractQuery.php(607): Doctrine\\ORM\\Query->_doExecute()\r\n#4 /usr/local/pear/share/pear/Doctrine/ORM/AbstractQuery.php(413): Doctrine\\ORM\\AbstractQuery->execute(Array, 1)\r\n#5 /home/thinkbig/progress/web/_plugins/DoctrineExtensions/lib/Gedmo/Sortable/SortableListener.php(304): Doctrine\\ORM\\AbstractQuery->getResult()\r\n#6 /home/thinkbig/progress/web/_plugins/DoctrineExtensions/lib/Gedmo/Sortable/SortableListener.php(104): Gedmo\\Sortable\\SortableListener->processRelocations(Object(Doctrine\\ORM\\EntityManager))\r\n#7 /usr/local/pear/share/pear/Doctrine/Common/EventManager.php(64): Gedmo\\Sortable\\SortableListener->onFlush(Object(Doctrine\\ORM\\Event\\OnFlushEventArgs))\r\n#8 /usr/local/pear/share/pear/Doctrine/ORM/UnitOfWork.php(280): Doctrine\\Common\\EventManager->dispatchEvent('onFlush', Object(Doctrine\\ORM\\Event\\OnFlushEventArgs))\r\n#9 /usr/local/pear/share/pear/Doctrine/ORM/EntityManager.php(334): Doctrine\\ORM\\UnitOfWork->commit()\r\n\r\nAs I could find out, the listener sets 3 parameters for it's update, but Doctrine expects only two for it's temp table insert.\r\n","number":197,"url":"https://api.github.com/repos/l3pp4rd/DoctrineExtensions/issues/197","comments":4,"assignee":null},"comment":{"user":{"login":"l3pp4rd","id":132389,"url":"https://api.github.com/users/l3pp4rd","avatar_url":"https://secure.gravatar.com/avatar/213cb2e855af1cbbee74fdc7e9c6d92d?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"213cb2e855af1cbbee74fdc7e9c6d92d"},"created_at":"2011-12-19T15:28:26Z","updated_at":"2011-12-19T15:28:26Z","id":3204434,"body":"this extension was actually contributed, I do not know well the source code, cannot promise a fix soon","url":"https://api.github.com/repos/l3pp4rd/DoctrineExtensions/issues/comments/3204434"},"action":"created"}