# Erledigt Warenkorb geht nicht mehr läd läd und läd

**URL:** <https://forum.shopware.com/t/erledigt-warenkorb-geht-nicht-mehr-laed-laed-und-laed/95083>\
**Category:** Shopware 5\
**Created:** [2. Juli 2022 um 07:58 UTC](https://forum.shopware.com/t/erledigt-warenkorb-geht-nicht-mehr-laed-laed-und-laed/95083 "2022-07-02T07:58:51Z")\
**Posts on this page:** 1\
**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:** [2. Juli 2022 um 07:58 UTC](https://forum.shopware.com/t/erledigt-warenkorb-geht-nicht-mehr-laed-laed-und-laed/95083/1 "2022-07-02T07:58:51Z")

</div>

Erledigt es war ein Fehler in den eigenden Bedingungen der Versandkosten

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`,‚4.650‘ as `weight`,‚2‘ as `count_article`,‚0‘ as `shippingfree`,‚253.25‘ as `amount`,‚212.81‘ as `amount_net`,‚253.25‘ as `amount_display`,‘’ as `length`,‚‘ as `height`,‚‘ as `width`,‚2315‘ as `userID`,‚0‘ as `has_topseller`,‚‘ as `has_comment`,‚0‘ as `has_esd`,‚0‘ as `allshippingfree`,‚‘ as `MIN((SELECT 2 FROM s_articles_categories WHERE articleID=a.id AND categoryID=128))`,‚‘ as `NCAufschlag`,‚19‘ as `max_tax`,‚0‘ as `basketStateId`,‚2‘ as `countryID`,‚25‘ as `paymentID`,‚1‘ as `customergroupID`,‚1‘ as `multishopID`,‚e9bbc9d7c2bc34f0aafde61d55f31165‘ 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 != 53 OR ({$offerPosition.trackingcode}))) GROUP BY d.id ORDER BY d.position, d.name ASC’ with params („e9bbc9d7c2bc34f0aafde61d55f31165“, 2513, 2513):

SQLSTATE(42000): Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‚}))) GROUP BY d.id ORDER BY d.position, d.name ASC‘ at line 13

{  
„uri“: „/checkout/ajaxCart“,  
„method“: „GET“,  
„query“: {  
„module“: „frontend“,  
„controller“: „checkout“,  
„action“: „ajaxCart“  
},  
„post“:   
}

* * *