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“:
}