Hallo Ich habe folgende Fehlermeldung im log via Mail erhalten: Next exception 'Zend\_Db\_Statement\_Exception' with message '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\_10 FROM s\_order\_basket b LEFT JOIN' at line 15' in /home/ecommer1/public\_html/wohndesign/shop/engine/Library/Zend/Db/Statement/Pdo.php:234 Stack trace: #0 /home/ecommer1/public\_html/wohndesign/shop/engine/Library/Zend/Db/Statement.php(303): Zend\_Db\_Statement\_Pdo-\>\_execute(Array) #1 /home/ecommer1/public\_html/wohndesign/shop/engine/Library/Zend/Db/Adapter/Abstract.php(480): Zend\_Db\_Statement-\>execute(Array) #2 /home/ecommer1/public\_html/wohndesign/shop/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend\_Db\_Adapter\_Abstract-\>query('\n SE...', Array) #3 /home/ecommer1/public\_html/wohndesign/shop/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(75): Zend\_Db\_Adapter\_Pdo\_Abstract-\>query('\n SE...', Array) #4 /home/ecommer1/public\_html/wohndesign/shop/engine/Library/Zend/Db/Adapter/Abstract.php(756): Enlight\_Components\_Db\_Adapter\_Pdo\_Mysql-\>query('\n SE...', Array) #5 /home/ecommer1/public\_html/wohndesign/shop/engine/core/class/sAdmin.php(3606): Zend\_Db\_Adapter\_Abstract-\>fetchRow('\n SE...', Array) #6 /home/ecommer1/public\_html/wohndesign/shop/engine/core/class/sAdmin.php(3995): sAdmin-\>sGetDispatchBasket('26') #7 /home/ecommer1/public\_html/wohndesign/shop/engine/Shopware/Controllers/Frontend/Checkout.php(646): sAdmin-\>sGetPremiumShippingcosts(Array) #8 /home/ecommer1/public\_html/wohndesign/shop/engine/Shopware/Controllers/Frontend/Checkout.php(658): Shopware\_Controllers\_Frontend\_Checkout-\>getShippingCosts() #9 /home/ecommer1/public\_html/wohndesign/shop/engine/Shopware/Controllers/Frontend/Checkout.php(322): Shopware\_Controllers\_Frontend\_Checkout-\>getBasket() #10 /home/ecommer1/public\_html/wohndesign/shop/engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Frontend\_Checkout-\>addArticleAction() #11 /home/ecommer1/public\_html/wohndesign/shop/engine/Library/Enlight/Controller/Dispatcher/Default.php(528): Enlight\_Controller\_Action-\>dispatch('addArticleActio...') #12 /home/ecommer1/public\_html/wohndesign/shop/engine/Library/Enlight/Controller/Front.php(228): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #13 /home/ecommer1/public\_html/wohndesign/shop/engine/Shopware/Kernel.php(145): Enlight\_Controller\_Front-\>dispatch() #14 /home/ecommer1/public\_html/wohndesign/shop/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(471): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #15 /home/ecommer1/public\_html/wohndesign/shop/engine/Shopware/Components/HttpCache/AppCache.php(257): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #16 /home/ecommer1/public\_html/wohndesign/shop/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(428): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #17 /home/ecommer1/public\_html/wohndesign/shop/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(328): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>fetch(Object(Symfony\Component\HttpFoundation\Request), true) #18 /home/ecommer1/public\_html/wohndesign/shop/engine/Shopware/Components/HttpCache/AppCache.php(179): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #19 /home/ecommer1/public\_html/wohndesign/shop/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(192): Shopware\Components\HttpCache\AppCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #20 /home/ecommer1/public\_html/wohndesign/shop/engine/Shopware/Components/HttpCache/AppCache.php(114): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #21 /home/ecommer1/public\_html/wohndesign/shop/shopware.php(109): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #22 {main} [] {"uid":"2c68712"} Was ist hier überhaupt der Fehler? Wie kann ich dies korrigieren? Im Frontend gelangt man nicht mehr auf den Warenkorb sowie auf den Checkout. (Weder mit Link noch mit Klick auf Warenkorb Icon) Zudem ist auch das Bestellen von Artikeln nicht mehr möglich. Sorry bin komplett neu dabei. Vielen Dank für hilfreiche Antworten.
Welche MySQL Version nutzt ihr ?
[quote=“kayyy”]Welche MySQL Version nutzt ihr ?[/quote] PHP Version 5.5.22 und my SQL 5.5.40 Was ich auch noch gefunden habe ist folgende Einstellung: sql.safe_mode Off
Fehler lag bei der Berechnungsformel, wo eine Klammer fehlte.