Probleme bei Update von 4.4.20 auf 4.4.50

**eixi** · 04.08.2020, 14:58

Nach etlichen Versuchen hat es jetzt geklappt, von 4.4.20 auf 4.4.50 upzudaten - mehrere Male müsste ich in Safe Mode gehen...

Leider lässt sich das Installtool nicht aufrufen.

In var/logs wird als letztes Meldung dies vermerkt:

Code:

[2020-08-04 15:54:03] 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 = 'varsek_db1' 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 /usr/www/users/varsek/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 /usr/www/users/varsek/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 /usr/www/users/varsek/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:88)"} []

"Syntax error or access violation: 1064 You have an error in your SQL syntax;"... !?
Kann mir jemand helfen, was das bedeutet? Hilft es, das Backup der Datenbank einzuspielen?

**eixi** · 05.08.2020, 15:16

Leider besteht der Fehler auch nach dem Einspielen der alten DB noch immer. Installtool lässt sich nicht aufrufen, Backend und Frontend funktionieren.

MySQL v. 5.7.31

Code:

[2020-08-05 16:07:42] 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.website.at/contao/install","method":"GET"} []
[2020-08-05 16:07:42] 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 = 'varsek_db1' 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 /usr/www/users/varsek/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 
/usr/www/users/varsek/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:83, 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 /usr/www/users/varsek/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78)"} []

Irgendwelche Ideen?

**Spooky** · 05.08.2020, 16:38

Der Fehler sollte eigentlich seit Contao 4.4.30 nicht mehr existieren. Siehe https://github.com/contao/contao/issues/212

Auf welcher Contao Version bist du nun?

**eixi** · 07.08.2020, 08:23

Ich bin jetzt schrittweise auf 4.4.30 gegangen...

Installtool lässt sich weiterhin nicht aufrufen (nach Passwortabfrage...)

Neue Fehlermeldung:

Code:

[2020-08-07 09:21:04] 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 
/usr/www/users/varsek/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/SchemaException.php:85)"} []

**Spooky** · 07.08.2020, 08:25

Zitat von eixi

Ich bin jetzt schrittweise auf 4.4.30 gegangen...

Warum hast du das gemacht? Du musst einfach auf Contao 4.4.50 aktualisieren. Trage für das Contao Open Course CMS (bzw. contao/manager-bundle) als Version Requirement ~4.4.50 ein und aktualisiere alle Pakete.

**eixi** · 07.08.2020, 08:33

direkt auf 4.4.50 hat's die Installation in Contao Manager jedesmal abgebrochen...

jetzt bin ich schrittweise raufgegangen und siehe da: es funktioniert!

Danke!