Hallo,
seit kurzem bekommen Kunden bei mir immer den o.g. Fehler. Die Bestellung werden zwar ausgeführt, ist aber für den Kd. blöd.
Software ist die aktuelle Version 5.2.24
Folgende Fehlermeldung bekomme ich per email:
exception 'Doctrine\ORM\Query\QueryException' with message 'SELECT orders, customer, debit, payment, details, billing, shipping, dispatch FROM Shopware\Models\Order\Order orders LEFT JOIN orders.customer customer LEFT JOIN customer.debit debit LEFT JOIN orders.payment payment LEFT JOIN orders.details details LEFT JOIN orders.billing billing LEFT JOIN orders.shipping shipping LEFT JOIN orders.dispatch dispatch WHERE orders.number = ?1' in /mykfqvqe/www.mykaffee.shop/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:41 Stack trace: #0 /mykfqvqe/www.mykaffee.shop/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(483): Doctrine\ORM\Query\QueryException::dqlError('SELECT orders, ...') #1 /mykfqvqe/www.mykaffee.shop/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1042): Doctrine\ORM\Query\Parser-\>semanticalError('Class Shopware\\...') #2 /mykfqvqe/www.mykaffee.shop/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1734): Doctrine\ORM\Query\Parser-\>JoinAssociationPathExpression() #3 /mykfqvqe/www.mykaffee.shop/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1674): Doctrine\ORM\Query\Parser-\>JoinAssociationDeclaration() #4 /mykfqvqe/www.mykaffee.shop/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1569): Doctrine\ORM\Query\Parser-\>Join() #5 /mykfqvqe/www.mykaffee.shop/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1292): Doctrine\ORM\Query\Parser-\>IdentificationVariableDeclaration() #6 /mykfqvqe/www.mykaffee.shop/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(874): Doctrine\ORM\Query\Parser-\>FromClause() #7 /mykfqvqe/www.mykaffee.shop/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(843): Doctrine\ORM\Query\Parser-\>SelectStatement() #8 /mykfqvqe/www.mykaffee.shop/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(268): Doctrine\ORM\Query\Parser-\>QueryLanguage() #9 /mykfqvqe/www.mykaffee.shop/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(351): Doctrine\ORM\Query\Parser-\>getAST() #10 /mykfqvqe/www.mykaffee.shop/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(281): Doctrine\ORM\Query\Parser-\>parse() #11 /mykfqvqe/www.mykaffee.shop/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(293): Doctrine\ORM\Query-\>\_parse() #12 /mykfqvqe/www.mykaffee.shop/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(969): Doctrine\ORM\Query-\>\_doExecute() #13 /mykfqvqe/www.mykaffee.shop/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(924): Doctrine\ORM\AbstractQuery-\>executeIgnoreQueryCache(NULL, 2) #14 /mykfqvqe/www.mykaffee.shop/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(766): Doctrine\ORM\AbstractQuery-\>execute(NULL, 2) #15 /mykfqvqe/www.mykaffee.shop/engine/Shopware/Plugins/Community/Core/Shopqueue/Bootstrap.php(339): Doctrine\ORM\AbstractQuery-\>getOneOrNullResult(2) #16 /mykfqvqe/www.mykaffee.shop/engine/Shopware/Plugins/Community/Core/Shopqueue/Bootstrap.php(178): Shopware\_Plugins\_Core\_Shopqueue\_Bootstrap-\>sendOrder(20119) #17 /mykfqvqe/www.mykaffee.shop/engine/Library/Enlight/Event/Handler/Plugin.php(149): Shopware\_Plugins\_Core\_Shopqueue\_Bootstrap-\>afterCheckout(Object(Enlight\_Hook\_HookArgs)) #18 /mykfqvqe/www.mykaffee.shop/engine/Library/Enlight/Event/EventManager.php(296): Enlight\_Event\_Handler\_Plugin-\>execute(Object(Enlight\_Hook\_HookArgs)) #19 /mykfqvqe/www.mykaffee.shop/engine/Library/Enlight/Hook/HookManager.php(191): Enlight\_Event\_EventManager-\>filter('sOrder::sSaveOr...', 20119, Object(Enlight\_Hook\_HookArgs)) #20 /mykfqvqe/www.mykaffee.shop/var/cache/production\_201705171506/proxies/sOrderProxy.php(18): Enlight\_Hook\_HookManager-\>executeHooks(Object(Shopware\_Proxies\_sOrderProxy), 'sSaveOrder', Array) #21 /mykfqvqe/www.mykaffee.shop/engine/Shopware/Controllers/Frontend/Checkout.php(839): Shopware\_Proxies\_sOrderProxy-\>sSaveOrder() #22 /mykfqvqe/www.mykaffee.shop/engine/Shopware/Controllers/Frontend/Checkout.php(372): Shopware\_Controllers\_Frontend\_Checkout-\>saveOrder() #23 /mykfqvqe/www.mykaffee.shop/engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Frontend\_Checkout-\>finishAction() #24 /mykfqvqe/www.mykaffee.shop/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight\_Controller\_Action-\>dispatch('finishAction') #25 /mykfqvqe/www.mykaffee.shop/engine/Library/Enlight/Controller/Front.php(223): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #26 /mykfqvqe/www.mykaffee.shop/engine/Shopware/Kernel.php(182): Enlight\_Controller\_Front-\>dispatch() #27 /mykfqvqe/www.mykaffee.shop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(491): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #28 /mykfqvqe/www.mykaffee.shop/engine/Shopware/Components/HttpCache/AppCache.php(266): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #29 /mykfqvqe/www.mykaffee.shop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(258): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #30 /mykfqvqe/www.mykaffee.shop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(275): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #31 /mykfqvqe/www.mykaffee.shop/engine/Shopware/Components/HttpCache/AppCache.php(141): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>invalidate(Object(Symfony\Component\HttpFoundation\Request), true) #32 /mykfqvqe/www.mykaffee.shop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(206): Shopware\Components\HttpCache\AppCache-\>invalidate(Object(Symfony\Component\HttpFoundation\Request), true) #33 /mykfqvqe/www.mykaffee.shop/engine/Shopware/Components/HttpCache/AppCache.php(114): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #34 /mykfqvqe/www.mykaffee.shop/shopware.php(117): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #35 {main} Next exception 'Doctrine\ORM\Query\QueryException' with message '[Semantical Error] line 0, col 178 near 'debit LEFT JOIN': Error: Class Shopware\Models\Customer\Customer has no association named debit' in /mykfqvqe/www.mykaffee.shop/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:63
Bin für jegliche Hilfe/Info dankbar.
Gruß,
Thomas