Contao-Camp 2024
Ergebnis 1 bis 9 von 9

Thema: con4gis - nach Update Probleme mit Backend und Install-Seite

  1. #1
    Contao-Nutzer
    Registriert seit
    15.02.2014.
    Beiträge
    196

    Standard 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

  2. #2
    Community-Moderator
    Wandelndes Contao-Lexikon
    Avatar von Spooky
    Registriert seit
    12.04.2012.
    Ort
    Scotland
    Beiträge
    33.896
    Partner-ID
    10107

    Standard

    Benutze den Debug-Modus und poste den Stack Trace des Fehlers.

  3. #3
    Contao-Nutzer
    Registriert seit
    15.02.2014.
    Beiträge
    196

    Standard

    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 ...

  4. #4
    Community-Moderator
    Wandelndes Contao-Lexikon
    Avatar von Spooky
    Registriert seit
    12.04.2012.
    Ort
    Scotland
    Beiträge
    33.896
    Partner-ID
    10107

  5. #5
    Contao-Nutzer
    Registriert seit
    15.02.2014.
    Beiträge
    196

    Standard

    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)

  6. #6
    Contao-Nutzer
    Registriert seit
    15.02.2014.
    Beiträge
    196

    Standard

    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)"} []

  7. #7
    Administrator Avatar von xchs
    Registriert seit
    19.06.2009.
    Beiträge
    14.548
    User beschenken
    Wunschliste
    Contao-Projekt unterstützen

    Support Contao
    Contao Community Administrator

    [Unterstützungsmöglichkeiten]

  8. #8
    Contao-Nutzer
    Registriert seit
    15.02.2014.
    Beiträge
    196

    Standard

    Ä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.

    Danke!

  9. #9
    Contao-Nutzer
    Registriert seit
    15.02.2014.
    Beiträge
    196

    Standard

    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

Aktive Benutzer

Aktive Benutzer

Aktive Benutzer in diesem Thema: 1 (Registrierte Benutzer: 0, Gäste: 1)

Lesezeichen

Lesezeichen

Berechtigungen

  • Neue Themen erstellen: Nein
  • Themen beantworten: Nein
  • Anhänge hochladen: Nein
  • Beiträge bearbeiten: Nein
  •