# Was ist dieser Backend-Bestellungen Fehler? **URL:** \ **Category:** Allgemein\ **Created:** [1. November 2017 um 18:36 UTC](https://forum.shopware.com/t/was-ist-dieser-backend-bestellungen-fehler/49207 "2017-11-01T18:36:54Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![balazs](https://avatars.discourse-cdn.com/v4/letter/b/cc9497/32.png) [@balazs](https://forum.shopware.com/u/balazs)\ **Post date:** [1. November 2017 um 18:36 UTC](https://forum.shopware.com/t/was-ist-dieser-backend-bestellungen-fehler/49207/1 "2017-11-01T18:36:54Z")
Hallo Leute. Kann mir jemand bitte sagen, was das ist und wie kann ich es beheben? Es zeigt sich in Backend-Bestellungen.   Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. An exception occurred while executing ‘SELECT s0\_.id AS id\_0, s0\_.ordernumber AS ordernumber\_1, s0\_.userID AS userID\_2, s0\_.status AS status\_3, s0\_.cleared AS cleared\_4, s0\_.paymentID AS paymentID\_5, s0\_.dispatchID AS dispatchID\_6, s0\_.partnerID AS partnerID\_7, s0\_.subshopID AS subshopID\_8, s0\_.invoice\_amount AS invoice\_amount\_9, s0\_.invoice\_amount\_net AS invoice\_amount\_net\_10, s0\_.invoice\_shipping AS invoice\_shipping\_11, s0\_.invoice\_shipping\_net AS invoice\_shipping\_net\_12, s0\_.ordertime AS ordertime\_13, s0\_.transactionID AS transactionID\_14, s0\_.comment AS comment\_15, s0\_.customercomment AS customercomment\_16, s0\_.internalcomment AS internalcomment\_17, s0\_.net AS net\_18, s0\_.taxfree AS taxfree\_19, s0\_.temporaryID AS temporaryID\_20, s0\_.referer AS referer\_21, s0\_.cleareddate AS cleareddate\_22, s0\_.trackingcode AS trackingcode\_23, s0\_.language AS language\_24, s0\_.currency AS currency\_25, s0\_.currencyfactor AS currencyfactor\_26, s0\_.remote\_addr AS remote\_addr\_27, s0\_.deviceType AS deviceType\_28, s1\_.customernumber AS customernumber\_29, s1\_.id AS id\_30, s1\_.paymentID AS paymentID\_31, s1\_.customergroup AS customergroup\_32, s1\_.subshopID AS subshopID\_33, s1\_.pricegroupID AS pricegroupID\_34, s1\_.encoder AS encoder\_35, s1\_.password AS password\_36, s1\_.active AS active\_37, s1\_.email AS email\_38, s1\_.firstlogin AS firstlogin\_39, s1\_.lastlogin AS lastlogin\_40, s1\_.accountmode AS accountmode\_41, s1\_.confirmationkey AS confirmationkey\_42, s1\_.sessionID AS sessionID\_43, s1\_.newsletter AS newsletter\_44, s1\_.validation AS validation\_45, s1\_.affiliate AS affiliate\_46, s1\_.paymentpreset AS paymentpreset\_47, s1\_.language AS language\_48, s1\_.referer AS referer\_49, s1\_.internalcomment AS internalcomment\_50, s1\_.failedlogins AS failedlogins\_51, s1\_.lockedUntil AS lockedUntil\_52, s1\_.salutation AS salutation\_53, s1\_.title AS title\_54, s1\_.firstname AS firstname\_55, s1\_.lastname AS lastname\_56, s1\_.birthday AS birthday\_57, s2\_.title AS title\_58, s2\_.additional\_address\_line1 AS additional\_address\_line1\_59, s2\_.additional\_address\_line2 AS additional\_address\_line2\_60, s2\_.id AS id\_61, s2\_.orderID AS orderID\_62, s2\_.countryID AS countryID\_63, s2\_.stateID AS stateID\_64, s2\_.userID AS userID\_65, s2\_.company AS company\_66, s2\_.department AS department\_67, s2\_.salutation AS salutation\_68, s2\_.firstname AS firstname\_69, s2\_.lastname AS lastname\_70, s2\_.street AS street\_71, s2\_.zipcode AS zipcode\_72, s2\_.city AS city\_73, s2\_.phone AS phone\_74, s3\_.id AS id\_75, s3\_.countryID AS countryID\_76, s3\_.position AS position\_77, s3\_.name AS name\_78, s3\_.shortcode AS shortcode\_79, s3\_.active AS active\_80, s4\_.id AS id\_81, s4\_.countryname AS countryname\_82, s4\_.countryiso AS countryiso\_83, s4\_.countryen AS countryen\_84, s4\_.position AS position\_85, s4\_.notice AS notice\_86, s4\_.taxfree AS taxfree\_87, s4\_.taxfree\_ustid AS taxfree\_ustid\_88, s4\_.taxfree\_ustid\_checked AS taxfree\_ustid\_checked\_89, s4\_.active AS active\_90, s4\_.iso3 AS iso3\_91, s4\_.display\_state\_in\_registration AS display\_state\_in\_registration\_92, s4\_.force\_state\_in\_registration AS force\_state\_in\_registration\_93, s4\_.areaID AS areaID\_94, s5\_.id AS id\_95, s5\_.main\_id AS main\_id\_96, s5\_.category\_id AS category\_id\_97, s5\_.name AS name\_98, s5\_.title AS title\_99, s5\_.position AS position\_100, s5\_.host AS host\_101, s5\_.base\_path AS base\_path\_102, s5\_.base\_url AS base\_url\_103, s5\_.hosts AS hosts\_104, s5\_.secure AS secure\_105, s5\_.always\_secure AS always\_secure\_106, s5\_.secure\_host AS secure\_host\_107, s5\_.secure\_base\_path AS secure\_base\_path\_108, s5\_.template\_id AS template\_id\_109, s5\_.`default` AS default\_110, s5\_.active AS active\_111, s5\_.customer\_scope AS customer\_scope\_112, s6\_.id AS id\_113, s6\_.locale AS locale\_114, s6\_.language AS language\_115, s6\_.territory AS territory\_116, s7\_.id AS id\_117, s7\_.name AS name\_118, s7\_.description AS description\_119, s7\_.template AS template\_120, s7\_.class AS class\_121, s7\_.`table` AS table\_122, s7\_.hide AS hide\_123, s7\_.additionaldescription AS additionaldescription\_124, s7\_.debit\_percent AS debit\_percent\_125, s7\_.surcharge AS surcharge\_126, s7\_.surchargestring AS surchargestring\_127, s7\_.position AS position\_128, s7\_.active AS active\_129, s7\_.esdactive AS esdactive\_130, s7\_.mobile\_inactive AS mobile\_inactive\_131, s7\_.embediframe AS embediframe\_132, s7\_.hideprospect AS hideprospect\_133, s7\_.action AS action\_134, s7\_.pluginID AS pluginID\_135, s7\_.source AS source\_136, s8\_.id AS id\_137, s8\_.name AS name\_138, s8\_.description AS description\_139, s8\_.position AS position\_140, s8\_.`group` AS group\_141, s8\_.mail AS mail\_142, s9\_.id AS id\_143, s9\_.name AS name\_144, s9\_.description AS description\_145, s9\_.position AS position\_146, s9\_.`group` AS group\_147, s9\_.mail AS mail\_148, s10\_.title AS title\_149, s10\_.additional\_address\_line1 AS additional\_address\_line1\_150, s10\_.additional\_address\_line2 AS additional\_address\_line2\_151, s10\_.id AS id\_152, s10\_.orderID AS orderID\_153, s10\_.userID AS userID\_154, s10\_.countryID AS countryID\_155, s10\_.stateID AS stateID\_156, s10\_.company AS company\_157, s10\_.department AS department\_158, s10\_.salutation AS salutation\_159, s10\_.customernumber AS customernumber\_160, s10\_.firstname AS firstname\_161, s10\_.lastname AS lastname\_162, s10\_.street AS street\_163, s10\_.zipcode AS zipcode\_164, s10\_.city AS city\_165, s10\_.phone AS phone\_166, s10\_.ustid AS ustid\_167, s11\_.id AS id\_168, s11\_.countryname AS countryname\_169, s11\_.countryiso AS countryiso\_170, s11\_.countryen AS countryen\_171, s11\_.position AS position\_172, s11\_.notice AS notice\_173, s11\_.taxfree AS taxfree\_174, s11\_.taxfree\_ustid AS taxfree\_ustid\_175, s11\_.taxfree\_ustid\_checked AS taxfree\_ustid\_checked\_176, s11\_.active AS active\_177, s11\_.iso3 AS iso3\_178, s11\_.display\_state\_in\_registration AS display\_state\_in\_registration\_179, s11\_.force\_state\_in\_registration AS force\_state\_in\_registration\_180, s11\_.areaID AS areaID\_181, s12\_.id AS id\_182, s12\_.countryID AS countryID\_183, s12\_.position AS position\_184, s12\_.name AS name\_185, s12\_.shortcode AS shortcode\_186, s12\_.active AS active\_187, s13\_.id AS id\_188, s13\_.main\_id AS main\_id\_189, s13\_.category\_id AS category\_id\_190, s13\_.name AS name\_191, s13\_.title AS title\_192, s13\_.position AS position\_193, s13\_.host AS host\_194, s13\_.base\_path AS base\_path\_195, s13\_.base\_url AS base\_url\_196, s13\_.hosts AS hosts\_197, s13\_.secure AS secure\_198, s13\_.always\_secure AS always\_secure\_199, s13\_.secure\_host AS secure\_host\_200, s13\_.secure\_base\_path AS secure\_base\_path\_201, s13\_.template\_id AS template\_id\_202, s13\_.`default` AS default\_203, s13\_.active AS active\_204, s13\_.customer\_scope AS customer\_scope\_205, s14\_.id AS id\_206, s14\_.name AS name\_207, s14\_.type AS type\_208, s14\_.description AS description\_209, s14\_.comment AS comment\_210, s14\_.active AS active\_211, s14\_.position AS position\_212, s14\_.calculation AS calculation\_213, s14\_.surcharge\_calculation AS surcharge\_calculation\_214, s14\_.tax\_calculation AS tax\_calculation\_215, s14\_.shippingfree AS shippingfree\_216, s14\_.multishopID AS multishopID\_217, s14\_.customergroupID AS customergroupID\_218, s14\_.bind\_shippingFree AS bind\_shippingFree\_219, s14\_.bind\_time\_from AS bind\_time\_from\_220, s14\_.bind\_time\_to AS bind\_time\_to\_221, s14\_.bind\_instock AS bind\_instock\_222, s14\_.bind\_laststock AS bind\_laststock\_223, s14\_.bind\_weekday\_from AS bind\_weekday\_from\_224, s14\_.bind\_weekday\_to AS bind\_weekday\_to\_225, s14\_.bind\_weight\_from AS bind\_weight\_from\_226, s14\_.bind\_weight\_to AS bind\_weight\_to\_227, s14\_.bind\_price\_from AS bind\_price\_from\_228, s14\_.bind\_price\_to AS bind\_price\_to\_229, s14\_.bind\_sql AS bind\_sql\_230, s14\_.status\_link AS status\_link\_231, s14\_.calculation\_sql AS calculation\_sql\_232 FROM s\_order s0\_ LEFT JOIN s\_user s1\_ ON s0\_.userID = s1\_.id LEFT JOIN s\_order\_shippingaddress s2\_ ON s0\_.id = s2\_.orderID LEFT JOIN s\_core\_countries\_states s3\_ ON s2\_.stateID = s3\_.id LEFT JOIN s\_core\_countries s4\_ ON s2\_.countryID = s4\_.id LEFT JOIN s\_core\_shops s5\_ ON s0\_.language = s5\_.id LEFT JOIN s\_core\_locales s6\_ ON s5\_.locale\_id = s6\_.id LEFT JOIN s\_core\_paymentmeans s7\_ ON s0\_.paymentID = s7\_.id LEFT JOIN s\_core\_states s8\_ ON s0\_.cleared = s8\_.id LEFT JOIN s\_core\_states s9\_ ON s0\_.status = s9\_.id LEFT JOIN s\_order\_billingaddress s10\_ ON s0\_.id = s10\_.orderID LEFT JOIN s\_core\_countries s11\_ ON s10\_.countryID = s11\_.id LEFT JOIN s\_core\_countries\_states s12\_ ON s10\_.stateID = s12\_.id LEFT JOIN s\_core\_shops s13\_ ON s0\_.subshopID = s13\_.id LEFT JOIN s\_premium\_dispatch s14\_ ON s0\_.dispatchID = s14\_.id WHERE s0\_.id IN (?, ?, ?, ?)’ with params [17, 15, 10, 8]: ---
**Author:** ![balazs](https://avatars.discourse-cdn.com/v4/letter/b/cc9497/32.png) [@balazs](https://forum.shopware.com/u/balazs)\ **Post date:** [1. November 2017 um 18:37 UTC](https://forum.shopware.com/t/was-ist-dieser-backend-bestellungen-fehler/49207/2 "2017-11-01T18:37:28Z")
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s2\_.phone’ 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/Models/Order/Repository.php(445): Doctrine\ORM\AbstractQuery-\>getArrayResult() #7 engine/Shopware/Controllers/Backend/Order.php(1104): Shopware\Models\Order\Repository-\>getList(Array) #8 engine/Shopware/Controllers/Backend/Order.php(286): Shopware\_Controllers\_Backend\_Order-\>getList(Array, Array, ‘0’, ‘20’) #9 engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Backend\_Order-\>getListAction() #10 engine/Library/Enlight/Controller/Dispatcher/Default.php(530): Enlight\_Controller\_Action-\>dispatch(‘getListAction’) #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(189): Enlight\_Controller\_Front-\>dispatch() #13 vendor/symfony/http-kernel/HttpCache/HttpCache.php(491): 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(258): 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(118): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #18 {main} ---
**Author:** ![Moritz\_Naczenski](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/moritz_naczenski/32/7792_2.png) [@Moritz\_Naczenski](https://forum.shopware.com/u/Moritz_Naczenski)\ **Post date:** [1. November 2017 um 21:25 UTC](https://forum.shopware.com/t/was-ist-dieser-backend-bestellungen-fehler/49207/3 "2017-11-01T21:25:24Z")
Welche SW-Version hast du denn? Wenn du ein Update für das Security Plugin ausstehen hast, installier das mal. ---
**Author:** ![balazs](https://avatars.discourse-cdn.com/v4/letter/b/cc9497/32.png) [@balazs](https://forum.shopware.com/u/balazs)\ **Post date:** [1. November 2017 um 21:43 UTC](https://forum.shopware.com/t/was-ist-dieser-backend-bestellungen-fehler/49207/4 "2017-11-01T21:43:06Z")
Ich habe SW 5.3.4. Habe auch das Security Plugin installiert. ---
**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. November 2017 um 21:57 UTC](https://forum.shopware.com/t/was-ist-dieser-backend-bestellungen-fehler/49207/5 "2017-11-01T21:57:58Z")
Hallo, wenn du Shopware Version 5.3.4 hast, macht doch das Security - Plugin gar keinen Sinn (mehr), da diese Version die Security-Fixes bereits enthält. Am besten deaktivierst du einmal das Security - Plugin, da es mit dieser Version ja nicht mehr nötig ist. Alternativ einfach mal einen anderen Browser testen und den kompletten Shop Cache leeren und ggf. mal den Cache-Ordner auf dem FTP entfernen. Beste Grüße Sebastian ---
**Author:** ![Moritz\_Naczenski](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/moritz_naczenski/32/7792_2.png) [@Moritz\_Naczenski](https://forum.shopware.com/u/Moritz_Naczenski)\ **Post date:** [1. November 2017 um 22:08 UTC](https://forum.shopware.com/t/was-ist-dieser-backend-bestellungen-fehler/49207/6 "2017-11-01T22:08:04Z")
Brauchst nicht deaktivieren. Die Anpassungen greifen nur, wenn die Version nicht passt. Das ist so konzipiert, dass es immer aktiv bleiben kann. Dann liegt der Fehler nicht am Plugin. Da gab es einen ähnlichen in 5.3.2 mit alter Plugin Version. Könnte aber natürlich ein anderes Plugin sein. ---
**Author:** ![balazs](https://avatars.discourse-cdn.com/v4/letter/b/cc9497/32.png) [@balazs](https://forum.shopware.com/u/balazs)\ **Post date:** [2. November 2017 um 06:16 UTC](https://forum.shopware.com/t/was-ist-dieser-backend-bestellungen-fehler/49207/7 "2017-11-02T06:16:09Z")
Danke für die Tipps, ich habe sie alle angewendet, aber der Fehler ist immer noch derselbe. ---
**Author:** ![balazs](https://avatars.discourse-cdn.com/v4/letter/b/cc9497/32.png) [@balazs](https://forum.shopware.com/u/balazs)\ **Post date:** [8. November 2017 um 15:09 UTC](https://forum.shopware.com/t/was-ist-dieser-backend-bestellungen-fehler/49207/8 "2017-11-08T15:09:44Z")
Ein Restore war die Lösung…