undefined array key und undefined global variable errors nach Update auf X4.3.4

[eblick]

Habe gerade auf Eclipse 4.3.4 geupdatet, alles caches geleert usw.

jetzt erhalte ich im FE


ErrorException: Warning: Undefined array key "mmenu_top" at templates/layout/fe_page.html5:210 at include('/xxx/templates/layout/fe_page.html5') (vendor/contao/core-bundle/src/Resources/contao/library/Contao/TemplateInheritance.php:108) at Contao\Template->inherit() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Template.php:295) at Contao\Template->parse() (vendor/contao/core-bundle/src/Resources/contao/classes/FrontendTemplate.php:43) at Contao\FrontendTemplate->parse() (vendor/contao/core-bundle/src/Resources/contao/classes/FrontendTemplate.php:116) at Contao\FrontendTemplate->compile() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Template.php:322) at Contao\Template->getResponse() (vendor/contao/core-bundle/src/Resources/contao/classes/FrontendTemplate.php:85) at Contao\FrontendTemplate->getResponse() (vendor/contao/core-bundle/src/Resources/contao/pages/PageRegular.php:62) at Contao\PageRegular->getResponse() (vendor/contao/core-bundle/src/Resources/contao/controllers/FrontendIndex.php:320) at Contao\FrontendIndex->renderPage() (vendor/symfony/http-kernel/HttpKernel.php:163) at Symfony\Component\HttpKernel\HttpKernel->handleRaw() (vendor/symfony/http-kernel/HttpKernel.php:75) at Symfony\Component\HttpKernel\HttpKernel->handle() (vendor/symfony/http-kernel/Kernel.php:202) at Symfony\Component\HttpKernel\Kernel->handle() (web/index.php:44)


und im BE


ErrorException: Warning: Undefined global variable $loadDataContainer at system/modules/pct_customelements_plugin_customcatalog/PCT/CustomElements/Plugins/CustomCatalog/Attributes/AttributeCallbacks.php:515 at PCT\CustomElements\Plugins\CustomCatalog\Attribute s\AttributeCallbacks->getOptionFieldDefinition() (system/modules/pct_customelements_plugin_customcatalog/PCT/CustomElements/Plugins/CustomCatalog/Core/Hooks.php:375) at PCT\CustomElements\Plugins\CustomCatalog\Core\Hook s->getOptionFieldDefinitionHook() at call_user_func_array() (system/modules/pct_customelements_plugin_customcatalog/PCT/CustomElements/Plugins/CustomCatalog/Core/Hooks.php:65) at PCT\CustomElements\Plugins\CustomCatalog\Core\Hook s::callstatic() (system/modules/pct_customelements_plugin_customcatalog/PCT/CustomElements/Plugins/CustomCatalog/Core/SystemIntegration.php:1241) at PCT\CustomElements\Plugins\CustomCatalog\Core\Syst emIntegration::createDCA() (system/modules/pct_customelements_plugin_customcatalog/PCT/CustomElements/Plugins/CustomCatalog/Core/SystemIntegration.php:304) at PCT\CustomElements\Plugins\CustomCatalog\Core\Syst emIntegration->initSystem() (vendor/contao/core-bundle/src/Framework/ContaoFramework.php:405) at Contao\CoreBundle\Framework\ContaoFramework->triggerInitializeSystemHook() (vendor/contao/core-bundle/src/Framework/ContaoFramework.php:307) at Contao\CoreBundle\Framework\ContaoFramework->initializeFramework() (vendor/contao/core-bundle/src/Framework/ContaoFramework.php:122) at Contao\CoreBundle\Framework\ContaoFramework->initialize() (vendor/contao/core-bundle/src/Security/User/ContaoUserProvider.php:68) at Contao\CoreBundle\Security\User\ContaoUserProvider->loadUserByIdentifier() (vendor/contao/core-bundle/src/Security/User/ContaoUserProvider.php:87) at Contao\CoreBundle\Security\User\ContaoUserProvider->refreshUser() (vendor/symfony/security-http/Firewall/ContextListener.php:236) at Symfony\Component\Security\Http\Firewall\ContextLi stener->refreshUser() (vendor/symfony/security-http/Firewall/ContextListener.php:137) at Symfony\Component\Security\Http\Firewall\ContextLi stener->authenticate() (vendor/symfony/security-bundle/Debug/WrappedLazyListener.php:49) at Symfony\Bundle\SecurityBundle\Debug\WrappedLazyLis tener->authenticate() (vendor/symfony/security-http/Firewall/AbstractListener.php:26) at Symfony\Component\Security\Http\Firewall\AbstractL istener->__invoke() (vendor/symfony/security-bundle/Debug/TraceableFirewallListener.php:80) at Symfony\Bundle\SecurityBundle\Debug\TraceableFirew allListener->callListeners() (vendor/symfony/security-http/Firewall.php:92) at Symfony\Component\Security\Http\Firewall->onKernelRequest() (vendor/symfony/event-dispatcher/Debug/WrappedListener.php:118) at Symfony\Component\EventDispatcher\Debug\WrappedLis tener->__invoke() (vendor/symfony/event-dispatcher/EventDispatcher.php:230) at Symfony\Component\EventDispatcher\EventDispatcher->callListeners() (vendor/symfony/event-dispatcher/EventDispatcher.php:59) at Symfony\Component\EventDispatcher\EventDispatcher->dispatch() (vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:154) at Symfony\Component\EventDispatcher\Debug\TraceableE ventDispatcher->dispatch() (vendor/symfony/http-kernel/HttpKernel.php:139) at Symfony\Component\HttpKernel\HttpKernel->handleRaw() (vendor/symfony/http-kernel/HttpKernel.php:75) at Symfony\Component\HttpKernel\HttpKernel->handle() (vendor/symfony/http-kernel/Kernel.php:202) at Symfony\Component\HttpKernel\Kernel->handle() (web/index.php:44)


