# Nach dem Shopware 5 Update auf Shopware 5.7.6; Build Rev 202110251506 funktioniert Warenkorb nicht
**URL:** https://forum.shopware.com/t/nach-dem-shopware-5-update-auf-shopware-5-7-6-build-rev-202110251506-funktioniert-warenkorb-nicht/91509
**Category:** Shopware 5
**Created:** [16. November 2021 um 19:02 UTC](https://forum.shopware.com/t/nach-dem-shopware-5-update-auf-shopware-5-7-6-build-rev-202110251506-funktioniert-warenkorb-nicht/91509 "2021-11-16T19:02:27Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@Ergu1949](https://forum.shopware.com/u/Ergu1949)
#### Post date: [16. November 2021 um 19:02 UTC](https://forum.shopware.com/t/nach-dem-shopware-5-update-auf-shopware-5-7-6-build-rev-202110251506-funktioniert-warenkorb-nicht/91509/1 "2021-11-16T19:02:27Z")
Nach dem update kann man Warenkorbfenster nicht mehr öffnen (Quadrat dreht sich immer). Aber man sieht dass die Artikeln in den Warenkorb hinzugefügt wurde.
Es sieht aus, dass irgendwas mit Datenbank nicht klappt bzw. beim Update was schiefgelaufen ist.
Hier ist Fehlerlog Shopware:
**Ups! Ein Fehler ist aufgetreten!**
**Die nachfolgenden Hinweise sollten Ihnen weiterhelfen.**
_An exception occurred while executing 'SELECT d.id as `key`, d.id, d.name, d.description, d.calculation, d.status\_link, b. FROM s\_premium\_dispatch d INNER JOIN (SELECT ‚0‘ as `instock`,‚0‘ as `stockmin`,‚0‘ as `laststock`,‚18.000‘ as `weight`,‚3‘ as `count_article`,‚0‘ as `shippingfree`,‚463.95‘ as `amount`,‚389.88‘ as `amount_net`,‚463.95‘ as `amount_display`,‚230.000‘ as `length`,‚515.000‘ as `height`,‚415.000‘ as `width`,’’ as `userID`,‚0‘ as `has_topseller`,’’ as `has_comment`,‚0‘ as `has_esd`,‚18.000‘ as `gesamtgewicht`,’’ as `calculation_value_33`,‚19‘ as `max_tax`,‚0‘ as `basketStateId`,‚2‘ as `countryID`,‚181‘ as `paymentID`,‚1‘ as `customergroupID`,‚1‘ as `multishopID`,‚pvk46mrmb7rmgbd2ph3tn3mn6s‘ as `sessionID`) b ON 1=1 INNER JOIN s\_premium\_dispatch\_countries dc ON d.id = dc.dispatchID AND dc.countryID=b.countryID INNER JOIN s\_premium\_dispatch\_paymentmeans dp ON d.id = dp.dispatchID AND dp.paymentID=b.paymentID LEFT JOIN s\_premium\_holidays h ON h.date = CURDATE() LEFT JOIN s\_premium\_dispatch\_holidays dh ON d.id=dh.dispatchID AND h.id=dh.holidayID LEFT JOIN (SELECT dc.dispatchID FROM s\_order\_basket b INNER JOIN s\_articles\_categories\_ro ac ON ac.articleID = b.articleID INNER JOIN s\_premium\_dispatch\_categories dc ON dc.categoryID = ac.categoryID WHERE (b.modus = 0) AND (b.sessionID = ?) GROUP BY dc.dispatchID) dk ON dk.dispatchID=d.id LEFT JOIN s\_user u ON u.id=b.userID AND u.active=1 LEFT JOIN s\_user\_addresses ub ON ub.user\_id = u.id AND ub.id = ? LEFT JOIN s\_user\_addresses us ON us.user\_id = u.id AND us.id = ? WHERE (d.active = 1) AND (( (bind\_time\_from IS NULL AND bind\_time\_to IS NULL) OR (IFNULL(bind\_time\_from,0) \<= IFNULL(bind\_time\_to,86400) AND TIME\_TO\_SEC(DATE\_FORMAT(NOW(),"%H:%i:00")) BETWEEN IFNULL(bind\_time\_from,0) AND IFNULL(bind\_time\_to,86400)) OR (bind\_time\_from \> bind\_time\_to AND TIME\_TO\_SEC(DATE\_FORMAT(NOW(),"%H:%i:00")) NOT BETWEEN bind\_time\_to AND bind\_time\_from) )) AND (( (bind\_weekday\_from IS NULL AND bind\_weekday\_to IS NULL) OR (IFNULL(bind\_weekday\_from,1) \<= IFNULL(bind\_weekday\_to,7) AND WEEKDAY(NOW())+1 BETWEEN IFNULL(bind\_weekday\_from,1) AND IFNULL(bind\_weekday\_to,7)) OR (bind\_weekday\_from \> bind\_weekday\_to AND WEEKDAY(NOW())+1 NOT BETWEEN bind\_weekday\_to AND bind\_weekday\_from) )) AND ((bind\_weight\_from IS NULL OR bind\_weight\_from \<= b.weight)) AND ((bind\_weight\_to IS NULL OR bind\_weight\_to \>= b.weight)) AND ((bind\_price\_from IS NULL OR bind\_price\_from \<= b.amount)) AND ((bind\_price\_to IS NULL OR bind\_price\_to \>= b.amount)) AND ((bind\_instock=0 OR bind\_instock IS NULL OR (bind\_instock=1 AND b.instock) OR (bind\_instock=2 AND b.stockmin))) AND ((bind\_laststock=0 OR (bind\_laststock=1 AND b.laststock))) AND ((bind\_shippingfree!=1 OR NOT b.shippingfree)) AND (dh.holidayID IS NULL) AND ((d.multishopID IS NULL OR d.multishopID=b.multishopID)) AND ((d.customergroupID IS NULL OR d.customergroupID=b.customergroupID)) AND (dk.dispatchID IS NULL) AND (d.type IN (0)) AND ((d.id != 20 OR (gesamtgewicht \< 30))) AND ((d.id != 25 OR (gesamtgewicht \< 31,1))) AND ((d.id != 30 OR (gesamtgewicht \< 60))) AND ((d.id != 31 OR (gesamtgewicht \< 60))) AND ((d.id != 32 OR (gesamtgewicht \< 60))) AND ((d.id != 35 OR (gesamtgewicht \< 50))) GROUP BY d.id ORDER BY d.position, d.name ASC’ with params [„pvk46mrmb7rmgbd2ph3tn3mn6s“, 0, 0]: SQLSTATE[21000]: Cardinality violation: 1241 Operand should contain 1 column(s) in /html/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php on line 128_\*
**Stack trace:**
**#0 /html/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver-\>convertException(‚An exception oc…‘, Object(Doctrine\DBAL\Driver\PDO\Exception))**
**#1 /html/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(159): Doctrine\DBAL\DBALException::wrapException(Object(Doctrine\DBAL\Driver\PDO\MySQL\Driver), Object(Doctrine\DBAL\Driver\PDO\Exception), ‚An exception oc…‘)**
**#2 /html/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2225): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\MySQL\Driver), Object(Doctrine\DBAL\Driver\PDO\Exception), ‚SELECT d.id as …‘, Array)**
**#3 /html/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1312): Doctrine\DBAL\Connection-\>handleExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), ‚SELECT d.id as …‘, Array, Array)**
**#4 /html/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(212): Doctrine\DBAL\Connection-\>executeQuery(‚SELECT d.id as …‘, Array, Array)**
**#5 /html/shopware/engine/Shopware/Core/sAdmin.php(2797): Doctrine\DBAL\Query\QueryBuilder-\>execute()**
**#6 /html/shopware/engine/Shopware/Controllers/Frontend/Checkout.php(1593): sAdmin-\>sGetPremiumDispatches(2, NULL, NULL)**
**#7 /html/shopware/engine/Shopware/Controllers/Frontend/Checkout.php(1728): Shopware\_Controllers\_Frontend\_Checkout-\>getSelectedDispatch()**
**#8 /html/shopware/engine/Library/Enlight/Controller/Action.php(182): Shopware\_Controllers\_Frontend\_Checkout-\>ajaxCartAction()**
**#9 /html/shopware/engine/Library/Enlight/Controller/Dispatcher/Default.php(461): Enlight\_Controller\_Action-\>dispatch(‚ajaxCartAction‘)**
**#10 /html/shopware/engine/Library/Enlight/Controller/Front.php(225): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp))**
**#11 /html/shopware/engine/Shopware/Kernel.php(197): Enlight\_Controller\_Front-\>dispatch()**
**#12 /html/shopware/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(85): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)**
**#13 /html/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true)**
**#14 /html/shopware/engine/Shopware/Components/HttpCache/AppCache.php(262): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)**
**#15 /html/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(269): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true)**
**#16 /html/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(285): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true)**
**#17 /html/shopware/engine/Shopware/Components/HttpCache/AppCache.php(144): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>invalidate(Object(Symfony\Component\HttpFoundation\Request), true)**
**#18 /html/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(213): Shopware\Components\HttpCache\AppCache-\>invalidate(Object(Symfony\Component\HttpFoundation\Request), true)**
**#19 /html/shopware/engine/Shopware/Components/HttpCache/AppCache.php(114): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)**
**#20 /html/shopware/shopware.php(122): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request))**
**#21 {main}**
---
### Author:  [@R4M](https://forum.shopware.com/u/R4M)
#### Post date: [18. November 2021 um 07:17 UTC](https://forum.shopware.com/t/nach-dem-shopware-5-update-auf-shopware-5-7-6-build-rev-202110251506-funktioniert-warenkorb-nicht/91509/2 "2021-11-18T07:17:13Z")
Irgendetwas scheint mit der User Adresse nicht zu stimmen. Dort wird als ID 0 übertragen, das kann eigentlich nicht sein. Ist das bei jedem User so oder nur bei bestimmten?