Hallo,
seit gestern Abend wirft das Bestellungen Modul nur noch einen 503 aus und zeigt keine Bestellungen mehr an.
Folgende Fehlermeldung :
Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen.ping AS allow_shipping_103, s4_.areaID AS areaID_104, s5_.id AS id_105, s5_.main_id AS main_id_106, s5_.category_id AS category_id_107, s5_.name AS name_108, s5_.title AS title_109, s5_.position AS position_110, s5_.host AS host_111, s5_.base_path AS base_path_112, s5_.base_url […]lockedUntil_56, s1_.salutation AS salutation_57, s1_.title AS title_58, s1_.firstname AS firstname_59, s1_.lastname AS lastname_60, s1_.birthday AS birthday_61, s1_.doubleOptinRegister AS doubleOptinRegister_62, s1_.doubleOptinEmailSentDate AS doubleOptinEmailSentDate_63, s1_.doubleOptinConfirmDate AS doubleOptinConfirmDate_64, s1_.password_change_date AS password_change_date_65, s1_.register_opt_in_id AS register_opt_in_id_66, s2_.title AS title_67, s2_.additional_address_line1 AS additional_address_line1_68, s2_.additional_address_line2 AS additional_address_line2_69, s2_.id AS id_70, s2_.orderID AS orderID_71, s2_.countryID AS countryID_72, s2_.stateID AS stateID_73, s2_.userID AS userID_74, s2_.company AS company_75, s2_.department AS department_76, s2_.salutation AS salutation_77, s2_.firstname AS firstname_78, s2_.lastname AS lastname_79, s2_.street AS street_80, s2_.zipcode AS zipcode_81, s2_.city AS city_82, s2_.phone AS phone_83, s3_.id AS id_84, s3_.countryID AS countryID_85, s3_.position AS position_86, s3_.name AS name_87, s3_.shortcode AS shortcode_88, s3_.active AS active_89, s4_.id AS id_90, s4_.countryname AS countryname_91, s4_.countryiso AS countryiso_92, s4_.countryen AS countryen_93, s4_.position AS position_94, s4_.notice AS notice_95, s4_.taxfree AS taxfree_96, s4_.taxfree_ustid AS taxfree_ustid_97, s4_.taxfree_ustid_checked AS taxfree_ustid_checked_98, s4_.active AS active_99, s4_.iso3 AS iso3_100, s4_.display_state_in_registration AS display_state_in_registration_101, s4_.force_state_in_registration AS force_state_in_registration_102, s4_.allow_ship s10_.zipcode AS zipcode_169, s10_.city AS city_170, s10_.phone AS phone_171, s10_.ustid AS ustid_172, s11_.id AS id_173, s11_.countryname AS countryname_174, s11_.countryiso AS countryiso_175, s11_.countryen AS countryen_176, s11_.position AS position_177, s11_.notice AS notice_178, s11_.taxfree AS taxfree_179, s11_.taxfree_ustid AS taxfree_ustid_180, s11_.taxfree_ustid_checked AS taxfree_ustid_checked_181, s11_.active AS active_182, s11_.iso3 AS iso3_183, s11_.display_state_in_registration AS display_state_in_registration_184, s11_.force_state_in_registration AS force_state_in_registration_185, s11_.allow_shipping AS allow_shipping_186, s11_.areaID AS areaID_187, s12_.id AS id_188, s12_.countryID AS countryID_189, s12_.position AS position_190, s12_.name AS name_191, s12_.shortcode AS shortcode_192, s12_.active AS active_193, s13_.id AS id_194, s13_.main_id AS main_id_195, s13_.category_id AS category_id_196, s13_.name AS name_197, s13_.title AS title_198, s13_.position AS position_199, s13_.host AS host_200, s13_.base_path AS base_path_201, s13_.base_url AS base_url_202, s13_.hosts AS hosts_203, s13_.secure AS secure_204, s13_.template_id AS template_id_205, s13_.
default
AS default_206, s13_.active AS active_207, s13_.customer_scope AS customer_scope_208, s14_.id AS id_209, s14_.name AS name_210, s14_.type AS type_211, s14_.description AS description_212, s14_.comment AS comment_213, s14_.active AS active_214, s14_.position AS position_215, s14_.calculation AS calculation_216, s14_.surcharge_calculation AS surcharge_calculation_217, s14_.tax_calculation AS tax_calculation_218, s14_.shippingfree AS shippingfree_219, s14_.multishopID AS multishopID_220, s14_.customergroupID AS customergroupID_221, s14_.bind_shippingFree AS bind_shippingFree_222, s14_.bind_time_from AS bind_time_from_223, s14_.bind_time_to AS bind_time_to_224, s14_.bind_instock AS bind_instock_225, s14_.bind_laststock AS bind_laststock_226, s14_.bind_weekday_from AS bind_weekday_from_227, s14_.bind_weekday_to AS bind_weekday_to_228, s14_.bind_weight_from AS bind_weight_from_229, s14_.bind_weight_to AS bind_weight_to_230, s14_.bind_price_from AS bind_price_from_231, s14_.bind_price_to AS bind_price_to_232, s14_.bind_sql AS bind_sql_233, s14_.status_link AS status_link_234, s14_.calculation_sql AS calculation_sql_235 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 [131, 129, 127, 125, 123, 121, 109]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‚s1_.password_change_date‘ in ‚field list‘ in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 179 Stack trace: #0 vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(150): Doctrine\DBAL\DBALException::wrapException(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), ‚An exception oc…‘) #1 vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(915): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), ‚SELECT s0_.id A…‘, Array) #2 vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection->executeQuery(‚SELECT s0_.id A…‘, Array, Array, NULL) #3 vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(334): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array) #4 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(967): Doctrine\ORM\Query->_doExecute() #5 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(922): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 2) #6 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(738): Doctrine\ORM\AbstractQuery->execute(NULL, 2) #7 engine/Shopware/Models/Order/Repository.php(405): Doctrine\ORM\AbstractQuery->getArrayResult() #8 engine/Shopware/Controllers/Backend/Order.php(1389): Shopware\Models\Order\Repository->getList(Array) #9 engine/Shopware/Controllers/Backend/Order.php(335): Shopware_Controllers_Backend_Order->getList(Array, Array, 0, 20) #10 engine/Library/Enlight/Controller/Action.php(192): Shopware_Controllers_Backend_Order->getListAction() #11 engine/Library/Enlight/Controller/Dispatcher/Default.php(478): Enlight_Controller_Action->dispatch(‚getListAction‘) #12 engine/Library/Enlight/Controller/Front.php(228): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #13 engine/Shopware/Kernel.php(185): Enlight_Controller_Front->dispatch() #14 vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #15 vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true) #16 engine/Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #17 vendor/symfony/http-kernel/HttpCache/HttpCache.php(238): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #18 engine/Shopware/Components/HttpCache/AppCache.php(99): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #19 shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #20 {main}
Anscheinden Fehlt die Column ‚s1_.password_change_date‘. Aber bevor ich die jetzt einfach wieder da rein klatsche, zumal ich so spontan auch nicht im Kopft hätte wo die hingehört, wollte ich zumindest mal fragen, ob jemand mit der Fehlermeldung was anfangen kann.
Mit besten Grüßen
Florian.