wo kann das denn plötzlich herkommen?

[eblick]

Doctrine\DBAL\Exception\NonUniqueFieldNameExceptio n: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'type' in where clause is ambiguous at vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:72 at Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert() (vendor/doctrine/dbal/src/Connection.php:1938) at Doctrine\DBAL\Connection->handleDriverException() (vendor/doctrine/dbal/src/Connection.php:1880) at Doctrine\DBAL\Connection->convertExceptionDuringQuery() (vendor/doctrine/dbal/src/Connection.php:1105) at Doctrine\DBAL\Connection->executeQuery() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:279) at Contao\Database\Statement->query() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:235) at Contao\Database\Statement->execute() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Model.php:1096) at Contao\Model::find() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Model.php:962) at Contao\Model::findBy() (system/modules/pct_megamenu/PCT/MegaMenu/Module.php:77) at PCT\MegaMenu\Module->compile() (vendor/contao/core-bundle/src/Resources/contao/modules/Module.php:214) at Contao\Module->generate() (system/modules/pct_megamenu/PCT/MegaMenu/Module.php:57) at PCT\MegaMenu\Module->generate() (system/modules/pct_megamenu/PCT/MegaMenu/ContaoCallbacks.php:56) at PCT\MegaMenu\ContaoCallbacks->replaceInsertTagsCallback() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/InsertTags.php:1172) at Contao\InsertTags->executeReplace() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/InsertTags.php:100) at Contao\InsertTags->replaceInternal() (vendor/contao/core-bundle/src/InsertTag/InsertTagParser.php:77) at Contao\CoreBundle\InsertTag\InsertTagParser->callLegacyClass() (vendor/contao/core-bundle/src/InsertTag/InsertTagParser.php:37) at Contao\CoreBundle\InsertTag\InsertTagParser->replaceChunked() (vendor/contao/core-bundle/src/InsertTag/InsertTagParser.php:32) at Contao\CoreBundle\InsertTag\InsertTagParser->replace() (vendor/contao/core-bundle/src/Resources/contao/classes/FrontendTemplate.php:128) at Contao\FrontendTemplate->compile() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Template.php:322) at Contao\Template->getResponse() (vendor/contao/core-bundle/src/Resources/contao/classes/FrontendTemplate.php:85) at Contao\FrontendTemplate->getResponse() (vendor/contao/core-bundle/src/Resources/contao/pages/PageRegular.php:62) at Contao\PageRegular->getResponse() (vendor/contao/core-bundle/src/Resources/contao/controllers/FrontendIndex.php:320) at Contao\FrontendIndex->renderPage() (vendor/symfony/http-kernel/HttpKernel.php:163) at Symfony\Component\HttpKernel\HttpKernel->handleRaw() (vendor/symfony/http-kernel/HttpKernel.php:75) at Symfony\Component\HttpKernel\HttpKernel->handle() (vendor/symfony/http-kernel/Kernel.php:202) at Symfony\Component\HttpKernel\Kernel->handle() (web/index.php:44)

Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'type' in where clause is ambiguous at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28 at Doctrine\DBAL\Driver\PDO\Exception::new() (vendor/doctrine/dbal/src/Driver/PDO/Connection.php:76) at Doctrine\DBAL\Driver\PDO\Connection->query() (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:33) at Doctrine\DBAL\Driver\Middleware\AbstractConnection Middleware->query() (vendor/doctrine/dbal/src/Logging/Connection.php:43) at Doctrine\DBAL\Logging\Connection->query() (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:33) at Doctrine\DBAL\Driver\Middleware\AbstractConnection Middleware->query() (vendor/symfony/doctrine-bridge/Middleware/Debug/DBAL3/Connection.php:69) at Symfony\Bridge\Doctrine\Middleware\Debug\DBAL3\Con nection->query() (vendor/doctrine/dbal/src/Connection.php:1100) at Doctrine\DBAL\Connection->executeQuery() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:279) at Contao\Database\Statement->query() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:235) at Contao\Database\Statement->execute() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Model.php:1096) at Contao\Model::find() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Model.php:962) at Contao\Model::findBy() (system/modules/pct_megamenu/PCT/MegaMenu/Module.php:77) at PCT\MegaMenu\Module->compile() (vendor/contao/core-bundle/src/Resources/contao/modules/Module.php:214) at Contao\Module->generate() (system/modules/pct_megamenu/PCT/MegaMenu/Module.php:57) at PCT\MegaMenu\Module->generate() (system/modules/pct_megamenu/PCT/MegaMenu/ContaoCallbacks.php:56) at PCT\MegaMenu\ContaoCallbacks->replaceInsertTagsCallback() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/InsertTags.php:1172) at Contao\InsertTags->executeReplace() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/InsertTags.php:100) at Contao\InsertTags->replaceInternal() (vendor/contao/core-bundle/src/InsertTag/InsertTagParser.php:77) at Contao\CoreBundle\InsertTag\InsertTagParser->callLegacyClass() (vendor/contao/core-bundle/src/InsertTag/InsertTagParser.php:37) at Contao\CoreBundle\InsertTag\InsertTagParser->replaceChunked() (vendor/contao/core-bundle/src/InsertTag/InsertTagParser.php:32) at Contao\CoreBundle\InsertTag\InsertTagParser->replace() (vendor/contao/core-bundle/src/Resources/contao/classes/FrontendTemplate.php:128) at Contao\FrontendTemplate->compile() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Template.php:322) at Contao\Template->getResponse() (vendor/contao/core-bundle/src/Resources/contao/classes/FrontendTemplate.php:85) at Contao\FrontendTemplate->getResponse() (vendor/contao/core-bundle/src/Resources/contao/pages/PageRegular.php:62) at Contao\PageRegular->getResponse() (vendor/contao/core-bundle/src/Resources/contao/controllers/FrontendIndex.php:320) at Contao\FrontendIndex->renderPage() (vendor/symfony/http-kernel/HttpKernel.php:163) at Symfony\Component\HttpKernel\HttpKernel->handleRaw() (vendor/symfony/http-kernel/HttpKernel.php:75) at Symfony\Component\HttpKernel\HttpKernel->handle() (vendor/symfony/http-kernel/Kernel.php:202) at Symfony\Component\HttpKernel\Kernel->handle() (web/index.php:44)

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'type' in where clause is ambiguous at vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71 at PDO->query() (vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71) at Doctrine\DBAL\Driver\PDO\Connection->query() (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:33) at Doctrine\DBAL\Driver\Middleware\AbstractConnection Middleware->query() (vendor/doctrine/dbal/src/Logging/Connection.php:43) at Doctrine\DBAL\Logging\Connection->query() (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:33) at Doctrine\DBAL\Driver\Middleware\AbstractConnection Middleware->query() (vendor/symfony/doctrine-bridge/Middleware/Debug/DBAL3/Connection.php:69) at Symfony\Bridge\Doctrine\Middleware\Debug\DBAL3\Con nection->query() (vendor/doctrine/dbal/src/Connection.php:1100) at Doctrine\DBAL\Connection->executeQuery() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:279) at Contao\Database\Statement->query() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:235) at Contao\Database\Statement->execute() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Model.php:1096) at Contao\Model::find() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Model.php:962) at Contao\Model::findBy() (system/modules/pct_megamenu/PCT/MegaMenu/Module.php:77) at PCT\MegaMenu\Module->compile() (vendor/contao/core-bundle/src/Resources/contao/modules/Module.php:214) at Contao\Module->generate() (system/modules/pct_megamenu/PCT/MegaMenu/Module.php:57) at PCT\MegaMenu\Module->generate() (system/modules/pct_megamenu/PCT/MegaMenu/ContaoCallbacks.php:56) at PCT\MegaMenu\ContaoCallbacks->replaceInsertTagsCallback() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/InsertTags.php:1172) at Contao\InsertTags->executeReplace() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/InsertTags.php:100) at Contao\InsertTags->replaceInternal() (vendor/contao/core-bundle/src/InsertTag/InsertTagParser.php:77) at Contao\CoreBundle\InsertTag\InsertTagParser->callLegacyClass() (vendor/contao/core-bundle/src/InsertTag/InsertTagParser.php:37) at Contao\CoreBundle\InsertTag\InsertTagParser->replaceChunked() (vendor/contao/core-bundle/src/InsertTag/InsertTagParser.php:32) at Contao\CoreBundle\InsertTag\InsertTagParser->replace() (vendor/contao/core-bundle/src/Resources/contao/classes/FrontendTemplate.php:128) at Contao\FrontendTemplate->compile() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Template.php:322) at Contao\Template->getResponse() (vendor/contao/core-bundle/src/Resources/contao/classes/FrontendTemplate.php:85) at Contao\FrontendTemplate->getResponse() (vendor/contao/core-bundle/src/Resources/contao/pages/PageRegular.php:62) at Contao\PageRegular->getResponse() (vendor/contao/core-bundle/src/Resources/contao/controllers/FrontendIndex.php:320) at Contao\FrontendIndex->renderPage() (vendor/symfony/http-kernel/HttpKernel.php:163) at Symfony\Component\HttpKernel\HttpKernel->handleRaw() (vendor/symfony/http-kernel/HttpKernel.php:75) at Symfony\Component\HttpKernel\HttpKernel->handle() (vendor/symfony/http-kernel/Kernel.php:202) at Symfony\Component\HttpKernel\Kernel->handle() (web/index.php:44)

