Nach Deinstallation von Advanced Promotion Suit - Öffnen von Bestellungen fehlgeschlagen

Moin,

wir hatten zu testzwecken Advanced Promotion Suit installiert, seit der Deinstallation können wir keine Bestellungen mehr öffnen…

fehler

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 :sleepy:

Der Eintrag „s1_.swag_promotion_item_discount" scheint noch in der Tabelle der Datenbank vorhanden zu sein und zu Verwirrung zu führen.

Danke für die schnelle Antwort, finde ich den Eintrag in der MySQL ?

Schau’ mal in der Tabelle s_order_details bzw. s_order_details_attributes.

1 „Gefällt mir“

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.