Contao 4.6.9 Update of "doctrine/dbal" v2.9.0 throws error invoking "contao/install"

**Seefahrer** · 04.12.2018, 09:28

After updating (with some difficulties) the CM to v1.1.1 I did run a package update which updated "doctrine/dbal" to v 2.9.0.

Now the contao/install route throws fllwg error:

Code:

2018-12-04 09:01:30] 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 ASNull, 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 = 'xxxxx' 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 .../cmsc4ME/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 = 'xxxxxxx' 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 .../cmsc4ME/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 .../cmsc4ME/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:90, 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

"doctrine/dbal" needed to be downgraded back to v2.8.1 to let the install work again:

Code:

"conflict": { 
   "doctrine/dbal": "2.9.0" 
},

reported on github: https://github.com/contao/contao/issues/212

**Knut** · 04.12.2018, 09:29

Hallo zusammen,
ich bekomme bei Alfahosting in var/log folgenden Fehler beim Update angezeigt:

Code:

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 = 'usr_xxx' 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 /var/www/xxx/html/cms/c44demo/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 /var/www/xxx/html/cms/c44demo/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:90, 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 /var/www/xxx/html/cms/c44demo/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:88)"} []

Bisher haben alle Updates funktioniert. Vielleicht hat jemand eine Idee?

**Spooky** · 04.12.2018, 09:37

Moderation: Themen zusammengeführt.

Zwei Threads zum gleichen Thema zur fast gleichen Zeit, nice

**Spooky** · 04.12.2018, 09:38

@Seefahrer danke für's reporten

**Ingenious Design** · 04.12.2018, 10:31

Hallo liebe Community,

nach dem Core update auf die neueste 4.4er Version, komme ich leider nicht mehr ins Install-Tool von Contao. Ein Blick in die Logs ergab folgenden Fehler:

Code:

[2018-12-04 10:25:12] 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 = 'db546042' 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 /kunden/546042_93476/webseiten/ingenious-design.de/website/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 /kunden/546042_93476/webseiten/ingenious-design.de/website/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:90, 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 /kunden/546042_93476/webseiten/ingenious-design.de/website/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:88)"} []

Kann sich darauf jemand nen Reim machen?
Es wurde schon der Cache geleert und gelöscht und die Sytemwartung sowohl im Manager als auch im Backend durchgeführt.

Vielen Dank schon mal für eure Hilfe.

**allmächt!** · 04.12.2018, 10:35

Guten Tag,

ich habe heute
a) ein Testsystem (neueste Version von 4.6) unter MAMP neu aufgesetzt und
b) bei einem bestehenden System (WebGo) den neuen Manager 1.1.1eingespielt.

Beides tat, jedoch kann ich bei beiden Systemen das InstallTool nicht aufrufen. Meldung bei beiden Systemen:

Es ist ein Fehler aufgetreten
Was ist das Problem?

Bei der Ausführung des Skriptes ist ein Fehler aufgetreten. Irgendetwas funktioniert nicht richtig.

In ../var/logs wird diese Fehlermeldung geschrieben (bei der WebGo Installation):

[2018-12-04 10:09:16] request.INFO: Matched route "contao_install". {"route":"contao_install","route_parameters":{" _ro ute":"contao_install","_scope":"backend","_token_ c heck":true,"_controller":"Contao\\InstallationBund le\\Controller\\InstallationController::installAct ion"},"request_uri":"https://domain.xx/contao/install","method":"HEAD"} []
[2018-12-04 10:09:16] request.INFO: Matched route "contao_install". {"route":"contao_install","route_parameters":{" _ro ute":"contao_install","_scope":"backend","_token_ c heck":true,"_controller":"Contao\\InstallationBund le\\Controller\\InstallationController::installAct ion"},"request_uri":"https://domain.xx/contao/install","method":"GET"} []
[2018-12-04 10:09:16] 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 = 'web74_db2' 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/www/domain.xx/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {"exception":"[object] (Doctrine\\DBAL\\Exception\\SyntaxErrorException(c ode: 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 = 'web74_db2' 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/www/domain.xx/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/www/domain.xx/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:90, 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/www/domain.xx/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:88)"} []

