# Nach Deinstallation von Advanced Promotion Suit - Öffnen von Bestellungen fehlgeschlagen **URL:** \ **Category:** Shopware 5\ **Tags:** general\ **Created:** [25. April 2022 um 08:21 UTC](https://forum.shopware.com/t/nach-deinstallation-von-advanced-promotion-suit-oeffnen-von-bestellungen-fehlgeschlagen/94074 "2022-04-25T08:21:04Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![DanielKunze](https://avatars.discourse-cdn.com/v4/letter/d/aeb1de/32.png) [@DanielKunze](https://forum.shopware.com/u/DanielKunze)\ **Post date:** [25. April 2022 um 08:21 UTC](https://forum.shopware.com/t/nach-deinstallation-von-advanced-promotion-suit-oeffnen-von-bestellungen-fehlgeschlagen/94074/1 "2022-04-25T08:21:05Z")
Moin, wir hatten zu testzwecken Advanced Promotion Suit installiert, seit der Deinstallation können wir keine Bestellungen mehr öffnen… ![fehler](https://europe1.discourse-cdn.com/flex013/uploads/shopware/original/3X/b/e/bed8d0c9a5f1f38fdbd59c7ba0ffcadf340d2293.jpeg) Log Critical: 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\_.bundle\_id AS bundle\_id\_29, s1\_.bundle\_article\_ordernumber AS bundle\_article\_ordernumber\_30, s1\_.bundle\_package\_id AS bundle\_package\_id\_31, s1\_.swag\_promotion\_item\_discount AS swag\_promotion\_item\_discount\_32, s1\_.swag\_promotion\_direct\_item\_discount AS swag\_promotion\_direct\_item\_discount\_33, s1\_.swag\_promotion\_direct\_promotions AS swag\_promotion\_direct\_promotions\_34 FROM s\_order\_details s0\_ LEFT JOIN s\_order\_details\_attributes s1\_ ON s0\_.id = s1\_.detailID WHERE s0\_.orderID IN (?)‘ with params (783): SQLSTATE(42S22): Column not found: 1054 Unknown column ‚s1\_.swag\_promotion\_item\_discount‘ in ‚field list‘ Log Error: PDOException: SQLSTATE(42S22): Column not found: 1054 Unknown column ‚s1\_.swag\_promotion\_item\_discount‘ in ‚field list‘ in /vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117 Stack trace: #0 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOStatement-\>execute() #1 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1303): Doctrine\DBAL\Driver\PDOStatement-\>execute() #2 /vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(31): Doctrine\DBAL\Connection-\>executeQuery() #3 /vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(325): Doctrine\ORM\Query\Exec\SingleSelectExecutor-\>execute() #4 /vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1181): Doctrine\ORM\Query-\>\_doExecute() #5 /vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1135): Doctrine\ORM\AbstractQuery-\>executeIgnoreQueryCache() #6 /vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(883): Doctrine\ORM\AbstractQuery-\>execute() #7 /engine/Shopware/Models/Order/Repository.php(525): Doctrine\ORM\AbstractQuery-\>getArrayResult() #8 /engine/Shopware/Controllers/Backend/Order.php(1474): Shopware\Models\Order\Repository-\>getDetails() #9 /engine/Shopware/Controllers/Backend/Order.php(361): Shopware\_Controllers\_Backend\_Order-\>getList() #10 /engine/Library/Enlight/Controller/Action.php(186): Shopware\_Controllers\_Backend\_Order-\>getListAction() #11 /engine/Library/Enlight/Controller/Dispatcher/Default.php(467): Enlight\_Controller\_Action-\>dispatch() #12 /engine/Library/Enlight/Controller/Front.php(225): Enlight\_Controller\_Dispatcher\_Default-\>dispatch() #13 /engine/Shopware/Kernel.php(197): Enlight\_Controller\_Front-\>dispatch() #14 /vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(85): Shopware\Kernel-\>handle() #15 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle() #16 /engine/Shopware/Components/HttpCache/AppCache.php(266): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward() #17 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(269): Shopware\Components\HttpCache\AppCache-\>forward() #18 /engine/Shopware/Components/HttpCache/AppCache.php(106): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass() #19 /home/_ **/www.** _\*\*.de/shopware.php(122): Shopware\Components\HttpCache\AppCache-\>handle() #20 Juhu und das an einem Montag 😪 ---
**Author:** ![SmartStylez](https://avatars.discourse-cdn.com/v4/letter/s/a88e4f/32.png) [@SmartStylez](https://forum.shopware.com/u/SmartStylez)\ **Post date:** [25. April 2022 um 08:30 UTC](https://forum.shopware.com/t/nach-deinstallation-von-advanced-promotion-suit-oeffnen-von-bestellungen-fehlgeschlagen/94074/2 "2022-04-25T08:30:17Z")
Der Eintrag „s1\_.swag\_promotion\_item\_discount" scheint noch in der Tabelle der Datenbank vorhanden zu sein und zu Verwirrung zu führen. ---
**Author:** ![DanielKunze](https://avatars.discourse-cdn.com/v4/letter/d/aeb1de/32.png) [@DanielKunze](https://forum.shopware.com/u/DanielKunze)\ **Post date:** [25. April 2022 um 08:52 UTC](https://forum.shopware.com/t/nach-deinstallation-von-advanced-promotion-suit-oeffnen-von-bestellungen-fehlgeschlagen/94074/3 "2022-04-25T08:52:15Z")
> [@DanielKunze](#): > > s1\_.swag\_promotion\_item\_discount Danke für die schnelle Antwort, finde ich den Eintrag in der MySQL ? ---
**Author:** ![SmartStylez](https://avatars.discourse-cdn.com/v4/letter/s/a88e4f/32.png) [@SmartStylez](https://forum.shopware.com/u/SmartStylez)\ **Post date:** [25. April 2022 um 09:02 UTC](https://forum.shopware.com/t/nach-deinstallation-von-advanced-promotion-suit-oeffnen-von-bestellungen-fehlgeschlagen/94074/4 "2022-04-25T09:02:17Z")
Schau’ mal in der Tabelle s\_order\_details bzw. s\_order\_details\_attributes. ---
**Author:** ![DanielKunze](https://avatars.discourse-cdn.com/v4/letter/d/aeb1de/32.png) [@DanielKunze](https://forum.shopware.com/u/DanielKunze)\ **Post date:** [25. April 2022 um 09:32 UTC](https://forum.shopware.com/t/nach-deinstallation-von-advanced-promotion-suit-oeffnen-von-bestellungen-fehlgeschlagen/94074/5 "2022-04-25T09:32:53Z")
FML… sorry für den Ausdruck, aber junge junge, das ganze hat mich jetzt 2 Stunden gekostet. Da ich wohl nicht der einzige mit dem Problem bin, hier zur Lösung: @SmartStylez wie du gesagt hattest, war noch ein Artikel tatsächlich mit irgendeiner Prom Bezeichnung, diesen habe ich kurzerhand einfach gelöscht, und zusätzlich in der MySQL den Eintrag mit „PROM“ gelöscht. Danach war das Problem allerdings nicht gelöst, ich musste zusätzlich unter Freitext-Verwaltung die Tabellen s\_oder\_details\_attributes - Model genieren „drücken“ und die Tabelle s\_order\_attributes - Model genieren. Danach waren alle Bestellungen wieder da.