Hallo zusammen,
habe heute mal die Kopie unseres Shopware Systems (aktuell 5.5.7) in einer Entwicklungsumgebung auf 5.6.9 aktualisiert.
Inkl. PHP Update auf v 7.4.3 und MySQL Update auf 8.0.22
So weit so gut, nun ist es aber so, sobald ich einen Artikel in den Warenkorb lege und zur Kasse gehe (also auf /checkout/confirm), tritt folgendes Problem auf:
(Semantical Error) line 0, col 103 near 'attribute WHERE': Error: Class Shopware\Models\Article\Article has no association named attribute
(Semantical Error) line 0, col 103 near 'attribute WHERE': Error: Class Shopware\Models\Article\Article has no association named attribute
und
Doctrine\ORM\Query\QueryException: SELECT articles, attribute FROM Shopware\Models\Article\Article articles INNER JOIN articles.attribute attribute WHERE articles.id = 78 in /vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:43 Stack trace:
#0 /vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(492): Doctrine\ORM\Query\QueryException::dqlError()
#1 /vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1061): Doctrine\ORM\Query\Parser->semanticalError()
#2 /vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1767): Doctrine\ORM\Query\Parser->JoinAssociationPathExpression()
#3 /vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1701): Doctrine\ORM\Query\Parser->JoinAssociationDeclaration()
#4 /vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1597): Doctrine\ORM\Query\Parser->Join()
#5 /vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1320): Doctrine\ORM\Query\Parser->IdentificationVariableDeclaration()
#6 /vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(879): Doctrine\ORM\Query\Parser->FromClause()
#7 /vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(848): Doctrine\ORM\Query\Parser->SelectStatement()
#8 /vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(261): Doctrine\ORM\Query\Parser->QueryLanguage()
#9 /vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(360): Doctrine\ORM\Query\Parser->getAST()
#10 /vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(286): Doctrine\ORM\Query\Parser->parse()
#11 /vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(298): Doctrine\ORM\Query->_parse()
#12 /vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(968): Doctrine\ORM\Query->_doExecute()
#13 /vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(923): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache()
#14 /vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(750): Doctrine\ORM\AbstractQuery->execute()
#15 /vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(125): Doctrine\ORM\AbstractQuery->getScalarResult()
#16 /engine/Library/Smarty/plugins/function.getattr.php(27): Doctrine\ORM\Tools\Pagination\Paginator->count()
#17 [shopware_path]/var/cache/production_202011060821/templates/frontend_shop_de_de_DE_1_secure_esi/e5/27/49/e527499222337b1d1e5c0e0a74369d8d351d9fbf.string.php(30): smarty_function_getattr()
#18 /engine/Library/Smarty/sysplugins/smarty_internal_templatebase.php(180): content_5fbe7fc0856ff6_17595655()
#19 /engine/Library/Smarty/sysplugins/smarty_internal_template.php(286): Smarty_Internal_TemplateBase->fetch()
#20 [shopware_path]/var/cache/production_202011060821/templates/frontend_shop_de_de_DE_1_secure_esi/08/96/26/0896260563353d1f4a2f0301b3ec3c6b4c02ca2c.snippet.confirm_item_product.tpl.php(216): Smarty_Internal_Template->getSubTemplate()
#21 [shopware_path]/var/cache/production_202011060821/templates/frontend_shop_de_de_DE_1_secure_esi/08/96/26/0896260563353d1f4a2f0301b3ec3c6b4c02ca2c.snippet.confirm_item_product.tpl.php(79): content_5fbe7fc07e33e7_66553454()
#22 /engine/Library/Smarty/sysplugins/smarty_internal_templatebase.php(180): content_5fbe7fc084f0b9_91881495()
#23 /engine/Library/Smarty/sysplugins/smarty_internal_template.php(286): Smarty_Internal_TemplateBase->fetch()
#24 [shopware_path]/var/cache/production_202011060821/templates/frontend_shop_de_de_DE_1_secure/7c/57/8c/7c578cc22799bd0bb6da5abed1eb60562479442b.snippet.index.tpl.php(6526): Smarty_Internal_Template->getSubTemplate()
#25 [shopware_path]/var/cache/production_202011060821/templates/frontend_shop_de_de_DE_1_secure/7c/57/8c/7c578cc22799bd0bb6da5abed1eb60562479442b.snippet.index.tpl.php(1935): content_5fbe7fc05de3d3_05803262()
#26 /engine/Library/Smarty/sysplugins/smarty_internal_templatebase.php(180): content_5fbe7fc07b6170_33789817()
#27 /engine/Library/Enlight/View/Default.php(295): Smarty_Internal_TemplateBase->fetch()
#28 /engine/Library/Enlight/Controller/Plugins/ViewRenderer/Bootstrap.php(212): Enlight_View_Default->render()
#29 /engine/Library/Enlight/Controller/Plugins/ViewRenderer/Bootstrap.php(238): Enlight_Controller_Plugins_ViewRenderer_Bootstrap->renderTemplate()
#30 /engine/Library/Enlight/Controller/Plugins/ViewRenderer/Bootstrap.php(132): Enlight_Controller_Plugins_ViewRenderer_Bootstrap->render()
#31 /engine/Library/Enlight/Event/Handler/Default.php(87): Enlight_Controller_Plugins_ViewRenderer_Bootstrap->onPostDispatch()
#32 /engine/Library/Enlight/Event/EventManager.php(214): Enlight_Event_Handler_Default->execute()
#33 /engine/Library/Enlight/Controller/Action.php(233): Enlight_Event_EventManager->notify()
#34 /engine/Library/Enlight/Controller/Dispatcher/Default.php(478): Enlight_Controller_Action->dispatch()
#35 /engine/Library/Enlight/Controller/Front.php(228): Enlight_Controller_Dispatcher_Default->dispatch()
#36 /engine/Shopware/Kernel.php(188): Enlight_Controller_Front->dispatch()
#37 /vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle()
#38 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(453): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle()
#39 /engine/Shopware/Components/HttpCache/AppCache.php(261): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward()
#40 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(426): Shopware\Components\HttpCache\AppCache->forward()
#41 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(317): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch()
#42 /engine/Shopware/Components/HttpCache/AppCache.php(188): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup()
#43 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(192): Shopware\Components\HttpCache\AppCache->lookup()
#44 /engine/Shopware/Components/HttpCache/AppCache.php(113): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle()
#45 [shopware_path]/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle()
#46
Was ich bereits probiert habe:
- Models für Artikel Attribute neu generieren (Backend und via Console)
- Cache löschen (Backend)
- Responsive Theme verwenden statt eigenes Theme
- Sicherheitsmodus bei Plugins aktivieren
Jedoch leider alles ohne Erfolg.
Langsam bin ich ratlos.
Der Fehler taucht lediglich in der production_core Logfile auf.
Sowohl apache als auch mysql error.logs sind leer.
Jemand eine Idee was hier das Problem ist?
