# Deinstallation von "Advanced Promotion Suite" führt zu Fehlermeldung. Shop nicht mehr nutzbar. **URL:** \ **Category:** Plugins\ **Created:** [26. Januar 2021 um 14:14 UTC](https://forum.shopware.com/t/deinstallation-von-advanced-promotion-suite-fuhrt-zu-fehlermeldung-shop-nicht-mehr-nutzbar/72342 "2021-01-26T14:14:03Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![philippsteinhaeuser](https://avatars.discourse-cdn.com/v4/letter/p/ec9cab/32.png) [@philippsteinhaeuser](https://forum.shopware.com/u/philippsteinhaeuser)\ **Post date:** [26. Januar 2021 um 14:14 UTC](https://forum.shopware.com/t/deinstallation-von-advanced-promotion-suite-fuhrt-zu-fehlermeldung-shop-nicht-mehr-nutzbar/72342/1 "2021-01-26T14:14:03Z")
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. ---
**Author:** ![Moritz\_Naczenski](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/moritz_naczenski/32/7792_2.png) [@Moritz\_Naczenski](https://forum.shopware.com/u/Moritz_Naczenski)\ **Post date:** [26. Januar 2021 um 14:27 UTC](https://forum.shopware.com/t/deinstallation-von-advanced-promotion-suite-fuhrt-zu-fehlermeldung-shop-nicht-mehr-nutzbar/72342/2 "2021-01-26T14:27:00Z")
Cache auf dem Server komplett löschen unter var/cache