Fehler der Such-Indexierung nach Update auf 5.4.5

Shopware 5 Administration
1

Hallo zusammen,

das Update von 5.3.3 auf 5.4.5 lief reibungslos, auch im Frontend gibt es keine offensichtlichen Probleme. Aber die manuelle Suchindexierung über Performance -> Einstellungen -> Suche -> Suchindex neu aufbauen scheitert nun erstmalig. Folgender Eintrag steht in der Logdatei:

[2018-07-10 10:04:17] core.ERROR: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'keywords' in 'field list' in /var/www/vhosts/eslamica.de/httpdocs/eslamica_shop_umzug/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:852 Stack trace: #0 /var/www/vhosts/eslamica.de/httpdocs/eslamica_shop_umzug/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(852): PDO->query('SELECT (SELECT ...') #1 /var/www/vhosts/eslamica.de/httpdocs/eslamica_shop_umzug/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(785): Doctrine\DBAL\Connection->executeQuery('SELECT (SELECT ...', Array, Array) #2 /var/www/vhosts/eslamica.de/httpdocs/eslamica_shop_umzug/engine/Shopware/Bundle/SearchBundleDBAL/SearchTerm/SearchIndexer.php(157): Doctrine\DBAL\Connection->fetchAll('SELECT (SELECT ...') #3 /var/www/vhosts/eslamica.de/httpdocs/eslamica_shop_umzug/engine/Shopware/Plugins/Default/Core/RebuildIndex/Controllers/SearchIndex.php(43): Shopware\Bundle\SearchBundleDBAL\SearchTerm\SearchIndexer->build() #4 /var/www/vhosts/eslamica.de/httpdocs/eslamica_shop_umzug/engine/Library/Enlight/Controller/Action.php(193): Shopware_Controllers_Backend_SearchIndex->buildAction() #5 /var/www/vhosts/eslamica.de/httpdocs/eslamica_shop_umzug/engine/Library/Enlight/Controller/Dispatcher/Default.php(549): Enlight_Controller_Action->dispatch('buildAction') #6 /var/www/vhosts/eslamica.de/httpdocs/eslamica_shop_umzug/engine/Library/Enlight/Controller/Front.php(222): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #7 /var/www/vhosts/eslamica.de/httpdocs/eslamica_shop_umzug/engine/Shopware/Kernel.php(215): Enlight_Controller_Front->dispatch() #8 /var/www/vhosts/eslamica.de/httpdocs/eslamica_shop_umzug/vendor/symfony/http-kernel/HttpCache/HttpCache.php(486): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #9 /var/www/vhosts/eslamica.de/httpdocs/eslamica_shop_umzug/engine/Shopware/Components/HttpCache/AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #10 /var/www/vhosts/eslamica.de/httpdocs/eslamica_shop_umzug/vendor/symfony/http-kernel/HttpCache/HttpCache.php(253): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #11 /var/www/vhosts/eslamica.de/httpdocs/eslamica_shop_umzug/engine/Shopware/Components/HttpCache/AppCache.php(105): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #12 /var/www/vhosts/eslamica.de/httpdocs/eslamica_shop_umzug/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #13 {main} Next Doctrine\DBAL\DBALException: An exception occurred while executing 'SELECT (SELECT articleID FROM s_articles_details WHERE id = articledetailsID LIMIT 1) as id, keywords FROM s_articles_attributes': SQLSTATE[42S22]: Column not found: 1054 Unknown column 'keywords' in 'field list' in /var/www/vhosts/eslamica.de/httpdocs/eslamica_shop_umzug/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:131 Stack trace: #0 /var/www/vhosts/eslamica.de/httpdocs/eslamica_shop_umzug/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(855): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), 'SELECT (SELECT ...', Array) #1 /var/www/vhosts/eslamica.de/httpdocs/eslamica_shop_umzug/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(785): Doctrine\DBAL\Connection->executeQuery('SELECT (SELECT ...', Array, Array) #2 /var/www/vhosts/eslamica.de/httpdocs/eslamica_shop_umzug/engine/Shopware/Bundle/SearchBundleDBAL/SearchTerm/SearchIndexer.php(157): Doctrine\DBAL\Connection->fetchAll('SELECT (SELECT ...') #3 /var/www/vhosts/eslamica.de/httpdocs/eslamica_shop_umzug/engine/Shopware/Plugins/Default/Core/RebuildIndex/Controllers/SearchIndex.php(43): Shopware\Bundle\SearchBundleDBAL\SearchTerm\SearchIndexer->build() #4 /var/www/vhosts/eslamica.de/httpdocs/eslamica_shop_umzug/engine/Library/Enlight/Controller/Action.php(193): Shopware_Controllers_Backend_SearchIndex->buildAction() #5 /var/www/vhosts/eslamica.de/httpdocs/eslamica_shop_umzug/engine/Library/Enlight/Controller/Dispatcher/Default.php(549): Enlight_Controller_Action->dispatch('buildAction') #6 /var/www/vhosts/eslamica.de/httpdocs/eslamica_shop_umzug/engine/Library/Enlight/Controller/Front.php(222): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #7 /var/www/vhosts/eslamica.de/httpdocs/eslamica_shop_umzug/engine/Shopware/Kernel.php(215): Enlight_Controller_Front->dispatch() #8 /var/www/vhosts/eslamica.de/httpdocs/eslamica_shop_umzug/vendor/symfony/http-kernel/HttpCache/HttpCache.php(486): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #9 /var/www/vhosts/eslamica.de/httpdocs/eslamica_shop_umzug/engine/Shopware/Components/HttpCache/AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #10 /var/www/vhosts/eslamica.de/httpdocs/eslamica_shop_umzug/vendor/symfony/http-kernel/HttpCache/HttpCache.php(253): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #11 /var/www/vhosts/eslamica.de/httpdocs/eslamica_shop_umzug/engine/Shopware/Components/HttpCache/AppCache.php(105): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #12 /var/www/vhosts/eslamica.de/httpdocs/eslamica_shop_umzug/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #13 {main} [] {"uid":"ff953d4"}

Könnte das irgendein Plugin sein, welches entgegen der Aussage des Autors doch nicht kompatibel mit der neusten Shopware-Version ist oder was bedeutet dieser Eintrag, wie gehe ich hier am besten auf Fehlersuche?

Column not found: 1054 Unknown column ‘keywords’ in ‘field list’

Viele Grüße

2

Klingt mir nach einer falschen Konfiguration der Spalten die in die Suche mit einbezogen werden.

Am besten mal in den Grundeinstellungen schauen.

3

Das war in der Tat das Problem. “Keywords” befindet sich in der Tabelle s_articles und nicht in s_articles_attributes. Das wurde durch das Update offenbar verändert?! Jedenfalls funktioniert es nun wieder, danke dir.