con4gis - nach Update Probleme mit Backend und Install-Seite

Druckbare Version

22.01.2020, 12:01
bteppan

con4gis - nach Update Probleme mit Backend und Install-Seite

Hallo!
Ich habe leider ein Problem nach dem Update des Tools 'con4gis'.
Die Installation via Contao-Mnager verlief bis zum abschließenden Aufruf der Installationsseite und Aktualisierung der DB ohne Probleme, ich konnte aich noch das Passwort eingeben nur danach gab es eine Fehlermeldung.
Ich komme nun auch nicht mehr ins Backend der Website - hier erscheint nur eine weiße Seite.
Das Frontend funktioniert bis auf jene Seite, in welcher das con4gis-Modul eingebunden wird - ebenfalls Fehlermeldung.

Anbei das Fehlerprotokoll wobei die Zeilen mit der Uhrzeit:
12:40:xx den Fehler beim Aufruf der Seite im Frontend,
12:42:xx den Fehler beim Aufruf des Backends und
12:43:xx den Fehler beim Aufruf der Contao Installationsseite zeigen.

Code:

[2020-01-22 12:40:39] request.INFO: Matched route "contao_index". {"route":"contao_index","route_parameters":{"_token_check":true,"_controller":"Contao\\CoreBundle\\Controller\\FrontendController::indexAction","_scope":"frontend","_route":"contao_index"},"request_uri":"https://www.sewe5.at/","method":"HEAD"} [] [2020-01-22 12:40:39] security.INFO: Attempting SimplePreAuthentication. {"key":"frontend","authenticator":"Contao\\CoreBundle\\Security\\ContaoAuthenticator"} [] [2020-01-22 12:40:39] request.INFO: Matched route "contao_index". {"route":"contao_index","route_parameters":{"_token_check":true,"_controller":"Contao\\CoreBundle\\Controller\\FrontendController::indexAction","_scope":"frontend","_route":"contao_index"},"request_uri":"https://www.sewe5.at/","method":"GET"} [] [2020-01-22 12:40:39] security.INFO: Attempting SimplePreAuthentication. {"key":"frontend","authenticator":"Contao\\CoreBundle\\Security\\ContaoAuthenticator"} [] [2020-01-22 12:40:40] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\TableNotFoundException: "An exception occurred while executing 'SELECT * FROM tl_nc_gateway WHERE tl_nc_gateway.type='queue' AND tl_nc_gateway.queue_cronEnable=1 AND tl_nc_gateway.queue_cronInterval='minutely'': SQLSTATE[42S02]: Base table or view not found: 1146 Table '6379568db2.tl_nc_gateway' doesn't exist" at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 42 {"exception":"[object] (Doctrine\\DBAL\\Exception\\TableNotFoundException(code: 0): An exception occurred while executing 'SELECT * FROM tl_nc_gateway WHERE tl_nc_gateway.type='queue' AND tl_nc_gateway.queue_cronEnable=1 AND tl_nc_gateway.queue_cronInterval='minutely'':\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table '6379568db2.tl_nc_gateway' doesn't exist at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:42, Doctrine\\DBAL\\Driver\\PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table '6379568db2.tl_nc_gateway' doesn't exist at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table '6379568db2.tl_nc_gateway' doesn't exist at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:75)"} [] [2020-01-22 12:40:52] request.INFO: Matched route "contao_frontend". {"route":"contao_frontend","route_parameters":{"_token_check":true,"_controller":"Contao\\CoreBundle\\Controller\\FrontendController::indexAction","_scope":"frontend","alias":"kontakt","_route":"contao_frontend"},"request_uri":"https://www.sewe5.at/kontakt.html","method":"HEAD"} [] [2020-01-22 12:40:52] security.INFO: Attempting SimplePreAuthentication. {"key":"frontend","authenticator":"Contao\\CoreBundle\\Security\\ContaoAuthenticator"} [] [2020-01-22 12:40:52] request.INFO: Matched route "contao_frontend". {"route":"contao_frontend","route_parameters":{"_token_check":true,"_controller":"Contao\\CoreBundle\\Controller\\FrontendController::indexAction","_scope":"frontend","alias":"kontakt","_route":"contao_frontend"},"request_uri":"https://www.sewe5.at/kontakt.html","method":"GET"} [] [2020-01-22 12:40:52] security.INFO: Attempting SimplePreAuthentication. {"key":"frontend","authenticator":"Contao\\CoreBundle\\Security\\ContaoAuthenticator"} [] [2020-01-22 12:40:52] app.CRITICAL: An exception occurred. {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'SELECT tl_c4g_maps.*, j1.`id` AS profile__id, j1.`tstamp` AS profile__tstamp, j1.`name` AS profile__name, j1.`theme` AS profile__theme, j1.`is_backend_editor_default` AS profile__is_backend_editor_default, j1.`is_backend_geopicker_default` AS profile__is_backend_geopicker_default, j1.`baselayers` AS profile__baselayers, j1.`default_baselayer` AS profile__default_baselayer, j1.`locstyles` AS profile__locstyles, j1.`label_color` AS profile__label_color, j1.`zoom_panel` AS profile__zoom_panel, j1.`zoom_panel_button` AS profile__zoom_panel_button, j1.`zoom_panel_slider` AS profile__zoom_panel_slider, j1.`mouse_nav` AS profile__mouse_nav, j1.`mouse_nav_wheel` AS profile__mouse_nav_wheel, j1.`mouse_nav_doubleclick_zoom` AS profile__mouse_nav_doubleclick_zoom, j1.`mouse_nav_zoombox` AS profile__mouse_nav_zoombox, j1.`mouse_nav_kinetic` AS profile__mouse_nav_kinetic, j1.`mouse_nav_dragmode` AS profile__mouse_nav_dragmode, j1.`keyboard_nav` AS profile__keyboard_nav, j1.`touch_nav` AS profile__touch_nav, j1.`nav_history` AS profile__nav_history, j1.`fullscreen` AS profile__fullscreen, j1.`print` AS profile__print, j1.`starboard` AS profile__starboard, j1.`starboard_open` AS profile__starboard_open, j1.`starboard_label` AS profile__starboard_label, j1.`starboard_div` AS profile__starboard_div, j1.`starboard_filter` AS profile__starboard_filter, j1.`starboard_button` AS profile__starboard_button, j1.`cluster_all` AS profile__cluster_all, j1.`cluster_distance` AS profile__cluster_distance, j1.`cluster_fillcolor` AS profile__cluster_fillcolor, j1.`cluster_fontcolor` AS profile__cluster_fontcolor, j1.`cluster_zoom` AS profile__cluster_zoom, j1.`baselayerswitcher` AS profile__baselayerswitcher, j1.`baselayerswitcher_label` AS profile__baselayerswitcher_label, j1.`layerswitcher` AS profile__layerswitcher, j1.`layerswitcher_label` AS profile__layerswitcher_label, j1.`measuretool` AS profile__measuretool, j1.`graticule` AS profile__graticule, j1.`editor` AS profile__editor, j1.`attribution` AS profile__attribution, j1.`collapsed_attribution` AS profile__collapsed_attribution, j1.`cfg_logo_attribution` AS profile__cfg_logo_attribution, j1.`div_attribution` AS profile__div_attribution, j1.`add_attribution` AS profile__add_attribution, j1.`overviewmap` AS profile__overviewmap, j1.`geobookmarks` AS profile__geobookmarks, j1.`scaleline` AS profile__scaleline, j1.`mouseposition` AS profile__mouseposition, j1.`permalink` AS profile__permalink, j1.`permalink_get_param` AS profile__permalink_get_param, j1.`zoomlevel` AS profile__zoomlevel, j1.`account` AS profile__account, j1.`geosearch` AS profile__geosearch, j1.`geosearch_engine` AS profile__geosearch_engine, j1.`geosearch_show` AS profile__geosearch_show, j1.`geosearchParams` AS profile__geosearchParams, j1.`geosearch_results` AS profile__geosearch_results, j1.`geosearch_customengine_url` AS profile__geosearch_customengine_url, j1.`geosearch_customengine_attribution` AS profile__geosearch_customengine_attribution, j1.`geosearch_key` AS profile__geosearch_key, j1.`geosearch_div` AS profile__geosearch_div, j1.`geosearch_zoomto` AS profile__geosearch_zoomto, j1.`geosearch_zoombounds` AS profile__geosearch_zoombounds, j1.`geosearch_animate` AS profile__geosearch_animate, j1.`geosearch_markresult` AS profile__geosearch_markresult, j1.`geosearch_popup` AS profile__geosearch_popup, j1.`geosearch_attribution` AS profile__geosearch_attribution, j1.`geosearch_collapsed` AS profile__geosearch_collapsed, j1.`geopicker` AS profile__geopicker, j1.`geopicker_fieldx` AS profile__geopicker_fieldx, j1.`geopicker_fieldy` AS profile__geopicker_fieldy, j1.`geopicker_searchdiv` AS profile__geopicker_searchdiv, j1.`geopicker_attribution` AS profile__geopicker_attribution, j1.`geopicker_disabled` AS profile__geopicker_disabled, j1.`geopicker_anonymous` AS profile__geopicker_anonymous, j1.`libsource` AS profile__libsource, j1.`overpass_url` AS profile__overpass_url, j1.`custom_div` AS profile__custom_div, j1.`infopage` AS profile__infopage, j1.`link_newwindow` AS profile__link_newwindow, j1.`link_open_on` AS profile__link_open_on, j1.`hover_popups` AS profile__hover_popups, j1.`hover_popups_stay` AS profile__hover_popups_stay, j1.`popupAutoPan` AS profile__popupAutoPan, j1.`editor_styles_point` AS profile__editor_styles_point, j1.`editor_styles_line` AS profile__editor_styles_line, j1.`editor_styles_polygon` AS profile__editor_styles_polygon, j1.`editor_styles_circle` AS profile__editor_styles_circle, j1.`editor_styles_freehand` AS profile__editor_styles_freehand, j1.`editor_vars` AS profile__editor_vars, j1.`editor_show_items` AS profile__editor_show_items, j1.`editor_helpurl` AS profile__editor_helpurl, j1.`be_optimize_checkboxes_limit` AS profile__be_optimize_checkboxes_limit, j1.`cesium` AS profile__cesium, j1.`cesium_always` AS profile__cesium_always, j1.`caching` AS profile__caching FROM tl_c4g_maps LEFT JOIN tl_c4g_map_profiles j1 ON tl_c4g_maps.`profile`=j1.id WHERE tl_c4g_maps.`id`='1' LIMIT 0,1':\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'j1.geosearchParams' in 'field list' at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:60, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'j1.geosearchParams' in 'field list' at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'j1.geosearchParams' in 'field list' at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:75)"} [] [2020-01-22 12:42:10] 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":"https://www.sewe5.at/contao","method":"HEAD"} [] [2020-01-22 12:42:10] security.INFO: Attempting SimplePreAuthentication. {"key":"backend","authenticator":"Contao\\CoreBundle\\Security\\ContaoAuthenticator"} [] [2020-01-22 12:42:12] app.CRITICAL: An exception occurred. {"exception":"[object] (Doctrine\\DBAL\\Exception\\TableNotFoundException(code: 0): An exception occurred while executing 'SELECT * FROM tl_nc_gateway WHERE tl_nc_gateway.type='queue' AND tl_nc_gateway.queue_cronEnable=1 AND tl_nc_gateway.queue_cronInterval='minutely'':\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table '6379568db2.tl_nc_gateway' doesn't exist at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:42, Doctrine\\DBAL\\Driver\\PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table '6379568db2.tl_nc_gateway' doesn't exist at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table '6379568db2.tl_nc_gateway' doesn't exist at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:75)"} [] [2020-01-22 12:43:12] request.INFO: Matched route "contao_catch_all". {"route":"contao_catch_all","route_parameters":{"_scope":"frontend","_token_check":true,"_controller":"Contao\\CoreBundle\\Controller\\FrontendController::indexAction","_url_fragment":"favicon.ico","_route":"contao_catch_all"},"request_uri":"https://www.sewe5.at/favicon.ico","method":"HEAD"} [] [2020-01-22 12:43:12] security.INFO: Attempting SimplePreAuthentication. {"key":"frontend","authenticator":"Contao\\CoreBundle\\Security\\ContaoAuthenticator"} [] [2020-01-22 12:43:12] request.INFO: Matched route "contao_catch_all". {"route":"contao_catch_all","route_parameters":{"_scope":"frontend","_token_check":true,"_controller":"Contao\\CoreBundle\\Controller\\FrontendController::indexAction","_url_fragment":"favicon.ico","_route":"contao_catch_all"},"request_uri":"https://www.sewe5.at/favicon.ico","method":"GET"} [] [2020-01-22 12:43:12] security.INFO: Attempting SimplePreAuthentication. {"key":"frontend","authenticator":"Contao\\CoreBundle\\Security\\ContaoAuthenticator"} [] [2020-01-22 12:43:12] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\TableNotFoundException: "An exception occurred while executing 'SELECT * FROM tl_nc_gateway WHERE tl_nc_gateway.type='queue' AND tl_nc_gateway.queue_cronEnable=1 AND tl_nc_gateway.queue_cronInterval='minutely'': SQLSTATE[42S02]: Base table or view not found: 1146 Table '6379568db2.tl_nc_gateway' doesn't exist" at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 42 {"exception":"[object] (Doctrine\\DBAL\\Exception\\TableNotFoundException(code: 0): An exception occurred while executing 'SELECT * FROM tl_nc_gateway WHERE tl_nc_gateway.type='queue' AND tl_nc_gateway.queue_cronEnable=1 AND tl_nc_gateway.queue_cronInterval='minutely'':\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table '6379568db2.tl_nc_gateway' doesn't exist at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:42, Doctrine\\DBAL\\Driver\\PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table '6379568db2.tl_nc_gateway' doesn't exist at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table '6379568db2.tl_nc_gateway' doesn't exist at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:75)"} [] [2020-01-22 12:43:21] request.INFO: Matched route "contao_install". {"route":"contao_install","route_parameters":{"_scope":"backend","_token_check":true,"_controller":"Contao\\InstallationBundle\\Controller\\InstallationController::installAction","_route":"contao_install"},"request_uri":"https://www.sewe5.at/contao/install","method":"HEAD"} [] [2020-01-22 12:43:21] request.INFO: Matched route "contao_install". {"route":"contao_install","route_parameters":{"_scope":"backend","_token_check":true,"_controller":"Contao\\InstallationBundle\\Controller\\InstallationController::installAction","_route":"contao_install"},"request_uri":"https://www.sewe5.at/contao/install","method":"GET"} [] [2020-01-22 12:43:21] app.CRITICAL: An exception occurred. {"exception":"[object] (Doctrine\\DBAL\\Exception\\SyntaxErrorException(code: 0): An exception occurred while executing 'SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = '6379568db2' AND TABLE_NAME = 'tl_layout' ORDER BY ORDINAL_POSITION ASC AND COLUMN_NAME = 'sections'':\n\nSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND COLUMN_NAME = 'sections'' at line 1 at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\\DBAL\\Driver\\PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND COLUMN_NAME = 'sections'' at line 1 at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND COLUMN_NAME = 'sections'' at line 1 at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:75)"} []

