# Problem nach Update auf 4.2.2 - Hilfe! **URL:** \ **Category:** Shopware 3.5\ **Tags:** administration\ **Created:** [30. April 2014 um 06:34 UTC](https://forum.shopware.com/t/problem-nach-update-auf-4-2-2-hilfe/19995 "2014-04-30T06:34:30Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![m.streiber](https://avatars.discourse-cdn.com/v4/letter/m/eb9ed0/32.png) [@m.streiber](https://forum.shopware.com/u/m.streiber)\ **Post date:** [30. April 2014 um 06:34 UTC](https://forum.shopware.com/t/problem-nach-update-auf-4-2-2-hilfe/19995/1 "2014-04-30T06:34:30Z")
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} ---
**Author:** ![tiggar](https://avatars.discourse-cdn.com/v4/letter/t/839c29/32.png) [@tiggar](https://forum.shopware.com/u/tiggar)\ **Post date:** [4. Mai 2014 um 10:27 UTC](https://forum.shopware.com/t/problem-nach-update-auf-4-2-2-hilfe/19995/2 "2014-05-04T10:27:21Z")
Habe seit gestern anscheinend den gleichen Fehler wie Du… Hattest du das Paypal Modul aktiviert ? Das ist das einzige was ich geändert hatte. ---
**Author:** ![MaverikMS2001](https://avatars.discourse-cdn.com/v4/letter/m/e47774/32.png) [@MaverikMS2001](https://forum.shopware.com/u/MaverikMS2001)\ **Post date:** [25. September 2014 um 20:23 UTC](https://forum.shopware.com/t/problem-nach-update-auf-4-2-2-hilfe/19995/3 "2014-09-25T20:23:43Z")
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} ---
**Author:** ![MSB](https://avatars.discourse-cdn.com/v4/letter/m/6a8cbe/32.png) [@MSB](https://forum.shopware.com/u/MSB)\ **Post date:** [2. Oktober 2014 um 17:24 UTC](https://forum.shopware.com/t/problem-nach-update-auf-4-2-2-hilfe/19995/4 "2014-10-02T17:24:09Z")
gibs hier Loesungsansaetzte habe das selbe problem bei Bestellungen