Skip to content

Instantly share code, notes, and snippets.

@BenjaminNolan
Last active August 29, 2015 14:06
Show Gist options
  • Select an option

  • Save BenjaminNolan/3323ac1d653f880dbe45 to your computer and use it in GitHub Desktop.

Select an option

Save BenjaminNolan/3323ac1d653f880dbe45 to your computer and use it in GitHub Desktop.
This generates a weird error in doctrine/dbal 2.5 when it's used from doctrine/orm 2.4
{
"name": "ohlook/its-a-bee",
"description": "Super Secret Project",
"license": "All Rights Reserved",
"keywords": [
"bp",
"fll",
"api"
],
"homepage": "http://www.wearetilt.com/",
"require": {
"php": ">=5.5.0",
"zendframework/zendframework": "2.3.*",
"doctrine/doctrine-module": "0.*",
"doctrine/doctrine-orm-module": "0.*",
"hounddog/doctrine-data-fixture-module": "0.*",
"phpunit/phpunit": "4.*",
"guzzlehttp/guzzle": "4.*"
},
"require-dev": {
"zf-commons/zfc-user": "dev-master",
"onelogin/php-saml": "dev-master",
"twowholeworms/tww-saml": "dev-master",
"zendframework/zendservice-apple-apns": "dev-master",
"zendframework/zend-developer-tools": "dev-master",
"zendframework/zftool": "dev-master",
"doctrine/dbal": "2.5.*@dev",
"doctrine/orm": "2.5.*@dev",
"bjyoungblood/bjy-profiler": "dev-master"
}
}
<?php
// [Syntax Error] line 0, col -1: Error: "Expected Literal, got end of string"
//
// I think it's line 12 that's causing that to happen. It spits out "DELETE BP\\Entity\\UserDevice ud WHERE " and that's it.
$objectManager = $this->getServiceLocator()->get('Doctrine\\ORM\\EntityManager');
$user = $objectManager->getRepository('Tww\\Entity\\User')->findOneBy(['ntid' => $samlUserdata['user-id']]);
$qb = $objectManager->createQueryBuilder();
$qb->delete('Tww\\Entity\\UserDevice', 'ud')
->andWhere($qb->expr()->eq('ud.user', ':user'))
->setParameter(':user', $user);
$q = $qb->getQuery();
$q->execute();
exception 'Doctrine\ORM\Query\QueryException' with message 'DELETE Tww\Entity\UserDevice ud WHERE ' in project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:41
Stack trace:
#0 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(448): Doctrine\ORM\Query\QueryException::dqlError()
#1 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2586): Doctrine\ORM\Query\Parser->syntaxError()
#2 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2774): Doctrine\ORM\Query\Parser->Literal()
#3 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2708): Doctrine\ORM\Query\Parser->ArithmeticPrimary()
#4 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2676): Doctrine\ORM\Query\Parser->ArithmeticFactor()
#5 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2650): Doctrine\ORM\Query\Parser->ArithmeticTerm()
#6 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2637): Doctrine\ORM\Query\Parser->SimpleArithmeticExpression()
#7 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2973): Doctrine\ORM\Query\Parser->ArithmeticExpression()
#8 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2501): Doctrine\ORM\Query\Parser->ComparisonExpression()
#9 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2384): Doctrine\ORM\Query\Parser->SimpleConditionalExpression()
#10 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2360): Doctrine\ORM\Query\Parser->ConditionalPrimary()
#11 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2328): Doctrine\ORM\Query\Parser->ConditionalFactor()
#12 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2303): Doctrine\ORM\Query\Parser->ConditionalTerm()
#13 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1327): Doctrine\ORM\Query\Parser->ConditionalExpression()
#14 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(907): Doctrine\ORM\Query\Parser->WhereClause()
#15 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(851): Doctrine\ORM\Query\Parser->DeleteStatement()
#16 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(268): Doctrine\ORM\Query\Parser->QueryLanguage()
#17 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(351): Doctrine\ORM\Query\Parser->getAST()
#18 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(255): Doctrine\ORM\Query\Parser->parse()
#19 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(267): Doctrine\ORM\Query->_parse()
#20 project/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(794): Doctrine\ORM\Query->_doExecute()
#21 project/module/Tww/src/Tww/Controller/AuthController.php(149): Doctrine\ORM\AbstractQuery->execute()
#22 project/vendor/zendframework/zendframework/library/Zend/Mvc/Controller/AbstractRestfulController.php(456): Tww\Controller\AuthController->create()
#23 project/vendor/zendframework/zendframework/library/Zend/Mvc/Controller/AbstractRestfulController.php(414): Zend\Mvc\Controller\AbstractRestfulController->processPostData()
#24 (): Zend\Mvc\Controller\AbstractRestfulController->onDispatch()
#25 project/vendor/zendframework/zendframework/library/Zend/EventManager/EventManager.php(468): call_user_func()
#26 project/vendor/zendframework/zendframework/library/Zend/EventManager/EventManager.php(207): Zend\EventManager\EventManager->triggerListeners()
#27 project/vendor/zendframework/zendframework/library/Zend/Mvc/Controller/AbstractController.php(117): Zend\EventManager\EventManager->trigger()
#28 project/vendor/zendframework/zendframework/library/Zend/Mvc/Controller/AbstractRestfulController.php(300): Zend\Mvc\Controller\AbstractController->dispatch()
#29 project/vendor/zendframework/zendframework/library/Zend/Mvc/DispatchListener.php(114): Zend\Mvc\Controller\AbstractRestfulController->dispatch()
#30 (): Zend\Mvc\DispatchListener->onDispatch()
#31 project/vendor/zendframework/zendframework/library/Zend/EventManager/EventManager.php(468): call_user_func()
#32 project/vendor/zendframework/zendframework/library/Zend/EventManager/EventManager.php(207): Zend\EventManager\EventManager->triggerListeners()
#33 project/vendor/zendframework/zendframework/library/Zend/Mvc/Application.php(313): Zend\EventManager\EventManager->trigger()
#34 project/public/index.php(21): Zend\Mvc\Application->run()
#35 {main}
Next exception 'Doctrine\ORM\Query\QueryException' with message '[Syntax Error] line 0, col -1: Error: Expected Literal, got end of string.' in project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:52
Stack trace:
#0 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(448): Doctrine\ORM\Query\QueryException::syntaxError()
#1 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2586): Doctrine\ORM\Query\Parser->syntaxError()
#2 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2774): Doctrine\ORM\Query\Parser->Literal()
#3 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2708): Doctrine\ORM\Query\Parser->ArithmeticPrimary()
#4 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2676): Doctrine\ORM\Query\Parser->ArithmeticFactor()
#5 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2650): Doctrine\ORM\Query\Parser->ArithmeticTerm()
#6 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2637): Doctrine\ORM\Query\Parser->SimpleArithmeticExpression()
#7 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2973): Doctrine\ORM\Query\Parser->ArithmeticExpression()
#8 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2501): Doctrine\ORM\Query\Parser->ComparisonExpression()
#9 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2384): Doctrine\ORM\Query\Parser->SimpleConditionalExpression()
#10 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2360): Doctrine\ORM\Query\Parser->ConditionalPrimary()
#11 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2328): Doctrine\ORM\Query\Parser->ConditionalFactor()
#12 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2303): Doctrine\ORM\Query\Parser->ConditionalTerm()
#13 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1327): Doctrine\ORM\Query\Parser->ConditionalExpression()
#14 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(907): Doctrine\ORM\Query\Parser->WhereClause()
#15 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(851): Doctrine\ORM\Query\Parser->DeleteStatement()
#16 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(268): Doctrine\ORM\Query\Parser->QueryLanguage()
#17 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(351): Doctrine\ORM\Query\Parser->getAST()
#18 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(255): Doctrine\ORM\Query\Parser->parse()
#19 project/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(267): Doctrine\ORM\Query->_parse()
#20 project/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(794): Doctrine\ORM\Query->_doExecute()
#21 project/module/Tww/src/Tww/Controller/AuthController.php(149): Doctrine\ORM\AbstractQuery->execute()
#22 project/vendor/zendframework/zendframework/library/Zend/Mvc/Controller/AbstractRestfulController.php(456): Tww\Controller\AuthController->create()
#23 project/vendor/zendframework/zendframework/library/Zend/Mvc/Controller/AbstractRestfulController.php(414): Zend\Mvc\Controller\AbstractRestfulController->processPostData()
#24 (): Zend\Mvc\Controller\AbstractRestfulController->onDispatch()
#25 project/vendor/zendframework/zendframework/library/Zend/EventManager/EventManager.php(468): call_user_func()
#26 project/vendor/zendframework/zendframework/library/Zend/EventManager/EventManager.php(207): Zend\EventManager\EventManager->triggerListeners()
#27 project/vendor/zendframework/zendframework/library/Zend/Mvc/Controller/AbstractController.php(117): Zend\EventManager\EventManager->trigger()
#28 project/vendor/zendframework/zendframework/library/Zend/Mvc/Controller/AbstractRestfulController.php(300): Zend\Mvc\Controller\AbstractController->dispatch()
#29 project/vendor/zendframework/zendframework/library/Zend/Mvc/DispatchListener.php(114): Zend\Mvc\Controller\AbstractRestfulController->dispatch()
#30 (): Zend\Mvc\DispatchListener->onDispatch()
#31 project/vendor/zendframework/zendframework/library/Zend/EventManager/EventManager.php(468): call_user_func()
#32 project/vendor/zendframework/zendframework/library/Zend/EventManager/EventManager.php(207): Zend\EventManager\EventManager->triggerListeners()
#33 project/vendor/zendframework/zendframework/library/Zend/Mvc/Application.php(313): Zend\EventManager\EventManager->trigger()
#34 project/public/index.php(21): Zend\Mvc\Application->run()
#35 {main}
ORM 2.5 => 2.4
==============
Removed "doctrine/orm": "2.5.*@dev" from composer.json, ran composer update, got this:
- Removing doctrine/instantiator (1.0.2)
- Updating doctrine/orm (dev-master 15a00ea => v2.4.4)
Checking out fc19c3b53dcd00e6584db40669fdd699c4671f97
DBAL 2.5 => 2.4
===============
Removed "doctrine/dbal": "2.5.*@dev" from composer.json, ran composer update, got this:
- Updating doctrine/dbal (dev-master 7175964 => v2.4.2)
Checking out fec965d330c958e175c39e61c3f6751955af32d0
DBAL 2.4 => 2.5
===============
Added "doctrine/dbal": "2.5.*@dev" to composer.json, ran composer update, got this:
- Updating doctrine/dbal (v2.4.2 => dev-master 7175964)
Checking out 7175964c30f4fd54c90f6f9c7c6f7bf49fc1c939
ORM 2.4 => 2.5
==============
Added "doctrine/orm": "2.5.*@dev" to composer.json, ran composer update, got this:
- Installing doctrine/instantiator (1.0.2)
Loading from cache
- Updating doctrine/orm (v2.4.4 => dev-master 15a00ea)
Checking out 15a00ea80746e1b93a5964807a2a6f63143758d3
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment