Probleme mit dem Öffnen von Kategorien und Produkten im Backend

Hallo

Habe im Backend den Cache bereinigen lassen und jetzt und 14 Plugin geupdatet.
Nun kann ich keine Kategorien oder Produkte mehr öffnen.

Bekomme folgende 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_.cbax_advanced_menu_column_amount AS cbax_advanced_menu_column_amount_29, s1_.cbax_google_category AS cbax_google_category_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 [462, “462”]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s1_.cbax_google_category’ 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(180): Enlight_Controller_Front->dispatch() #12 vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel->handle(Object(Enlight_Controller_Request_RequestHttp), 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(117): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #17 {main}  

OK

 

Wie bekomme ich es wieder zum laufen?

LG Mirko

 

 

Hallo,

der Fehler ist folgender:

Unknown column 's1_.cbax_google_category'

und kommt von einem Plugin vom Hersteller coolbax. Am besten erst einmal den kompletten Shop Cache (inklusive Theme- und Backend-Cache) leeren und auch den Browser Cache und dann im Shopware Backend neu anmelden.

Wenn das nicht hilft, entweder den Hersteller einmal konktaktieren oder das Plugin wieder installieren / eventuell neu installieren, wobei dann natürlich auch vorgenommene Einstellungen verloren gehen. Hier wurden wahrscheinlich die hinzugefügten Freitextfelder des Plugins nicht korrekt deinstalliert und deshalb kommt der Fehler. Eventuell reicht es auch schon aus, über die Freitextfeld-Verwaltung die Models der entsprechenden Tabellen neu generieren zu lassen.

Grüße

Sebastian

OK, habe über die Console das Plugin  „Google Shopping Export“ von Coolbax deinstalliert und schon gehen wieder die Kategogien und Produkte.
Da ich heute das Plugin geupdatet habe, ist warschein der Fehler aufgetreten.

Vielen Dank

Oder der Cache wurde nicht komplett geleert, kommt auch ab und zu vor

Ich hab schon den Cache per FTP geleert, hat leider auch nix gebracht! Erst nach der Deinstallation war eh nur eine Demo Version!