Sorry, aber ich bin mit den Fehlermeldungen leider überfordert und bitte um eure Unterstützung.

Danke schon vorweg für alle Hinweise und schöne Grüße
Bernhard
22.01.2020, 12:02
Spooky

Benutze den Debug-Modus und poste den Stack Trace des Fehlers.
22.01.2020, 12:24
bteppan

OK - Debug-Modus habe ich hinbekommen (SSH) aber wo bekomme ich diesen 'Stack Trace' bzw. wo steht der nach dem Aufruf der Website mit dem Debug-Modus-Zusatz?
Sorry - aber das Neuland für mich, bitte um Nachsicht ... :o
22.01.2020, 12:28
Spooky

https://docs.contao.org/manual/de/system/debug-modus/
22.01.2020, 12:43
bteppan

Okay - Danke!
Interessanterweise geht nun das Backend wieder nachdem ich das Frontend mit der Erweiterun /app_dev.php aufgrufen habe.
Die Installseite erzeugt folgenden 'Stack Trace' - ich hoffe das ist das Richtige.

Code:

Doctrine\DBAL\Exception\SyntaxErrorException: An exception occurred while executing 'SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = '6379568db2' AND TABLE_NAME = 'tl_layout' ORDER BY ORDINAL_POSITION ASC AND COLUMN_NAME = 'sections'': SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND COLUMN_NAME = 'sections'' at line 1 at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79 at Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception occurred while executing \'SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = \'6379568db2\' AND TABLE_NAME = \'tl_layout\' ORDER BY ORDINAL_POSITION ASC AND COLUMN_NAME = \'sections\'\':SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'AND COLUMN_NAME = \'sections\'\' at line 1', object(PDOException)) (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:166) at Doctrine\DBAL\DBALException::wrapException(object(Driver), object(PDOException), 'An exception occurred while executing \'SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = \'6379568db2\' AND TABLE_NAME = \'tl_layout\' ORDER BY ORDINAL_POSITION ASC AND COLUMN_NAME = \'sections\'\':SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'AND COLUMN_NAME = \'sections\'\' at line 1') (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:146) at Doctrine\DBAL\DBALException::driverExceptionDuringQuery(object(Driver), object(PDOException), 'SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = \'6379568db2\' AND TABLE_NAME = \'tl_layout\' ORDER BY ORDINAL_POSITION ASC AND COLUMN_NAME = \'sections\'', array()) (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:912) at Doctrine\DBAL\Connection->executeQuery('SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = \'6379568db2\' AND TABLE_NAME = \'tl_layout\' ORDER BY ORDINAL_POSITION ASC AND COLUMN_NAME = \'sections\'', array(), array()) (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:553) at Doctrine\DBAL\Connection->fetchAssoc('SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = \'6379568db2\' AND TABLE_NAME = \'tl_layout\' ORDER BY ORDINAL_POSITION ASC AND COLUMN_NAME = \'sections\'') (vendor/contao/installation-bundle/src/InstallTool.php:213) at Contao\InstallationBundle\InstallTool->hasOldDatabase() (vendor/contao/installation-bundle/src/Controller/InstallationController.php:95) at Contao\InstallationBundle\Controller\InstallationController->installAction() (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:151) at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1) (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:68) at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true) (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php:200) at Symfony\Component\HttpKernel\Kernel->handle(object(Request)) (web/app_dev.php:64)
22.01.2020, 12:48
bteppan

