Cron Job "Search" wird beendet mit Fehlermeldung "Unknown column 'value_numeric' in 'field list'"

Shopware 5 Administration
1

Hallo zusammen ich wollte bei mir den “Search” Cronjob aufrufen.

_// Aufruf aller Crons AUSSER Newsletter_ http:_//www.meinshop.de/backend/cron_

Erhalte aber dann bei meinem Shop den Fehler, ist das ein bekannter Bug? Weiss jemand mehr darüber. Ich verwende Shopware 5.2.9

An exception occurred while executing 'SELECT id as id, value, value_numeric FROM s_filter_values': SQLSTATE[42S22]: Column not found: 1054 Unknown column 'value_numeric' in 'field list' in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 119
Stack trace:

#0 vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(836): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), 'SELECT id as id...', Array)
#1 vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(766): Doctrine\DBAL\Connection->executeQuery('SELECT id as id...', Array, Array)
#2 engine/Shopware/Bundle/SearchBundleDBAL/SearchTerm/SearchIndexer.php(150): Doctrine\DBAL\Connection->fetchAll('SELECT id as id...')
#3 engine/Shopware/Plugins/Default/Frontend/CronRefresh/Bootstrap.php(95): Shopware\Bundle\SearchBundleDBAL\SearchTerm\SearchIndexer->build()
#4 engine/Library/Enlight/Event/Handler/Plugin.php(149): Shopware_Plugins_Frontend_CronRefresh_Bootstrap->onCronJobSearch(Object(Shopware_Components_Cron_CronJob))
#5 engine/Library/Enlight/Event/EventManager.php(251): Enlight_Event_Handler_Plugin->execute(Object(Shopware_Components_Cron_CronJob))
#6 engine/Library/Enlight/Components/Cron/Manager.php(258): Enlight_Event_EventManager->notifyUntil('Shopware_CronJo...', Object(Shopware_Components_Cron_CronJob))
#7 engine/Shopware/Plugins/Default/Core/Cron/Cron.php(52): Enlight_Components_Cron_Manager->runJob(Object(Enlight_Components_Cron_Job))
#8 engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Backend_Cron->indexAction()
#9 engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch('indexAction')
#10 engine/Library/Enlight/Controller/Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#11 engine/Shopware/Kernel.php(177): Enlight_Controller_Front->dispatch()
#12 vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#13 engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#14 vendor/symfony/http-kernel/HttpCache/HttpCache.php(258): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#15 engine/Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true)
#16 shopware.php(113): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#17 {main}

Besten Dank

2

Hello 

it seems that your store is not updated correctly…   the store is trying to use the field  s_filter_values.value_numeric but this field is deleted, this field should be removed in version  Shopware 5.2 

here’s proof  https://github.com/shopware/shopware/blob/5.2/UPGRADE-5.2.md

  • Removed deprecated columns s_filter_values.value_numeric and s_filter_options.default

 

I recommend you to check code against version Shopware 5.2.9  Because there may be other unpleasant moments .

Cheers,

Bogdan