Dringend! 503 service unaivailable

WER KANN HELFEN WEDER DER SHOP WIRD GELADEN NOCH DIE PRODUKTE!

Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. An exception occurred while executing ‚SELECT t0.id AS id_1, t0.articledetailsID AS articledetailsID_2, t0.attr1 AS attr1_3, t0.attr2 AS attr2_4, t0.attr3 AS attr3_5, t0.attr4 AS attr4_6, t0.attr5 AS attr5_7, t0.attr6 AS attr6_8, t0.attr7 AS attr7_9, t0.attr8 AS attr8_10, t0.attr9 AS attr9_11, t0.attr10 AS attr10_12, t0.attr11 AS attr11_13, t0.attr12 AS attr12_14, t0.attr13 AS attr13_15, t0.attr14 AS attr14_16, t0.attr15 AS attr15_17, t0.attr16 AS attr16_18, t0.attr17 AS attr17_19, t0.attr18 AS attr18_20, t0.attr19 AS attr19_21, t0.attr20 AS attr20_22, t0.badge_neon AS badge_neon_23, t0.badge_bundle AS badge_bundle_24, t0.emz_show_number_sales AS emz_show_number_sales_25, t0.raw_hide_preview_color AS raw_hide_preview_color_26, t0.heptacom_youtube AS heptacom_youtube_27, t0.ezadmin_internalcomment AS ezadmin_internalcomment_28, t0.kib_variantlisting_img AS kib_variantlisting_img_29, t0.digi1_showleftsidebar AS digi1_showleftsidebar_30, t0.ace_additional_tab_title AS ace_additional_tab_title_31, t0.ace_additional_tab_desc AS ace_additional_tab_desc_32, t0.deal_countdown_offer_status AS deal_countdown_offer_status_33, t0.deal_countdown_start_date AS deal_countdown_start_date_34, t0.deal_countdown_end_date AS deal_countdown_end_date_35, t0.six_short_description AS six_short_description_36, t0.nn_ah_activated AS nn_ah_activated_37, t0.nn_ah_style AS nn_ah_style_38, t0.nn_ah_event AS nn_ah_event_39, t0.nn_ah_repeating AS nn_ah_repeating_40, t0.nn_ah_repeating_interval AS nn_ah_repeating_interval_41, t0.articledetailsID AS articledetailsID_42 FROM s_articles_attributes t0 WHERE t0.articledetailsID = ?‘ with params [114471]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‚t0.nn_ah_activated‘ in ‚field list‘ in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 179 Stack trace: #0 vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(150): Doctrine\DBAL\DBALException::wrapException(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), ‚An exception oc…‘) #1 vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(915): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), ‚SELECT t0.id AS…‘, Array) #2 engine/Library/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(386): Doctrine\DBAL\Connection->executeQuery(‚SELECT t0.id AS…‘, Array, Array) #3 engine/Library/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(462): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load(Array, NULL, Array) #4 vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(2708): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity(Array, Object(Shopware\Models\Article\Detail)) #5 vendor/doctrine/orm/lib/Doctrine/ORM/Internal/Hydration/ObjectHydrator.php(271): Doctrine\ORM\UnitOfWork->createEntity(‚Shopware\Models…‘, Array, Array) #6 vendor/doctrine/orm/lib/Doctrine/ORM/Internal/Hydration/ObjectHydrator.php(492): Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity(Array, ‚detail‘) #7 vendor/doctrine/orm/lib/Doctrine/ORM/Internal/Hydration/ObjectHydrator.php(162): Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData(Array, Array) #8 vendor/doctrine/orm/lib/Doctrine/ORM/Internal/Hydration/AbstractHydrator.php(152): Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData() #9 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(976): Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll(Object(PDOStatement), Object(Doctrine\ORM\Query\ResultSetMapping), Array) #10 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(922): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 1) #11 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(726): Doctrine\ORM\AbstractQuery->execute(NULL, 1) #12 vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(167): Doctrine\ORM\AbstractQuery->getResult(1) #13 engine/Shopware/Components/MultiEdit/Resource/Product/Filter.php(184): Doctrine\ORM\Tools\Pagination\Paginator->getIterator() #14 engine/Shopware/Components/MultiEdit/Resource/Product/Filter.php(206): Shopware\Components\MultiEdit\Resource\Product\Filter->getPaginatedResult(Object(Doctrine\ORM\Query)) #15 engine/Shopware/Components/MultiEdit/Resource/Product.php(109): Shopware\Components\MultiEdit\Resource\Product\Filter->filter(Array, 0, ‚25‘, Array) #16 engine/Shopware/Controllers/Backend/ArticleList.php(374): Shopware\Components\MultiEdit\Resource\Product->filter(Array, 0, ‚25‘, Array) #17 engine/Library/Enlight/Controller/Action.php(192): Shopware_Controllers_Backend_ArticleList->filterAction() #18 engine/Library/Enlight/Controller/Dispatcher/Default.php(478): Enlight_Controller_Action->dispatch(‚filterAction‘) #19 engine/Library/Enlight/Controller/Front.php(228): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #20 engine/Shopware/Kernel.php(185): Enlight_Controller_Front->dispatch() #21 vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #22 vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true) #23 engine/Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #24 vendor/symfony/http-kernel/HttpCache/HttpCache.php(238): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #25 engine/Shopware/Components/HttpCache/AppCache.php(99): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #26 shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #27 {main}

OK

Servus,

so eine schwindlige Fehlermeldung hatte ich auch Zwischendurch schon gehabt.
Meistens wenn ich mal ein anderes Theme zugewiesen habe oder ein Plugin deinstalliert habe.
In dem Fall hat es geholfen, wenn ich einfach den kompletten Cache-Ordner gelöscht habe (var/cache/production…), danach lief es i.d.R. wieder.

Da wird noch auf eine Spalte in der Tabelle „s_articles_attributes” zugegriffen die es gar nicht mehr gibt. Wurde wohl ein Plugin nicht sauber gelöscht. In diesem Falle mal KOMPLETT den Cache leeren.