Version 4.4.48 mitdem Shopsystem Merconis. Ich habe versucht heute die Contao Markrting Suite über den Contao Manager zu installieren , um die Cookie opt-in Möglichkeit nutzen zu können die diese Erweiterung unter annderem auch bietet.Es hat auch ohne Probleme funktioniert. Bein aktualisieren der WebSeite konnte diese aber nicht mehr angezeigt werden
Folgende Meldung finde ich in der Log Datei :
Ich kann damit nichts anfangen, es scheint so wie wenn eine sql Abfrage das Problem wäre .
Ich habe dann das Paket allerdingswieder entfern und alles funktioniert wie vorher.
Vielleicht weiß jemand rat?
[2020-04-10 13:57:38] app.CRITICAL: An exception occurred. {"exception":"[object] (Doctrine\\DBAL\\Exception\\NonUniqueFieldNameExce ption(code: 0): An exception occurred while executing 'SELECT tl_content.*, j1.`id` AS mlJumpTo__id, j1.`pid` AS mlJumpTo__pid, j1.`sorting` AS mlJumpTo__sorting, j1.`tstamp` AS mlJumpTo__tstamp, j1.`title` AS mlJumpTo__title, j1.`alias` AS mlJumpTo__alias, j1.`type` AS mlJumpTo__type, j1.`pageTitle` AS mlJumpTo__pageTitle, j1.`language` AS mlJumpTo__language, j1.`robots` AS mlJumpTo__robots, j1.`description` AS mlJumpTo__description, j1.`redirect` AS mlJumpTo__redirect, j1.`jumpTo` AS mlJumpTo__jumpTo, j1.`redirectBack` AS mlJumpTo__redirectBack, j1.`url` AS mlJumpTo__url, j1.`target` AS mlJumpTo__target, j1.`dns` AS mlJumpTo__dns, j1.`staticFiles` AS mlJumpTo__staticFiles, j1.`staticPlugins` AS mlJumpTo__staticPlugins, j1.`fallback` AS mlJumpTo__fallback, j1.`adminEmail` AS mlJumpTo__adminEmail, j1.`dateFormat` AS mlJumpTo__dateFormat, j1.`timeFormat` AS mlJumpTo__timeFormat, j1.`datimFormat` AS mlJumpTo__datimFormat, j1.`createSitemap` AS mlJumpTo__createSitemap, j1.`sitemapName` AS mlJumpTo__sitemapName, j1.`useSSL` AS mlJumpTo__useSSL, j1.`autoforward` AS mlJumpTo__autoforward, j1.`protected` AS mlJumpTo__protected, j1.`groups` AS mlJumpTo__groups, j1.`includeLayout` AS mlJumpTo__includeLayout, j1.`layout` AS mlJumpTo__layout, j1.`mobileLayout` AS mlJumpTo__mobileLayout, j1.`includeCache` AS mlJumpTo__includeCache, j1.`cache` AS mlJumpTo__cache, j1.`clientCache` AS mlJumpTo__clientCache, j1.`includeChmod` AS mlJumpTo__includeChmod, j1.`cuser` AS mlJumpTo__cuser, j1.`cgroup` AS mlJumpTo__cgroup, j1.`chmod` AS mlJumpTo__chmod, j1.`noSearch` AS mlJumpTo__noSearch, j1.`cssClass` AS mlJumpTo__cssClass, j1.`sitemap` AS mlJumpTo__sitemap, j1.`hide` AS mlJumpTo__hide, j1.`guests` AS mlJumpTo__guests, j1.`tabindex` AS mlJumpTo__tabindex, j1.`accesskey` AS mlJumpTo__accesskey, j1.`published` AS mlJumpTo__published, j1.`start` AS mlJumpTo__start, j1.`stop` AS mlJumpTo__stop, j1.`ls_cnc_languageSelector_correspondingMainLangu agePage` AS mlJumpTo__ls_cnc_languageSelector_correspondingMai nLanguagePage, j1.`ls_shop_useAsCategoryForErp` AS mlJumpTo__ls_shop_useAsCategoryForErp, j1.`ls_shop_currencyBeforeValue` AS mlJumpTo__ls_shop_currencyBeforeValue, j1.`ls_shop_decimalsSeparator` AS mlJumpTo__ls_shop_decimalsSeparator, j1.`ls_shop_thousandsSeparator` AS mlJumpTo__ls_shop_thousandsSeparator, j1.`lsShopOutputDefinitionSet` AS mlJumpTo__lsShopOutputDefinitionSet, j1.`lsShopIncludeLayoutForDetailsView` AS mlJumpTo__lsShopIncludeLayoutForDetailsView, j1.`lsShopLayoutForDetailsView` AS mlJumpTo__lsShopLayoutForDetailsView, j1.`lsShopMobileLayoutForDetailsView` AS mlJumpTo__lsShopMobileLayoutForDetailsView, j1.`cms_root_license` AS mlJumpTo__cms_root_license, j1.`cms_exclude_health_check` AS mlJumpTo__cms_exclude_health_check, j1.`cms_root_key` AS mlJumpTo__cms_root_key, j1.`cms_root_data` AS mlJumpTo__cms_root_data, j1.`cms_root_sign` AS mlJumpTo__cms_root_sign, j1.`cms_mi_views` AS mlJumpTo__cms_mi_views, j1.`cms_mi_reset` AS mlJumpTo__cms_mi_reset FROM tl_content LEFT JOIN tl_page j1 ON tl_content.`mlJumpTo`=j1.id WHERE type in ('cms_overlay') AND ptable='tl_cms_conversion_item' AND invisible='' AND cms_pages_scope!='' AND cms_pages_scope!='none'':\n\nSQLSTATE[23000]: Integrity constraint violation: 1052 Column 'type' in where clause is ambiguous at /var/www/vhosts/www.marktplatzkaernten.at/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:65, Doctrine\\DBAL\\Driver\\PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'type' in where clause is ambiguous at /var/www/vhosts/www.marktplatzkaernten.at/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80, PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'type' in where clause is ambiguous at /var/www/vhosts/www.marktplatzkaernten.at/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:75)"} []
[2020-04-10 13:57:39] request.INFO: Matched route "contao_catch_all". {"route":"contao_catch_all","route_parameters":{"_ scope":"frontend","_token_check":true,"_controller ":"Contao\\CoreBundle\\Controller\\FrontendControl ler::indexAction","_url_fragment":"favicon.ico","_ route":"contao_catch_all"},"request_uri":"https://www.marktplatzkaernten.at/favicon.ico","method":"GET"} []
[2020-04-10 13:57:39] security.INFO: Attempting SimplePreAuthentication. {"key":"frontend","authenticator":"Contao\\CoreBun dle\\Security\\ContaoAuthenticator"} []
[2020-04-10 13:57:39] request.ERROR: Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\NotFoundHtt pException: "Page not found: https://www.marktplatzkaernten.at/favicon.ico" at /var/www/vhosts/www.marktplatzkaernten.at/htdocs/vendor/contao/core-bundle/src/EventListener/ExceptionConverterListener.php line 112 {"exception":"[object] (Symfony\\Component\\HttpKernel\\Exception\\NotFou ndHttpException(code: 0): Page not found: https://www.marktplatzkaernten.at/favicon.ico at /var/www/vhosts/www.marktplatzkaernten.at/htdocs/vendor/contao/core-bundle/src/EventListener/ExceptionConverterListener.php:112, Contao\\CoreBundle\\Exception\\PageNotFoundExcepti on(code: 0): Page not found: https://www.marktplatzkaernten.at/favicon.ico at /var/www/vhosts/www.marktplatzkaernten.at/htdocs/vendor/contao/core-bundle/src/Resources/contao/controllers/FrontendIndex.php:63)"} []
[2020-04-10 14:02:56] request.INFO: Matched route "contao_frontend". {"route":"contao_frontend","route_parameters":{"_t oken_check":true,"_controller":"Contao\\CoreBundle \\Controller\\FrontendController::indexAction","_s cope":"frontend","alias":"home","_route":"contao_f rontend"},"request_uri":"https://www.marktplatzkaernten.at/home.html","method":"GET"} []
[2020-04-10 14:02:56] security.INFO: Attempting SimplePreAuthentication. {"key":"frontend","authenticator":"Contao\\CoreBun dle\\Security\\ContaoAuthenticator"} []
[2020-04-10 14:02:56] app.CRITICAL: An exception occurred. {"exception":"[object] (Doctrine\\DBAL\\Exception\\NonUniqueFieldNameExce ption(code: 0): An exception occurred while executing 'SELECT tl_content.*, j1.`id` AS mlJumpTo__id, j1.`pid` AS mlJumpTo__pid, j1.`sorting` AS mlJumpTo__sorting, j1.`tstamp` AS mlJumpTo__tstamp, j1.`title` AS mlJumpTo__title, j1.`alias` AS mlJumpTo__alias, j1.`type` AS mlJumpTo__type, j1.`pageTitle` AS
Lesezeichen