Bei der neuen Installation auf MAMP lief die Installation durch, bis das Installtool aufgerufen (Datenbank Einrichtung klappte noch) werden sollte, danach kam die Meldung, dass ein Fehler aufgetreten sei.

Grüße aus Mittelfranken-Süd
Rudolf

**seagull** · 04.12.2018, 10:37

Hallo,

ich habe eine Installation Contao 4.4.28 umgezogen auf einen neuen Serverplatz.
Zunächst wurde der Contao-Manager upgedatet, dann wollte die Installation von Contao 4.4.29 nur mit Cloud-Resolver laufen, obwohl das bisher immer ohne ging.
Nach dem Aufruf des Installtools und Einbinden der DB erhalte ich eine Fehlermeldung "Es ist ein Fehler aufgetreten"

Code:

[2018-12-04 10:05:20] 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":"contao-manager/users.json","_route":"contao_catch_all"},"request_uri":"http://www.lmcare.de/contao-manager/users.json","method":"HEAD"} []
[2018-12-04 10:05:20] security.INFO: Attempting SimplePreAuthentication. {"key":"frontend","authenticator":"Contao\\CoreBundle\\Security\\ContaoAuthenticator"} []
[2018-12-04 10:05:20] 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":"contao-manager/users.json","_route":"contao_catch_all"},"request_uri":"http://www.lmcare.de/contao-manager/users.json","method":"GET"} []
[2018-12-04 10:05:20] security.INFO: Attempting SimplePreAuthentication. {"key":"frontend","authenticator":"Contao\\CoreBundle\\Security\\ContaoAuthenticator"} []
[2018-12-04 10:05:20] request.ERROR: Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\NotFoundHttpException: "Page not found: http://www.lmcare.de/contao-manager/users.json" at /var/www/11115/lmcare.de/htdocs/vendor/contao/core-bundle/src/EventListener/ExceptionConverterListener.php line 112 {"exception":"[object] (Symfony\\Component\\HttpKernel\\Exception\\NotFoundHttpException(code: 0): Page not found: http://www.lmcare.de/contao-manager/users.json at /var/www/11115/lmcare.de/htdocs/vendor/contao/core-bundle/src/EventListener/ExceptionConverterListener.php:112, Contao\\CoreBundle\\Exception\\PageNotFoundException(code: 0): Page not found: http://www.lmcare.de/contao-manager/users.json at /var/www/11115/lmcare.de/htdocs/vendor/contao/core-bundle/src/Resources/contao/controllers/FrontendIndex.php:64)"} []
[2018-12-04 10:08:49] 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":"contao-manager/users.json","_route":"contao_catch_all"},"request_uri":"http://www.lmcare.de/contao-manager/users.json","method":"HEAD"} []
[2018-12-04 10:08:49] security.INFO: Attempting SimplePreAuthentication. {"key":"frontend","authenticator":"Contao\\CoreBundle\\Security\\ContaoAuthenticator"} []
[2018-12-04 10:08:49] 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":"contao-manager/users.json","_route":"contao_catch_all"},"request_uri":"http://www.lmcare.de/contao-manager/users.json","method":"GET"} []
[2018-12-04 10:08:49] security.INFO: Attempting SimplePreAuthentication. {"key":"frontend","authenticator":"Contao\\CoreBundle\\Security\\ContaoAuthenticator"} []
[2018-12-04 10:08:49] request.ERROR: Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\NotFoundHttpException: "Page not found: http://www.lmcare.de/contao-manager/users.json" at /var/www/11115/lmcare.de/htdocs/vendor/contao/core-bundle/src/EventListener/ExceptionConverterListener.php line 112 {"exception":"[object] (Symfony\\Component\\HttpKernel\\Exception\\NotFoundHttpException(code: 0): Page not found: http://www.lmcare.de/contao-manager/users.json at /var/www/11115/lmcare.de/htdocs/vendor/contao/core-bundle/src/EventListener/ExceptionConverterListener.php:112, Contao\\CoreBundle\\Exception\\PageNotFoundException(code: 0): Page not found: http://www.lmcare.de/contao-manager/users.json at /var/www/11115/lmcare.de/htdocs/vendor/contao/core-bundle/src/Resources/contao/controllers/FrontendIndex.php:64)"} []
[2018-12-04 10:10:27] 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":"contao-manager/users.json","_route":"contao_catch_all"},"request_uri":"http://www.lmcare.de/contao-manager/users.json","method":"HEAD"} []
[2018-12-04 10:10:27] security.INFO: Attempting SimplePreAuthentication. {"key":"frontend","authenticator":"Contao\\CoreBundle\\Security\\ContaoAuthenticator"} []
[2018-12-04 10:10:27] 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":"contao-manager/users.json","_route":"contao_catch_all"},"request_uri":"http://www.lmcare.de/contao-manager/users.json","method":"GET"} []
[2018-12-04 10:10:27] security.INFO: Attempting SimplePreAuthentication. {"key":"frontend","authenticator":"Contao\\CoreBundle\\Security\\ContaoAuthenticator"} []
[2018-12-04 10:10:27] request.ERROR: Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\NotFoundHttpException: "Page not found: http://www.lmcare.de/contao-manager/users.json" at /var/www/11115/lmcare.de/htdocs/vendor/contao/core-bundle/src/EventListener/ExceptionConverterListener.php line 112 {"exception":"[object] (Symfony\\Component\\HttpKernel\\Exception\\NotFoundHttpException(code: 0): Page not found: http://www.lmcare.de/contao-manager/users.json at /var/www/11115/lmcare.de/htdocs/vendor/contao/core-bundle/src/EventListener/ExceptionConverterListener.php:112, Contao\\CoreBundle\\Exception\\PageNotFoundException(code: 0): Page not found: http://www.lmcare.de/contao-manager/users.json at /var/www/11115/lmcare.de/htdocs/vendor/contao/core-bundle/src/Resources/contao/controllers/FrontendIndex.php:64)"} []
[2018-12-04 10:16:14] 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":"http://www.lmcare.de/contao/install","method":"HEAD"} []
[2018-12-04 10:16:14] 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":"http://www.lmcare.de/contao/install","method":"GET"} []
[2018-12-04 10:16: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 = 'db_11115_1' 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 /var/www/11115/lmcare.de/htdocs/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 /var/www/11115/lmcare.de/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:90, 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 /var/www/11115/lmcare.de/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:88)"} []
[2018-12-04 10:16:29] 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":"http://www.lmcare.de/contao/install","method":"HEAD"} []
[2018-12-04 10:16:29] 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":"http://www.lmcare.de/contao/install","method":"GET"} []
[2018-12-04 10:16:29] 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 = 'db_11115_1' 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 /var/www/11115/lmcare.de/htdocs/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 /var/www/11115/lmcare.de/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:90, 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 /var/www/11115/lmcare.de/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:88)"} []

