Unsere Subscription für das Plugin „Advanced Promotion Suite“ ist abgelaufen also haben wir dies deinstalliert und gelöscht. Nun erhalten wir die nachfolgende Fehlermeldung wenn die Bestellübersicht geöffnet wird:
Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. An exception occurred while executing ‚SELECT s0_.id AS id_0, s0_.orderID AS orderID_1, s0_.articleID AS articleID_2, s0_.taxID AS taxID_3, s0_.tax_rate AS tax_rate_4, s0_.status AS status_5, s0_.articleDetailID AS articleDetailID_6, s0_.ordernumber AS ordernumber_7, s0_.articleordernumber AS articleordernumber_8, s0_.price AS price_9, s0_.quantity AS quantity_10, s0_.name AS name_11, s0_.shipped AS shipped_12, s0_.shippedgroup AS shippedgroup_13, s0_.releasedate AS releasedate_14, s0_.modus AS modus_15, s0_.esdarticle AS esdarticle_16, s0_.config AS config_17, s0_.ean AS ean_18, s0_.unit AS unit_19, s0_.pack_unit AS pack_unit_20, s1_.id AS id_21, s1_.detailID AS detailID_22, s1_.attribute1 AS attribute1_23, s1_.attribute2 AS attribute2_24, s1_.attribute3 AS attribute3_25, s1_.attribute4 AS attribute4_26, s1_.attribute5 AS attribute5_27, s1_.attribute6 AS attribute6_28, s1_.mopt_payone_payment_status AS mopt_payone_payment_status_29, s1_.mopt_payone_shipment_date AS mopt_payone_shipment_date_30, s1_.mopt_payone_captured AS mopt_payone_captured_31, s1_.mopt_payone_debit AS mopt_payone_debit_32, s1_.swag_promotion_item_discount AS swag_promotion_item_discount_33, s1_.swag_promotion_direct_item_discount AS swag_promotion_direct_item_discount_34, s1_.swag_promotion_direct_promotions AS swag_promotion_direct_promotions_35, s1_.basket_item_id AS basket_item_id_36, s1_.mollie_transaction_id AS mollie_transaction_id_37, s1_.mollie_order_line_id AS mollie_order_line_id_38, s1_.mollie_return AS mollie_return_39 FROM s_order_details s0_ LEFT JOIN s_order_details_attributes s1_ ON s0_.id = s1_.detailID WHERE s0_.orderID IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)‘ with params [7202, 7200, 7197, 7195, 7193, 7191, 7189, 7187, 7185, 7184, 7182, 7180, 7176, 7174, 7172, 7170, 7168, 7166, 7163, 7161]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‚s1_.swag_promotion_item_discount‘ 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 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(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(732): Doctrine\ORM\AbstractQuery->execute(NULL, 2) #6 engine/Shopware/Models/Order/Repository.php(502): Doctrine\ORM\AbstractQuery->getArrayResult() #7 engine/Shopware/Controllers/Backend/Order.php(1345): Shopware\Models\Order\Repository->getDetails(Array) #8 var/cache/production_201906060858/proxies/ShopwareControllersBackendOrderProxy.php(79): Shopware_Controllers_Backend_Order->getList(Array, Array, 0, 20) #9 engine/Library/Enlight/Hook/HookExecutionContext.php(141): Shopware_Proxies_ShopwareControllersBackendOrderProxy->__executeOriginalMethod(‚getList‘, Array) #10 engine/Library/Enlight/Hook/HookExecutionContext.php(107): Enlight_Hook_HookExecutionContext->executeReplaceChain(Array) #11 engine/Library/Enlight/Hook/HookManager.php(185): Enlight_Hook_HookExecutionContext->execute() #12 var/cache/production_201906060858/proxies/ShopwareControllersBackendOrderProxy.php(102): Enlight_Hook_HookManager->executeHooks(Object(Shopware_Proxies_ShopwareControllersBackendOrderProxy), ‚getList‘, Array) #13 engine/Shopware/Controllers/Backend/Order.php(333): Shopware_Proxies_ShopwareControllersBackendOrderProxy->getList(Array, Array, 0, 20) #14 engine/Library/Enlight/Controller/Action.php(192): Shopware_Controllers_Backend_Order->getListAction() #15 engine/Library/Enlight/Controller/Dispatcher/Default.php(563): Enlight_Controller_Action->dispatch(‚getListAction‘) #16 engine/Library/Enlight/Controller/Front.php(222): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #17 engine/Shopware/Kernel.php(202): Enlight_Controller_Front->dispatch() #18 vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #19 vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true) #20 engine/Shopware/Components/HttpCache/AppCache.php(260): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #21 vendor/symfony/http-kernel/HttpCache/HttpCache.php(238): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #22 engine/Shopware/Components/HttpCache/AppCache.php(105): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #23 shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #24 {main}
Falls jemand eine Idee für einen fix hat wären wir sehr dankbar.