Fatal error: Uncaught 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_19, (300 * b.quantity) as calculation_value_20 FROM ' at line 1 in /html/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:907 Stack trace: #0 /html/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(907): PDOStatement->execute() #1 /html/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): Doctrine\DBAL\Connection->executeQuery('SELECT MIN(d.in...', Array, Array) #2 /html/shopware/engine/Shopware/Core/sAdmin.php(2600): Doctrine\DBAL\Query\QueryBuilder->execute() #3 /html/shopware/engine/Shopware/Core/sAdmin.php(2699): sAdmin->sGetDispatchBasket('2', NULL, NULL) #4 /html/shopware/custom/plugins/BestitKlarnaPayments/Subscriber/Frontend/Detail.php(127): sAdmin->sGetPremiumDispatches('2') #5 /html/shopware/engine/Library/Enlight/Event/Handler/Default.php(87): BestitKlarnaPayments\Subscriber\Frontend\Detail->addNormalizedInstantShoppingPayLoadToView(Object(Enlight_Controller_ActionEventArgs)) #6 /html/shopware/engine/Library/Enlight/Event/EventManager.php(214): Enlight_Event_Handler_Default->execute(Object(Enlight_Controller_ActionEventArgs)) #7 /html/shopware/engine/Library/Enlight/Controller/Action.php(207): Enlight_Event_EventManager->notify('Enlight_Control...', Object(Enlight_Controller_ActionEventArgs)) #8 /html/shopware/engine/Library/Enlight/Controller/Dispatcher/Default.php(478): Enlight_Controller_Action->dispatch('indexAction') #9 /html/shopware/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/engine/Shopware/Kernel.php(188): Enlight_Controller_Front->dispatch() #11 /html/shopware/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #12 /html/shopware/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/engine/Shopware/Components/HttpCache/AppCache.php(261): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #14 /html/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(426): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #15 /html/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(317): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true) #16 /html/shopware/engine/Shopware/Components/HttpCache/AppCache.php(188): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #17 /html/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(192): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #18 /html/shopware/engine/Shopware/Components/HttpCache/AppCache.php(113): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #19 /html/shopware/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #20 {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.weight*b.quantity) as weight, SUM(IF(a.id,b.quantity,0)) as count_article, MAX(b.shippingfree) as shippingfree, SUM(IF(b.modus=0,b.quantity*CAST(b.price as DECIMAL(10,2))/b.currencyFactor,0)) as amount, SUM(IF(b.modus=0,b.quantity*ROUND(CAST(b.price as DECIMAL(10,2))/(100+t.tax)*100,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, MIN(at.attr15='sperrgut') as sperrgut, MIN(at.attr15='stueckgut') as stueckgut, MIN(at.attr15='palette') as palette, at.attr17 as gewichtsstufe, SUM(b.quantity * at.attr17) AS gesamtgewicht, (IF(SUM(at.attr17*b.quantity) <= 30, 0, 9.9)) as calculation_value_9, (IF(SUM(at.attr17 * b.quantity) < 30, 9.9, 49.9)) as calculation_value_10, (49 * b.quantity) as calculation_value_11, (IF(at.attr15='palette',49 * b.quantity,49)) as calculation_value_12, (IF(SUM(at.attr17*b.quantity) <= 2, 14,IF(SUM(at.attr17*b.quantity) <= 5, 16, IF(SUM(at.attr17*b.quantity) <= 10, 18, IF(SUM(at.attr17*b.quantity) <= 20, 23, IF(SUM(at.attr17*b.quantity) <= 30, 28, 55)))))) as calculation_value_13, (IF(SUM(at.attr17 * b.quantity) <= 5, b.quantity * 40, IF(SUM(at.attr17 * b.quantity) <= 10, b.quantity * 45, IF(SUM(at.attr17 * b.quantity) <= 20, b.quantity * 50, IF(SUM(at.attr17 * b.quantity) <= 30, b.quantity * 55, IF(SUM(at.attr17 * b.quantity) <= 40, b.quantity * 200, b.quantity * 200)))))) as calculation_value_14, (250 * b.quantity) as calculation_value_15, (IF(at.attr15='palette',120 * b.quantity,120)) as calculation_value_16, (IF(SUM(at.attr17*b.quantity) <= 2, 15,IF(SUM(at.attr17*b.quantity) <= 5, 18, IF(SUM(at.attr17*b.quantity) <= 10, 22, IF(SUM(at.attr17*b.quantity) <= 20, 30, IF(SUM(at.attr17*b.quantity) <= 30, 38, 80)))))) as calculation_value_17, (IF(at.attr15='palette', 350 * b.quantity, 350)) as calculation_value_18, (IF(SUM(at.attr17 * b.quantity) <= 2, b.quantity * 40, IF(SUM(at.attr17 * b.quantity) <= 5, b.quantity * 45, IF(SUM(at.attr17 * b.quantity) <= 10, b.quantity * 50, IF(SUM(at.attr17 * b.quantity) <= 20, b.quantity * 55, IF(SUM(at.attr17 * b.quantity) <= 30, b.quantity * 65, IF(SUM(at.attr17 * b.quantity) <= 40, b.quantity * 300)))))) as calculation_value_19, (300 * b.quantity) as calculation_value_20 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 [null, 0, 0, "7fab61ea99356f6799056a76846a92f65d7036847da815d05e47c199a5494552"]: 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_19, (300 * b.quantity) as calculation_value_20 FROM ' at line 1 in /html/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:179 Stack trace: #0 /html/shopware/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/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/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): Doctrine\DBAL\Connection->executeQuery('SELECT MIN(d.in...', Array, Array) #3 /html/shopware/engine/Shopware/Core/sAdmin.php(2600): Doctrine\DBAL\Query\QueryBuilder->execute() #4 /html/shopware/engine/Shopware/Core/sAdmin.php(2699): sAdmin->sGetDispatchBasket('2', NULL, NULL) #5 /html/shopware/custom/plugins/BestitKlarnaPayments/Subscriber/Frontend/Detail.php(127): sAdmin->sGetPremiumDispatches('2') #6 /html/shopware/engine/Library/Enlight/Event/Handler/Default.php(87): BestitKlarnaPayments\Subscriber\Frontend\Detail->addNormalizedInstantShoppingPayLoadToView(Object(Enlight_Controller_ActionEventArgs)) #7 /html/shopware/engine/Library/Enlight/Event/EventManager.php(214): Enlight_Event_Handler_Default->execute(Object(Enlight_Controller_ActionEventArgs)) #8 /html/shopware/engine/Library/Enlight/Controller/Action.php(207): Enlight_Event_EventManager->notify('Enlight_Control...', Object(Enlight_Controller_ActionEventArgs)) #9 /html/shopware/engine/Library/Enlight/Controller/Dispatcher/Default.php(478): Enlight_Controller_Action->dispatch('indexAction') #10 /html/shopware/engine/Library/Enlight/Controller/Front.php(228): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #11 /html/shopware/engine/Shopware/Kernel.php(188): Enlight_Controller_Front->dispatch() #12 /html/shopware/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #13 /html/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(453): 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(261): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #15 /html/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(426): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #16 /html/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(317): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true) #17 /html/shopware/engine/Shopware/Components/HttpCache/AppCache.php(188): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #18 /html/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(192): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #19 /html/shopware/engine/Shopware/Components/HttpCache/AppCache.php(113): 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} thrown in /html/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 179