Der Fehler scheint ähnlich wie bei dem vorangegangenen thread.

LG seagull

**Seefahrer** · 04.12.2018, 10:41

@allmächt!

Dafür gibt es bereits einen Thread mit Report auf Github.

https://community.contao.org/de/showthread.php?72801

**Seefahrer** · 04.12.2018, 10:43

Im Moment hilft nur ein Downgrade von "doctrine/dbal" auf v2.8.1

s.a. https://community.contao.org/de/showthread.php?72801

**Seefahrer** · 04.12.2018, 10:45

https://community.contao.org/de/showthread.php?72801

**Ingenious Design** · 04.12.2018, 10:52

Danke für die schnelle Antwort, ich werd's versuchen!

**seagull** · 04.12.2018, 10:57

Danke

Ich hab den conflict in der composer.json eingetragen, nach dem composer update alles wieder ok.

LG seagull

**Spooky** · 04.12.2018, 10:58

Moderation: Thema zusammengeführt.

**Ingenious Design** · 04.12.2018, 11:23

Die Antwort von @Seefahrer hat auch bei mir funktioniert

**Schmidty** · 04.12.2018, 12:30

Hallo,
ich bekomme bei einer Contao 4.4.29 Neuinstallation im Install-Tool eine Fehlermeldung. Auf dem gleichen Paket laufen weitere Contao 4.4.29-Installationen ohne Probleme (noch mit ContaoManager 1.0.4, die letzten Updates wurden bei diesen Installationen am 23.11.18 durchgeführt. Hier die Daten der Problem-Installation:

Paket All-Inkl Business
Contao-Manager 1.1.1, Cloud-Resolver aktiviert
PHP 7.2.11-nmm1
MySQL 5.7.21

Contao Neuinstallation (Full), im Install-Tool lassen sich die Datenbankdaten eingeben, wenn man dann weiter macht wird bei der Erstellung der Datenbanktabellen die Contao-Fehlermeldung „Es ist ein Fehler aufgetreten“ angezeigt. Es wird auf var/logs verwiesen, da steht in der Datei prod-2018-12-04.log:

Code:

[2018-12-04 11:43:14] 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":"http://domain.de/contao/install","method":"POST"} []
[2018-12-04 11:43:14] 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 = 'dXXXXXXX' 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 /www/htdocs/wXXXXXXX/verzeichnisname/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 /www/htdocs/wXXXXXXX/verzeichnis/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:90, 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 /www/htdocs/wXXXXXXX/verzeichnis/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:88)"} []

