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}