# Backendbestellung nicht mehr möglich
**URL:** https://forum.shopware.com/t/backendbestellung-nicht-mehr-moglich/52872
**Category:** Administration
**Created:** [14. Mai 2018 um 08:39 UTC](https://forum.shopware.com/t/backendbestellung-nicht-mehr-moglich/52872 "2018-05-14T08:39:22Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Sharky1980](https://forum.shopware.com/u/Sharky1980)
#### Post date: [14. Mai 2018 um 08:39 UTC](https://forum.shopware.com/t/backendbestellung-nicht-mehr-moglich/52872/1 "2018-05-14T08:39:22Z")
Hallo Leute,
seit gestern habe ich diese Meldung wenn ich eine Backendbestellung ausführen möchte.
Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. An exception occurred while executing ‚SELECT (CASE WHEN (s0\_.default\_billing\_address\_id = s1\_.id) THEN 1 ELSE 0 END) AS sclr\_0, (CASE WHEN (s0\_.default\_shipping\_address\_id = s1\_.id) THEN 1 ELSE 0 END) AS sclr\_1, s1\_.id AS id\_2, s1\_.company AS company\_3, s1\_.department AS department\_4, s1\_.salutation AS salutation\_5, s1\_.firstname AS firstname\_6, s1\_.title AS title\_7, s1\_.lastname AS lastname\_8, s1\_.street AS street\_9, s1\_.zipcode AS zipcode\_10, s1\_.city AS city\_11, s1\_.phone AS phone\_12, s1\_.ustid AS ustid\_13, s1\_.additional\_address\_line1 AS additional\_address\_line1\_14, s1\_.additional\_address\_line2 AS additional\_address\_line2\_15, s1\_.country\_id AS country\_id\_16, s1\_.state\_id AS state\_id\_17, s2\_.id AS id\_18, s2\_.countryname AS countryname\_19, s2\_.countryiso AS countryiso\_20, s2\_.countryen AS countryen\_21, s2\_.position AS position\_22, s2\_.notice AS notice\_23, s2\_.taxfree AS taxfree\_24, s2\_.taxfree\_ustid AS taxfree\_ustid\_25, s2\_.taxfree\_ustid\_checked AS taxfree\_ustid\_checked\_26, s2\_.active AS active\_27, s2\_.iso3 AS iso3\_28, s2\_.display\_state\_in\_registration AS display\_state\_in\_registration\_29, s2\_.force\_state\_in\_registration AS force\_state\_in\_registration\_30, s2\_.areaID AS areaID\_31, s3\_.id AS id\_32, s3\_.countryID AS countryID\_33, s3\_.position AS position\_34, s3\_.name AS name\_35, s3\_.shortcode AS shortcode\_36, s3\_.active AS active\_37, s4\_.id AS id\_38, s4\_.address\_id AS address\_id\_39, s4\_.text1 AS text1\_40, s4\_.text2 AS text2\_41, s4\_.text3 AS text3\_42, s4\_.text4 AS text4\_43, s4\_.text5 AS text5\_44, s4\_.text6 AS text6\_45, s4\_.bestit\_amazon\_hash AS bestit\_amazon\_hash\_46, s4\_.bestit\_amazon\_sw\_hash AS bestit\_amazon\_sw\_hash\_47, s4\_.bestit\_amazon\_type AS bestit\_amazon\_type\_48 FROM s\_user\_addresses s1\_ LEFT JOIN s\_core\_countries s2\_ ON s1\_.country\_id = s2\_.id LEFT JOIN s\_core\_countries\_states s3\_ ON s1\_.state\_id = s3\_.id LEFT JOIN s\_user\_addresses\_attributes s4\_ ON s1\_.id = s4\_.address\_id INNER JOIN s\_user s0\_ ON s1\_.user\_id = s0\_.id WHERE s1\_.user\_id = ? ORDER BY sclr\_0 DESC, sclr\_1 DESC‘ with params [107]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‚s4\_.bestit\_amazon\_hash‘ in ‚field list‘ in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 131 Stack trace: #0 vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(855): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), ‚SELECT (CASE WH…‘, Array) #1 vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection-\>executeQuery(‚SELECT (CASE WH…‘, 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(962): Doctrine\ORM\Query-\>\_doExecute() #4 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(917): Doctrine\ORM\AbstractQuery-\>executeIgnoreQueryCache(NULL, 2) #5 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(720): Doctrine\ORM\AbstractQuery-\>execute(NULL, 2) #6 engine/Shopware/Models/Customer/AddressRepository.php(46): Doctrine\ORM\AbstractQuery-\>getResult(2) #7 custom/plugins/SwagBackendOrder/Components/CustomerRepository.php(55): Shopware\Models\Customer\AddressRepository-\>getListArray(107) #8 custom/plugins/SwagBackendOrder/Controllers/Backend/SwagBackendOrder.php(69): SwagBackendOrder\Components\CustomerRepository-\>get(107) #9 engine/Library/Enlight/Controller/Action.php(193): Shopware\_Controllers\_Backend\_SwagBackendOrder-\>getCustomerAction() #10 engine/Library/Enlight/Controller/Dispatcher/Default.php(549): Enlight\_Controller\_Action-\>dispatch(‚getCustomerActi…‘) #11 engine/Library/Enlight/Controller/Front.php(222): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #12 engine/Shopware/Kernel.php(215): Enlight\_Controller\_Front-\>dispatch() #13 vendor/symfony/http-kernel/HttpCache/HttpCache.php(486): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #14 engine/Shopware/Components/HttpCache/AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #15 vendor/symfony/http-kernel/HttpCache/HttpCache.php(253): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #16 engine/Shopware/Components/HttpCache/AppCache.php(105): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #17 shopware.php(122): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #18 {main}
_OK_
* * *
liegt dort ein Fehler auf der DB vor ?
Vielleicht kann mir da wer helfen.
Gruss Arne
---
### Author:  [@dogado\_shops](https://forum.shopware.com/u/dogado_shops)
#### Post date: [14. Mai 2018 um 08:41 UTC](https://forum.shopware.com/t/backendbestellung-nicht-mehr-moglich/52872/2 "2018-05-14T08:41:48Z")
Hi Arne,
da fehlt Dir wohl eine Spalte in einer Tabelle, die mit dem BestIT Amazon Plugin zu tun hat:
Column not found: 1054 Unknown column ’ **s4\_.bestit\_amazon\_hash** ’
Du kannst versuchen, das Plugin neu zu installieren.
VG
---
### Author:  [@Sharky1980](https://forum.shopware.com/u/Sharky1980)
#### Post date: [14. Mai 2018 um 09:40 UTC](https://forum.shopware.com/t/backendbestellung-nicht-mehr-moglich/52872/3 "2018-05-14T09:40:12Z")
> [@AIXPRO schrieb:](https://forum.shopware.com/profile/2481/AIXPRO "AIXPRO")
>
> Hi Arne,
>
> da fehlt Dir wohl eine Spalte in einer Tabelle, die mit dem BestIT Amazon Plugin zu tun hat:
>
> Column not found: 1054 Unknown column ’ **s4\_.bestit\_amazon\_hash** ’
>
> Du kannst versuchen, das Plugin neu zu installieren.
>
> VG
Hallo AIX, danke dir das Plugin war fehlerhaft ! Super vielen herzlichen Dank