# Cron Job "Search" wird beendet mit Fehlermeldung "Unknown column 'value\_numeric' in 'field list'"

**URL:** https://forum.shopware.com/t/cron-job-search-wird-beendet-mit-fehlermeldung-unknown-column-value-numeric-in-field-list/44612
**Category:** Administration
**Created:** [18. März 2017 um 14:17 UTC](https://forum.shopware.com/t/cron-job-search-wird-beendet-mit-fehlermeldung-unknown-column-value-numeric-in-field-list/44612 "2017-03-18T14:17:14Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![megloff](https://avatars.discourse-cdn.com/v4/letter/m/e47774/32.png) [@megloff](https://forum.shopware.com/u/megloff)
#### Post date: [18. März 2017 um 14:17 UTC](https://forum.shopware.com/t/cron-job-search-wird-beendet-mit-fehlermeldung-unknown-column-value-numeric-in-field-list/44612/1 "2017-03-18T14:17:14Z")

</div>

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

---

<div class="post-metadata">

### Author: ![bogus](https://avatars.discourse-cdn.com/v4/letter/b/a87d85/32.png) [@bogus](https://forum.shopware.com/u/bogus)
#### Post date: [18. März 2017 um 14:40 UTC](https://forum.shopware.com/t/cron-job-search-wird-beendet-mit-fehlermeldung-unknown-column-value-numeric-in-field-list/44612/2 "2017-03-18T14:40:50Z")

</div>

Hello&nbsp;

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

here’s proof &nbsp;[https://github.com/shopware/shopware/blob/5.2/UPGRADE-5.2.md](https://github.com/shopware/shopware/blob/5.2/UPGRADE-5.2.md)

> - Removed deprecated columns&nbsp;`s_filter_values.value_numeric`&nbsp;and&nbsp;`s_filter_options.default`

&nbsp;

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

Cheers,

Bogdan