Hier auch noch das LOG-File:

Code:

[2020-01-22 13:39:54] php.INFO: User Deprecated: Passing the path to the Composer installed.json as first argument is no longer supported in version 2.3. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Passing the path to the Composer installed.json as first argument is no longer supported in version 2.3. at /home/.sites/413/site6379568/web/proto1/vendor/contao/manager-plugin/src/PluginLoader.php:46)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using a bundles.json file has been deprecated and will no longer work in version 3.0. Use the Plugin::getBundles() method to define your bundles instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using a bundles.json file has been deprecated and will no longer work in version 3.0. Use the Plugin::getBundles() method to define your bundles instead. at /home/.sites/413/site6379568/web/proto1/vendor/contao/manager-plugin/src/Bundle/Parser/JsonParser.php:24)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: The type "binary_string" was explicitly marked as commented in its configuration. This is no longer necessary and will be removed in DoctrineBundle 2.0. Please remove the "commented" attribute from the type configuration. {"exception":"[object] (ErrorException(code: 0): User Deprecated: The type \"binary_string\" was explicitly marked as commented in its configuration. This is no longer necessary and will be removed in DoctrineBundle 2.0. Please remove the \"commented\" attribute from the type configuration. at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/doctrine-bundle/ConnectionFactory.php:153)"} [] [2020-01-22 13:39:54] request.INFO: Matched route "contao_install". {"route":"contao_install","route_parameters":{"_scope":"backend","_token_check":true,"_controller":"Contao\\InstallationBundle\\Controller\\InstallationController::installAction","_route":"contao_install"},"request_uri":"https://www.sewe5.at/app_dev.php/contao/install","method":"GET"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ClassLoader::addClasses() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ClassLoader::addClasses() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ClassLoader.php:119)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ClassLoader.php:105)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ClassLoader::addNamespaces() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ClassLoader::addNamespaces() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ClassLoader.php:73)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ClassLoader::addNamespace() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ClassLoader::addNamespace() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ClassLoader.php:54)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ClassLoader::addClasses() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ClassLoader::addClasses() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ClassLoader.php:119)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ClassLoader.php:105)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ClassLoader.php:105)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ClassLoader.php:105)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ClassLoader.php:105)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ClassLoader.php:105)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ClassLoader.php:105)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ClassLoader.php:105)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ClassLoader.php:105)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ClassLoader::addNamespaces() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ClassLoader::addNamespaces() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ClassLoader.php:73)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ClassLoader::addNamespace() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ClassLoader::addNamespace() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ClassLoader.php:54)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ClassLoader::addClasses() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ClassLoader::addClasses() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ClassLoader.php:119)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ClassLoader::addClasses() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ClassLoader::addClasses() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ClassLoader.php:119)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ClassLoader.php:105)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ClassLoader.php:105)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ClassLoader.php:105)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ClassLoader::addClasses() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ClassLoader::addClasses() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ClassLoader.php:119)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ClassLoader.php:105)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ClassLoader.php:105)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ClassLoader.php:105)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ClassLoader.php:105)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ClassLoader.php:105)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ClassLoader::addClasses() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ClassLoader::addClasses() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ClassLoader.php:119)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ClassLoader.php:105)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ClassLoader.php:105)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ClassLoader.php:105)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ClassLoader.php:105)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ClassLoader.php:105)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ModuleLoader::getActive() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ModuleLoader::getActive() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ModuleLoader.php:56)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using ModuleLoader::getActive() has been deprecated and will no longer work in Contao 5.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using ModuleLoader::getActive() has been deprecated and will no longer work in Contao 5.0. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/ModuleLoader.php:56)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: Using the Contao\RequestToken class has been deprecated and will no longer work in Contao 5.0. Use the Symfony CSRF service via the container instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the Contao\\RequestToken class has been deprecated and will no longer work in Contao 5.0. Use the Symfony CSRF service via the container instead. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/RequestToken.php:15)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: The "contao.install_tool" service is private, getting it from the container is deprecated since Symfony 3.2 and will fail in 4.0. You should either make the service public, or stop using the container directly and use dependency injection instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: The \"contao.install_tool\" service is private, getting it from the container is deprecated since Symfony 3.2 and will fail in 4.0. You should either make the service public, or stop using the container directly and use dependency injection instead. at /home/.sites/413/site6379568/web/proto1/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Container.php:282)"} [] [2020-01-22 13:39:54] php.INFO: User Deprecated: The "contao.install_tool_user" service is private, getting it from the container is deprecated since Symfony 3.2 and will fail in 4.0. You should either make the service public, or stop using the container directly and use dependency injection instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: The \"contao.install_tool_user\" service is private, getting it from the container is deprecated since Symfony 3.2 and will fail in 4.0. You should either make the service public, or stop using the container directly and use dependency injection instead. at /home/.sites/413/site6379568/web/proto1/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Container.php:282)"} [] [2020-01-22 13:39:54] app.CRITICAL: An exception occurred. {"exception":"[object] (Doctrine\\DBAL\\Exception\\SyntaxErrorException(code: 0): An exception occurred while executing 'SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = '6379568db2' AND TABLE_NAME = 'tl_layout' ORDER BY ORDINAL_POSITION ASC AND COLUMN_NAME = 'sections'':\n\nSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND COLUMN_NAME = 'sections'' at line 1 at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\\DBAL\\Driver\\PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND COLUMN_NAME = 'sections'' at line 1 at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND COLUMN_NAME = 'sections'' at line 1 at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:75)"} [] [2020-01-22 13:39:54] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\SyntaxErrorException: "An exception occurred while executing 'SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = '6379568db2' AND TABLE_NAME = 'tl_layout' ORDER BY ORDINAL_POSITION ASC AND COLUMN_NAME = 'sections'': SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND COLUMN_NAME = 'sections'' at line 1" at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {"exception":"[object] (Doctrine\\DBAL\\Exception\\SyntaxErrorException(code: 0): An exception occurred while executing 'SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = '6379568db2' AND TABLE_NAME = 'tl_layout' ORDER BY ORDINAL_POSITION ASC AND COLUMN_NAME = 'sections'':\n\nSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND COLUMN_NAME = 'sections'' at line 1 at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\\DBAL\\Driver\\PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND COLUMN_NAME = 'sections'' at line 1 at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND COLUMN_NAME = 'sections'' at line 1 at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:75)"} []
22.01.2020, 18:28
xchs

