# Fehler beim Bearbeiten von Artikeln
**URL:** https://forum.shopware.com/t/fehler-beim-bearbeiten-von-artikeln/40362
**Category:** Allgemein
**Created:** [7. Oktober 2016 um 12:26 UTC](https://forum.shopware.com/t/fehler-beim-bearbeiten-von-artikeln/40362 "2016-10-07T12:26:52Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@doster](https://forum.shopware.com/u/doster)
#### Post date: [7. Oktober 2016 um 12:26 UTC](https://forum.shopware.com/t/fehler-beim-bearbeiten-von-artikeln/40362/1 "2016-10-07T12:26:52Z")
Hallo Zusammen,
wenn wir einen Artikel bearbeiten wollen, erscheint folgender Fehler:
Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. An exception occurred while executing ‘SELECT s0\_.id AS id\_0, s0\_.main\_detail\_id AS main\_detail\_id\_1, s0\_.supplierID AS supplierID\_2, s0\_.taxID AS taxID\_3, s0\_.pricegroupID AS pricegroupID\_4, s0\_.filtergroupID AS filtergroupID\_5, s0\_.configurator\_set\_id AS configurator\_set\_id\_6, s0\_.name AS name\_7, s0\_.description AS description\_8, s0\_.description\_long AS description\_long\_9, s0\_.datum AS datum\_10, s0\_.active AS active\_11, s0\_.pseudosales AS pseudosales\_12, s0\_.topseller AS topseller\_13, s0\_.keywords AS keywords\_14, s0\_.metaTitle AS metaTitle\_15, s0\_.changetime AS changetime\_16, s0\_.pricegroupActive AS pricegroupActive\_17, s0\_.laststock AS laststock\_18, s0\_.crossbundlelook AS crossbundlelook\_19, s0\_.notification AS notification\_20, s0\_.template AS template\_21, s0\_.mode AS mode\_22, s0\_.available\_from AS available\_from\_23, s0\_.available\_to AS available\_to\_24, s1\_.id AS id\_25, s1\_.articleID AS articleID\_26, s1\_.unitID AS unitID\_27, s1\_.ordernumber AS ordernumber\_28, s1\_.suppliernumber AS suppliernumber\_29, s1\_.kind AS kind\_30, s1\_.additionaltext AS additionaltext\_31, s1\_.active AS active\_32, s1\_.instock AS instock\_33, s1\_.stockmin AS stockmin\_34, s1\_.weight AS weight\_35, s1\_.width AS width\_36, s1\_.length AS length\_37, s1\_.height AS height\_38, s1\_.ean AS ean\_39, s1\_.purchaseprice AS purchaseprice\_40, s1\_.position AS position\_41, s1\_.minpurchase AS minpurchase\_42, s1\_.purchasesteps AS purchasesteps\_43, s1\_.maxpurchase AS maxpurchase\_44, s1\_.purchaseunit AS purchaseunit\_45, s1\_.referenceunit AS referenceunit\_46, s1\_.packunit AS packunit\_47, s1\_.shippingfree AS shippingfree\_48, s1\_.releasedate AS releasedate\_49, s1\_.shippingtime AS shippingtime\_50, s2\_.id AS id\_51, s2\_.tax AS tax\_52, s2\_.description AS description\_53, s3\_.id AS id\_54, s3\_.articleID AS articleID\_55, s3\_.articledetailsID AS articledetailsID\_56, s3\_.attr1 AS attr1\_57, s3\_.attr2 AS attr2\_58, s3\_.attr3 AS attr3\_59, s3\_.attr4 AS attr4\_60, s3\_.attr5 AS attr5\_61, s3\_.attr6 AS attr6\_62, s3\_.attr7 AS attr7\_63, s3\_.attr8 AS attr8\_64, s3\_.attr9 AS attr9\_65, s3\_.attr10 AS attr10\_66, s3\_.attr11 AS attr11\_67, s3\_.attr12 AS attr12\_68, s3\_.attr13 AS attr13\_69, s3\_.attr14 AS attr14\_70, s3\_.attr15 AS attr15\_71, s3\_.attr16 AS attr16\_72, s3\_.attr17 AS attr17\_73, s3\_.attr18 AS attr18\_74, s3\_.attr19 AS attr19\_75, s3\_.attr20 AS attr20\_76, s3\_.motion\_article\_name AS motion\_article\_name\_77, s3\_.viison\_storage\_location AS viison\_storage\_location\_78, s3\_.viison\_incoming\_stock AS viison\_incoming\_stock\_79, s3\_.viison\_physical\_stock AS viison\_physical\_stock\_80, s3\_.viison\_not\_relevant\_for\_stock\_manager AS viison\_not\_relevant\_for\_stock\_manager\_81, s3\_.viison\_not\_relevant\_for\_picking AS viison\_not\_relevant\_for\_picking\_82, s3\_.viison\_required\_information\_upon\_picking AS viison\_required\_information\_upon\_picking\_83 FROM s\_articles s0\_ LEFT JOIN s\_articles\_details s1\_ ON s0\_.main\_detail\_id = s1\_.id LEFT JOIN s\_core\_tax s2\_ ON s0\_.taxID = s2\_.id LEFT JOIN s\_articles\_attributes s3\_ ON s1\_.id = s3\_.articledetailsID WHERE s0\_.id = ?’ with params [“1364”]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s3\_.motion\_article\_name’ 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(1665): Doctrine\ORM\AbstractQuery-\>getArrayResult() #7 [internal function]: Shopware\_Controllers\_Backend\_Article-\>getArticleData(‘1364’) #8 var/cache/production\_201607251359/proxies/ShopwareControllersBackendArticleProxy.php(6): call\_user\_func\_array(Array, Array) #9 engine/Library/Enlight/Hook/HookManager.php(187): Shopware\_Proxies\_ShopwareControllersBackendArticleProxy-\>executeParent(‘getArticleData’, Array) #10 var/cache/production\_201607251359/proxies/ShopwareControllersBackendArticleProxy.php(39): Enlight\_Hook\_HookManager-\>executeHooks(Object(Shopware\_Proxies\_ShopwareControllersBackendArticleProxy), ‘getArticleData’, Array) #11 engine/Shopware/Controllers/Backend/Article.php(1968): Shopware\_Proxies\_ShopwareControllersBackendArticleProxy-\>getArticleData(‘1364’) #12 engine/Shopware/Controllers/Backend/Article.php(1426): Shopware\_Controllers\_Backend\_Article-\>getArticle(‘1364’) #13 engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Backend\_Article-\>loadStoresAction() #14 engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight\_Controller\_Action-\>dispatch(‘loadStoresActio…’) #15 engine/Library/Enlight/Controller/Front.php(226): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #16 engine/Shopware/Kernel.php(176): Enlight\_Controller\_Front-\>dispatch() #17 vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #18 engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #19 vendor/symfony/http-kernel/HttpCache/HttpCache.php(258): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #20 engine/Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #21 shopware.php(101): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #22 {main}
Kann mir da jemand weiter helfen?
Vielen Dank schonmal
---
### Author:  [@DanielNogel](https://forum.shopware.com/u/DanielNogel)
#### Post date: [8. Oktober 2016 um 11:11 UTC](https://forum.shopware.com/t/fehler-beim-bearbeiten-von-artikeln/40362/2 "2016-10-08T11:11:50Z")
Hi,
es gehlt das Attribut “motion\_article\_name”. Sowas kann beispielsweise entstehen, wenn ein Plugin nicht korrekt durchgeführt wurde oder du in der Programmierung auf ein Freitextfeld / Attribut zugreifst, das nicht existierst. Vielleicht hilft der der Name des Attribtus schon weiter, das Problem einzugrenzen?
Daniel