# \[Semantical Error\] line 0, col 240 near 'currencies LEFT'

**URL:** <https://forum.shopware.com/t/semantical-error-line-0-col-240-near-currencies-left/19410>\
**Category:** Shopware 3.5\
**Tags:** general\
**Created:** [28. März 2014 um 12:55 UTC](https://forum.shopware.com/t/semantical-error-line-0-col-240-near-currencies-left/19410 "2014-03-28T12:55:42Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![eWeniger](https://avatars.discourse-cdn.com/v4/letter/e/9de053/32.png) [@eWeniger](https://forum.shopware.com/u/eWeniger)\
**Post date:** [28. März 2014 um 12:55 UTC](https://forum.shopware.com/t/semantical-error-line-0-col-240-near-currencies-left/19410/1 "2014-03-28T12:55:42Z")

</div>

Hallo, kann jemand weiterhelfen, ich kann mit diesen Meldungen immer nichts anfangen? Was kann ich tun, um das das Frontend wieder funktioniert. [quote] [Semantical Error] line 0, col 240 near ‘currencies LEFT’: Error: Class Shopware\Models\Shop\Shop has no association named currencies in vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php on line 63 Stack trace: #0 vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(483): Doctrine\ORM\Query\QueryException::semanticalError(‘line 0, col 240…’, Object(Doctrine\ORM\Query\QueryException)) #1 vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1042): Doctrine\ORM\Query\Parser-\>semanticalError(‘Class Shopware…’) #2 vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1688): Doctrine\ORM\Query\Parser-\>JoinAssociationPathExpression() #3 vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1628): Doctrine\ORM\Query\Parser-\>JoinAssociationDeclaration() #4 vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1558): Doctrine\ORM\Query\Parser-\>Join() #5 vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1286): Doctrine\ORM\Query\Parser-\>IdentificationVariableDeclaration() #6 vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(874): Doctrine\ORM\Query\Parser-\>FromClause() #7 vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(843): Doctrine\ORM\Query\Parser-\>SelectStatement() #8 vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(268): Doctrine\ORM\Query\Parser-\>QueryLanguage() #9 vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(351): Doctrine\ORM\Query\Parser-\>getAST() #10 vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(255): Doctrine\ORM\Query\Parser-\>parse() #11 vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(267): Doctrine\ORM\Query-\>\_parse() #12 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(794): Doctrine\ORM\Query-\>\_doExecute() #13 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(574): Doctrine\ORM\AbstractQuery-\>execute(NULL, 1) #14 Shopware/Models/Shop/Repository.php(327): Doctrine\ORM\AbstractQuery-\>getResult() #15 Shopware/Plugins/Default/Core/Router/Bootstrap.php(103): Shopware\Models\Shop\Repository-\>getActiveByRequest(Object(Enlight\_Controller\_Request\_RequestHttp)) #16 Enlight/Event/Handler/Plugin.php(149): Shopware\_Plugins\_Core\_Router\_Bootstrap-\>onRouteStartup(Object(Enlight\_Controller\_EventArgs)) #17 Enlight/Event/EventManager.php(211): Enlight\_Event\_Handler\_Plugin-\>execute(Object(Enlight\_Controller\_EventArgs)) #18 Enlight/Controller/Front.php(170): Enlight\_Event\_EventManager-\>notify(‘Enlight\_Control…’, Object(Enlight\_Controller\_EventArgs)) #19 Shopware/Kernel.php(141): Enlight\_Controller\_Front-\>dispatch() #20 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(473): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #21 Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #22 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(430): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #23 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(330): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>fetch(Object(Symfony\Component\HttpFoundation\Request), true) #24 Shopware/Components/HttpCache/AppCache.php(178): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #25 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(194): Shopware\Components\HttpCache\AppCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #26 Shopware/Components/HttpCache/AppCache.php(113): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #27 shopware.php(91): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #28 {main} [/quote]

---

<div class="post-metadata">

**Author:** ![eWeniger](https://avatars.discourse-cdn.com/v4/letter/e/9de053/32.png) [@eWeniger](https://forum.shopware.com/u/eWeniger)\
**Post date:** [28. März 2014 um 13:51 UTC](https://forum.shopware.com/t/semantical-error-line-0-col-240-near-currencies-left/19410/2 "2014-03-28T13:51:44Z")

</div>

Habe per FTP alle Chaches gelöscht, jetzt geht alles wieder. Weiß aber nicht, ob es daran gelegen hat.