503 Service Unavailable bei Kunden-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_.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

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.

Der Fehler kommt von Payever, funktioniert es denn ohne das Plugin?

@Moritz Naczenski schrieb:

Der Fehler kommt von Payever, funktioniert es denn ohne das Plugin?

 

Dieses Plugin ist bei mir unter dem Plugin Manager als deinstalliert markiert. 

Hat keiner einer Idee was ich da machen kann ?

Vielleicht hift ein Entfernen oder eine Neuinstallation.

Das Payever Plugin ist deinstalliert. Leider besteht der Fehler weiterhin. Soll ich es nochmal neu Installieren ?

Den Cache mal komplett auf dem Server geleert?

Also /var/cache/production_ umbenannt?

@Moritz Naczenski schrieb:

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. 

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.