1054 Unknown column 'category.showfiltergroups' in 'field list''

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

 

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

Hallo,

genau das war es. 

Vielen Dank und viele Grüße

Natproduct

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

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 ’ 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.