Hallo,
wir haben letzte Woche Shopware auf Version 5.2.2 geupdatet, seitdem funktioniert die Zahlart Rechnung nicht mehr.
Im Shopware Log kommt folgender Fehler:
core.ERROR: exception ‚Doctrine\ORM\Query\QueryException‘ with message ‚SELECT orders, details, documents, payment, customer, paymentInstances, shipping, billing, billingCountry, shippingCountry, shop, dispatch, paymentStatus, orderStatus, documentType, billingAttribute, attribute, detailAttribute, documentAttribute, shippingAttribute, paymentAttribute, dispatchAttribute, subShop, locale, customerBilling FROM Shopware\Models\Order\Order orders LEFT JOIN orders.details details LEFT JOIN orders.documents documents LEFT JOIN documents.type documentType LEFT JOIN orders.payment payment LEFT JOIN orders.paymentStatus paymentStatus LEFT JOIN orders.orderStatus orderStatus LEFT JOIN orders.customer customer LEFT JOIN orders.paymentInstances paymentInstances LEFT JOIN orders.billing billing LEFT JOIN billing.country billingCountry LEFT JOIN orders.shipping shipping LEFT JOIN orders.shop shop LEFT JOIN orders.dispatch dispatch LEFT JOIN payment.attribute paymentAttribute LEFT JOIN dispatch.attribute dispatchAttribute LEFT JOIN billing.attribute billingAttribute LEFT JOIN shipping.attribute shippingAttribute LEFT JOIN details.attribute detailAttribute LEFT JOIN documents.attribute documentAttribute LEFT JOIN orders.attribute attribute LEFT JOIN orders.languageSubShop subShop LEFT JOIN subShop.locale locale LEFT JOIN shipping.country shippingCountry LEFT JOIN customer.billing customerBilling WHERE orders.status NOT IN(‘-1’) AND orders.number IS NOT NULL AND (orders.number = ?1 OR customerBilling.number = ?1 OR billing.company = ?1 OR billing.firstName = ?1 OR billing.lastName = ?1 OR billing.zipCode = ?1 OR billing.city = ?1)’ in /htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:41 Stack trace: #0 /htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(483): Doctrine\ORM\Query\QueryException::dqlError(‚SELECT orders, …‘) #1 /htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(759): Doctrine\ORM\Query\Parser->semanticalError(‚Class Shopware\…‘, Array) #2 /htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(279): Doctrine\ORM\Query\Parser->processDeferredPathExpressions(Object(Doctrine\ORM\Query\AST\SelectStatement)) #3 /htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(351): Doctrine\ORM\Query\Parser->getAST() #4 /htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(281): Doctrine\ORM\Query\Parser->parse() #5 /htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(293): Doctrine\ORM\Query->_parse() #6 /htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(969): Doctrine\ORM\Query->_doExecute() #7 /htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(924): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 3) #8 /htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(751): Doctrine\ORM\AbstractQuery->execute(NULL, 3) #9 /htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(151): Doctrine\ORM\AbstractQuery->getScalarResult() #10 /htdocs/engine/Shopware/Plugins/Community/Core/GhswShopwareConnect/Components/Api/Resource/GhOrder.php(172): Doctrine\ORM\Tools\Pagination\Paginator->getIterator() #11 /htdocs/engine/Shopware/Plugins/Community/Core/GhswShopwareConnect/Controllers/Api/GhOrders.php(68): Shopware\Components\Api\Resource\GhOrder->getListBySearch(0, 100, Array, Array) #12 /htdocs/engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Api_GhOrders->indexAction() #13 /htdocs/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch(‚indexAction‘) #14 /htdocs/engine/Library/Enlight/Controller/Front.php(226): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #15 /htdocs/engine/Shopware/Kernel.php(176): Enlight_Controller_Front->dispatch() #16 /htdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #17 /htdocs/engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #18 /htdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(444): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #19 /htdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(344): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true) #20 /htdocs/engine/Shopware/Components/HttpCache/AppCache.php(178): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #21 /htdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(210): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #22 /htdocs/engine/Shopware/Components/HttpCache/AppCache.php(114): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #23 /htdocs/shopware.php(101): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #24 {main} Next exception ‚Doctrine\ORM\Query\QueryException‘ with message ‚[Semantical Error] line 0, col 1438 near ‚number = ?1 OR‘: Error: Class Shopware\Models\Customer\Billing has no field or association named number‘ in /htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:63 Stack trace: #0 /htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(483): Doctrine\ORM\Query\QueryException::semanticalError(‚line 0, col 143…‘, Object(Doctrine\ORM\Query\QueryException)) #1 /htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(759): Doctrine\ORM\Query\Parser->semanticalError(‚Class Shopware\…‘, Array) #2 /htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(279): Doctrine\ORM\Query\Parser->processDeferredPathExpressions(Object(Doctrine\ORM\Query\AST\SelectStatement)) #3 /htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(351): Doctrine\ORM\Query\Parser->getAST() #4 /htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(281): Doctrine\ORM\Query\Parser->parse() #5 /htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(293): Doctrine\ORM\Query->_parse() #6 /htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(969): Doctrine\ORM\Query->_doExecute() #7 /htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(924): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 3) #8 /htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(751): Doctrine\ORM\AbstractQuery->execute(NULL, 3) #9 /htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(151): Doctrine\ORM\AbstractQuery->getScalarResult() #10 /htdocs/engine/Shopware/Plugins/Community/Core/GhswShopwareConnect/Components/Api/Resource/GhOrder.php(172): Doctrine\ORM\Tools\Pagination\Paginator->getIterator() #11 /htdocs/engine/Shopware/Plugins/Community/Core/GhswShopwareConnect/Controllers/Api/GhOrders.php(68): Shopware\Components\Api\Resource\GhOrder->getListBySearch(0, 100, Array, Array) #12 /htdocs/engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Api_GhOrders->indexAction() #13 /htdocs/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch(‚indexAction‘) #14 /htdocs/engine/Library/Enlight/Controller/Front.php(226): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #15 /htdocs/engine/Shopware/Kernel.php(176): Enlight_Controller_Front->dispatch() #16 /htdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #17 /htdocs/engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #18 /htdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(444): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #19 /htdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(344): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true) #20 /htdocs/engine/Shopware/Components/HttpCache/AppCache.php(178): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #21 /htdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(210): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #22 /htdocs/engine/Shopware/Components/HttpCache/AppCache.php(114): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #23 /htdocs/shopware.php(101): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #24 {main} {„uid“:„bd3c1de“}
Aufgefallen ist das, weil sich bei den Bestellungen dann die Detailansicht nicht mehr öffnen lässt mit folgdendem JS fehler:
Uncaught TypeError: Cannot read property ‚data‘ of undefined
Zeile: shipping = Ext.create(‚Shopware.apps.Order.model.Shipping‘, billing.data);
Kennt das Problem wer, oder hat das schon mal gehabt?