https://community.contao.org/de/show...o-install-quot
23.01.2020, 12:30
bteppan

Ähmm ... der Thread verwirrt mich jetzt noch mehr!
Da werden alle möglichen Contao-Version durcheinandergewürfelt und mehrere Lösungsansätze aufgezeigt, ich weiß aber nicht was genau auf mein Problem zutrifft.

Darf ich um einen etwas präziseren Hinweis bitten. :eek:

Danke!
27.01.2020, 11:03
bteppan

Hallo!
Darf ich nochmal höflich um Unterstützung bitten!
Ich komme mit den bisherigen Tipps und Links nicht zurecht bzw. weiß ich nicht, wo ich da ansetzen soll.
Zwischenzeitlich habe ich das Paket 'Con4Gis' vollständig via Contao-Manager gelöscht und die SQL-DB manuell über meinen Webhoster und MySQL-Zugang bereinigt - sprich die c4g-Tabellen entfernt.
Es funktioniert nun das Backend wieder ohne Einschränkungen nur komme ich nach wie vor nicht in das 'Install-Tool' bzw. die 'Install-Seite'.
Folgendes LOG-File wird nun ausgegeben:

Code:

[2020-01-27 11:46:36] php.INFO: User Deprecated: Passing the path to the Composer installed.json as first argument is no longer supported in version 2.3. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Passing the path to the Composer installed.json as first argument is no longer supported in version 2.3. at /home/.sites/413/site6379568/web/proto1/vendor/contao/manager-plugin/src/PluginLoader.php:46)"} [] [2020-01-27 11:46:36] php.INFO: User Deprecated: Using a bundles.json file has been deprecated and will no longer work in version 3.0. Use the Plugin::getBundles() method to define your bundles instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using a bundles.json file has been deprecated and will no longer work in version 3.0. Use the Plugin::getBundles() method to define your bundles instead. at /home/.sites/413/site6379568/web/proto1/vendor/contao/manager-plugin/src/Bundle/Parser/JsonParser.php:24)"} [] [2020-01-27 11:46:36] php.INFO: User Deprecated: The type "binary_string" was explicitly marked as commented in its configuration. This is no longer necessary and will be removed in DoctrineBundle 2.0. Please remove the "commented" attribute from the type configuration. {"exception":"[object] (ErrorException(code: 0): User Deprecated: The type \"binary_string\" was explicitly marked as commented in its configuration. This is no longer necessary and will be removed in DoctrineBundle 2.0. Please remove the \"commented\" attribute from the type configuration. at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/doctrine-bundle/ConnectionFactory.php:153)"} [] [2020-01-27 11:46:37] request.INFO: Matched route "contao_install". {"route":"contao_install","route_parameters":{"_scope":"backend","_token_check":true,"_controller":"Contao\\InstallationBundle\\Controller\\InstallationController::installAction","_route":"contao_install"},"request_uri":"https://www.sewe5.at/app_dev.php/contao/install","method":"GET"} [] [2020-01-27 11:46:37] php.INFO: User Deprecated: Using the Contao\RequestToken class has been deprecated and will no longer work in Contao 5.0. Use the Symfony CSRF service via the container instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the Contao\\RequestToken class has been deprecated and will no longer work in Contao 5.0. Use the Symfony CSRF service via the container instead. at /home/.sites/413/site6379568/web/proto1/vendor/contao/core-bundle/src/Resources/contao/library/Contao/RequestToken.php:15)"} [] [2020-01-27 11:46:37] php.INFO: User Deprecated: The "contao.install_tool" service is private, getting it from the container is deprecated since Symfony 3.2 and will fail in 4.0. You should either make the service public, or stop using the container directly and use dependency injection instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: The \"contao.install_tool\" service is private, getting it from the container is deprecated since Symfony 3.2 and will fail in 4.0. You should either make the service public, or stop using the container directly and use dependency injection instead. at /home/.sites/413/site6379568/web/proto1/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Container.php:282)"} [] [2020-01-27 11:46:37] php.INFO: User Deprecated: The "contao.install_tool_user" service is private, getting it from the container is deprecated since Symfony 3.2 and will fail in 4.0. You should either make the service public, or stop using the container directly and use dependency injection instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: The \"contao.install_tool_user\" service is private, getting it from the container is deprecated since Symfony 3.2 and will fail in 4.0. You should either make the service public, or stop using the container directly and use dependency injection instead. at /home/.sites/413/site6379568/web/proto1/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Container.php:282)"} [] [2020-01-27 11:46:37] app.CRITICAL: An exception occurred. {"exception":"[object] (Doctrine\\DBAL\\Exception\\SyntaxErrorException(code: 0): An exception occurred while executing 'SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = '6379568db2' AND TABLE_NAME = 'tl_layout' ORDER BY ORDINAL_POSITION ASC AND COLUMN_NAME = 'sections'':\n\nSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND COLUMN_NAME = 'sections'' at line 1 at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\\DBAL\\Driver\\PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND COLUMN_NAME = 'sections'' at line 1 at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND COLUMN_NAME = 'sections'' at line 1 at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:75)"} [] [2020-01-27 11:46:37] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\SyntaxErrorException: "An exception occurred while executing 'SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = '6379568db2' AND TABLE_NAME = 'tl_layout' ORDER BY ORDINAL_POSITION ASC AND COLUMN_NAME = 'sections'': SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND COLUMN_NAME = 'sections'' at line 1" at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {"exception":"[object] (Doctrine\\DBAL\\Exception\\SyntaxErrorException(code: 0): An exception occurred while executing 'SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = '6379568db2' AND TABLE_NAME = 'tl_layout' ORDER BY ORDINAL_POSITION ASC AND COLUMN_NAME = 'sections'':\n\nSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND COLUMN_NAME = 'sections'' at line 1 at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\\DBAL\\Driver\\PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND COLUMN_NAME = 'sections'' at line 1 at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND COLUMN_NAME = 'sections'' at line 1 at /home/.sites/413/site6379568/web/proto1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:75)"} []

Ich stehe mit meinem Wissen hier wirklich an, muss das Problem aber irgendwie bereinigen.
Bitte, lasst mich nicht hängen!

Danke und schöne Grüße
Bernhard