Systemwartung und CE?

[Juli_ane]

Hi,

immer wenn ich den "Wizard Updater" ausführen will, bekomme ich diese Fehlermeldung:

An exception occurred while executing 'SELECT * FROM tl_pct_customelement WHERE alias=(SELECT cce_event_box_button FROM tl_cce_customer WHERE id='1') LIMIT 0,1': SQLSTATE[42S22]: Column not found: 1054 Unknown column 'cce_event_box_button' in 'field list'

In der Error.log steht folgendes:

[2018-03-16 10:08:41] request.INFO: Matched route "contao_backend". {"route":"contao_backend","route_parameters":{"_scope":"backend","_token_check":true,"_controller":"Contao\\CoreBundle\\Controller\\BackendController::mainAction","_route":"contao_backend"},"request_uri":"http://dev.intranet.de/contao?do=maintenance&key=wizardupdater&ref=crIjljiB&rt=J60CDNwQa6jHNvVxzW0LmBqLkpnsZnnC0x7fx08BLPQ","method":"HEAD"} []
[2018-03-16 10:08:41] security.INFO: Attempting SimplePreAuthentication. {"key":"backend","authenticator":"Contao\\CoreBundle\\Security\\ContaoAuthenticator"} []
[2018-03-16 10:08:41] request.INFO: Matched route "contao_backend". {"route":"contao_backend","route_parameters":{"_scope":"backend","_token_check":true,"_controller":"Contao\\CoreBundle\\Controller\\BackendController::mainAction","_route":"contao_backend"},"request_uri":"http://dev.intranet.de/contao?do=maintenance&key=wizardupdater&ref=crIjljiB&rt=J60CDNwQa6jHNvVxzW0LmBqLkpnsZnnC0x7fx08BLPQ","method":"GET"} []
[2018-03-16 10:08:41] security.INFO: Attempting SimplePreAuthentication. {"key":"backend","authenticator":"Contao\\CoreBundle\\Security\\ContaoAuthenticator"} []
[2018-03-16 10:08:41] app.CRITICAL: An exception occurred. {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'SELECT * FROM tl_pct_customelement WHERE alias=(SELECT cce_event_box_button FROM tl_cce_customer WHERE id='1') LIMIT 0,1':\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'cce_event_box_button' in 'field list' at /wwwroot.wwwnew/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'cce_event_box_button' in 'field list' at /wwwroot.wwwnew/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:106, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'cce_event_box_button' in 'field list' at /wwwroot.wwwnew/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104)"} []
[2018-03-16 10:09:20] request.INFO: Matched route "contao_backend". {"route":"contao_backend","route_parameters":{"_scope":"backend","_token_check":true,"_controller":"Contao\\CoreBundle\\Controller\\BackendController::mainAction","_route":"contao_backend"},"request_uri":"http://dev.intranet.de/contao?do=maintenance&key=wizardupdater&ref=4b4zo5P4&rt=J60CDNwQa6jHNvVxzW0LmBqLkpnsZnnC0x7fx08BLPQ","method":"HEAD"} []
[2018-03-16 10:09:20] security.INFO: Attempting SimplePreAuthentication. {"key":"backend","authenticator":"Contao\\CoreBundle\\Security\\ContaoAuthenticator"} []
[2018-03-16 10:09:21] request.INFO: Matched route "contao_backend". {"route":"contao_backend","route_parameters":{"_scope":"backend","_token_check":true,"_controller":"Contao\\CoreBundle\\Controller\\BackendController::mainAction","_route":"contao_backend"},"request_uri":"http://dev.intranet.de/contao?do=maintenance&key=wizardupdater&ref=4b4zo5P4&rt=J60CDNwQa6jHNvVxzW0LmBqLkpnsZnnC0x7fx08BLPQ","method":"GET"} []
[2018-03-16 10:09:21] security.INFO: Attempting SimplePreAuthentication. {"key":"backend","authenticator":"Contao\\CoreBundle\\Security\\ContaoAuthenticator"} []
[2018-03-16 10:09:21] app.CRITICAL: An exception occurred. {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'SELECT * FROM tl_pct_customelement WHERE alias=(SELECT cce_event_box_button FROM tl_cce_customer WHERE id='1') LIMIT 0,1':\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'cce_event_box_button' in 'field list' at /wwwroot.wwwnew/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'cce_event_box_button' in 'field list' at /wwwroot.wwwnew/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:106, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'cce_event_box_button' in 'field list' at /wwwroot.wwwnew/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104)"} []

Wo liegt denn da der Fehler?

LG & Danke

[Tim]

Hast anscheinend ein altes Attribut irgendwo liegen.
Warum musst du die Wizards updaten? Hast du hier eine Installation, die ca. 4 Jahre alt ist und bestand CE 1.0 hat?

[Juli_ane]

Nein, dass nicht aber ich bin einfach ein freund von funktionierenden Systemen und die Meldung sagt mir zumindest, dass da noch etwas nicht stimmt, oder?

[Tim]

Wenn du nicht gerade ein 4 Jahre alte Installation hast, ist es nicht nötig. Hast du mal den Beschreibungstext zu dieser Systemwartung gelesen? "Diese Funktion dient besonders dem Updaten älterer CustomElements Daten"

Vielleicht in einem CC ein CE FeldWidget angelegt, später gelöscht, aber nicht die DB geupdated. Per Ferndiagnose nicht feststellbar.