# Backend Fehler bei Artikeldetails aufruf
**URL:** https://forum.shopware.com/t/backend-fehler-bei-artikeldetails-aufruf/43445
**Category:** Installation/Einstieg
**Created:** [6. Februar 2017 um 11:36 UTC](https://forum.shopware.com/t/backend-fehler-bei-artikeldetails-aufruf/43445 "2017-02-06T11:36:09Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@terradog](https://forum.shopware.com/u/terradog)
#### Post date: [6. Februar 2017 um 11:36 UTC](https://forum.shopware.com/t/backend-fehler-bei-artikeldetails-aufruf/43445/1 "2017-02-06T11:36:09Z")
Hallo, leider erhalte ich die folgende Fehlermeldung wenn ich im Backend die Artikeldetails aufrufen möchte?
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, s4\_.id AS id\_64, s4\_.template\_price\_id AS template\_price\_id\_65 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 [“4270”]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s0\_.purchaseprice’ 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(1934): Doctrine\ORM\AbstractQuery-\>getArrayResult() #7 engine/Shopware/Controllers/Backend/Article.php(1992): Shopware\_Controllers\_Backend\_Article-\>getArticleConfiguratorTemplate(‘4270’, Array) #8 engine/Shopware/Controllers/Backend/Article.php(1426): Shopware\_Controllers\_Backend\_Article-\>getArticle(‘4270’) #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(179): 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}
_Und wenn ich einen neuen Artikel anlegen/speichern möchte komm diese Fehlermeldung:_
Fehlgeschlagen
Während des Speicherns ist ein Fehler aufgetreten: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, s4\_.id AS id\_64, s4\_.template\_price\_id AS template\_price\_id\_65 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 [4272]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s0\_.purchaseprice’ in ‘field list’
Was kann das Problem sein? Fehlen vieleicht die Tabelen/Daten in der myphp Datenbank?
---
### Author:  [@TimmeHosting](https://forum.shopware.com/u/TimmeHosting)
#### Post date: [7. Februar 2017 um 11:51 UTC](https://forum.shopware.com/t/backend-fehler-bei-artikeldetails-aufruf/43445/2 "2017-02-07T11:51:18Z")
Hat die Tabelle s\_article\_configurator\_templates eine Spalte namens purchaseprice? Hast Du mal versucht (z.B. in phpMyAdmin), die Tabelle zu reparieren (evtl. ist sie gecrasht)?
Timme Hosting - schnelles nginx-Hosting
[www.timmehosting.de](https://timmehosting.de/)
---
### Author:  [@terradog](https://forum.shopware.com/u/terradog)
#### Post date: [7. Februar 2017 um 13:57 UTC](https://forum.shopware.com/t/backend-fehler-bei-artikeldetails-aufruf/43445/3 "2017-02-07T13:57:43Z")
Nein eine Spalte mit purchaseprice gibt es da nicht. Ich hatte alle meine Artikel aus einen Backup über phpMyAdmin neu angelegt.
---
### Author:  [@Moritz\_Naczenski](https://forum.shopware.com/u/Moritz_Naczenski)
#### Post date: [7. Februar 2017 um 14:01 UTC](https://forum.shopware.com/t/backend-fehler-bei-artikeldetails-aufruf/43445/4 "2017-02-07T14:01:22Z")
Die Spalte gibt es aber dort in der 5.2 und wird auch vom Update angelegt: [shopware/750-migrate-article-details-base-price.php at 27507fe404cede0b75ad561fc081ce4fc9554569 · shopware/shopware · GitHub](https://github.com/shopware/shopware/blob/27507fe404cede0b75ad561fc081ce4fc9554569/_sql/migrations/750-migrate-article-details-base-price.php)
---
### Author:  [@terradog](https://forum.shopware.com/u/terradog)
#### Post date: [7. Februar 2017 um 14:09 UTC](https://forum.shopware.com/t/backend-fehler-bei-artikeldetails-aufruf/43445/5 "2017-02-07T14:09:56Z")
Super, vielen Dank!!! Das war es.
