# Brauche Hilfe    An exception occurred while executing

**URL:** https://forum.shopware.com/t/brauche-hilfe-an-exception-occurred-while-executing/44956
**Category:** Job Posting
**Created:** [1. April 2017 um 16:34 UTC](https://forum.shopware.com/t/brauche-hilfe-an-exception-occurred-while-executing/44956 "2017-04-01T16:34:55Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![HausundSicherheit](https://avatars.discourse-cdn.com/v4/letter/h/b487fb/32.png) [@HausundSicherheit](https://forum.shopware.com/u/HausundSicherheit)
#### Post date: [1. April 2017 um 16:34 UTC](https://forum.shopware.com/t/brauche-hilfe-an-exception-occurred-while-executing/44956/1 "2017-04-01T16:34:55Z")

</div>

Hallo

Wir brauchen Hilfe bei folgendem Problem

Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. An exception occurred while executing ‚SELECT s0\_.id AS id\_0, s0\_.article\_id AS article\_id\_1, s0\_.unit\_id AS unit\_id\_2, s0\_.order\_number AS order\_number\_3, s0\_.suppliernumber AS suppliernumber\_4, s0\_.additionaltext AS additionaltext\_5, s0\_.active AS active\_6, s0\_.instock AS instock\_7, s0\_.stockmin AS stockmin\_8, s0\_.weight AS weight\_9, s0\_.width AS width\_10, s0\_.length AS length\_11, s0\_.height AS height\_12, s0\_.ean AS ean\_13, s0\_.purchaseprice AS purchaseprice\_14, s0\_.position AS position\_15, s0\_.minpurchase AS minpurchase\_16, s0\_.purchasesteps AS purchasesteps\_17, s0\_.maxpurchase AS maxpurchase\_18, s0\_.purchaseunit AS purchaseunit\_19, s0\_.referenceunit AS referenceunit\_20, s0\_.packunit AS packunit\_21, s0\_.shippingfree AS shippingfree\_22, s0\_.releasedate AS releasedate\_23, s0\_.shippingtime AS shippingtime\_24, s1\_.id AS id\_25, s1\_.template\_id AS template\_id\_26, s1\_.customer\_group\_key AS customer\_group\_key\_27, s1\_.`from` AS from\_28, s1\_.`to` AS to\_29, s1\_.price AS price\_30, s1\_.pseudoprice AS pseudoprice\_31, s1\_.percent AS percent\_32, s2\_.id AS id\_33, s2\_.groupkey AS groupkey\_34, s2\_.description AS description\_35, s2\_.tax AS tax\_36, s2\_.taxinput AS taxinput\_37, s2\_.mode AS mode\_38, s2\_.discount AS discount\_39, s2\_.minimumorder AS minimumorder\_40, s2\_.minimumordersurcharge AS minimumordersurcharge\_41, s3\_.id AS id\_42, s3\_.template\_id AS template\_id\_43, s3\_.attr1 AS attr1\_44, s3\_.attr2 AS attr2\_45, s3\_.attr3 AS attr3\_46, s3\_.attr4 AS attr4\_47, s3\_.attr5 AS attr5\_48, s3\_.attr6 AS attr6\_49, s3\_.attr7 AS attr7\_50, s3\_.attr8 AS attr8\_51, s3\_.attr9 AS attr9\_52, s3\_.attr10 AS attr10\_53, s3\_.attr11 AS attr11\_54, s3\_.attr12 AS attr12\_55, s3\_.attr13 AS attr13\_56, s3\_.attr14 AS attr14\_57, s3\_.attr15 AS attr15\_58, s3\_.attr16 AS attr16\_59, s3\_.attr17 AS attr17\_60, s3\_.attr18 AS attr18\_61, s3\_.attr19 AS attr19\_62, s3\_.attr20 AS attr20\_63, s3\_.syn\_gs\_title AS syn\_gs\_title\_64, s3\_.syn\_gs\_description AS syn\_gs\_description\_65, s3\_.syn\_gs\_category AS syn\_gs\_category\_66, s3\_.syn\_gs\_gender AS syn\_gs\_gender\_67, s3\_.syn\_gs\_age\_group AS syn\_gs\_age\_group\_68, s3\_.syn\_gs\_size AS syn\_gs\_size\_69, s3\_.syn\_gs\_size\_type AS syn\_gs\_size\_type\_70, s3\_.syn\_gs\_size\_system AS syn\_gs\_size\_system\_71, s3\_.syn\_gs\_color AS syn\_gs\_color\_72, s3\_.syn\_gs\_energy\_efficiency\_class AS syn\_gs\_energy\_efficiency\_class\_73, s3\_.syn\_gs\_adult AS syn\_gs\_adult\_74, s3\_.syn\_gs\_condition AS syn\_gs\_condition\_75, s3\_.syn\_gs\_identifier\_exists AS syn\_gs\_identifier\_exists\_76, s3\_.syn\_gs\_pattern AS syn\_gs\_pattern\_77, s3\_.syn\_gs\_material AS syn\_gs\_material\_78, s3\_.syn\_gs\_excluded\_destination AS syn\_gs\_excluded\_destination\_79, s3\_.syn\_gs\_sale\_price\_effective\_begin AS syn\_gs\_sale\_price\_effective\_begin\_80, s3\_.syn\_gs\_sale\_price\_effective\_end AS syn\_gs\_sale\_price\_effective\_end\_81, s3\_.syn\_gs\_custom\_label0 AS syn\_gs\_custom\_label0\_82, s3\_.syn\_gs\_custom\_label1 AS syn\_gs\_custom\_label1\_83, s3\_.syn\_gs\_custom\_label2 AS syn\_gs\_custom\_label2\_84, s3\_.syn\_gs\_custom\_label3 AS syn\_gs\_custom\_label3\_85, s3\_.syn\_gs\_custom\_label4 AS syn\_gs\_custom\_label4\_86, s4\_.id AS id\_87, s4\_.template\_price\_id AS template\_price\_id\_88 FROM s\_article\_configurator\_templates s0\_ LEFT JOIN s\_article\_configurator\_template\_prices s1\_ ON s0\_.id = s1\_.template\_id LEFT JOIN s\_core\_customergroups s2\_ ON s1\_.customer\_group\_key = s2\_.groupkey LEFT JOIN s\_article\_configurator\_templates\_attributes s3\_ ON s0\_.id = s3\_.template\_id LEFT JOIN s\_article\_configurator\_template\_prices\_attributes s4\_ ON s1\_.id = s4\_.template\_price\_id WHERE s0\_.article\_id = ?‘ with params [„9571“]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‚s3\_.syn\_gs\_title‘ 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(739): Doctrine\ORM\AbstractQuery-\>execute(NULL, 2) #6 engine/Shopware/Controllers/Backend/Article.php(1936): Doctrine\ORM\AbstractQuery-\>getArrayResult() #7 engine/Shopware/Controllers/Backend/Article.php(1994): Shopware\_Controllers\_Backend\_Article-\>getArticleConfiguratorTemplate(‚9571‘, Array) #8 engine/Shopware/Controllers/Backend/Article.php(1428): Shopware\_Controllers\_Backend\_Article-\>getArticle(‚9571‘) #9 engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Backend\_Article-\>loadStoresAction() #10 engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight\_Controller\_Action-\>dispatch(‚loadStoresActio…‘) #11 engine/Library/Enlight/Controller/Front.php(223): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #12 engine/Shopware/Kernel.php(180): Enlight\_Controller\_Front-\>dispatch() #13 vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #14 engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #15 vendor/symfony/http-kernel/HttpCache/HttpCache.php(258): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #16 engine/Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #17 shopware.php(117): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #18 {main} &nbsp;

&nbsp;

&nbsp;

&nbsp;

---

<div class="post-metadata">

### Author: ![sschreier](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/sschreier/32/23296_2.png) [@sschreier](https://forum.shopware.com/u/sschreier)
#### Post date: [1. April 2017 um 16:47 UTC](https://forum.shopware.com/t/brauche-hilfe-an-exception-occurred-while-executing/44956/2 "2017-04-01T16:47:25Z")

</div>

Hallo,

der Fehler steht doch deutlich da: "Column not found: 1054 Unknown column ‚s3\_. **syn\_gs\_title** ‘ in ‚field list‘ ". Da dies kein Standardfeld ist, erzeugt den Fehler ein installiertes Plugin.

Beste Grüße

Sebastian

---

<div class="post-metadata">

### Author: ![HausundSicherheit](https://avatars.discourse-cdn.com/v4/letter/h/b487fb/32.png) [@HausundSicherheit](https://forum.shopware.com/u/HausundSicherheit)
#### Post date: [1. April 2017 um 17:04 UTC](https://forum.shopware.com/t/brauche-hilfe-an-exception-occurred-while-executing/44956/3 "2017-04-01T17:04:11Z")

</div>

Hallo

&nbsp;

Erst mal Danke .

Allerdings habe ich keinen Schimmer welches, denn gestern ging noch alles und wir haben keine update etc gemacht.

Hab jetzt auch fast alles deaktiviert, ohne Änderung

---

<div class="post-metadata">

### Author: ![sschreier](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/sschreier/32/23296_2.png) [@sschreier](https://forum.shopware.com/u/sschreier)
#### Post date: [1. April 2017 um 17:13 UTC](https://forum.shopware.com/t/brauche-hilfe-an-exception-occurred-while-executing/44956/4 "2017-04-01T17:13:07Z")

</div>

> [@HausundSicherheit schrieb:](https://forum.shopware.com/profile/25709/HausundSicherheit "HausundSicherheit")
> 
> Hallo
> 
> &nbsp;
> 
> Erst mal Danke .
> 
> Allerdings habe ich keinen Schimmer welches, denn gestern ging noch alles und wir haben keine update etc gemacht.
> 
> Hab jetzt auch fast alles deaktiviert, ohne Änderung

Hallo,

hast du das Shopware - Plugin „Google Shopping Professional“ aktiv?

Beste Grüße

Sebastian

---

<div class="post-metadata">

### Author: ![HausundSicherheit](https://avatars.discourse-cdn.com/v4/letter/h/b487fb/32.png) [@HausundSicherheit](https://forum.shopware.com/u/HausundSicherheit)
#### Post date: [1. April 2017 um 17:22 UTC](https://forum.shopware.com/t/brauche-hilfe-an-exception-occurred-while-executing/44956/5 "2017-04-01T17:22:52Z")

</div>

Nein

 ![](https://europe1.discourse-cdn.com/flex013/uploads/shopware/original/2X/1/1bbec8aa467c4a505d4b2289e395cd288591d730.png)

---

<div class="post-metadata">

### Author: ![sschreier](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/sschreier/32/23296_2.png) [@sschreier](https://forum.shopware.com/u/sschreier)
#### Post date: [1. April 2017 um 17:33 UTC](https://forum.shopware.com/t/brauche-hilfe-an-exception-occurred-while-executing/44956/6 "2017-04-01T17:33:49Z")

</div>

Hallo,

kann es sein, das du das Plugin einmal aktiv oder installiert hattest? Der Feldname **syn\_gs\_title** deutet nämlich darauf hin, weil syn =&nbsp;SYNERGY NETWORKS GmbH, gs = Google Shopping und dazu kommt nach deinem fehlenden Feld genau die Felder, die das Plugin alle besitzt. Ich gehe also davon aus, das du das Plugin einmal bei dir installiert hattest und dieses fehlerhaft deinstalliert wurde, sodass das Plugin nun deinstalliert ist, aber das System immernoch denkt, dass die Felder da sind.

Welche Shopware - Version ist bei dir im Einsatz? Wenn über Shopware 5.2, kannst du ja mal in der Freitextfelder-Verwaltung das Model vom Artikel neu generieren lassen und danach den **kompletten** Shop Cache (also inklusive Theme- und Backend-Cache) leeren.

Beste Grüße

Sebastian

---

<div class="post-metadata">

### Author: ![HausundSicherheit](https://avatars.discourse-cdn.com/v4/letter/h/b487fb/32.png) [@HausundSicherheit](https://forum.shopware.com/u/HausundSicherheit)
#### Post date: [1. April 2017 um 18:33 UTC](https://forum.shopware.com/t/brauche-hilfe-an-exception-occurred-while-executing/44956/7 "2017-04-01T18:33:09Z")

</div>

Hallo

&nbsp;

Was immer es auch war…habe auf 5.2.21 aktualisiert…Jetzt ist der Fehler weg.

&nbsp;

Danke fuer Tipps und Zeit

---

<div class="post-metadata">

### Author: ![rpatzel](https://avatars.discourse-cdn.com/v4/letter/r/57b2e6/32.png) [@rpatzel](https://forum.shopware.com/u/rpatzel)
#### Post date: [1. April 2017 um 19:37 UTC](https://forum.shopware.com/t/brauche-hilfe-an-exception-occurred-while-executing/44956/8 "2017-04-01T19:37:47Z")

</div>

“Brauche Hilfe” ist als Titel übrigens sehr dürftig…  
Man sollte wenigstens anreissen worum es geht.