Was ist dieser Backend-Bestellungen Fehler?

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]:

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}

Welche SW-Version hast du denn?

Wenn du ein Update für das Security Plugin ausstehen hast, installier das mal.

Ich habe SW 5.3.4. Habe auch das Security Plugin installiert.

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

1 Like

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.

Danke für die Tipps, ich habe sie alle angewendet, aber der Fehler ist immer noch derselbe.

Ein Restore war die Lösung…