Ist das ein Fehler bei Contao oder muss ich bei All-Inkl etwas umstellen?

Danke für die Hilfe.

**mlweb** · 04.12.2018, 12:36

Dürfte das hier sein. https://community.contao.org/de/show...o-install-quot

**Claudi** · 04.12.2018, 12:57

Hallo,

habe letzte Woche per Contao Manager die neueste Contao 4.6.9 und dann noch einige Erweiterungen installiert. Heute hab ich auf den Contao Manager 1.1.1 aktualisiert. Danach hab ich noch eine Erweiterung aktualisiert und mich beim Installtool eingeloggt.
Seitdem bekomm ich die Seite mit "Es ist ein Fehler aufgetreten" angezeigt.
In der Logdatei steht:

Code:

[2018-12-04 12:32:56] request.INFO: Matched route "contao_install". {"route":"contao_install","route_parameters":{"_route":"contao_install","_scope":"backend","_token_check":true,"_controller":"Contao\\InstallationBundle\\Controller\\InstallationController::installAction"},"request_uri":"http://XXXXXXXXX.at/contao/install","method":"HEAD"} []
[2018-12-04 12:32:56] request.INFO: Matched route "contao_install". {"route":"contao_install","route_parameters":{"_route":"contao_install","_scope":"backend","_token_check":true,"_controller":"Contao\\InstallationBundle\\Controller\\InstallationController::installAction"},"request_uri":"http://XXXXXXXXX.at/contao/install","method":"GET"} []
[2018-12-04 12:32:56] 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 = 'XXX-MYNAME-XXX' 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 /www/XXX-MYNAME-XXX/html/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 = 'XXX-MYNAME-XXX' 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 /www/XXX-MYNAME-XXX/html/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 /www/XXX-MYNAME-XXX/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:90, 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 /www/XXX-MYNAME-XXX/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:88)"} []

Kann mir hier eventuell jemand weiterhelfen?

Danke!

**tab** · 04.12.2018, 12:58

Siehe hier: https://community.contao.org/de/show...o-install-quot

**Tina** · 04.12.2018, 12:59

Hallo zusammen,

bis zum Datenbank-Update lief die Installation von Contao 4.4 mit dem Manager problemlos.

Das Update wird auch durchgeführt (zumindest kann ich die angelegten Tabellen in phpMyAdmin sehen), aber anschließend bekomme ich folgende Fehlermeldung:

Code:

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 = 'db764228401' 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 /homepages/16/d42881359/htdocs/relaunch2018/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 /homepages/16/d42881359/htdocs/relaunch2018/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:90, 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 /homepages/16/d42881359/htdocs/relaunch2018/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:88)"} []

MySQL 5.5, Typ MyISAM
PHP 7.2
Hosting: 1&1 Homepage Business

Ich habe es auch noch mal mit folgender config.yml probiert (Cache unter „var/cache“ habe ich geleert). Ergebnis war das gleiche.

Code:

doctrine:
    dbal:
        connections:
            default:
                default_table_options:
                    charset: utf8
                    collate: utf8_unicode_ci
                    engine: MyISAM

Der Contao Check sagt, dass eigentlich alles richtig ist.

Hat jemand ähnliche Erfahrungen?

Viele Grüße
Tina

***xchs*** · 04.12.2018, 13:02

Contao 4.6.10 und Contao 4.4.30 wurden vorhin veröffentlicht. Das Problem sollte dort behoben sein.

