Problem bei Datenbank aktualisieren
Hallo zusammen,
bei der neuen Insrtallation von Contao4.4 erscheint folgendes Problem. Contao/install die Datenbank wird geöffnet, die Daten sollen bereinigt werden. darauf erscheint eine Fehlermeldung, die empfiehlt in der log-datei nachzusehen. Dort steht:
[2018-01-30 19:50:47] request.INFO: Matched route "contao_install". {"route":"contao_install","route_parameters":{"_sc ope":"backend","_token_check":true,"_controller":" Contao\\InstallationBundle\\Controller\\Installati onController::installAction","_route":"contao_inst all"},"request_uri":"http://scse-neu.de/contao/install","method":"POST"} []
[2018-01-30 19:50:47] app.CRITICAL: An exception occurred. {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred while executing 'ALTER TABLE tl_article CHANGE id 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 /customers/b/c/8/scse-neu.de/httpd.www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, 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 /customers/b/c/8/scse-neu.de/httpd.www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:106, 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 /customers/b/c/8/scse-neu.de/httpd.www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104)"} []
Der Fehler erscheint immer wieder, wenn man die contao/install aufruft und die Datenbank aktualisieren will.
Was ist zu tun?
Problem Datenbank-Update 1&1 - Contao
Hallo,
ich habe bei 1&1 das gleiche Problem, bekomme es aber leider nicht hin :(
Contao: 4.6.14
[2019-02-17 13:50:44] 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":"http://xxxx.de/contao/install","method":"POST"} []
[2019-02-17 13:50:44] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing 'ALTER TABLE tl_page CHANGE id 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 /homepages/22/d255246729/htdocs/xxxxx/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 126 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred while executing 'ALTER TABLE tl_page CHANGE id 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 /homepages/22/d255246729/htdocs/ixxxx/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:126, 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 /homepages/22/d255246729/htdocs/xxxx/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:109, 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 /homepages/22/d255246729/htdocs/xxxx/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:107)"} []
@Spooky: wenn du es nachvollziehen möchtest, melde dich bitte via PN