# 1054 Unknown column 'category.showfiltergroups' in 'field list'' **URL:** \ **Category:** Programmierung\ **Created:** [10. Juli 2016 um 19:55 UTC](https://forum.shopware.com/t/1054-unknown-column-category-showfiltergroups-in-field-list/38086 "2016-07-10T19:55:21Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![natproduct](https://avatars.discourse-cdn.com/v4/letter/n/d6d6ee/32.png) [@natproduct](https://forum.shopware.com/u/natproduct)\ **Post date:** [10. Juli 2016 um 19:55 UTC](https://forum.shopware.com/t/1054-unknown-column-category-showfiltergroups-in-field-list/38086/1 "2016-07-10T19:55:21Z")
Hallo, nachdem ich trotz mehrfacher Versuche mit dem Update von 5.1.6 auf 5.2.1 gescheitert bin, habe ich ein Backup (5.1.6) wieder hochgeladen. Leider scheint bei der Datenbank oder bei einem Plugin etwas auf der Strecke geblieben zu sein. Denn ich bekomme nun im Frontend die folgende Fehlermeldung ( in verkürzter Form ): **Fatal error** : Uncaught exception ‘PDOException’ with message ‘SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘category.showfiltergroups’ in ‘field list’’ in /www/htdocs/XXXXX/XXXXXXX/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:828 Stack trace: #0… Im Backend lassen sich auch die Artikel und Kategoien nicht mehr öffnen. Fehlermeldung bei den Kategorien: Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. An exception occurred while executing 'SELECT s0\_.id AS id\_0, s0\_.parent AS parent\_1, s0\_.stream\_id AS stream\_id\_2, s0\_.description AS description\_3, s0\_.position AS position\_4, s0\_.meta\_title AS meta\_title\_5, s0\_.metakeywords AS metakeywords\_6, s0\_.metadescription AS metadescription\_7, s0\_.cmsheadline AS cmsheadline\_8, s0\_.cmstext AS cmstext\_9, s0\_.active AS active\_10, s0\_.template AS template\_11, s0\_.product\_box\_layout AS product\_box\_layout\_12, s0\_.blog AS blog\_13, s0\_.path AS path\_14,… Wenn mir dabei jemand helfen könnte, was und wo ich etwas ergänzen muss, wäre ich sehr dankbar. Viele Grüsse Natproduct   ---
**Author:** ![Moritz\_Naczenski](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/moritz_naczenski/32/7792_2.png) [@Moritz\_Naczenski](https://forum.shopware.com/u/Moritz_Naczenski)\ **Post date:** [11. Juli 2016 um 05:54 UTC](https://forum.shopware.com/t/1054-unknown-column-category-showfiltergroups-in-field-list/38086/2 "2016-07-11T05:54:27Z")
Hallo, spiel das Backup mal in eine leere Datenbank ein und setze auch die Daten auf dem Server alle zurück. Aufgrund der Fehlermeldung gehe ich davon aus, dass du aktuell ein 5.2./5.1 Mischmasch auf dem Server hast. Moritz ---
**Author:** ![natproduct](https://avatars.discourse-cdn.com/v4/letter/n/d6d6ee/32.png) [@natproduct](https://forum.shopware.com/u/natproduct)\ **Post date:** [12. Juli 2016 um 15:16 UTC](https://forum.shopware.com/t/1054-unknown-column-category-showfiltergroups-in-field-list/38086/3 "2016-07-12T15:16:33Z")
Hallo, genau das war es.  Vielen Dank und viele Grüße Natproduct ---
**Author:** ![meine-gute-stube](https://avatars.discourse-cdn.com/v4/letter/m/c4cdca/32.png) [@meine-gute-stube](https://forum.shopware.com/u/meine-gute-stube)\ **Post date:** [8. November 2016 um 10:54 UTC](https://forum.shopware.com/t/1054-unknown-column-category-showfiltergroups-in-field-list/38086/4 "2016-11-08T10:54:50Z")
Hallo, habe heute dasselbe Problem. Im Backend, wenn ich Kategorien anklicke kommt die Fehlermeldung: Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. An exception occurred while executing ‚SELECT s0\_.id AS id\_0, s0\_.parent AS parent\_1, s0\_.stream\_id AS stream\_id\_2, s0\_.description AS description\_3, s0\_.position AS position\_4, s0\_.meta\_title AS meta\_title\_5, s0\_.metakeywords AS metakeywords\_6, s0\_.metadescription AS metadescription\_7, s0\_.cmsheadline AS cmsheadline\_8, s0\_.cmstext AS cmstext\_9, s0\_.active AS active\_10, s0\_.template AS template\_11, s0\_.product\_box\_layout AS product\_box\_layout\_12, s0\_.blog AS blog\_13, s0\_.path AS path\_14, s0\_.external AS external\_15, s0\_.hidefilter AS hidefilter\_16, s0\_.hidetop AS hidetop\_17, s0\_.changed AS changed\_18, s0\_.added AS added\_19, s0\_.mediaID AS mediaID\_20, s1\_.id AS id\_21, s1\_.categoryID AS categoryID\_22, s1\_.attribute1 AS attribute1\_23, s1\_.attribute2 AS attribute2\_24, s1\_.attribute3 AS attribute3\_25, s1\_.attribute4 AS attribute4\_26, s1\_.attribute5 AS attribute5\_27, s1\_.attribute6 AS attribute6\_28, s1\_.kategorie\_listing\_farben AS kategorie\_listing\_farben\_29, s1\_.filter\_storelocator AS filter\_storelocator\_30, s2\_.id AS id\_31, s2\_.parent\_id AS parent\_id\_32, s2\_.active AS active\_33, s2\_.name AS name\_34, s2\_.userID AS userID\_35, s2\_.position AS position\_36, s2\_.device AS device\_37, s2\_.fullscreen AS fullscreen\_38, s2\_.valid\_from AS valid\_from\_39, s2\_.is\_landingpage AS is\_landingpage\_40, s2\_.seo\_title AS seo\_title\_41, s2\_.seo\_keywords AS seo\_keywords\_42, s2\_.seo\_description AS seo\_description\_43, s2\_.valid\_to AS valid\_to\_44, s2\_.create\_date AS create\_date\_45, s2\_.modified AS modified\_46, s2\_.rows AS rows\_47, s2\_.cols AS cols\_48, s2\_.cell\_spacing AS cell\_spacing\_49, s2\_.cell\_height AS cell\_height\_50, s2\_.article\_height AS article\_height\_51, s2\_.show\_listing AS show\_listing\_52, s2\_.template\_id AS template\_id\_53, s2\_.mode AS mode\_54, s3\_.id AS id\_55, s3\_.albumID AS albumID\_56, s3\_.name AS name\_57, s3\_.description AS description\_58, s3\_.path AS path\_59, s3\_.type AS type\_60, s3\_.extension AS extension\_61, s3\_.userID AS userID\_62, s3\_.created AS created\_63, s3\_.file\_size AS file\_size\_64, s3\_.width AS width\_65, s3\_.height AS height\_66, s4\_.id AS id\_67, s4\_.groupkey AS groupkey\_68, s4\_.description AS description\_69, s4\_.tax AS tax\_70, s4\_.taxinput AS taxinput\_71, s4\_.mode AS mode\_72, s4\_.discount AS discount\_73, s4\_.minimumorder AS minimumorder\_74, s4\_.minimumordersurcharge AS minimumordersurcharge\_75 FROM s\_categories s0\_ LEFT JOIN s\_categories\_attributes s1\_ ON s0\_.id = s1\_.categoryID LEFT JOIN s\_emotion\_categories s5\_ ON s0\_.id = s5\_.category\_id LEFT JOIN s\_emotion s2\_ ON s2\_.id = s5\_.emotion\_id LEFT JOIN s\_media s3\_ ON s0\_.mediaID = s3\_.id LEFT JOIN s\_categories\_avoid\_customergroups s6\_ ON s0\_.id = s6\_.categoryID LEFT JOIN s\_core\_customergroups s4\_ ON s4\_.id = s6\_.customergroupID WHERE s0\_.id = ? AND s0\_.id IN (?)‘ with params [9, „9“]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‚s1\_.filter\_storelocator‘ 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 s0\_.id A…‘, Array) #1 vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection-\>executeQuery(‚SELECT s0\_.id A…‘, Array, Array, NULL) #2 vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(321): Doctrine\ORM\Query\Exec\SingleSelectExecutor-\>execute(Object(Doctrine\DBAL\Connection), Array, Array) #3 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(969): Doctrine\ORM\Query-\>\_doExecute() #4 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(924): Doctrine\ORM\AbstractQuery-\>executeIgnoreQueryCache(NULL, 2) #5 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(727): Doctrine\ORM\AbstractQuery-\>execute(NULL, 2) #6 vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(165): Doctrine\ORM\AbstractQuery-\>getResult(2) #7 engine/Shopware/Controllers/Backend/Category.php(295): Doctrine\ORM\Tools\Pagination\Paginator-\>getIterator() #8 engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Backend\_Category-\>getDetailAction() #9 engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight\_Controller\_Action-\>dispatch(‚getDetailAction‘) #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}     Hatte zuvor eine leere Datenbank angelegt und in die eine ältere Version der Seite eingespielt, da es in der Datenbak zu Fehlern mit den EKW kam. Jetzt bekomme ich die Meldung. Gestern hatte ich außerdem die Dateien auf dem ftp Server ersetzt durch die Original 5.2.9 Installdateien.   Für Hilfe wäre ich sehr dankbar   Gruß Henrik ---
**Author:** ![testwazz](https://avatars.discourse-cdn.com/v4/letter/t/b5a626/32.png) [@testwazz](https://forum.shopware.com/u/testwazz)\ **Post date:** [15. Mai 2019 um 06:47 UTC](https://forum.shopware.com/t/1054-unknown-column-category-showfiltergroups-in-field-list/38086/5 "2019-05-15T06:47:18Z")
Hi Shopware, i have updated shopware version from 5.2.5 to 5.3.3, after that i got error on frontend **Fatal error** : Uncaught exception ‘PDOException’ with message ‘SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘category.hide\_sortings’ in ‘field list’’ in /var/www/clients/client18/web93/web/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:847 Stack trace: #0 /var/www/clients/client18/web93/web/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(847): PDOStatement-\>execute() #1 /var/www/clients/client18/web93/web/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): Doctrine\DBAL\Connection-\>executeQuery(‘SELECT shop.id …’, Array, Array) #2 /var/www/clients/client18/web93/web/engine/Shopware/Bundle/StoreFrontBundle/Gateway/DBAL/ShopGateway.php(141): Doctrine\DBAL\Query\QueryBuilder-\>execute() #3 /var/www/clients/client18/web93/web/engine/Shopware/Bundle/StoreFrontBundle/Gateway/DBAL/ShopGateway.php(78): Shopware\Bundle\StoreFrontBundle\Gateway\DBAL\ShopGateway-\>getShops(Array) #4 /var/www/clients/client18/web93/web/engine/Shopware/Bundle/StoreFrontBundle/Gateway/DBAL/ShopGateway.php(66): Shopw in  **/var/www/clients/client18/web93/web/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php**  on line  **131** **2-when i have checked my backend category i find some issue realted ’** [my-good-room](https://forum.shopware.com/profile/8485/meine-gute-stube) **’ members.** **error-** Oops! An error has occurred! The following notes should help you. An exception occurred while executing 'SELECT s0\_.sorting\_ids AS sorting\_ids\_0, s0\_.hide\_sortings AS hide\_sortings\_1 etc…     can you guys tell me what should i d to solve this.