Hello,
I’ve recently inherited an Omeka S installation and have been tasked with upgrading to 4.0.4. After following the documentation from github, and clicking on update db with php 8.2 or php 8.1 I keep receiving this error
Omeka S encountered an error
Doctrine\ORM\Query\QueryException
Invalid parameter format, : given, but : or ? expected.
Details:
Doctrine\ORM\Query\QueryException: Invalid parameter format, : given, but :<name> or ?<num> expected. in /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:108
Stack trace:
#0 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Query/AST/InputParameter.php(34): Doctrine\ORM\Query\QueryException::invalidParameterFormat()
#1 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(3271): Doctrine\ORM\Query\AST\InputParameter->__construct()
#2 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2641): Doctrine\ORM\Query\Parser->LikeExpression()
#3 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2532): Doctrine\ORM\Query\Parser->SimpleConditionalExpression()
#4 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2508): Doctrine\ORM\Query\Parser->ConditionalPrimary()
#5 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2476): Doctrine\ORM\Query\Parser->ConditionalFactor()
#6 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2451): Doctrine\ORM\Query\Parser->ConditionalTerm()
#7 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1405): Doctrine\ORM\Query\Parser->ConditionalExpression()
#8 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(916): Doctrine\ORM\Query\Parser->WhereClause()
#9 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(883): Doctrine\ORM\Query\Parser->SelectStatement()
#10 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(293): Doctrine\ORM\Query\Parser->QueryLanguage()
#11 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(393): Doctrine\ORM\Query\Parser->getAST()
#12 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(274): Doctrine\ORM\Query\Parser->parse()
#13 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(286): Doctrine\ORM\Query->parse()
#14 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1181): Doctrine\ORM\Query->_doExecute()
#15 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1135): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache()
#16 /var/www/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(871): Doctrine\ORM\AbstractQuery->execute()
#17 /var/www/omeka-s/application/data/migrations/20230601060113_AddMediaRender.php(28): Doctrine\ORM\AbstractQuery->getResult()
#18 /var/www/omeka-s/application/src/Db/Migration/Manager.php(80): Omeka\Db\Migrations\AddMediaRender->up()
#19 /var/www/omeka-s/application/src/Controller/MigrateController.php(38): Omeka\Db\Migration\Manager->upgrade()
#20 /var/www/omeka-s/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(71): Omeka\Controller\MigrateController->indexAction()
#21 /var/www/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\Controller\AbstractActionController->onDispatch()
#22 /var/www/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(179): Laminas\EventManager\EventManager->triggerListeners()
#23 /var/www/omeka-s/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(97): Laminas\EventManager\EventManager->triggerEventUntil()
#24 /var/www/omeka-s/vendor/laminas/laminas-mvc/src/DispatchListener.php(132): Laminas\Mvc\Controller\AbstractController->dispatch()
#25 /var/www/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\DispatchListener->onDispatch()
#26 /var/www/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(179): Laminas\EventManager\EventManager->triggerListeners()
#27 /var/www/omeka-s/vendor/laminas/laminas-mvc/src/Application.php(325): Laminas\EventManager\EventManager->triggerEventUntil()
#28 /var/www/omeka-s/index.php(21): Laminas\Mvc\Application->run()
#29 {main}
Powered by Omeka S
Blockquote