# Bestimmte Artikel von der Versandkostenfrei-Summe ausschließen

**URL:** <https://forum.shopware.com/t/bestimmte-artikel-von-der-versandkostenfrei-summe-ausschliessen/89306>\
**Category:** Allgemein\
**Created:** [21. Juli 2021 um 13:37 UTC](https://forum.shopware.com/t/bestimmte-artikel-von-der-versandkostenfrei-summe-ausschliessen/89306 "2021-07-21T13:37:48Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Henrik\_smp4u](https://avatars.discourse-cdn.com/v4/letter/h/258eb7/32.png) [@Henrik\_smp4u](https://forum.shopware.com/u/Henrik_smp4u)\
**Post date:** [21. Juli 2021 um 13:37 UTC](https://forum.shopware.com/t/bestimmte-artikel-von-der-versandkostenfrei-summe-ausschliessen/89306/1 "2021-07-21T13:37:48Z")

</div>

Hallo Zusammen,  
wir möchten gerne einige Artikel aus der Berechnung der Versandkostenfrei-Summe ausschließen. Dabei bin ich nach dieser Anleitung vorgegangen:

[https://docs.shopware.com/de/shopware-5-de/versand-und-zahlungsarten/individuelle-versandkosten#bestimmte-artikel-von-der-versandkostenfrei-summe-ausschliessen](https://docs.shopware.com/de/shopware-5-de/versand-und-zahlungsarten/individuelle-versandkosten#bestimmte-artikel-von-der-versandkostenfrei-summe-ausschliessen)

Ich habe in der Freitextfeldverwaltung das Feld „attr5“ als Checkbox konfiguriert. Wenn diese bei einem Artikel angehakt ist, soll dieser nicht in die Berechnung einfließen.  
Bei den Einstellungen der Versandkosten ist die Berechnungsart „Eigene Berechnung ausgewählt“. Die Staffelung ist 0 bis beliebig, wobei der Wert der Versandkosten frei gelassen ist und der Faktor 100 eingetragen ist. In den erweiterten Einstellungen habe ich, analog zur Anleitung, folgendes unter „eigene Berechnung“ eingetragen:

> IF(SUM(IF(at.attr5 != ‚1‘,b.price\*b.quantity,0))\<75,4.95,0)

Leider hat das ganze keine Auswirkungen auf die Berechnung der Versandkosten. Es werden immer die 4,95 berechnet, egal ob das Freitextfeld angehakt ist oder nicht.

Habe ich etwas übersehen?

---

<div class="post-metadata">

**Author:** ![Henrik\_smp4u](https://avatars.discourse-cdn.com/v4/letter/h/258eb7/32.png) [@Henrik\_smp4u](https://forum.shopware.com/u/Henrik_smp4u)\
**Post date:** [17. August 2021 um 09:16 UTC](https://forum.shopware.com/t/bestimmte-artikel-von-der-versandkostenfrei-summe-ausschliessen/89306/2 "2021-08-17T09:16:59Z")

</div>

Hat keiner eine Idee? ☹

---

<div class="post-metadata">

**Author:** ![kontakt3](https://avatars.discourse-cdn.com/v4/letter/k/bc8723/32.png) [@kontakt3](https://forum.shopware.com/u/kontakt3)\
**Post date:** [17. September 2021 um 16:22 UTC](https://forum.shopware.com/t/bestimmte-artikel-von-der-versandkostenfrei-summe-ausschliessen/89306/3 "2021-09-17T16:22:32Z")

</div>

Es gibt eine andere Lösung, bei der das Freitextfeld nicht als Checkbox konfiguriert wird sondern als Feld, wo der gewünschte Versandkostenwert eingetragen wird. Habe sie aber gerade nicht bei der Hand.

---

<div class="post-metadata">

**Author:** ![phil](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/phil/32/13661_2.png) [@phil](https://forum.shopware.com/u/phil)\
**Post date:** [18. September 2021 um 06:49 UTC](https://forum.shopware.com/t/bestimmte-artikel-von-der-versandkostenfrei-summe-ausschliessen/89306/4 "2021-09-18T06:49:08Z")

</div>

Ich tippe auf ein Problem mit den Datentypen. Freitextfeld als Checkbox ist vermutlich kein String, sondern numerisch. Probier mal folgendes:

```auto
IF(SUM(IF(at.attr5 != 1,b.price*b.quantity,0))<75,4.95,0)

```

Und natürlich muss mit dieser Formel der Gesamtwert aller Artikel im Warenkorb, die nicht von Versandkostenfrei ausgenommen sind, 75€ übersteigen, damit die Versandkosten entfallen.

LG Phil

---

<div class="post-metadata">

**Author:** ![Henrik\_smp4u](https://avatars.discourse-cdn.com/v4/letter/h/258eb7/32.png) [@Henrik\_smp4u](https://forum.shopware.com/u/Henrik_smp4u)\
**Post date:** [20. September 2021 um 09:22 UTC](https://forum.shopware.com/t/bestimmte-artikel-von-der-versandkostenfrei-summe-ausschliessen/89306/5 "2021-09-20T09:22:10Z")

</div>

Leider klappt es so auch nicht, aber dennoch vielen Dank für die Mühe 🙂

---

<div class="post-metadata">

**Author:** ![phil](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/phil/32/13661_2.png) [@phil](https://forum.shopware.com/u/phil)\
**Post date:** [20. September 2021 um 10:11 UTC](https://forum.shopware.com/t/bestimmte-artikel-von-der-versandkostenfrei-summe-ausschliessen/89306/6 "2021-09-20T10:11:46Z")

</div>

Schick bitte mal nen Screenshot von deinen Einstellungen.

---

<div class="post-metadata">

**Author:** ![Henrik\_smp4u](https://avatars.discourse-cdn.com/v4/letter/h/258eb7/32.png) [@Henrik\_smp4u](https://forum.shopware.com/u/Henrik_smp4u)\
**Post date:** [21. September 2021 um 08:14 UTC](https://forum.shopware.com/t/bestimmte-artikel-von-der-versandkostenfrei-summe-ausschliessen/89306/7 "2021-09-21T08:14:32Z")

</div>

![1](https://europe1.discourse-cdn.com/flex013/uploads/shopware/original/2X/7/761e92d5cf9b371c4989d95e22afb78dc63664c4.png)  
 ![2](https://europe1.discourse-cdn.com/flex013/uploads/shopware/original/2X/9/93699203239e50f66dfce88d418354ca84196686.png)

---

<div class="post-metadata">

**Author:** ![phil](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/phil/32/13661_2.png) [@phil](https://forum.shopware.com/u/phil)\
**Post date:** [21. September 2021 um 08:44 UTC](https://forum.shopware.com/t/bestimmte-artikel-von-der-versandkostenfrei-summe-ausschliessen/89306/8 "2021-09-21T08:44:04Z")

</div>

Sieht soweit OK aus. Setz die Berechnung mal testweise auf  
`SUM(IF(at.attr5 != 1,b.price*b.quantity,0)`  
Die Versandkosten müssten dann gleich dem Warenkorbwert aller zu berücksichtigenden Artikel entsprechen. Werden dann die Versandkosten mit mehr als 75€ angezeigt?

LG Phil

---

<div class="post-metadata">

**Author:** ![Henrik\_smp4u](https://avatars.discourse-cdn.com/v4/letter/h/258eb7/32.png) [@Henrik\_smp4u](https://forum.shopware.com/u/Henrik_smp4u)\
**Post date:** [23. September 2021 um 14:06 UTC](https://forum.shopware.com/t/bestimmte-artikel-von-der-versandkostenfrei-summe-ausschliessen/89306/9 "2021-09-23T14:06:53Z")

</div>

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.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_ROUND(CAST(b.price as DECIMAL(10,2))_(100+t.tax)/100,2)/b.currencyFactor,0)) as amount, SUM(IF(b.modus=0,b.quantity_CAST(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.price_b.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.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_ROUND(CAST(b.price as DECIMAL(10,2))_(100+t.tax)/100,2)/b.currencyFactor,0)) as amount, SUM(IF(b.modus=0,b.quantity_CAST(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.price_b.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.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_ROUND(CAST(b.price as DECIMAL(10,2))_(100+t.tax)/100,2)/b.currencyFactor,0)) as amount, SUM(IF(b.modus=0,b.quantity_CAST(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.price_b.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.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_ROUND(CAST(b.price as DECIMAL(10,2))_(100+t.tax)/100,2)/b.currencyFactor,0)) as amount, SUM(IF(b.modus=0,b.quantity_CAST(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.price_b.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.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_ROUND(CAST(b.price as DECIMAL(10,2))_(100+t.tax)/100,2)/b.currencyFactor,0)) as amount, SUM(IF(b.modus=0,b.quantity_CAST(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.price_b.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.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_ROUND(CAST(b.price as DECIMAL(10,2))_(100+t.tax)/100,2)/b.currencyFactor,0)) as amount, SUM(IF(b.modus=0,b.quantity_CAST(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.price_b.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“}