Uncaught SmartyException & komplett voller System-Log; Wie beheben?

Hallo alle zusammen,
leider ist mein Shop nicht mehr erreichbar und es wir nur folgende Fehlermeldung im Browser angezeigt:
Fatal error : Uncaught SmartyException: Unable to load template snippet ‚widgets/error/generic_error.tpl‘ in /is/htdocs/wp1112165_VOIHP9HYHO/www3/engine/Library/Smarty/sysplugins/smarty_internal_templatebase.php:127 Stack trace: #0 /is/htdocs/wp1112165_VOIHP9HYHO/www3/engine/Library/Enlight/View/Default.php(286): Smarty_Internal_TemplateBase->fetch() #1 /is/htdocs/wp1112165_VOIHP9HYHO/www3/engine/Library/Enlight/Controller/Plugins/ViewRenderer/Bootstrap.php(180): Enlight_View_Default->render(Object(Enlight_Template_Default)) #2 /is/htdocs/wp1112165_VOIHP9HYHO/www3/engine/Library/Enlight/Controller/Plugins/ViewRenderer/Bootstrap.php(207): Enlight_Controller_Plugins_ViewRenderer_Bootstrap->renderTemplate(Object(Enlight_Template_Default)) #3 /is/htdocs/wp1112165_VOIHP9HYHO/www3/engine/Library/Enlight/Controller/Plugins/ViewRenderer/Bootstrap.php(124): Enlight_Controller_Plugins_ViewRenderer_Bootstrap->render() #4 /is/htdocs/wp1112165_VOIHP9HYHO/www3/engine/Library/Enlight/Event/Handler/Default.php(90): Enlight_Controller_Plug in /is/htdocs/wp1112165_VOIHP9HYHO/www3/engine/Library/Smarty/sysplugins/smarty_internal_templatebase.php on line 127

Leider kenne ich mich zu wenig aus und weiß nicht einmal genau was Smarty ist.
Kann mir bitte bitte jemand weiterhelfen wie ich den Fehler beheben kann? Über ausführliche Antworten würde ich mich wirklich sehr freuen.

In der Log-Datei bei System-Log hab ich bereits nachgesehen und dort wird seit heute 00:01 Uhr fast im 2min Takt eine neue Fehlermeldung angezeigt. Dabei handelt es sich unter anderem um folgende zwei Meldungen:
erstens:
PDOException: SQLSTATE(42S22): Column not found: 1054 Unknown column ‚productAttribute.nwt1‘ in ‚field list‘ in /vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117 Stack trace:
#0 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOStatement->execute(NULL)
#1 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1304): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(212): Doctrine\DBAL\Connection->executeQuery(‚SELECT product…‘, Array, Array)
#3 /engine/Shopware/Bundle/StoreFrontBundle/Gateway/DBAL/ListProductGateway.php(66): Doctrine\DBAL\Query\QueryBuilder->execute()
#4 /engine/Shopware/Bundle/StoreFrontBundle/Service/Core/ListProductService.php(104): Shopware\Bundle\StoreFrontBundle\Gateway\DBAL\ListProductGateway->getList(Array, Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext))
#5 /engine/Shopware/Bundle/SearchBundle/ProductSearch.php(62): Shopware\Bundle\StoreFrontBundle\Service\Core\ListProductService->getList(Array, Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext))
#6 /engine/Shopware/Bundle/SearchBundle/VariantSearch.php(66): Shopware\Bundle\SearchBundle\ProductSearch->search(Object(Shopware\Bundle\SearchBundle\Criteria), Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext))
#7 /engine/Shopware/Core/sArticles.php(2444): Shopware\Bundle\SearchBundle\VariantSearch->search(Object(Shopware\Bundle\SearchBundle\Criteria), Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext))
#8 /engine/Shopware/Core/sArticles.php(505): sArticles->getListing(44, Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext), Object(Enlight_Controller_Request_RequestHttp), Object(Shopware\Bundle\SearchBundle\Criteria))
#9 /engine/Shopware/Controllers/Frontend/Listing.php(591): sArticles->sGetArticlesByCategory(44, Object(Shopware\Bundle\SearchBundle\Criteria))
#10 /engine/Shopware/Controllers/Frontend/Listing.php(147): Shopware_Controllers_Frontend_Listing->loadCategoryListing(44, Array, Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext))
#11 /engine/Library/Enlight/Controller/Action.php(186): Shopware_Controllers_Frontend_Listing->indexAction(Object(Enlight_Controller_Request_RequestHttp), Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext))
#12 /engine/Library/Enlight/Controller/Dispatcher/Default.php(467): Enlight_Controller_Action->dispatch(‚indexAction‘)
#13 /engine/Library/Enlight/Controller/Front.php(225): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#14 /engine/Shopware/Kernel.php(197): Enlight_Controller_Front->dispatch()
#15 /vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(85): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#16 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true)
#17 /engine/Shopware/Components/HttpCache/AppCache.php(266): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#18 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(452): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#19 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(346): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true)
#20 /engine/Shopware/Components/HttpCache/AppCache.php(192): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true)
#21 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(224): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true)
#22 /engine/Shopware/Components/HttpCache/AppCache.php(117): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#23 /is/htdocs/wp1112165_VOIHP9HYHO/www3/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#24

