Filter by property generates an error

Omeka S
1

I have this error when I try to filter by property (both in admin and public page).

Any idea?


Omeka S rencontre une erreur

Doctrine\ORM\Query\QueryException
[Syntax Error] line 0, col 76: Error: Expected =, <, <=, <>, >, >=, !=, got 'AND'

Détails :

Doctrine\ORM\Query\QueryException: SELECT v FROM Omeka\Entity\Value v INNER JOIN v.resource r WHERE v.property AND :omeka_2 in /site/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:41
Stack trace:
#0 /site/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(448): Doctrine\ORM\Query\QueryException::dqlError('SELECT v FROM O...')
#1 /site/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(3325): Doctrine\ORM\Query\Parser->syntaxError('=, <, <=, <>, >...')
#2 /site/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(3040): Doctrine\ORM\Query\Parser->ComparisonOperator()
#3 /site/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2564): Doctrine\ORM\Query\Parser->ComparisonExpression()
#4 /site/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2447): Doctrine\ORM\Query\Parser->SimpleConditionalExpression()
#5 /site/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2423): Doctrine\ORM\Query\Parser->ConditionalPrimary()
#6 /site/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2391): Doctrine\ORM\Query\Parser->ConditionalFactor()
#7 /site/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2366): Doctrine\ORM\Query\Parser->ConditionalTerm()
#8 /site/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1333): Doctrine\ORM\Query\Parser->ConditionalExpression()
#9 /site/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(876): Doctrine\ORM\Query\Parser->WhereClause()
#10 /site/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(843): Doctrine\ORM\Query\Parser->SelectStatement()
#11 /site/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(268): Doctrine\ORM\Query\Parser->QueryLanguage()
#12 /site/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(351): Doctrine\ORM\Query\Parser->getAST()
#13 /site/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(281): Doctrine\ORM\Query\Parser->parse()
#14 /site/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(293): Doctrine\ORM\Query->_parse()
#15 /site/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(962): Doctrine\ORM\Query->_doExecute()
#16 /site/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(917): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 1)
#17 /site/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(720): Doctrine\ORM\AbstractQuery->execute(NULL, 1)
#18 /siteapplication/src/Api/Adapter/AbstractResourceEntityAdapter.php(364): Doctrine\ORM\AbstractQuery->getResult()
#19 /siteapplication/src/Api/Representation/AbstractResourceEntityRepresentation.php(345): Omeka\Api\Adapter\AbstractResourceEntityAdapter->getSubjectValues(Object(Omeka\Entity\Item), 1, 25, '60')
#20 /siteapplication/src/Api/Representation/AbstractResourceEntityRepresentation.php(444): Omeka\Api\Representation\AbstractResourceEntityRepresentation->subjectValues(1, 25, '60')
#21 /sitethemes/ahp/view/omeka/site/item/show.phtml(110): Omeka\Api\Representation\AbstractResourceEntityRepresentation->displaySubjectValues(1, 25, '60')
#22 /site/vendor/zendframework/zend-view/src/Renderer/PhpRenderer.php(506): include('/sites/ehp-ahpn...')
#23 /site/vendor/zendframework/zend-view/src/View.php(207): Zend\View\Renderer\PhpRenderer->render(NULL)
#24 /site/vendor/zendframework/zend-view/src/View.php(236): Zend\View\View->render(Object(Zend\View\Model\ViewModel))
#25 /site/vendor/zendframework/zend-view/src/View.php(200): Zend\View\View->renderChildren(Object(Zend\View\Model\ViewModel))
#26 /site/vendor/zendframework/zend-mvc/src/View/Http/DefaultRenderingStrategy.php(105): Zend\View\View->render(Object(Zend\View\Model\ViewModel))
#27 /site/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Zend\Mvc\View\Http\DefaultRenderingStrategy->render(Object(Zend\Mvc\MvcEvent))
#28 /site/vendor/zendframework/zend-eventmanager/src/EventManager.php(171): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent))
#29 /site/vendor/zendframework/zend-mvc/src/Application.php(367): Zend\EventManager\EventManager->triggerEvent(Object(Zend\Mvc\MvcEvent))
#30 /site/vendor/zendframework/zend-mvc/src/Application.php(348): Zend\Mvc\Application->completeRequest(Object(Zend\Mvc\MvcEvent))
#31 /siteindex.php(21): Zend\Mvc\Application->run()
#32 {main}

