Wenn ich eine Versandart mit dieser Berechnung erstelle, führt das dazu, dass der Off-Canvas Warenkorb nicht mehr funktioniert (lädt nicht). Zusätzlich funktioniert der Log-In dann nicht mehr. Diese Meldungen werden dann im Log abgelegt:
[2021-09-23 16:04:19] core.CRITICAL: An exception occurred while executing ‚SELECT MIN(d.instock>=b.quantity) as instock, MIN(d.instock>=(b.quantity+d.stockmin)) as stockmin, MIN(a.laststock) as laststock, SUM(d.weightb.quantity) as weight, SUM(IF(a.id,b.quantity,0)) as count_article, MAX(b.shippingfree) as shippingfree, SUM(IF(b.modus=0,b.quantityROUND(CAST(b.price as DECIMAL(10,2))(100+t.tax)/100,2)/b.currencyFactor,0)) as amount, SUM(IF(b.modus=0,b.quantityCAST(b.price as DECIMAL(10,2))/b.currencyFactor,0)) as amount_net, SUM(CAST(b.price as DECIMAL(10,2))b.quantity) as amount_display, MAX(d.length) as length, MAX(d.height) as height, MAX(d.width) as width, u.id as userID, MAX(a.topseller) as has_topseller, MAX(at.attr3) as has_comment, MAX(b.esdarticle) as has_esd, (’’) as calculation_value_19, (’’) as calculation_value_20, (’’) as calculation_value_21, (’’) as calculation_value_22, (’’) as calculation_value_23, (’’) as calculation_value_25, (SUM(IF(at.attr5 != 1,b.priceb.quantity,0)) as calculation_value_27, (‘’) as calculation_value_61 FROM s_order_basket b LEFT JOIN s_articles a ON b.articleID = a.id AND b.modus = 0 AND b.esdarticle = 0 LEFT JOIN s_user u ON u.id = ? AND u.active = 1 LEFT JOIN s_articles_details d ON (d.ordernumber = b.ordernumber) AND d.articleID = a.id LEFT JOIN s_core_tax t ON t.id = a.taxID LEFT JOIN s_articles_attributes at ON at.articledetailsID = d.id 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 b.sessionID = ? GROUP BY b.sessionID’ with params (1212, 1521, 1521, „5p02o57voar7p9j8qp4500v52c“): 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 ‚as calculation_value_27, (‘’) as calculation_value_61 FROM s_order_basket b LEFT’ at line 1 {„uid“:„238f8f5“}
[2021-09-23 16:04:19] core.CRITICAL: An exception occurred while executing ‚SELECT MIN(d.instock>=b.quantity) as instock, MIN(d.instock>=(b.quantity+d.stockmin)) as stockmin, MIN(a.laststock) as laststock, SUM(d.weightb.quantity) as weight, SUM(IF(a.id,b.quantity,0)) as count_article, MAX(b.shippingfree) as shippingfree, SUM(IF(b.modus=0,b.quantityROUND(CAST(b.price as DECIMAL(10,2))(100+t.tax)/100,2)/b.currencyFactor,0)) as amount, SUM(IF(b.modus=0,b.quantityCAST(b.price as DECIMAL(10,2))/b.currencyFactor,0)) as amount_net, SUM(CAST(b.price as DECIMAL(10,2))b.quantity) as amount_display, MAX(d.length) as length, MAX(d.height) as height, MAX(d.width) as width, u.id as userID, MAX(a.topseller) as has_topseller, MAX(at.attr3) as has_comment, MAX(b.esdarticle) as has_esd, (’’) as calculation_value_19, (’’) as calculation_value_20, (’’) as calculation_value_21, (’’) as calculation_value_22, (’’) as calculation_value_23, (’’) as calculation_value_25, (SUM(IF(at.attr5 != 1,b.priceb.quantity,0)) as calculation_value_27, (‘’) as calculation_value_61 FROM s_order_basket b LEFT JOIN s_articles a ON b.articleID = a.id AND b.modus = 0 AND b.esdarticle = 0 LEFT JOIN s_user u ON u.id = ? AND u.active = 1 LEFT JOIN s_articles_details d ON (d.ordernumber = b.ordernumber) AND d.articleID = a.id LEFT JOIN s_core_tax t ON t.id = a.taxID LEFT JOIN s_articles_attributes at ON at.articledetailsID = d.id 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 b.sessionID = ? GROUP BY b.sessionID’ with params (1212, 1521, 1521, „5p02o57voar7p9j8qp4500v52c“): 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 ‚as calculation_value_27, (‘’) as calculation_value_61 FROM s_order_basket b LEFT’ at line 1 {„uid“:„238f8f5“}
[2021-09-23 16:04:19] core.ERROR: PDOException: 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 ‚as calculation_value_27, (‘’) as calculation_value_61 FROM s_order_basket b LEFT’ at line 1 in /html/shopware-staging/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:907 Stack trace: #0 /html/shopware-staging/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(907): PDOStatement->execute() #1 /html/shopware-staging/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): Doctrine\DBAL\Connection->executeQuery(‚SELECT MIN(d.in…‘, Array, Array) #2 /html/shopware-staging/engine/Shopware/Core/sAdmin.php(2607): Doctrine\DBAL\Query\QueryBuilder->execute() #3 /html/shopware-staging/engine/Shopware/Core/sAdmin.php(3030): sAdmin->sGetDispatchBasket(NULL) #4 /html/shopware-staging/engine/Shopware/Core/sBasket.php(2062): sAdmin->sGetPremiumShippingcosts() #5 /html/shopware-staging/engine/Shopware/Controllers/Frontend/Account.php(680): sBasket->sRefreshBasket() #6 /html/shopware-staging/engine/Shopware/Controllers/Frontend/Account.php(272): Shopware_Controllers_Frontend_Account->refreshBasket() #7 /html/shopware-staging/var/cache/production_202105060633/proxies/ShopwareControllersFrontendAccountProxy.php(79): Shopware_Controllers_Frontend_Account->loginAction() #8 /html/shopware-staging/engine/Library/Enlight/Hook/HookExecutionContext.php(137): Shopware_Proxies_ShopwareControllersFrontendAccountProxy->__executeOriginalMethod(‚loginAction‘, Array) #9 /html/shopware-staging/engine/Library/Enlight/Hook/HookExecutionContext.php(103): Enlight_Hook_HookExecutionContext->executeReplaceChain(Array) #10 /html/shopware-staging/engine/Library/Enlight/Hook/HookManager.php(180): Enlight_Hook_HookExecutionContext->execute() #11 /html/shopware-staging/var/cache/production_202105060633/proxies/ShopwareControllersFrontendAccountProxy.php(114): Enlight_Hook_HookManager->executeHooks(Object(Shopware_Proxies_ShopwareControllersFrontendAccountProxy), ‚loginAction‘, Array) #12 /html/shopware-staging/engine/Library/Enlight/Controller/Action.php(192): Shopware_Proxies_ShopwareControllersFrontendAccountProxy->loginAction() #13 /html/shopware-staging/engine/Library/Enlight/Controller/Dispatcher/Default.php(478): Enlight_Controller_Action->dispatch(‚loginAction‘) #14 /html/shopware-staging/engine/Library/Enlight/Controller/Front.php(228): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #15 /html/shopware-staging/engine/Shopware/Kernel.php(188): Enlight_Controller_Front->dispatch() #16 /html/shopware-staging/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #17 /html/shopware-staging/vendor/symfony/http-kernel/HttpCache/HttpCache.php(453): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true) #18 /html/shopware-staging/engine/Shopware/Components/HttpCache/AppCache.php(261): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #19 /html/shopware-staging/vendor/symfony/http-kernel/HttpCache/HttpCache.php(238): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #20 /html/shopware-staging/vendor/symfony/http-kernel/HttpCache/HttpCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #21 /html/shopware-staging/engine/Shopware/Components/HttpCache/AppCache.php(143): Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate(Object(Symfony\Component\HttpFoundation\Request), true) #22 /html/shopware-staging/vendor/symfony/http-kernel/HttpCache/HttpCache.php(181): Shopware\Components\HttpCache\AppCache->invalidate(Object(Symfony\Component\HttpFoundation\Request), true) #23 /html/shopware-staging/engine/Shopware/Components/HttpCache/AppCache.php(113): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #24 /html/shopware-staging/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #25 {main} Next Doctrine\DBAL\DBALException: An exception occurred while executing ‚SELECT MIN(d.instock>=b.quantity) as instock, MIN(d.instock>=(b.quantity+d.stockmin)) as stockmin, MIN(a.laststock) as laststock, SUM(d.weightb.quantity) as weight, SUM(IF(a.id,b.quantity,0)) as count_article, MAX(b.shippingfree) as shippingfree, SUM(IF(b.modus=0,b.quantityROUND(CAST(b.price as DECIMAL(10,2))(100+t.tax)/100,2)/b.currencyFactor,0)) as amount, SUM(IF(b.modus=0,b.quantityCAST(b.price as DECIMAL(10,2))/b.currencyFactor,0)) as amount_net, SUM(CAST(b.price as DECIMAL(10,2))b.quantity) as amount_display, MAX(d.length) as length, MAX(d.height) as height, MAX(d.width) as width, u.id as userID, MAX(a.topseller) as has_topseller, MAX(at.attr3) as has_comment, MAX(b.esdarticle) as has_esd, (’’) as calculation_value_19, (’’) as calculation_value_20, (’’) as calculation_value_21, (’’) as calculation_value_22, (’’) as calculation_value_23, (’’) as calculation_value_25, (SUM(IF(at.attr5 != 1,b.priceb.quantity,0)) as calculation_value_27, (‘’) as calculation_value_61 FROM s_order_basket b LEFT JOIN s_articles a ON b.articleID = a.id AND b.modus = 0 AND b.esdarticle = 0 LEFT JOIN s_user u ON u.id = ? AND u.active = 1 LEFT JOIN s_articles_details d ON (d.ordernumber = b.ordernumber) AND d.articleID = a.id LEFT JOIN s_core_tax t ON t.id = a.taxID LEFT JOIN s_articles_attributes at ON at.articledetailsID = d.id 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 b.sessionID = ? GROUP BY b.sessionID’ with params (1212, 1521, 1521, „5p02o57voar7p9j8qp4500v52c“): 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 ‚as calculation_value_27, (‘’) as calculation_value_61 FROM s_order_basket b LEFT’ at line 1 in /html/shopware-staging/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:179 Stack trace: #0 /html/shopware-staging/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(150): Doctrine\DBAL\DBALException::wrapException(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), ‚An exception oc…‘) #1 /html/shopware-staging/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(915): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), ‚SELECT MIN(d.in…‘, Array) #2 /html/shopware-staging/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): Doctrine\DBAL\Connection->executeQuery(‚SELECT MIN(d.in…‘, Array, Array) #3 /html/shopware-staging/engine/Shopware/Core/sAdmin.php(2607): Doctrine\DBAL\Query\QueryBuilder->execute() #4 /html/shopware-staging/engine/Shopware/Core/sAdmin.php(3030): sAdmin->sGetDispatchBasket(NULL) #5 /html/shopware-staging/engine/Shopware/Core/sBasket.php(2062): sAdmin->sGetPremiumShippingcosts() #6 /html/shopware-staging/engine/Shopware/Controllers/Frontend/Account.php(680): sBasket->sRefreshBasket() #7 /html/shopware-staging/engine/Shopware/Controllers/Frontend/Account.php(272): Shopware_Controllers_Frontend_Account->refreshBasket() #8 /html/shopware-staging/var/cache/production_202105060633/proxies/ShopwareControllersFrontendAccountProxy.php(79): Shopware_Controllers_Frontend_Account->loginAction() #9 /html/shopware-staging/engine/Library/Enlight/Hook/HookExecutionContext.php(137): Shopware_Proxies_ShopwareControllersFrontendAccountProxy->__executeOriginalMethod(‚loginAction‘, Array) #10 /html/shopware-staging/engine/Library/Enlight/Hook/HookExecutionContext.php(103): Enlight_Hook_HookExecutionContext->executeReplaceChain(Array) #11 /html/shopware-staging/engine/Library/Enlight/Hook/HookManager.php(180): Enlight_Hook_HookExecutionContext->execute() #12 /html/shopware-staging/var/cache/production_202105060633/proxies/ShopwareControllersFrontendAccountProxy.php(114): Enlight_Hook_HookManager->executeHooks(Object(Shopware_Proxies_ShopwareControllersFrontendAccountProxy), ‚loginAction‘, Array) #13 /html/shopware-staging/engine/Library/Enlight/Controller/Action.php(192): Shopware_Proxies_ShopwareControllersFrontendAccountProxy->loginAction() #14 /html/shopware-staging/engine/Library/Enlight/Controller/Dispatcher/Default.php(478): Enlight_Controller_Action->dispatch(‚loginAction‘) #15 /html/shopware-staging/engine/Library/Enlight/Controller/Front.php(228): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #16 /html/shopware-staging/engine/Shopware/Kernel.php(188): Enlight_Controller_Front->dispatch() #17 /html/shopware-staging/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #18 /html/shopware-staging/vendor/symfony/http-kernel/HttpCache/HttpCache.php(453): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true) #19 /html/shopware-staging/engine/Shopware/Components/HttpCache/AppCache.php(261): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #20 /html/shopware-staging/vendor/symfony/http-kernel/HttpCache/HttpCache.php(238): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #21 /html/shopware-staging/vendor/symfony/http-kernel/HttpCache/HttpCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #22 /html/shopware-staging/engine/Shopware/Components/HttpCache/AppCache.php(143): Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate(Object(Symfony\Component\HttpFoundation\Request), true) #23 /html/shopware-staging/vendor/symfony/http-kernel/HttpCache/HttpCache.php(181): Shopware\Components\HttpCache\AppCache->invalidate(Object(Symfony\Component\HttpFoundation\Request), true) #24 /html/shopware-staging/engine/Shopware/Components/HttpCache/AppCache.php(113): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #25 /html/shopware-staging/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #26 {main} {„uid“:„238f8f5“}
[2021-09-23 16:04:22] core.CRITICAL: An exception occurred while executing ‚SELECT MIN(d.instock>=b.quantity) as instock, MIN(d.instock>=(b.quantity+d.stockmin)) as stockmin, MIN(a.laststock) as laststock, SUM(d.weightb.quantity) as weight, SUM(IF(a.id,b.quantity,0)) as count_article, MAX(b.shippingfree) as shippingfree, SUM(IF(b.modus=0,b.quantityROUND(CAST(b.price as DECIMAL(10,2))(100+t.tax)/100,2)/b.currencyFactor,0)) as amount, SUM(IF(b.modus=0,b.quantityCAST(b.price as DECIMAL(10,2))/b.currencyFactor,0)) as amount_net, SUM(CAST(b.price as DECIMAL(10,2))b.quantity) as amount_display, MAX(d.length) as length, MAX(d.height) as height, MAX(d.width) as width, u.id as userID, MAX(a.topseller) as has_topseller, MAX(at.attr3) as has_comment, MAX(b.esdarticle) as has_esd, (’’) as calculation_value_19, (’’) as calculation_value_20, (’’) as calculation_value_21, (’’) as calculation_value_22, (’’) as calculation_value_23, (’’) as calculation_value_25, (SUM(IF(at.attr5 != 1,b.priceb.quantity,0)) as calculation_value_27, (‘’) as calculation_value_61 FROM s_order_basket b LEFT JOIN s_articles a ON b.articleID = a.id AND b.modus = 0 AND b.esdarticle = 0 LEFT JOIN s_user u ON u.id = ? AND u.active = 1 LEFT JOIN s_articles_details d ON (d.ordernumber = b.ordernumber) AND d.articleID = a.id LEFT JOIN s_core_tax t ON t.id = a.taxID LEFT JOIN s_articles_attributes at ON at.articledetailsID = d.id 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 b.sessionID = ? GROUP BY b.sessionID’ with params (1212, 1521, 1521, „5p02o57voar7p9j8qp4500v52c“): 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 ‚as calculation_value_27, (‘’) as calculation_value_61 FROM s_order_basket b LEFT’ at line 1 {„uid“:„6539318“}
[2021-09-23 16:04:22] core.CRITICAL: An exception occurred while executing ‚SELECT MIN(d.instock>=b.quantity) as instock, MIN(d.instock>=(b.quantity+d.stockmin)) as stockmin, MIN(a.laststock) as laststock, SUM(d.weightb.quantity) as weight, SUM(IF(a.id,b.quantity,0)) as count_article, MAX(b.shippingfree) as shippingfree, SUM(IF(b.modus=0,b.quantityROUND(CAST(b.price as DECIMAL(10,2))(100+t.tax)/100,2)/b.currencyFactor,0)) as amount, SUM(IF(b.modus=0,b.quantityCAST(b.price as DECIMAL(10,2))/b.currencyFactor,0)) as amount_net, SUM(CAST(b.price as DECIMAL(10,2))b.quantity) as amount_display, MAX(d.length) as length, MAX(d.height) as height, MAX(d.width) as width, u.id as userID, MAX(a.topseller) as has_topseller, MAX(at.attr3) as has_comment, MAX(b.esdarticle) as has_esd, (’’) as calculation_value_19, (’’) as calculation_value_20, (’’) as calculation_value_21, (’’) as calculation_value_22, (’’) as calculation_value_23, (’’) as calculation_value_25, (SUM(IF(at.attr5 != 1,b.priceb.quantity,0)) as calculation_value_27, (‘’) as calculation_value_61 FROM s_order_basket b LEFT JOIN s_articles a ON b.articleID = a.id AND b.modus = 0 AND b.esdarticle = 0 LEFT JOIN s_user u ON u.id = ? AND u.active = 1 LEFT JOIN s_articles_details d ON (d.ordernumber = b.ordernumber) AND d.articleID = a.id LEFT JOIN s_core_tax t ON t.id = a.taxID LEFT JOIN s_articles_attributes at ON at.articledetailsID = d.id 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 b.sessionID = ? GROUP BY b.sessionID’ with params (1212, 1521, 1521, „5p02o57voar7p9j8qp4500v52c“): 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 ‚as calculation_value_27, (‘’) as calculation_value_61 FROM s_order_basket b LEFT’ at line 1 {„uid“:„6539318“}
[2021-09-23 16:04:22] core.ERROR: PDOException: 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 ‚as calculation_value_27, (‘’) as calculation_value_61 FROM s_order_basket b LEFT’ at line 1 in /html/shopware-staging/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:907 Stack trace: #0 /html/shopware-staging/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(907): PDOStatement->execute() #1 /html/shopware-staging/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): Doctrine\DBAL\Connection->executeQuery(‚SELECT MIN(d.in…‘, Array, Array) #2 /html/shopware-staging/engine/Shopware/Core/sAdmin.php(2607): Doctrine\DBAL\Query\QueryBuilder->execute() #3 /html/shopware-staging/engine/Shopware/Core/sAdmin.php(2706): sAdmin->sGetDispatchBasket(2, NULL, NULL) #4 /html/shopware-staging/engine/Shopware/Controllers/Frontend/Checkout.php(1572): sAdmin->sGetPremiumDispatches(2, NULL, NULL) #5 /html/shopware-staging/engine/Shopware/Controllers/Frontend/Checkout.php(1707): Shopware_Controllers_Frontend_Checkout->getSelectedDispatch() #6 /html/shopware-staging/engine/Library/Enlight/Controller/Action.php(192): Shopware_Controllers_Frontend_Checkout->ajaxCartAction() #7 /html/shopware-staging/engine/Library/Enlight/Controller/Dispatcher/Default.php(478): Enlight_Controller_Action->dispatch(‚ajaxCartAction‘) #8 /html/shopware-staging/engine/Library/Enlight/Controller/Front.php(228): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #9 /html/shopware-staging/engine/Shopware/Kernel.php(188): Enlight_Controller_Front->dispatch() #10 /html/shopware-staging/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #11 /html/shopware-staging/vendor/symfony/http-kernel/HttpCache/HttpCache.php(453): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true) #12 /html/shopware-staging/engine/Shopware/Components/HttpCache/AppCache.php(261): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #13 /html/shopware-staging/vendor/symfony/http-kernel/HttpCache/HttpCache.php(426): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #14 /html/shopware-staging/vendor/symfony/http-kernel/HttpCache/HttpCache.php(317): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true) #15 /html/shopware-staging/engine/Shopware/Components/HttpCache/AppCache.php(188): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #16 /html/shopware-staging/vendor/symfony/http-kernel/HttpCache/HttpCache.php(192): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #17 /html/shopware-staging/engine/Shopware/Components/HttpCache/AppCache.php(113): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #18 /html/shopware-staging/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #19 {main} Next Doctrine\DBAL\DBALException: An exception occurred while executing ‚SELECT MIN(d.instock>=b.quantity) as instock, MIN(d.instock>=(b.quantity+d.stockmin)) as stockmin, MIN(a.laststock) as laststock, SUM(d.weightb.quantity) as weight, SUM(IF(a.id,b.quantity,0)) as count_article, MAX(b.shippingfree) as shippingfree, SUM(IF(b.modus=0,b.quantityROUND(CAST(b.price as DECIMAL(10,2))(100+t.tax)/100,2)/b.currencyFactor,0)) as amount, SUM(IF(b.modus=0,b.quantityCAST(b.price as DECIMAL(10,2))/b.currencyFactor,0)) as amount_net, SUM(CAST(b.price as DECIMAL(10,2))b.quantity) as amount_display, MAX(d.length) as length, MAX(d.height) as height, MAX(d.width) as width, u.id as userID, MAX(a.topseller) as has_topseller, MAX(at.attr3) as has_comment, MAX(b.esdarticle) as has_esd, (’’) as calculation_value_19, (’’) as calculation_value_20, (’’) as calculation_value_21, (’’) as calculation_value_22, (’’) as calculation_value_23, (’’) as calculation_value_25, (SUM(IF(at.attr5 != 1,b.priceb.quantity,0)) as calculation_value_27, (‘’) as calculation_value_61 FROM s_order_basket b LEFT JOIN s_articles a ON b.articleID = a.id AND b.modus = 0 AND b.esdarticle = 0 LEFT JOIN s_user u ON u.id = ? AND u.active = 1 LEFT JOIN s_articles_details d ON (d.ordernumber = b.ordernumber) AND d.articleID = a.id LEFT JOIN s_core_tax t ON t.id = a.taxID LEFT JOIN s_articles_attributes at ON at.articledetailsID = d.id 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 b.sessionID = ? GROUP BY b.sessionID’ with params (1212, 1521, 1521, „5p02o57voar7p9j8qp4500v52c“): 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 ‚as calculation_value_27, (‘’) as calculation_value_61 FROM s_order_basket b LEFT’ at line 1 in /html/shopware-staging/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:179 Stack trace: #0 /html/shopware-staging/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(150): Doctrine\DBAL\DBALException::wrapException(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), ‚An exception oc…‘) #1 /html/shopware-staging/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(915): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), ‚SELECT MIN(d.in…‘, Array) #2 /html/shopware-staging/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): Doctrine\DBAL\Connection->executeQuery(‚SELECT MIN(d.in…‘, Array, Array) #3 /html/shopware-staging/engine/Shopware/Core/sAdmin.php(2607): Doctrine\DBAL\Query\QueryBuilder->execute() #4 /html/shopware-staging/engine/Shopware/Core/sAdmin.php(2706): sAdmin->sGetDispatchBasket(2, NULL, NULL) #5 /html/shopware-staging/engine/Shopware/Controllers/Frontend/Checkout.php(1572): sAdmin->sGetPremiumDispatches(2, NULL, NULL) #6 /html/shopware-staging/engine/Shopware/Controllers/Frontend/Checkout.php(1707): Shopware_Controllers_Frontend_Checkout->getSelectedDispatch() #7 /html/shopware-staging/engine/Library/Enlight/Controller/Action.php(192): Shopware_Controllers_Frontend_Checkout->ajaxCartAction() #8 /html/shopware-staging/engine/Library/Enlight/Controller/Dispatcher/Default.php(478): Enlight_Controller_Action->dispatch(‚ajaxCartAction‘) #9 /html/shopware-staging/engine/Library/Enlight/Controller/Front.php(228): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #10 /html/shopware-staging/engine/Shopware/Kernel.php(188): Enlight_Controller_Front->dispatch() #11 /html/shopware-staging/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #12 /html/shopware-staging/vendor/symfony/http-kernel/HttpCache/HttpCache.php(453): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true) #13 /html/shopware-staging/engine/Shopware/Components/HttpCache/AppCache.php(261): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #14 /html/shopware-staging/vendor/symfony/http-kernel/HttpCache/HttpCache.php(426): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #15 /html/shopware-staging/vendor/symfony/http-kernel/HttpCache/HttpCache.php(317): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true) #16 /html/shopware-staging/engine/Shopware/Components/HttpCache/AppCache.php(188): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #17 /html/shopware-staging/vendor/symfony/http-kernel/HttpCache/HttpCache.php(192): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #18 /html/shopware-staging/engine/Shopware/Components/HttpCache/AppCache.php(113): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #19 /html/shopware-staging/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #20 {main} {„uid“:„6539318“}
