Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings
Discussion options

I recently updated my local Pimcore to 2025.3. Think I got everything working, but when I run bin/console generic-data-index:update:index -r, I get the following error:

18:04:32 WARNING   [pimcore] Dispatching Queue Message failed: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'g0_.id' in 'SELECT' in /var/www/html/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:57
Stack trace:
#0 /var/www/html/vendor/doctrine/dbal/src/Driver/PDO/Connection.php(57): PDO->query('SELECT count(g0...')
#1 /var/www/html/vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php(24): Doctrine\DBAL\Driver\PDO\Connection->query('SELECT count(g0...')
#2 /var/www/html/vendor/doctrine/dbal/src/Logging/Connection.php(39): Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->query('SELECT count(g0...')
#3 /var/www/html/vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php(24): Doctrine\DBAL\Logging\Connection->query('SELECT count(g0...')
#4 /var/www/html/vendor/symfony/doctrine-bridge/Middleware/Debug/Connection.php(55): Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->query('SELECT count(g0...')
#5 /var/www/html/vendor/doctrine/dbal/src/Connection.php(782): Symfony\Bridge\Doctrine\Middleware\Debug\Connection->query('SELECT count(g0...')
#6 /var/www/html/vendor/doctrine/orm/src/Query/Exec/FinalizedSelectExecutor.php(27): Doctrine\DBAL\Connection->executeQuery('SELECT count(g0...', Array, Array, NULL)
#7 /var/www/html/vendor/doctrine/orm/src/Query.php(296): Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array)
#8 /var/www/html/vendor/doctrine/orm/src/AbstractQuery.php(935): Doctrine\ORM\Query->_doExecute()
#9 /var/www/html/vendor/doctrine/orm/src/AbstractQuery.php(891): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 4)
#10 /var/www/html/vendor/doctrine/orm/src/AbstractQuery.php(773): Doctrine\ORM\AbstractQuery->execute(NULL, 4)
#11 /var/www/html/vendor/doctrine/orm/src/AbstractQuery.php(802): Doctrine\ORM\AbstractQuery->getSingleResult(4)
#12 /var/www/html/vendor/pimcore/generic-data-index-bundle/src/Repository/IndexQueueRepository.php(77): Doctrine\ORM\AbstractQuery->getSingleScalarResult()
#13 /var/www/html/vendor/pimcore/generic-data-index-bundle/src/MessageHandler/DispatchQueueMessagesHandler.php(43): Pimcore\Bundle\GenericDataIndexBundle\Repository\IndexQueueRepository->countIndexQueueEntries()
#14 /var/www/html/vendor/symfony/messenger/Middleware/HandleMessageMiddleware.php(152): Pimcore\Bundle\GenericDataIndexBundle\MessageHandler\DispatchQueueMessagesHandler->__invoke(Object(Pimcore\Bundle\GenericDataIndexBundle\Message\DispatchQueueMessagesMessage))
#15 /var/www/html/vendor/symfony/messenger/Middleware/HandleMessageMiddleware.php(91): Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler(Object(Closure), Object(Pimcore\Bundle\GenericDataIndexBundle\Message\DispatchQueueMessagesMessage), NULL, NULL)
#16 /var/www/html/vendor/symfony/messenger/Middleware/SendMessageMiddleware.php(71): Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle(Object(Symfony\Component\Messenger\Envelope), Object(Symfony\Component\Messenger\Middleware\TraceableStack))
#17 /var/www/html/vendor/symfony/messenger/Middleware/FailedMessageProcessingMiddleware.php(34): Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle(Object(Symfony\Component\Messenger\Envelope), Object(Symfony\Component\Messenger\Middleware\TraceableStack))
#18 /var/www/html/vendor/symfony/messenger/Middleware/DispatchAfterCurrentBusMiddleware.php(61): Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle(Object(Symfony\Component\Messenger\Envelope), Object(Symfony\Component\Messenger\Middleware\TraceableStack))
#19 /var/www/html/vendor/symfony/messenger/Middleware/RejectRedeliveredMessageMiddleware.php(41): Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle(Object(Symfony\Component\Messenger\Envelope), Object(Symfony\Component\Messenger\Middleware\TraceableStack))
#20 /var/www/html/vendor/symfony/messenger/Middleware/AddBusNameStampMiddleware.php(37): Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle(Object(Symfony\Component\Messenger\Envelope), Object(Symfony\Component\Messenger\Middleware\TraceableStack))
#21 /var/www/html/vendor/symfony/messenger/Middleware/TraceableMiddleware.php(40): Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle(Object(Symfony\Component\Messenger\Envelope), Object(Symfony\Component\Messenger\Middleware\TraceableStack))
#22 /var/www/html/vendor/symfony/messenger/MessageBus.php(70): Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle(Object(Symfony\Component\Messenger\Envelope), Object(Symfony\Component\Messenger\Middleware\TraceableStack))
#23 /var/www/html/vendor/symfony/messenger/TraceableMessageBus.php(38): Symfony\Component\Messenger\MessageBus->dispatch(Object(Symfony\Component\Messenger\Envelope), Array)
#24 /var/www/html/vendor/symfony/messenger/RoutableMessageBus.php(54): Symfony\Component\Messenger\TraceableMessageBus->dispatch(Object(Symfony\Component\Messenger\Envelope), Array)
#25 /var/www/html/vendor/symfony/messenger/Transport/Sync/SyncTransport.php(58): Symfony\Component\Messenger\RoutableMessageBus->dispatch(Object(Symfony\Component\Messenger\Envelope))
#26 /var/www/html/vendor/symfony/messenger/Middleware/SendMessageMiddleware.php(62): Symfony\Component\Messenger\Transport\Sync\SyncTransport->send(Object(Symfony\Component\Messenger\Envelope))
#27 /var/www/html/vendor/symfony/messenger/Middleware/FailedMessageProcessingMiddleware.php(34): Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle(Object(Symfony\Component\Messenger\Envelope), Object(Symfony\Component\Messenger\Middleware\TraceableStack))
#28 /var/www/html/vendor/symfony/messenger/Middleware/DispatchAfterCurrentBusMiddleware.php(68): Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle(Object(Symfony\Component\Messenger\Envelope), Object(Symfony\Component\Messenger\Middleware\TraceableStack))
#29 /var/www/html/vendor/symfony/messenger/Middleware/RejectRedeliveredMessageMiddleware.php(41): Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle(Object(Symfony\Component\Messenger\Envelope), Object(Symfony\Component\Messenger\Middleware\TraceableStack))
#30 /var/www/html/vendor/symfony/messenger/Middleware/AddBusNameStampMiddleware.php(37): Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle(Object(Symfony\Component\Messenger\Envelope), Object(Symfony\Component\Messenger\Middleware\TraceableStack))
#31 /var/www/html/vendor/symfony/messenger/Middleware/TraceableMiddleware.php(40): Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle(Object(Symfony\Component\Messenger\Envelope), Object(Symfony\Component\Messenger\Middleware\TraceableStack))
#32 /var/www/html/vendor/symfony/messenger/MessageBus.php(70): Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle(Object(Symfony\Component\Messenger\Envelope), Object(Symfony\Component\Messenger\Middleware\TraceableStack))
#33 /var/www/html/vendor/symfony/messenger/TraceableMessageBus.php(38): Symfony\Component\Messenger\MessageBus->dispatch(Object(Pimcore\Bundle\GenericDataIndexBundle\Message\DispatchQueueMessagesMessage), Array)
#34 /var/www/html/vendor/pimcore/generic-data-index-bundle/src/Service/SearchIndex/IndexQueue/QueueMessagesDispatcher.php(49): Symfony\Component\Messenger\TraceableMessageBus->dispatch(Object(Pimcore\Bundle\GenericDataIndexBundle\Message\DispatchQueueMessagesMessage), Array)
#35 /var/www/html/vendor/pimcore/generic-data-index-bundle/src/Service/SearchIndex/IndexQueue/EnqueueService.php(232): Pimcore\Bundle\GenericDataIndexBundle\Service\SearchIndex\IndexQueue\QueueMessagesDispatcher->dispatchQueueMessages(true)
#36 /var/www/html/vendor/pimcore/generic-data-index-bundle/src/Command/Update/IndexUpdateCommand.php(196): Pimcore\Bundle\GenericDataIndexBundle\Service\SearchIndex\IndexQueue\EnqueueService->dispatchQueueMessages(true)
#37 /var/www/html/vendor/symfony/console/Command/Command.php(326): Pimcore\Bundle\GenericDataIndexBundle\Command\Update\IndexUpdateCommand->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#38 /var/www/html/vendor/symfony/console/Application.php(1096): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#39 /var/www/html/vendor/symfony/framework-bundle/Console/Application.php(126): Symfony\Component\Console\Application->doRunCommand(Object(Pimcore\Bundle\GenericDataIndexBundle\Command\Update\IndexUpdateCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#40 /var/www/html/vendor/symfony/console/Application.php(324): Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand(Object(Pimcore\Bundle\GenericDataIndexBundle\Command\Update\IndexUpdateCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#41 /var/www/html/vendor/symfony/framework-bundle/Console/Application.php(80): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#42 /var/www/html/vendor/symfony/console/Application.php(175): Symfony\Bundle\FrameworkBundle\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#43 /var/www/html/vendor/symfony/runtime/Runner/Symfony/ConsoleApplicationRunner.php(49): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#44 /var/www/html/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\ConsoleApplicationRunner->run()
#45 /var/www/html/bin/console(17): require_once('/var/www/html/v...')
#46 {main}
You must be logged in to vote

Make sure all migrations are executed

Replies: 1 comment · 1 reply

Comment options

Make sure all migrations are executed

You must be logged in to vote
1 reply
@dougpmls
Comment options

Ah, makes sense! That fixed it. Thank you for the reminder.

Answer selected by dougpmls
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
2 participants
Morty Proxy This is a proxified and sanitized view of the page, visit original site.