Hallo vor kurzem migrierten wir unseren Oxid-Shop in Shopware. Hier waren alle Statistiken, Kundendaten und Bestellungen funktionstüchtig und vorhanden. Nachdem der Shop nun nahezu eingerichtet ist und zwischenzeitlich auch auf die aktuelle Version 4.2.2 upgedatet wurde, ist aufgefallen, dass wir die Bestellungen nicht mehr einsehen können. Stattdessen erscheint die unten nachfolgende Fehlerliste. Wer weis hier Rat? Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. An exception occurred while executing ‚SELECT count(DISTINCT s0_.id) AS sclr0 FROM s_order s0_ LEFT JOIN s_core_paymentmeans s1_ ON s0_.paymentID = s1_.id LEFT JOIN s_core_states s2_ ON s0_.cleared = s2_.id LEFT JOIN s_core_states s3_ ON s0_.status = s3_.id LEFT JOIN s_order_billingaddress s4_ ON s0_.id = s4_.orderID LEFT JOIN s_user s5_ ON s0_.userID = s5_.id LEFT JOIN s_order_details s6_ ON s0_.id = s6_.orderID LEFT JOIN s_core_countries s7_ ON s4_.countryID = s7_.id LEFT JOIN s_core_shops s8_ ON s0_.subshopID = s8_.id LEFT JOIN s_premium_dispatch s9_ ON s0_.dispatchID = s9_.id LEFT JOIN s_order_billingaddress_attributes s10_ ON s4_.id = s10_.billingID LEFT JOIN WHERE s0_.status NOT IN (‘-1’) AND s0_.ordernumber IS NOT NULL’: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‚WHERE s0_.status NOT IN (‘-1’) AND s0_.ordernumber IS NOT NULL’ at line 1 in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 91 Stack trace: #0 /kunden/xxx/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(698): PDO->query(‚SELECT count(DI…‘) #1 /kunden/xxx/shopware/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection->executeQuery(‚SELECT count(DI…‘, Array, Array, NULL) #2 /kunden/xxx/shopware/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(286): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array) #3 /kunden/xxx/shopware/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(794): Doctrine\ORM\Query->_doExecute() #4 /kunden/xxx/shopware/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(598): Doctrine\ORM\AbstractQuery->execute(NULL, 3) #5 /kunden/xxx/shopware/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(143): Doctrine\ORM\AbstractQuery->getScalarResult() #6 /kunden/xxx/shopware/engine/Shopware/Controllers/Backend/Order.php(361): Doctrine\ORM\Tools\Pagination\Paginator->count() #7 [internal function]: Shopware_Controllers_Backend_Order->getList(NULL, NULL, ‚0‘, ‚20‘) #8 /kunden/xxx/shopware/cache/proxies/ShopwareControllersBackendOrderProxy.php(11): call_user_func_array(Array, Array) #9 /kunden/xxx/shopware/engine/Library/Enlight/Hook/HookManager.php(191): Shopware_Proxies_ShopwareControllersBackendOrderProxy->executeParent(‚getList‘, Array) #10 /kunden/xxx/shopware/cache/proxies/ShopwareControllersBackendOrderProxy.php(23): Enlight_Hook_HookManager->executeHooks(Object(Shopware_Proxies_ShopwareControllersBackendOrderProxy), ‚getList‘, Array) #11 /kunden/xxx/shopware/engine/Shopware/Controllers/Backend/Order.php(334): Shopware_Proxies_ShopwareControllersBackendOrderProxy->getList(NULL, NULL, ‚0‘, ‚20‘) #12 /kunden/xxx/shopware/engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Backend_Order->getListAction() #13 /kunden/xxx/shopware/engine/Library/Enlight/Controller/Dispatcher/Default.php(528): Enlight_Controller_Action->dispatch(‚getListAction‘) #14 /kunden/xxx/shopware/engine/Library/Enlight/Controller/Front.php(228): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #15 /kunden/xxx/shopware/engine/Shopware/Kernel.php(141): Enlight_Controller_Front->dispatch() #16 /kunden/xxx/shopware/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(473): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #17 /kunden/xxx/shopware/engine/Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #18 /kunden/xxx/shopware/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(244): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #19 /kunden/xxx/shopware/engine/Shopware/Components/HttpCache/AppCache.php(102): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #20 /kunden/xxx/shopware/shopware.php(91): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #21 {main} Next exception ‚Doctrine\DBAL\DBALException‘ with message ‚An exception occurred while executing ‚SELECT count(DISTINCT s0_.id) AS sclr0 FROM s_order s0_ LEFT JOIN s_core_paymentmeans s1_ ON s0_.paymentID = s1_.id LEFT JOIN s_core_states s2_ ON s0_.cleared = s2_.id LEFT JOIN s_core_states s3_ ON s0_.status = s3_.id LEFT JOIN s_order_billingaddress s4_ ON s0_.id = s4_.orderID LEFT JOIN s_user s5_ ON s0_.userID = s5_.id LEFT JOIN s_order_details s6_ ON s0_.id = s6_.orderID LEFT JOIN s_core_countries s7_ ON s4_.countryID = s7_.id LEFT JOIN s_core_shops s8_ ON s0_.subshopID = s8_.id LEFT JOIN s_premium_dispatch s9_ ON s0_.dispatchID = s9_.id LEFT JOIN s_order_billingaddress_attributes s10_ ON s4_.id = s10_.billingID LEFT JOIN WHERE s0_.status NOT IN (‘-1‘) AND s0_.ordernumber IS NOT NULL’: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‚WHERE s0_.status NOT IN (‘-1’) AND s0_.ordernumber IS NOT NULL’ at line 1’ in /kunden/xxx/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 Stack trace: #0 /kunden/xxx/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(701): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), ‚SELECT count(DI…‘, Array) #1 /kunden/xxx/shopware/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection->executeQuery(‚SELECT count(DI…‘, Array, Array, NULL) #2 /kunden/xxx/shopware/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(286): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array) #3 /kunden/xxx/shopware/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(794): Doctrine\ORM\Query->_doExecute() #4 /kunden/xxx/shopware/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(598): Doctrine\ORM\AbstractQuery->execute(NULL, 3) #5 /kunden/xxx/shopware/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(143): Doctrine\ORM\AbstractQuery->getScalarResult() #6 /kunden/xxx/shopware/engine/Shopware/Controllers/Backend/Order.php(361): Doctrine\ORM\Tools\Pagination\Paginator->count() #7 [internal function]: Shopware_Controllers_Backend_Order->getList(NULL, NULL, ‚0‘, ‚20‘) #8 /kunden/xxx/shopware/cache/proxies/ShopwareControllersBackendOrderProxy.php(11): call_user_func_array(Array, Array) #9 /kunden/xxx/shopware/engine/Library/Enlight/Hook/HookManager.php(191): Shopware_Proxies_ShopwareControllersBackendOrderProxy->executeParent(‚getList‘, Array) #10 /kunden/xxx/shopware/cache/proxies/ShopwareControllersBackendOrderProxy.php(23): Enlight_Hook_HookManager->executeHooks(Object(Shopware_Proxies_ShopwareControllersBackendOrderProxy), ‚getList‘, Array) #11 /kunden/xxx/shopware/engine/Shopware/Controllers/Backend/Order.php(334): Shopware_Proxies_ShopwareControllersBackendOrderProxy->getList(NULL, NULL, ‚0‘, ‚20‘) #12 /kunden/xxx/shopware/engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Backend_Order->getListAction() #13 /kunden/xxx/shopware/engine/Library/Enlight/Controller/Dispatcher/Default.php(528): Enlight_Controller_Action->dispatch(‚getListAction‘) #14 /kunden/xxx/shopware/engine/Library/Enlight/Controller/Front.php(228): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #15 /kunden/xxx/shopware/engine/Shopware/Kernel.php(141): Enlight_Controller_Front->dispatch() #16 /kunden/xxx/shopware/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(473): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #17 /kunden/xxx/shopware/engine/Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #18 /kunden/xxx/shopware/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(244): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #19 /kunden/xxx/shopware/engine/Shopware/Components/HttpCache/AppCache.php(102): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #20 /kunden/xxx/shopware/shopware.php(91): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #21 {main}
Habe seit gestern anscheinend den gleichen Fehler wie Du… Hattest du das Paypal Modul aktiviert ? Das ist das einzige was ich geändert hatte.
Selbes problem bei uns wir hatten bei einem Shop vergessen das Auto Update Plugin zu deaktivieren. Bei uns sieht der Fehler so aus. So langsam sollte man sich überlegen ob man bei so aktionen Shopware nicht mal in die Haftung nimmt. Wenn sich ein Update über ein plugin automatisch installiert muss es Idiotensicher sein. Hat jemand eine Lösung ? Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. An exception occurred while executing ‚SELECT s0_.id AS id0, s0_.name AS name1, s0_.label AS label2, s1_.id AS id3, s1_.auth_id AS auth_id4, s1_.label AS label5, s1_.column AS column6, s1_.position AS position7 FROM s_core_widgets s0_ LEFT JOIN s_core_widget_views s1_ ON s0_.id = s1_.widget_id WHERE s1_.auth_id = ?‘ with params [50]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‚s1_.label‘ in ‚field list‘ in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 91 Stack trace: #0 vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(701): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(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(286): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array) #3 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(794): Doctrine\ORM\Query->_doExecute() #4 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(586): Doctrine\ORM\AbstractQuery->execute(NULL, 2) #5 Shopware/Controllers/Backend/Widgets.php(74): Doctrine\ORM\AbstractQuery->getArrayResult() #6 Enlight/Controller/Action.php(159): Shopware_Controllers_Backend_Widgets->getListAction() #7 Enlight/Controller/Dispatcher/Default.php(528): Enlight_Controller_Action->dispatch(‚getListAction‘) #8 Enlight/Controller/Front.php(228): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #9 Shopware/Kernel.php(141): Enlight_Controller_Front->dispatch() #10 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(473): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #11 Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #12 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(244): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #13 Shopware/Components/HttpCache/AppCache.php(102): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #14 shopware.php(91): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #15 {main}
gibs hier Loesungsansaetzte habe das selbe problem bei Bestellungen