zweitens:
An exception occurred while executing ‚SELECT product.id as __product_id, product.supplierID as __product_supplierID, product.name as __product_name, product.description as __product_description, product.description_long as __product_description_long, product.shippingtime as __product_shippingtime, product.datum as __product_datum, product.active as __product_active, product.taxID as __product_taxID, product.pseudosales as __product_pseudosales, product.topseller as __product_topseller, product.metaTitle as __product_metaTitle, product.keywords as __product_keywords, product.changetime as __product_changetime, product.pricegroupID as __product_pricegroupID, product.pricegroupActive as __product_pricegroupActive, product.filtergroupID as __product_filtergroupID, product.crossbundlelook as __product_crossbundlelook, product.notification as __product_notification, product.template as __product_template, product.mode as __product_mode, product.main_detail_id as __product_main_detail_id, product.available_from as __product_available_from, product.available_to as __product_available_to, product.configurator_set_id as __product_configurator_set_id, productAttribute.id as __productAttribute_id, productAttribute.articledetailsID as __productAttribute_articledetailsID, productAttribute.attr1 as __productAttribute_attr1, productAttribute.attr2 as __productAttribute_attr2, productAttribute.attr3 as __productAttribute_attr3, productAttribute.attr4 as __productAttribute_attr4, productAttribute.attr5 as __productAttribute_attr5, productAttribute.attr6 as __productAttribute_attr6, productAttribute.attr7 as __productAttribute_attr7, productAttribute.attr8 as __productAttribute_attr8, productAttribute.attr9 as __productAttribute_attr9, productAttribute.attr10 as __productAttribute_attr10, productAttribute.attr11 as __productAttribute_attr11, productAttribute.attr12 as __productAttribute_attr12, productAttribute.attr13 as __productAttribute_attr13, productAttribute.attr14 as __productAttribute_attr14, productAttribute.attr15 as __productAttribute_attr15, productAttribute.attr16 as __productAttribute_attr16, productAttribute.attr17 as __productAttribute_attr17, productAttribute.attr18 as __productAttribute_attr18, productAttribute.attr19 as __productAttribute_attr19, productAttribute.attr20 as __productAttribute_attr20, productAttribute.nwt1 as __productAttribute_nwt1, productAttribute.rdz1 as __productAttribute_rdz1, topSeller.sales as __topSeller_sales, variant.id as __variant_id, variant.ordernumber as __variant_ordernumber, variant.suppliernumber as __variant_suppliernumber, variant.kind as __variant_kind, variant.additionaltext as __variant_additionaltext, variant.sales as __variant_sales, variant.active as __variant_active, variant.instock as __variant_instock, variant.stockmin as __variant_stockmin, variant.weight as __variant_weight, variant.position as __variant_position, variant.width as __variant_width, variant.height as __variant_height, variant.length as __variant_length, variant.ean as __variant_ean, variant.unitID as __variant_unitID, variant.releasedate as __variant_releasedate, variant.shippingfree as __variant_shippingfree, variant.shippingtime as __variant_shippingtime, variant.laststock as __product_laststock, unit.id as __unit_id, unit.description as __unit_description, unit.unit as __unit_unit, variant.packunit as __unit_packunit, variant.purchaseunit as __unit_purchaseunit, variant.referenceunit as __unit_referenceunit, variant.purchasesteps as __unit_purchasesteps, variant.minpurchase as __unit_minpurchase, variant.maxpurchase as __unit_maxpurchase, tax.id as __tax_id, tax.tax as __tax_tax, tax.description as __tax_description, priceGroup.id as __priceGroup_id, priceGroup.description as __priceGroup_description, manufacturer.id as __manufacturer_id, manufacturer.name as __manufacturer_name, manufacturer.img as __manufacturer_img, manufacturer.link as __manufacturer_link, manufacturer.description as __manufacturer_description, manufacturer.meta_title as __manufacturer_meta_title, manufacturer.meta_description as __manufacturer_meta_description, manufacturer.meta_keywords as __manufacturer_meta_keywords, manufacturerAttribute.id as __manufacturerAttribute_id, manufacturerAttribute.supplierID as __manufacturerAttribute_supplierID, esd.id as __esd_id, esd.articleID as __esd_articleID, esd.articledetailsID as __esd_articledetailsID, esd.file as __esd_file, esd.serials as __esd_serials, esd.notification as __esd_notification, esd.maxdownloads as __esd_maxdownloads, esd.datum as __esd_datum, esdAttribute.id as __esdAttribute_id, esdAttribute.esdID as __esdAttribute_esdID, (SELECT 1 FROM s_articles_esd variantEsd WHERE variantEsd.articleID = product.id LIMIT 1) as __product_has_esd, (SELECT GROUP_CONCAT(customerGroups.customergroupId SEPARATOR ‚|‘) FROM s_articles_avoid_customergroups customerGroups WHERE customerGroups.articleID = product.id) as __product_blocked_customer_groups, (SELECT COUNT(availableVariant.id) FROM s_articles_details availableVariant WHERE (availableVariant.articleID = product.id) AND (availableVariant.active = 1) AND ((availableVariant.laststock * availableVariant.instock) >= (availableVariant.laststock * availableVariant.minpurchase))) as __product_has_available_variants, (SELECT COUNT(DISTINCT ROUND(prices.price, 2)) as priceCount FROM s_articles_prices prices INNER JOIN s_articles_details priceVariant ON priceVariant.id = prices.articledetailsID and priceVariant.active = 1 WHERE (prices.from = 1) AND (prices.pricegroup = ?) AND (prices.articleID = product.id)) as __product_fallback_price_count, manufacturerMedia.id as __manufacturer_img_id FROM s_articles_details variant INNER JOIN s_articles product ON product.id = variant.articleID LEFT JOIN s_core_units unit ON unit.id = variant.unitID LEFT JOIN s_articles_attributes productAttribute ON productAttribute.articledetailsID = variant.id LEFT JOIN s_articles_esd esd ON esd.articledetailsID = variant.id INNER JOIN s_core_tax tax ON tax.id = product.taxID LEFT JOIN s_articles_supplier manufacturer ON manufacturer.id = product.supplierID LEFT JOIN s_core_pricegroups priceGroup ON priceGroup.id = product.pricegroupID LEFT JOIN s_articles_supplier_attributes manufacturerAttribute ON manufacturerAttribute.supplierID = product.supplierID LEFT JOIN s_articles_top_seller_ro topSeller ON topSeller.article_id = product.id LEFT JOIN s_media manufacturerMedia ON manufacturerMedia.path = manufacturer.img LEFT JOIN s_articles_esd_attributes esdAttribute ON esdAttribute.esdID = esd.id WHERE (variant.ordernumber IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (variant.active = 1) AND (product.active = 1)‘ with params („EK“, „414124-K“, „414112-K“, „414132-K“, „414216-K“, „414268-K“, „414140-K“, „414212-K“, 414104, „414128-K“, „414136-K“, „414256-K“, „414262-K“, „414248-K“, „414108-K“, 414256, 414262, 414268, 414140, 414132, 414216, 414128, 414124, 414212, 414136, 414112, 414108, 414100, 414110, „414100-K“, 414164, 6839, 100400, 35005, 35065, 35035, 35175, 35085, 35055, 35075, 35015, 35165, 35105, 35155, 35115, 35045, 35125, 35135, 35145, 35095, 35025, 35200, 82107, „414260-K“, 414260, 414248, „414142-K“, 414142, 414144, 21040, 21195, 21041, 21175, 21065, 21174, 21045, 21063, 21046, 21170, 21066, 21042, 21043, 21282, 21280, 21284, 21044, 21287, 21281, 21286, 21049, 21169, 21168, 21285, 21048, 21166, 21050, 21047, 21164, 21232, 21283, 21167, 21172, 21173, 21163, 21160, 21064, 21051, 21165, 16872, 16874, 14034, 14032, 16232, 16234, 16402, 16404, 14802, 14804, 16382, 16384, 15122, 15124, 15424, 15422, 19582, 19584, 12382, 12384, 15642, 15644, 14912, 14914, 12372, 12374, 12082, 12084, 12092, 12094, „414262-R“, „414128-R“): SQLSTATE(42S22): Column not found: 1054 Unknown column ‚productAttribute.nwt1‘ in ‚field list‘

Vielleicht sollte ich noch dazu sagen, dass wir absolut nichts an dem Shop geändert haben und somit auch keinen Anhaltspunkt haben warum der Fehler plötzlich auftritt.

Vielen vielen Dank für die Hilfe. Bitte

Da fehlt wohl eine Spalte bei einer Datenbank-Tabelle.

Evtl. ein Backup der Datenbank einspielen (lassen).

Viele Grüße

Wie kann es denn passieren, dass plötzlich eine Spalte in der Datenbank fehlt?
Dank ich werde das Backup hochladen.
Muss ich dazu vorher die Datenbank leeren?

Ich habe einen Testshop in einem Unterordner, welcher über eine extra Datenbank läuft. Ist es auch möglich, dass ich dort die fehlende Spalte kopiere und in die Datenbank des Live-Shops einfüge? Oder ist dies der unsichere Weg?

Schwer zu sagen, warum die Spalte weg ist - vielleicht irgendein Plugin deinstalliert ?

Ich empfehle, dass vollständige Backup einzuspielen - falls der Dump keinen „Drop table if exists“ Parameter enthält, solltest Du vorher alle Tabellen löschen.

Ok vielen Dank, dann probiere ich das aus.

Noch eine kurze Frage während das Backup noch läuft.
Und zwar habe ich eben herausgefunden, dass wohl scheinbar im Backend ein Freitextfeld mit dem Spaltennamen nwt1 gelöscht wurde, weil dieses nicht mehr gebraucht wurde. Kann der Fehler damit zusammen hängen und wenn ja, kann man ihn dann vielleicht ohne Backup lösen?

Passt konnte den Fehler beheben. Vielen Dank für ihre Hilfe SCOOPEX. :smiley:

1 Like