[Tim]

Das sind PHP Warnungen im aktiven Debug-Modus. Mag sein, dass die noch nicht erfasst wurden. Ich notier es mir zur Prüfung. Deativiere den Debug-Modus und ggf. display_error auf OFF in PHP, falls das aktiviert ist.

ps. /xxx/templates/layout/fe_page.html5 -> den templates/layout Pfad gibt es ab EX 4.0 nicht mehr (siehe manuelle Update-Schritte)! Bitte Update prüfen

2 Column 'type' in where clause is ambiguous at

Da hatte ich auch ein einziges Mal und habe daraufhin auch das MegaMenü Modul angepasst (das war im August).
Die Version ist allerdings noch nicht ausgerollt, weil ich es nicht erneut aufgetreten ist (keine Tickets etc.) und nicht direkt reproduzierbar war. Ich denke nach vollständigen Update des fe_page Templates aus dem richtigen Ordner, passt es.

Führe erstmal das Update vollständig zu Ende. Zur Not bitte im Ticket melden und ich schicke Dir das Modul in der kommenden Version zu.

[eblick]

Ich habe alle Update Schritte durchgeführt. Das war auch nicht von einer zu alten Version sondern von EX 4.2.1 auf 4.3.4.
Im Layout Ordner sind nur die customized templates. Das passt auch grundsätzlich in anderen Installationen so ohne Probleme.

Ich habe mal die Original fe_page von PCT verwendet, erhalte aber denselben Fehler

[2023-12-19T16:16:46.091426+01:00] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\NonUniqueFieldNameExceptio n: "An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'type' in where clause is ambiguous" at /xxx/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 72 {"exception":"[object] (Doctrine\\DBAL\\Exception\\NonUniqueFieldNameExce ption(code: 1052): An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'type' in where clause is ambiguous at /xxx/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:72)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1052): SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'type' in where clause is ambiguous at /xxx/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'type' in where clause is ambiguous at /xxx/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71)"} []