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