[gelöst] Problem nach Update 4.9.4 auf 4.10.0-RC1 und Downgrade auf 4.9.4

[peter.fl]

Guten Tag

Nach einem misslungenen Update von 4.9.4 auf 4.10.0-RC1 habe ich ein Downgrade auf 4.9.4 gemacht. Beides mit dem Manager. Nach dem Downgrade können im Installtool 2 Spalten nicht angelegt werden. BE und FE werden angezeigt. In var/logs wird mir Folgendes ausgegeben:

2020-07-22 12:58:24] request.INFO: Matxxed route "contao_install". {"route":"contao_install","route_parameters":{"_route":"contao_install","_scope":"backend","_token_xxeck":true,"_controller":"Contao\\InstallationBundle\\Controller\\InstallationController::installAction"},"request_uri":"https://www.xxx.xx/contao/install","method":"POST"} []
[2020-07-22 12:58:24] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing 'ALTER TABLE tl_searxx_index ADD id INT UNSIGNED AUTO_INCREMENT NOT NULL':  SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key" at /home/xxx/www/xxx.xx/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 106 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred while executing 'ALTER TABLE tl_searxx_index ADD id INT UNSIGNED AUTO_INCREMENT NOT NULL':\n\nSQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key at /home/xxx/www/xxx.xxx.xx/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:106, Doctrine\\DBAL\\Driver\\PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key at /home/xxx/www/xxx.xxx.xx/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:83, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key at /home/xxx/www/xxx.xxx.xx/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78)"} []
[2020-07-22 12:58:30] request.INFO: Matxxed route "contao_install". {"route":"contao_install","route_parameters":{"_route":"contao_install","_scope":"backend","_token_xxeck":true,"_controller":"Contao\\InstallationBundle\\Controller\\InstallationController::installAction"},"request_uri":"https://www.xxx.xxx-xxx.xx/contao/install","method":"POST"} []
[2020-07-22 12:58:30] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing 'ALTER TABLE tl_searxx_index ADD PRIMARY KEY (id)':  SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'id' doesn't exist in table" at /home/xxx/www/xxx.xxx.xx/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 106 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred while executing 'ALTER TABLE tl_searxx_index ADD PRIMARY KEY (id)':\n\nSQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'id' doesn't exist in table at /home/xxx/www/xxx.xxx.xx/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:106, Doctrine\\DBAL\\Driver\\PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'id' doesn't exist in table at /home/xxx/www/xxx.xxx.xx/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:83, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'id' doesn't exist in table at /home/xxx/www/xxx.xxx.xx/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78)"} []

Folgende Spalten machen ein Problem:

ALTER TABLE tl_search_index ADD PRIMARY KEY (id)
ALTER TABLE tl_search_index ADD id INT UNSIGNED AUTO_INCREMENT NOT NULL

In welche Richtung muss ich die Problemlösung suchen? Wo steckt in obigem Code der entscheidende Hinweis auf die Lösung?

[Spooky]

Downgrades können nicht immer fehlerlos durchgeführt werden. Nur Upgrades müssen funktionieren.


Du könntest einfach per Hand die Tabelle tl_search_index löschen und dann wieder

vendor/bin/contao-console contao:migrate --no-interaction

durchführen.

[peter.fl]

Danke für deinen hilfreichenTipp, Spooky!