**tab** · 04.12.2018, 13:06

Das hat mit 1&1 vermutlich nichts zu tun, wahrscheinlich bist du in ein aktuelles Problem reingelaufen, mittlerweile wurden schon neue Contao-Versionen veröffentlicht, die das fixen sollten.

**Claudi** · 04.12.2018, 13:10

Danke tab.

Das heißt mit einem Update auf 4.6.10 sollte das Problem behoben sein?
Oder brauch ich dennnoch den Eintrag in die composer.json?

**Tina** · 04.12.2018, 13:12

Zitat von tab

Das hat mit 1&1 vermutlich nichts zu tun, wahrscheinlich bist du in ein aktuelles Problem reingelaufen, mittlerweile wurden schon neue Contao-Versionen veröffentlicht, die das fixen sollten.

Contao 4.4 ist doch die stable Version. Da müssten doch aktuelle Probleme auch gefixt werden.

Contao 4.6 konnte ich nicht installieren, weil dafür MySQL 5.5 nicht ausreicht.

**tab** · 04.12.2018, 13:13

Es gibt neue Versionen sowohl für 4.4 als auch für 4.6.

**androsch** · 04.12.2018, 13:13

Hallo,

ich habe heute beim Timmehosting eine neue Contao Seite aufsetzen wollen - was bisher immer problemlos geklappt hat - aber das Installtool hängt sich beim anlegen der Datenbank immer auf. Werde aus der Fehlermeldung nicht schlau. Hat jemand eine Idee was da falsch läuft? Hier die Fehlermeldung aus der app_dev.php

Code:

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 = 'c4_dbcontao4' 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 MariaDB server version for the right syntax to use near 'AND COLUMN_NAME = 'sections'' at line 1

Stack Trace:

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 = 'c4_dbcontao4' 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 MariaDB 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 = \'c4_dbcontao4\' 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 MariaDB 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:169)
  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 = \'c4_dbcontao4\' 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 MariaDB server version for the right syntax to use near \'AND COLUMN_NAME = \'sections\'\' at line 1')
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:145)
  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 = \'c4_dbcontao4\' AND TABLE_NAME = \'tl_layout\' ORDER BY ORDINAL_POSITION ASC AND COLUMN_NAME = \'sections\'', array())
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:911)
  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 = \'c4_dbcontao4\' AND TABLE_NAME = \'tl_layout\' ORDER BY ORDINAL_POSITION ASC AND COLUMN_NAME = \'sections\'', array(), array())
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:545)
  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 = \'c4_dbcontao4\' AND TABLE_NAME = \'tl_layout\' ORDER BY ORDINAL_POSITION ASC AND COLUMN_NAME = \'sections\'')
     (vendor/contao/installation-bundle/src/InstallTool.php:165)
  at Contao\InstallationBundle\InstallTool->hasOldDatabase()
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:89)
  at Contao\InstallationBundle\Controller\InstallationController->installAction()
     (vendor/symfony/http-kernel/HttpKernel.php:149)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:66)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:188)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/app_dev.php:84)

Danke für die Hilfe,
LG

**Spooky** · 04.12.2018, 13:14

Mit der nächsten Contao Version wird das behoben sein (sowohl Contao 4.4 als auch 4.6). Bis dorthin kannst du den conflict in deiner composer.json eintragen und ein update machen. Sobald die nächste Contao Version veröffentlicht wurde, kannst du den conflict wieder entfernen.

**tab** · 04.12.2018, 13:14

Mittlerweile gibt es neue Contao-Versionen, bei denen das nicht mehr auftreten sollte.

**tab** · 04.12.2018, 13:16

Sollte mit dem Update behoben sein.

**Tina** · 04.12.2018, 13:28

Alles klar, lieben Dank für die schnelle Hilfe!

**Claudi** · 04.12.2018, 13:30

WORKS

Vielen DANK für das schnelle UPDATE!!

**allmächt!** · 04.12.2018, 14:49

Zitat von xchs

Contao 4.6.10 und Contao 4.4.30 wurden vorhin veröffentlicht. Das Problem sollte dort behoben sein.

Ja, alles ist wieder ok mit 4.6.10!

Grüße
Rudolf

**sfx** · 18.12.2018, 15:06

Zitat von Spooky

