Bei Bestellabschluss kommt "Ups es ist ein Fehler aufgetreten...

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

In der Meldung steht etwas von Shopqueue Plugin. Mach das mal aus und teste nochmal 

1 Like

@Moritz Naczenski schrieb:

In der Meldung steht etwas von Shopqueue Plugin. Mach das mal aus und teste nochmal 

 

Das war das Problem - Thx!