# 503 Service Unavailable bei Kunden-Bestellungen **URL:** \ **Category:** Administration\ **Created:** [3. November 2016 um 12:52 UTC](https://forum.shopware.com/t/503-service-unavailable-bei-kunden-bestellungen/41061 "2016-11-03T12:52:56Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![dsterworth](https://avatars.discourse-cdn.com/v4/letter/d/b2d939/32.png) [@dsterworth](https://forum.shopware.com/u/dsterworth)\ **Post date:** [3. November 2016 um 12:52 UTC](https://forum.shopware.com/t/503-service-unavailable-bei-kunden-bestellungen/41061/1 "2016-11-03T12:52:56Z")
``` 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_.id AS id_29, s1_.name AS name_30, s1_.description AS description_31, s1_.template AS template_32, s1_.class AS class_33, s1_.`table` AS table_34, s1_.hide AS hide_35, s1_.additionaldescription AS additionaldescription_36, s1_.debit_percent AS debit_percent_37, s1_.surcharge AS surcharge_38, s1_.surchargestring AS surchargestring_39, s1_.position AS position_40, s1_.active AS active_41, s1_.esdactive AS esdactive_42, s1_.mobile_inactive AS mobile_inactive_43, s1_.embediframe AS embediframe_44, s1_.hideprospect AS hideprospect_45, s1_.action AS action_46, s1_.pluginID AS pluginID_47, s1_.source AS source_48, s2_.id AS id_49, s2_.name AS name_50, s2_.description AS description_51, s2_.position AS position_52, s2_.`group` AS group_53, s2_.mail AS mail_54, s3_.id AS id_55, s3_.name AS name_56, s3_.description AS description_57, s3_.position AS position_58, s3_.`group` AS group_59, s3_.mail AS mail_60, s4_.id AS id_61, s4_.orderID AS orderID_62, s4_.userID AS userID_63, s4_.countryID AS countryID_64, s4_.stateID AS stateID_65, s4_.company AS company_66, s4_.department AS department_67, s4_.salutation AS salutation_68, s4_.customernumber AS customernumber_69, s4_.firstname AS firstname_70, s4_.lastname AS lastname_71, s4_.street AS street_72, s4_.zipcode AS zipcode_73, s4_.city AS city_74, s4_.phone AS phone_75, s4_.fax AS fax_76, s4_.ustid AS ustid_77, s4_.additional_address_line1 AS additional_address_line1_78, s4_.additional_address_line2 AS additional_address_line2_79, s5_.id AS id_80, s5_.paymentID AS paymentID_81, s5_.customergroup AS customergroup_82, s5_.subshopID AS subshopID_83, s5_.pricegroupID AS pricegroupID_84, s5_.encoder AS encoder_85, s5_.password AS password_86, s5_.active AS active_87, s5_.email AS email_88, s5_.firstlogin AS firstlogin_89, s5_.lastlogin AS lastlogin_90, s5_.accountmode AS accountmode_91, s5_.confirmationkey AS confirmationkey_92, s5_.sessionID AS sessionID_93, s5_.newsletter AS newsletter_94, s5_.validation AS validation_95, s5_.affiliate AS affiliate_96, s5_.paymentpreset AS paymentpreset_97, s5_.language AS language_98, s5_.referer AS referer_99, s5_.internalcomment AS internalcomment_100, s5_.failedlogins AS failedlogins_101, s5_.lockedUntil AS lockedUntil_102, s6_.id AS id_103, s6_.orderID AS orderID_104, s6_.articleID AS articleID_105, s6_.taxID AS taxID_106, s6_.tax_rate AS tax_rate_107, s6_.status AS status_108, s6_.ordernumber AS ordernumber_109, s6_.articleordernumber AS articleordernumber_110, s6_.price AS price_111, s6_.quantity AS quantity_112, s6_.name AS name_113, s6_.shipped AS shipped_114, s6_.shippedgroup AS shippedgroup_115, s6_.releasedate AS releasedate_116, s6_.modus AS modus_117, s6_.esdarticle AS esdarticle_118, s6_.config AS config_119, s6_.ean AS ean_120, s6_.unit AS unit_121, s6_.pack_unit AS pack_unit_122, s7_.id AS id_123, s7_.countryname AS countryname_124, s7_.countryiso AS countryiso_125, s7_.countryen AS countryen_126, s7_.position AS position_127, s7_.notice AS notice_128, s7_.shippingfree AS shippingfree_129, s7_.taxfree AS taxfree_130, s7_.taxfree_ustid AS taxfree_ustid_131, s7_.taxfree_ustid_checked AS taxfree_ustid_checked_132, s7_.active AS active_133, s7_.iso3 AS iso3_134, s7_.display_state_in_registration AS display_state_in_registration_135, s7_.force_state_in_registration AS force_state_in_registration_136, s7_.areaID AS areaID_137, s8_.id AS id_138, s8_.countryID AS countryID_139, s8_.position AS position_140, s8_.name AS name_141, s8_.shortcode AS shortcode_142, s8_.active AS active_143, s9_.id AS id_144, s9_.main_id AS main_id_145, s9_.category_id AS category_id_146, s9_.name AS name_147, s9_.title AS title_148, s9_.position AS position_149, s9_.host AS host_150, s9_.base_path AS base_path_151, s9_.base_url AS base_url_152, s9_.hosts AS hosts_153, s9_.secure AS secure_154, s9_.always_secure AS always_secure_155, s9_.secure_host AS secure_host_156, s9_.secure_base_path AS secure_base_path_157, s9_.template_id AS template_id_158, s9_.`default` AS default_159, s9_.active AS active_160, s9_.customer_scope AS customer_scope_161, s10_.id AS id_162, s10_.name AS name_163, s10_.type AS type_164, s10_.description AS description_165, s10_.comment AS comment_166, s10_.active AS active_167, s10_.position AS position_168, s10_.calculation AS calculation_169, s10_.surcharge_calculation AS surcharge_calculation_170, s10_.tax_calculation AS tax_calculation_171, s10_.shippingfree AS shippingfree_172, s10_.multishopID AS multishopID_173, s10_.customergroupID AS customergroupID_174, s10_.bind_shippingFree AS bind_shippingFree_175, s10_.bind_time_from AS bind_time_from_176, s10_.bind_time_to AS bind_time_to_177, s10_.bind_instock AS bind_instock_178, s10_.bind_laststock AS bind_laststock_179, s10_.bind_weekday_from AS bind_weekday_from_180, s10_.bind_weekday_to AS bind_weekday_to_181, s10_.bind_weight_from AS bind_weight_from_182, s10_.bind_weight_to AS bind_weight_to_183, s10_.bind_price_from AS bind_price_from_184, s10_.bind_price_to AS bind_price_to_185, s10_.bind_sql AS bind_sql_186, s10_.status_link AS status_link_187, ``` Shopware Version 5.1.1 ---
**Author:** ![dsterworth](https://avatars.discourse-cdn.com/v4/letter/d/b2d939/32.png) [@dsterworth](https://forum.shopware.com/u/dsterworth)\ **Post date:** [3. November 2016 um 12:54 UTC](https://forum.shopware.com/t/503-service-unavailable-bei-kunden-bestellungen/41061/2 "2016-11-03T12:54:21Z")
``` s10_.calculation_sql AS calculation_sql_188, s11_.id AS id_189, s11_.billingID AS billingID_190, s11_.text1 AS text1_191, s11_.text2 AS text2_192, s11_.text3 AS text3_193, s11_.text4 AS text4_194, s11_.text5 AS text5_195, s11_.text6 AS text6_196, s12_.id AS id_197, s12_.orderID AS orderID_198, s12_.attribute1 AS attribute1_199, s12_.attribute2 AS attribute2_200, s12_.attribute3 AS attribute3_201, s12_.attribute4 AS attribute4_202, s12_.attribute5 AS attribute5_203, s12_.attribute6 AS attribute6_204, s12_.swag_payal_billing_agreement_id AS swag_payal_billing_agreement_id_205, s12_.swag_payal_express AS swag_payal_express_206, s12_.payever_payment_details AS payever_payment_details_207 FROM s_order s0_ LEFT JOIN s_core_paymentmeans s1_ ON s0_.paymentID = s1_.id LEFT JOIN s_core_states s2_ ON s0_.cleared = s2_.id LEFT JOIN s_core_states s3_ ON s0_.status = s3_.id LEFT JOIN s_order_billingaddress s4_ ON s0_.id = s4_.orderID LEFT JOIN s_user s5_ ON s0_.userID = s5_.id LEFT JOIN s_order_details s6_ ON s0_.id = s6_.orderID LEFT JOIN s_core_countries s7_ ON s4_.countryID = s7_.id LEFT JOIN s_core_countries_states s8_ ON s4_.stateID = s8_.id LEFT JOIN s_core_shops s9_ ON s0_.subshopID = s9_.id LEFT JOIN s_premium_dispatch s10_ ON s0_.dispatchID = s10_.id LEFT JOIN s_order_billingaddress_attributes s11_ ON s4_.id = s11_.billingID LEFT JOIN s_order_attributes s12_ ON s0_.id = s12_.orderID WHERE s0_.status NOT IN ('-1') AND s0_.ordernumber IS NOT NULL AND s0_.id IN (?, ?) ORDER BY s0_.ordertime DESC' with params ["4", "2"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 's12_.payever_payment_details' 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(727): Doctrine\ORM\AbstractQuery->execute(NULL, 2) #6 vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(165): Doctrine\ORM\AbstractQuery->getResult(2) #7 Shopware/Controllers/Backend/Order.php(343): Doctrine\ORM\Tools\Pagination\Paginator->getIterator() #8 Shopware/Controllers/Backend/Order.php(313): Shopware_Controllers_Backend_Order->getList(NULL, NULL, '0', '20') #9 Enlight/Controller/Action.php(158): Shopware_Controllers_Backend_Order->getListAction() #10 Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch('getListAction') #11 Enlight/Controller/Front.php(227): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #12 Shopware/Kernel.php(148): Enlight_Controller_Front->dispatch() #13 vendor/symfony/http-kernel/HttpCache/HttpCache.php(492): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #14 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(263): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #16 Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #17 shopware.php(101): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #18 {main} OK ``` Diesen Fehler bekomme ich wenn ich auf Kunden-Beltellungen klicke. ---
**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:** [3. November 2016 um 12:55 UTC](https://forum.shopware.com/t/503-service-unavailable-bei-kunden-bestellungen/41061/3 "2016-11-03T12:55:34Z")
Der Fehler kommt von Payever, funktioniert es denn ohne das Plugin? ---
**Author:** ![dsterworth](https://avatars.discourse-cdn.com/v4/letter/d/b2d939/32.png) [@dsterworth](https://forum.shopware.com/u/dsterworth)\ **Post date:** [3. November 2016 um 12:57 UTC](https://forum.shopware.com/t/503-service-unavailable-bei-kunden-bestellungen/41061/4 "2016-11-03T12:57:26Z")
> [@Moritz Naczenski schrieb:](https://forum.shopware.com/profile/14574/Moritz%20Naczenski "Moritz%20Naczenski") > > Der Fehler kommt von Payever, funktioniert es denn ohne das Plugin? > >   > > Dieses Plugin ist bei mir unter dem Plugin Manager als deinstalliert markiert.  ---
**Author:** ![dsterworth](https://avatars.discourse-cdn.com/v4/letter/d/b2d939/32.png) [@dsterworth](https://forum.shopware.com/u/dsterworth)\ **Post date:** [4. November 2016 um 11:04 UTC](https://forum.shopware.com/t/503-service-unavailable-bei-kunden-bestellungen/41061/5 "2016-11-04T11:04:08Z")
Hat keiner einer Idee was ich da machen kann ? ---
**Author:** ![NextMike](https://avatars.discourse-cdn.com/v4/letter/n/838e76/32.png) [@NextMike](https://forum.shopware.com/u/NextMike)\ **Post date:** [4. November 2016 um 11:13 UTC](https://forum.shopware.com/t/503-service-unavailable-bei-kunden-bestellungen/41061/6 "2016-11-04T11:13:20Z")
Vielleicht hift ein Entfernen oder eine Neuinstallation. ---
**Author:** ![dsterworth](https://avatars.discourse-cdn.com/v4/letter/d/b2d939/32.png) [@dsterworth](https://forum.shopware.com/u/dsterworth)\ **Post date:** [4. November 2016 um 11:31 UTC](https://forum.shopware.com/t/503-service-unavailable-bei-kunden-bestellungen/41061/7 "2016-11-04T11:31:05Z")
Das Payever Plugin ist deinstalliert. Leider besteht der Fehler weiterhin. Soll ich es nochmal neu Installieren ? ---
**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:** [4. November 2016 um 12:34 UTC](https://forum.shopware.com/t/503-service-unavailable-bei-kunden-bestellungen/41061/8 "2016-11-04T12:34:58Z")
Den Cache mal komplett auf dem Server geleert? Also /var/cache/production\_ umbenannt? ---
**Author:** ![dsterworth](https://avatars.discourse-cdn.com/v4/letter/d/b2d939/32.png) [@dsterworth](https://forum.shopware.com/u/dsterworth)\ **Post date:** [7. November 2016 um 10:18 UTC](https://forum.shopware.com/t/503-service-unavailable-bei-kunden-bestellungen/41061/9 "2016-11-07T10:18:27Z")
> [@Moritz Naczenski schrieb:](https://forum.shopware.com/profile/14574/Moritz%20Naczenski "Moritz%20Naczenski") > > Den Cache mal komplett auf dem Server geleert? > > Also /var/cache/production\_ umbenannt? > >   > > Hallo, > > Ich habe den Cache geleert hat leider nichts gebracht.  > > Ich habe das Original PayPal Plugin deinstalliert und den Cache erneut gelöscht danach habe ich das PayPal Plugin erneut installiert.  > > Jetzt funktioniert es Fehlerfrei. Ich kann es mir nicht erklären wieso das so ist.  ---
**Author:** ![Plastikprint](https://avatars.discourse-cdn.com/v4/letter/p/53a042/32.png) [@Plastikprint](https://forum.shopware.com/u/Plastikprint)\ **Post date:** [6. April 2017 um 15:57 UTC](https://forum.shopware.com/t/503-service-unavailable-bei-kunden-bestellungen/41061/10 "2017-04-06T15:57:15Z")
``` 503 - Service Unacailable Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php on line 781 Stack trace: #0 engine/Shopware/Controllers/Backend/Order.php(401): Doctrine\ORM\AbstractQuery->getOneOrNullResult(2) #1 engine/Shopware/Controllers/Backend/Order.php(370): Shopware_Controllers_Backend_Order->getList(NULL, Array, '0', '20') #2 var/cache/production_201703211201/proxies/ShopwareControllersBackendOrderProxy.php(6): Shopware_Controllers_Backend_Order->getListAction() #3 engine/Library/Enlight/Hook/HookManager.php(186): Shopware_Proxies_ShopwareControllersBackendOrderProxy->executeParent('getListAction', Array) #4 var/cache/production_201703211201/proxies/ShopwareControllersBackendOrderProxy.php(17): Enlight_Hook_HookManager->executeHooks(Object(Shopware_Proxies_ShopwareControllersBackendOrderProxy), 'getListAction', Object(Enlight_Hook_HookArgs)) #5 engine/Library/Enlight/Controller/Action.php(159): Shopware_Proxies_ShopwareControllersBackendOrderProxy->getListAction() #6 engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch('getListAction') #7 engine/Library/Enlight/Controller/Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #8 engine/Shopware/Kernel.php(180): Enlight_Controller_Front->dispatch() #9 vendor/symfony/http-kernel/HttpCache/HttpCache.php(491): Shopware\Kernel->handle(Object(Enlight_Controller_Request_RequestHttp), 1, true) #10 engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #11 vendor/symfony/http-kernel/HttpCache/HttpCache.php(258): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #12 engine/Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #13 shopware.php(117): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #14 {main} ``` also ich hab leider ein ähnliches Problem. auch o.g. Maßnahme bringt keine besserung… meine Fehlermedlung sieht aber etwas anders aus: Taucht immer auf, wenn ich Kunden-\>Bestellungen öffne. Auch beim Versuch, die bestellungen zu filtern kommt der Fehler.