# Syntax Fehler

**URL:** <https://forum.shopware.com/t/syntax-fehler/25750>\
**Category:** Shopware 3.5\
**Tags:** installation--gettin\
**Created:** [20. März 2015 um 17:32 UTC](https://forum.shopware.com/t/syntax-fehler/25750 "2015-03-20T17:32:16Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![e-commerce](https://avatars.discourse-cdn.com/v4/letter/e/5f8ce5/32.png) [@e-commerce](https://forum.shopware.com/u/e-commerce)\
**Post date:** [20. März 2015 um 17:32 UTC](https://forum.shopware.com/t/syntax-fehler/25750/1 "2015-03-20T17:32:16Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Shopwareianer](https://avatars.discourse-cdn.com/v4/letter/s/b4bc9f/32.png) [@Shopwareianer](https://forum.shopware.com/u/Shopwareianer)\
**Post date:** [20. März 2015 um 17:39 UTC](https://forum.shopware.com/t/syntax-fehler/25750/2 "2015-03-20T17:39:02Z")

</div>

Welche MySQL Version nutzt ihr ?

---

<div class="post-metadata">

**Author:** ![e-commerce](https://avatars.discourse-cdn.com/v4/letter/e/5f8ce5/32.png) [@e-commerce](https://forum.shopware.com/u/e-commerce)\
**Post date:** [21. März 2015 um 20:08 UTC](https://forum.shopware.com/t/syntax-fehler/25750/3 "2015-03-21T20:08:56Z")

</div>

[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

---

<div class="post-metadata">

**Author:** ![e-commerce](https://avatars.discourse-cdn.com/v4/letter/e/5f8ce5/32.png) [@e-commerce](https://forum.shopware.com/u/e-commerce)\
**Post date:** [23. März 2015 um 08:47 UTC](https://forum.shopware.com/t/syntax-fehler/25750/4 "2015-03-23T08:47:56Z")

</div>

Fehler lag bei der Berechnungsformel, wo eine Klammer fehlte.