Error during upgrade

tflidd · October 13, 2016, 9:17pm

You had this problem already during the last update:

And there was an issue in owncloud that was fixed:

github.com/owncloud/core

Owncloud 8.2.2 manual upgrade to version 9.0.0 fails

opened 08:44PM - 08 Mar 16 UTC

closed 07:01PM - 06 Apr 16 UTC

samuelstein

Type:Bug db:mysql sev2-high app:dav

### Steps to reproduce 1. Owncloud 8.2.2 with addressbook needs to be installed …2. Manual upgrade installation to 9.0.0 (See: https://doc.owncloud.org/server/9.0/admin_manual/maintenance/manual_upgrade.html) 3. Open index.php ### Expected behaviour Owncloud and apps should be upgraded ### Actual behaviour owncloud.log shows following error: ``` json { "reqId": "wQzVLIALlhFjT6ci8uiC", "remoteAddr": "10.30.7.137", "app": "core", "message": "Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\DriverException\",\"Message\":\"An exception occurred while executing 'CREATE TABLE `oc_addressbooks` (`id` BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, `principaluri` VARCHAR(255) DEFAULT NULL, `displayname` VARCHAR(255) DEFAULT NULL, `uri` VARCHAR(255) DEFAULT NULL, `description` VARCHAR(255) DEFAULT NULL, `synctoken` INT UNSIGNED DEFAULT 1 NOT NULL, UNIQUE INDEX addressbook_index (`principaluri`, `uri`), PRIMARY KEY(`id`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB':\\n\\nSQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes\",\"Code\":0,\"Trace\":\"#0 \\/is\\/htdocs\\/wp10838123_LGOL2QNNTD\\/www\\/samuelstein.de\\/owncloud\\/3rdparty\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/DBALException.php(116): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\/is\\/htdocs\\/wp10838123_LGOL2QNNTD\\/www\\/samuelstein.de\\/owncloud\\/3rdparty\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Connection.php(945): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'CREATE TABLE `o...')\\n#2 \\/is\\/htdocs\\/wp10838123_LGOL2QNNTD\\/www\\/samuelstein.de\\/owncloud\\/lib\\/private\\/db\\/mdb2schemamanager.php(167): Doctrine\\\\DBAL\\\\Connection->query('CREATE TABLE `o...')\\n#3 \\/is\\/htdocs\\/wp10838123_LGOL2QNNTD\\/www\\/samuelstein.de\\/owncloud\\/lib\\/private\\/db\\/mdb2schemamanager.php(70): OC\\\\DB\\\\MDB2SchemaManager->executeSchemaChange(Object(Doctrine\\\\DBAL\\\\Schema\\\\Schema))\\n#4 \\/is\\/htdocs\\/wp10838123_LGOL2QNNTD\\/www\\/samuelstein.de\\/owncloud\\/lib\\/private\\/db.php(172): OC\\\\DB\\\\MDB2SchemaManager->createDbFromStructure('\\/is\\/htdocs\\/wp10...')\\n#5 \\/is\\/htdocs\\/wp10838123_LGOL2QNNTD\\/www\\/samuelstein.de\\/owncloud\\/lib\\/private\\/installer.php(567): OC_DB::createDbFromStructure('\\/is\\/htdocs\\/wp10...')\\n#6 \\/is\\/htdocs\\/wp10838123_LGOL2QNNTD\\/www\\/samuelstein.de\\/owncloud\\/lib\\/private\\/installer.php(546): OC_Installer::installShippedApp('dav')\\n#7 \\/is\\/htdocs\\/wp10838123_LGOL2QNNTD\\/www\\/samuelstein.de\\/owncloud\\/lib\\/private\\/updater.php(336): OC_Installer::installShippedApps()\\n#8 \\/is\\/htdocs\\/wp10838123_LGOL2QNNTD\\/www\\/samuelstein.de\\/owncloud\\/lib\\/private\\/updater.php(215): OC\\\\Updater->doUpgrade('9.0.0.19', '8.2.2.2')\\n#9 \\/is\\/htdocs\\/wp10838123_LGOL2QNNTD\\/www\\/samuelstein.de\\/owncloud\\/core\\/ajax\\/update.php(120): OC\\\\Updater->upgrade()\\n#10 {main}\",\"File\":\"\\/is\\/htdocs\\/wp10838123_LGOL2QNNTD\\/www\\/samuelstein.de\\/owncloud\\/3rdparty\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Driver\\/AbstractMySQLDriver.php\",\"Line\":115}", "level": 3, "time": "2016-03-08T20:07:11+00:00", "method": "GET", "url": "/core/ajax/update.php?requesttoken=WRxtLlhgIlocD3IGPCssBj0sXBgyNhgkUSQrXz0c%3Ak%2F%2BM75thUXA1tOtseI0BTYBEfgj6ZjBRLS9nXn8d" } ``` ### Server configuration **Operating system**: shared space at hosteurope **Web server:** apache **Database:** mysql **PHP version:** latest 5 Login as admin user into your ownCloud and access http://example.com/index.php/settings/integrity/failed paste the results here: ``` `ownCloud wird auf Version 9.0.0 aktualisiert. Das könnte eine Weile dauern. Update vorbereiten Log-Level auf "debug" gesetzt Wartungsmodus eingeschaltet Prüft, ob das Datenbankschema aktualisiert werden kann (dies kann je nach Datenbankgröße sehr lange dauern) Datenbankschema-Aktualisierung überprüft Es wird nach Updates für die Apps gesucht Datenbankschema-Aktualisierung für Apps überprüft Das Datenbankschema wird aktualisiert Datenbank aktualisiert Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'CREATE TABLE `oc_addressbooks` (`id` BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, `principaluri` VARCHAR(255) DEFAULT NULL, `displayname` VARCHAR(255) DEFAULT NULL, `uri` VARCHAR(255) DEFAULT NULL, `description` VARCHAR(255) DEFAULT NULL, `synctoken` INT UNSIGNED DEFAULT 1 NOT NULL, UNIQUE INDEX addressbook_index (`principaluri`, `uri`), PRIMARY KEY(`id`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB': SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes` ``` **List of activated apps:** **Are you using external storage:** no **Are you using encryption:** no **Are you using an external user-backend:** no ### Client configuration **Browser:** 48.0.2564.116 m (64-bit) **Operating system:** windows 7 #### Browser log Insert your browser log here, this could for example include: a) The javascript console log: 'https://ssl.webpack.de/cloud.samuelstein.de/core/js/oc.js?v=d78eff885055a5dff1258825d52763d5 Failed to load resource: the server responded with a status of 500 (Internal Server Error)'

@nickvergessen what can the user do to avoid this error in the future?