Mit der nächsten Contao Version wird das behoben sein (sowohl Contao 4.4 als auch 4.6). Bis dorthin kannst du den conflict in deiner composer.json eintragen und ein update machen. Sobald die nächste Contao Version veröffentlicht wurde, kannst du den conflict wieder entfernen.

Ich steh grad aufn Schlauch, habe die LTS 4.4.23, wie mache ich nun das update auf die 4.4.30 ? wenn ich über den contao - manager das in "4.4.*" eintrage, tut sich nichts beim updaten!?

Wie muss ich das dann machen ?

UPDATE

OK, mein Fehler, es reichte nicht nur "Contao Open Source CMS" upzudaten... nun ist es auf Version 4.4.31...jedoch bleibt das Problem mit dem installtool leider bestehen.

HTML-Code:

app.CRITICAL: An exception occurred. {"exception":"[object] (Doctrine\\DBAL\\Schema\\SchemaException(code: 30): There is no column with name 'path(333)' on table 'tl_files'. at /var/customers/webs/id11/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/SchemaException.php:82)"}

Habe Webgo managed Server
PHP 7.1
MySQL-Server-Version: 5.5.5-10.2.19-MariaDB-10.2.19+maria~stretch-log

**Spooky** · 18.12.2018, 15:16

Hast du den conflict Eintrag gemacht?

**sfx** · 18.12.2018, 15:42

Zitat von Spooky

Hast du den conflict Eintrag gemacht?

hm, ne glaube nicht, hab unter confict in der composer.json folgenden drin:

HTML-Code:

"conflict": {
        "contao-components/installer": "<1.3",
        "contao/core-bundle": "<4.4.8"

was muss ich da eintragen !?

**Spooky** · 18.12.2018, 15:42

Siehe https://community.contao.org/de/show...table-tl_files

**PaddySD** · 18.12.2018, 15:47

Code:

"conflict": {
        "contao-components/installer": "<1.3",
        "contao/core-bundle": "<4.4.8",
        "doctrine/dbal": "2.9.1"

**sfx** · 19.12.2018, 11:06

Vielen Dank,

leider besteht der Fehler immernoch :-(

HTML-Code:

app.CRITICAL: An exception occurred. {"exception":"[object] (Doctrine\\DBAL\\Schema\\SchemaException(code: 30): There is no column with name 'path(333)' on table 'tl_files'. at /var/customers/webs/id11/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/SchemaException.php:82)"} []

meine composer.json:

Code:

    "name": "contao/managed-edition",
    "type": "project",
    "description": "Contao Open Source CMS",
    "license": "LGPL-3.0-or-later",
    "authors": [
        {
            "name": "Leo Feyer",
            "homepage": "https://github.com/leofeyer"
        }
    ],
    "require": {
        "php": "^5.6 || ^7.0",
        "contao/calendar-bundle": "^4.4",
        "contao/comments-bundle": "^4.4",
        "contao/faq-bundle": "^4.4",
        "contao/listing-bundle": "^4.4",
        "contao/manager-bundle": "4.4.*",
        "contao/news-bundle": "^4.4",
        "contao/newsletter-bundle": "^4.4",
        "heimrichhannot/contao-multifileupload-bundle": "^1.0",
        "markocupic/gallery-creator-bundle": "^1.0",
        "oneup/contao-email-login": "^1.2",
        "premium-contao-themes/pct_theme_installer": "^1.2",
        "terminal42/contao-changelanguage": "^3.1",
        "terminal42/contao-fineuploader": "^2.1",
        "terminal42/contao-html-injection": "^1.1"
    },
    "conflict": {
        "contao-components/installer": "<1.3",
        "contao/core-bundle": "<4.4.8",
        "doctrine/dbal": "2.9.1"
    },
    "extra": {
        "branch-alias": {
            "dev-4.4": "4.4.x-dev"
        },
        "contao-component-dir": "assets"
    },
    "scripts": {
        "post-install-cmd": [
            "Contao\\ManagerBundle\\Composer\\ScriptHandler::initializeApplication"
        ],
        "post-update-cmd": [
            "Contao\\ManagerBundle\\Composer\\ScriptHandler::initializeApplication"
        ]
    }
}

muss ich irgendwo noch ein cache oder ähnl. leeren !?