Hallo wir bekommen seid heute Mail das unser Warenkorb nicht funktioniert, wir bekommen auch errormails
wo liegt das Problem ?
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
wir haben versucht einen Versandkostenpauschale zu erstellen leider ohne Funktion, es sollte auch alles wieder geändert worden sein