# Warenkorb funktioniert nicht mehr

**URL:** <https://forum.shopware.com/t/warenkorb-funktioniert-nicht-mehr/64722>\
**Category:** Administration\
**Created:** [14. Februar 2020 um 17:40 UTC](https://forum.shopware.com/t/warenkorb-funktioniert-nicht-mehr/64722 "2020-02-14T17:40:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sascha81](https://avatars.discourse-cdn.com/v4/letter/s/eb9ed0/32.png) [@sascha81](https://forum.shopware.com/u/sascha81)\
**Post date:** [14. Februar 2020 um 17:40 UTC](https://forum.shopware.com/t/warenkorb-funktioniert-nicht-mehr/64722/1 "2020-02-14T17:40:00Z")

</div>

Hallo wir bekommen seid heute Mail das unser Warenkorb nicht funktioniert, wir bekommen auch errormails&nbsp;

&nbsp;

wo liegt das Problem ?&nbsp;

&nbsp;

```
 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](http://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](http://u.id/) as userID, MAX(a.topseller) as has\_topseller, MAX(at.attr3) as has\_comment, MAX(b.esdarticle) as has\_esd, MIN(b.shippingfree) = 1 AS allshippingfree, FROM s\_order\_basket b LEFT JOIN s\_articles a ON b.articleID = [a.id](http://a.id/) AND b.modus = 0 AND b.esdarticle = 0 LEFT JOIN s\_user u ON [u.id](http://u.id/) = ? AND u.active = 1 LEFT JOIN s\_articles\_details d ON (d.ordernumber = b.ordernumber) AND d.articleID = [a.id](http://a.id/) LEFT JOIN s\_core\_tax t ON [t.id](http://t.id/) = a.taxID LEFT JOIN s\_articles\_attributes at ON at.articledetailsID = [d.id](http://d.id/) LEFT JOIN s\_user\_addresses ub ON ub.user\_id = [u.id](http://u.id/) AND [ub.id](http://ub.id/) = ? LEFT JOIN s\_user\_addresses us ON us.user\_id = [u.id](http://u.id/) AND [us.id](http://us.id/) = ? WHERE b.sessionID = ? GROUP BY b.sessionID' with params (null, 0, 0, "0b564b5302f9af8a4ca7cdee16ceece764cc77441216c8ab2e9f140fcffde495"): 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 'FROM s\_order\_basket b LEFT JOIN s\_articles a ON b.articleID = [a.id](http://a.id/) AND b.modus =' at line 1

```

&nbsp;

wir haben versucht einen Versandkostenpauschale zu erstellen leider ohne Funktion, es sollte auch alles wieder geändert worden sein&nbsp;

---

<div class="post-metadata">

**Author:** ![R4M](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/r4m/32/9983_2.png) [@R4M](https://forum.shopware.com/u/R4M)\
**Post date:** [17. Februar 2020 um 11:52 UTC](https://forum.shopware.com/t/warenkorb-funktioniert-nicht-mehr/64722/2 "2020-02-17T11:52:49Z")

</div>

Hm, bei

```
... MIN(b.shippingfree) = 1 AS allshippingfree, FROM ...

```

ist im Query ein Komma zuviel. Warum das so ist weiß ich allerdings auch nicht. Aber deshalb kommt es zur Fehlermeldung. Vermutlich durch eure Einstellungen verursacht. Also noch mal Einstellungen überprüfen und mal den Cache komplett leeren.

---

<div class="post-metadata">

**Author:** ![sascha81](https://avatars.discourse-cdn.com/v4/letter/s/eb9ed0/32.png) [@sascha81](https://forum.shopware.com/u/sascha81)\
**Post date:** [18. Februar 2020 um 10:30 UTC](https://forum.shopware.com/t/warenkorb-funktioniert-nicht-mehr/64722/3 "2020-02-18T10:30:43Z")

</div>

Danke das wars…