Hallo zusammen, ich bin noch recht neu bei Shopware und habe seit vorhin eine Fehlermeldung wenn ich Bestellungen einsehen möchte.
Leider kann ich damit nichts anfangen und weiß auch nicht wo ich suchen könnte. Hat jemand eine Idee dazu?
LG Andi
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_.swag_promotion_item_discount AS swag_promotion_item_discount_29, s1_.swag_promotion_direct_item_discount AS swag_promotion_direct_item_discount_30, s1_.swag_promotion_direct_promotions AS swag_promotion_direct_promotions_31, s1_.coe_used_voucher AS coe_used_voucher_32 FROM s_order_details s0_ LEFT JOIN s_order_details_attributes s1_ ON s0_.id = s1_.detailID WHERE s0_.orderID IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)‘ with params [90, 88, 86, 83, 81, 75, 70, 68, 54, 52, 49, 47, 44, 41, 38, 35, 30, 28, 25, 18]: 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 179 Stack trace: #0 vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(150): Doctrine\DBAL\DBALException::wrapException() #1 vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(915): Doctrine\DBAL\DBALException::driverExceptionDuringQuery() #2 vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection->executeQuery() #3 vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(337): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute() #4 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(968): Doctrine\ORM\Query->_doExecute() #5 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(923): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache() #6 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(738): Doctrine\ORM\AbstractQuery->execute() #7 engine/Shopware/Models/Order/Repository.php(508): Doctrine\ORM\AbstractQuery->getArrayResult() #8 engine/Shopware/Controllers/Backend/Order.php(1380): Shopware\Models\Order\Repository->getDetails() #9 engine/Shopware/Controllers/Backend/Order.php(335): Shopware_Controllers_Backend_Order->getList() #10 engine/Library/Enlight/Controller/Action.php(192): Shopware_Controllers_Backend_Order->getListAction() #11 engine/Library/Enlight/Controller/Dispatcher/Default.php(478): Enlight_Controller_Action->dispatch() #12 engine/Library/Enlight/Controller/Front.php(228): Enlight_Controller_Dispatcher_Default->dispatch() #13 engine/Shopware/Kernel.php(188): Enlight_Controller_Front->dispatch() #14 vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle() #15 vendor/symfony/http-kernel/HttpCache/HttpCache.php(453): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle() #16 engine/Shopware/Components/HttpCache/AppCache.php(261): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward() #17 vendor/symfony/http-kernel/HttpCache/HttpCache.php(238): Shopware\Components\HttpCache\AppCache->forward() #18 engine/Shopware/Components/HttpCache/AppCache.php(102): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass() #19 shopware.php(122): Shopware\Components\HttpCache\AppCache->handle() #20 {main}