Hallo Leute,
seit gestern habe ich diese Meldung wenn ich eine Backendbestellung ausführen möchte.
Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. An exception occurred while executing ‚SELECT (CASE WHEN (s0_.default_billing_address_id = s1_.id) THEN 1 ELSE 0 END) AS sclr_0, (CASE WHEN (s0_.default_shipping_address_id = s1_.id) THEN 1 ELSE 0 END) AS sclr_1, s1_.id AS id_2, s1_.company AS company_3, s1_.department AS department_4, s1_.salutation AS salutation_5, s1_.firstname AS firstname_6, s1_.title AS title_7, s1_.lastname AS lastname_8, s1_.street AS street_9, s1_.zipcode AS zipcode_10, s1_.city AS city_11, s1_.phone AS phone_12, s1_.ustid AS ustid_13, s1_.additional_address_line1 AS additional_address_line1_14, s1_.additional_address_line2 AS additional_address_line2_15, s1_.country_id AS country_id_16, s1_.state_id AS state_id_17, s2_.id AS id_18, s2_.countryname AS countryname_19, s2_.countryiso AS countryiso_20, s2_.countryen AS countryen_21, s2_.position AS position_22, s2_.notice AS notice_23, s2_.taxfree AS taxfree_24, s2_.taxfree_ustid AS taxfree_ustid_25, s2_.taxfree_ustid_checked AS taxfree_ustid_checked_26, s2_.active AS active_27, s2_.iso3 AS iso3_28, s2_.display_state_in_registration AS display_state_in_registration_29, s2_.force_state_in_registration AS force_state_in_registration_30, s2_.areaID AS areaID_31, s3_.id AS id_32, s3_.countryID AS countryID_33, s3_.position AS position_34, s3_.name AS name_35, s3_.shortcode AS shortcode_36, s3_.active AS active_37, s4_.id AS id_38, s4_.address_id AS address_id_39, s4_.text1 AS text1_40, s4_.text2 AS text2_41, s4_.text3 AS text3_42, s4_.text4 AS text4_43, s4_.text5 AS text5_44, s4_.text6 AS text6_45, s4_.bestit_amazon_hash AS bestit_amazon_hash_46, s4_.bestit_amazon_sw_hash AS bestit_amazon_sw_hash_47, s4_.bestit_amazon_type AS bestit_amazon_type_48 FROM s_user_addresses s1_ LEFT JOIN s_core_countries s2_ ON s1_.country_id = s2_.id LEFT JOIN s_core_countries_states s3_ ON s1_.state_id = s3_.id LEFT JOIN s_user_addresses_attributes s4_ ON s1_.id = s4_.address_id INNER JOIN s_user s0_ ON s1_.user_id = s0_.id WHERE s1_.user_id = ? ORDER BY sclr_0 DESC, sclr_1 DESC‘ with params [107]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‚s4_.bestit_amazon_hash‘ in ‚field list‘ in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 131 Stack trace: #0 vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(855): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), ‚SELECT (CASE WH…‘, Array) #1 vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection->executeQuery(‚SELECT (CASE WH…‘, 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(962): Doctrine\ORM\Query->_doExecute() #4 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(917): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 2) #5 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(720): Doctrine\ORM\AbstractQuery->execute(NULL, 2) #6 engine/Shopware/Models/Customer/AddressRepository.php(46): Doctrine\ORM\AbstractQuery->getResult(2) #7 custom/plugins/SwagBackendOrder/Components/CustomerRepository.php(55): Shopware\Models\Customer\AddressRepository->getListArray(107) #8 custom/plugins/SwagBackendOrder/Controllers/Backend/SwagBackendOrder.php(69): SwagBackendOrder\Components\CustomerRepository->get(107) #9 engine/Library/Enlight/Controller/Action.php(193): Shopware_Controllers_Backend_SwagBackendOrder->getCustomerAction() #10 engine/Library/Enlight/Controller/Dispatcher/Default.php(549): Enlight_Controller_Action->dispatch(‚getCustomerActi…‘) #11 engine/Library/Enlight/Controller/Front.php(222): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #12 engine/Shopware/Kernel.php(215): Enlight_Controller_Front->dispatch() #13 vendor/symfony/http-kernel/HttpCache/HttpCache.php(486): 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(253): 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(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #18 {main}
OK
liegt dort ein Fehler auf der DB vor ?
Vielleicht kann mir da wer helfen.
Gruss Arne