Next Doctrine\ORM\Query\QueryException: [Syntax Error] line 0, col 76: Error: Expected =, <, <=, <>, >, >=, !=, got 'AND' in /site/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:52
Stack trace:
#0 /site/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(448): Doctrine\ORM\Query\QueryException::syntaxError('line 0, col 76:...', Object(Doctrine\ORM\Query\QueryException))
#1 /site/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(3325): Doctrine\ORM\Query\Parser->syntaxError('=, <, <=, <>, >...')
#2 /site/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(3040): Doctrine\ORM\Query\Parser->ComparisonOperator()
#3 /site/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2564): Doctrine\ORM\Query\Parser->ComparisonExpression()
#4 /site/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2447): Doctrine\ORM\Query\Parser->SimpleConditionalExpression()
#5 /site/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2423): Doctrine\ORM\Query\Parser->ConditionalPrimary()
#6 /site/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2391): Doctrine\ORM\Query\Parser->ConditionalFactor()
#7 /site/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2366): Doctrine\ORM\Query\Parser->ConditionalTerm()
#8 /site/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1333): Doctrine\ORM\Query\Parser->ConditionalExpression()
#9 /site/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(876): Doctrine\ORM\Query\Parser->WhereClause()
#10 /site/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(843): Doctrine\ORM\Query\Parser->SelectStatement()
#11 /site/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(268): Doctrine\ORM\Query\Parser->QueryLanguage()
#12 /site/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(351): Doctrine\ORM\Query\Parser->getAST()
#13 /site/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(281): Doctrine\ORM\Query\Parser->parse()
#14 /site/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(293): Doctrine\ORM\Query->_parse()
#15 /site/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(962): Doctrine\ORM\Query->_doExecute()
#16 /site/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(917): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 1)
#17 /site/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(720): Doctrine\ORM\AbstractQuery->execute(NULL, 1)
#18 /siteapplication/src/Api/Adapter/AbstractResourceEntityAdapter.php(364): Doctrine\ORM\AbstractQuery->getResult()
#19 /siteapplication/src/Api/Representation/AbstractResourceEntityRepresentation.php(345): Omeka\Api\Adapter\AbstractResourceEntityAdapter->getSubjectValues(Object(Omeka\Entity\Item), 1, 25, '60')
#20 /siteapplication/src/Api/Representation/AbstractResourceEntityRepresentation.php(444): Omeka\Api\Representation\AbstractResourceEntityRepresentation->subjectValues(1, 25, '60')
#21 /sitethemes/ahp/view/omeka/site/item/show.phtml(110): Omeka\Api\Representation\AbstractResourceEntityRepresentation->displaySubjectValues(1, 25, '60')
#22 /site/vendor/zendframework/zend-view/src/Renderer/PhpRenderer.php(506): include('/sites/ehp-ahpn...')
#23 /site/vendor/zendframework/zend-view/src/View.php(207): Zend\View\Renderer\PhpRenderer->render(NULL)
#24 /site/vendor/zendframework/zend-view/src/View.php(236): Zend\View\View->render(Object(Zend\View\Model\ViewModel))
#25 /site/vendor/zendframework/zend-view/src/View.php(200): Zend\View\View->renderChildren(Object(Zend\View\Model\ViewModel))
#26 /site/vendor/zendframework/zend-mvc/src/View/Http/DefaultRenderingStrategy.php(105): Zend\View\View->render(Object(Zend\View\Model\ViewModel))
#27 /site/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Zend\Mvc\View\Http\DefaultRenderingStrategy->render(Object(Zend\Mvc\MvcEvent))
#28 /site/vendor/zendframework/zend-eventmanager/src/EventManager.php(171): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent))
#29 /site/vendor/zendframework/zend-mvc/src/Application.php(367): Zend\EventManager\EventManager->triggerEvent(Object(Zend\Mvc\MvcEvent))
#30 /site/vendor/zendframework/zend-mvc/src/Application.php(348): Zend\Mvc\Application->completeRequest(Object(Zend\Mvc\MvcEvent))
#31 /site/index.php(21): Zend\Mvc\Application->run()
#32 {main}
2

This is filtering “linked resources” by property?

That’s a known issue that’s fixed in the development version (and so will be fixed in the next release).

3

Yes it is!

Good to know it is already fixed.