# Uncaught SmartyException & komplett voller System-Log; Wie beheben? **URL:** \ **Category:** Programmierung\ **Tags:** general, programming\ **Created:** [26. August 2022 um 14:53 UTC](https://forum.shopware.com/t/uncaught-smartyexception-komplett-voller-system-log-wie-beheben/95972 "2022-08-26T14:53:25Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![jassi](https://avatars.discourse-cdn.com/v4/letter/j/b5ac83/32.png) [@jassi](https://forum.shopware.com/u/jassi)\ **Post date:** [26. August 2022 um 14:53 UTC](https://forum.shopware.com/t/uncaught-smartyexception-komplett-voller-system-log-wie-beheben/95972/1 "2022-08-26T14:53:25Z")
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 ---
**Author:** ![SCOOPEX](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/scoopex/32/18328_2.png) [@SCOOPEX](https://forum.shopware.com/u/SCOOPEX)\ **Post date:** [26. August 2022 um 14:56 UTC](https://forum.shopware.com/t/uncaught-smartyexception-komplett-voller-system-log-wie-beheben/95972/2 "2022-08-26T14:56:46Z")
> [@jassi](#): > > Column not found: 1054 Unknown column ‚productAttribute.nwt1‘ in ‚field list‘ Da fehlt wohl eine Spalte bei einer Datenbank-Tabelle. Evtl. ein Backup der Datenbank einspielen (lassen). Viele Grüße ---
**Author:** ![jassi](https://avatars.discourse-cdn.com/v4/letter/j/b5ac83/32.png) [@jassi](https://forum.shopware.com/u/jassi)\ **Post date:** [26. August 2022 um 14:59 UTC](https://forum.shopware.com/t/uncaught-smartyexception-komplett-voller-system-log-wie-beheben/95972/3 "2022-08-26T14:59:44Z")
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? ---
**Author:** ![jassi](https://avatars.discourse-cdn.com/v4/letter/j/b5ac83/32.png) [@jassi](https://forum.shopware.com/u/jassi)\ **Post date:** [26. August 2022 um 15:07 UTC](https://forum.shopware.com/t/uncaught-smartyexception-komplett-voller-system-log-wie-beheben/95972/4 "2022-08-26T15:07:20Z")
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? ---
**Author:** ![SCOOPEX](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/scoopex/32/18328_2.png) [@SCOOPEX](https://forum.shopware.com/u/SCOOPEX)\ **Post date:** [26. August 2022 um 15:14 UTC](https://forum.shopware.com/t/uncaught-smartyexception-komplett-voller-system-log-wie-beheben/95972/5 "2022-08-26T15:14:45Z")
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. ---
**Author:** ![jassi](https://avatars.discourse-cdn.com/v4/letter/j/b5ac83/32.png) [@jassi](https://forum.shopware.com/u/jassi)\ **Post date:** [26. August 2022 um 15:21 UTC](https://forum.shopware.com/t/uncaught-smartyexception-komplett-voller-system-log-wie-beheben/95972/6 "2022-08-26T15:21:12Z")
Ok vielen Dank, dann probiere ich das aus. ---
**Author:** ![jassi](https://avatars.discourse-cdn.com/v4/letter/j/b5ac83/32.png) [@jassi](https://forum.shopware.com/u/jassi)\ **Post date:** [26. August 2022 um 16:50 UTC](https://forum.shopware.com/t/uncaught-smartyexception-komplett-voller-system-log-wie-beheben/95972/7 "2022-08-26T16:50:46Z")
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? ---
**Author:** ![jassi](https://avatars.discourse-cdn.com/v4/letter/j/b5ac83/32.png) [@jassi](https://forum.shopware.com/u/jassi)\ **Post date:** [26. August 2022 um 17:01 UTC](https://forum.shopware.com/t/uncaught-smartyexception-komplett-voller-system-log-wie-beheben/95972/8 "2022-08-26T17:01:04Z")
Passt konnte den Fehler beheben. Vielen Dank für ihre Hilfe SCOOPEX. 😃