Owncloud 8.2 to nextcloud 9.0 upgrade error - should I be concerned?

Hi,

Just testing out an upgrade path and got the following error on ./occ upgrade

Is this an error to be concerned about?

Updated to 0.4.1 notifications: An exception occurred while executing 'CREATE TABLE `oc_notifications` (`notification_id` INT AUTO_INCREMENT NOT NULL, `app` VARCHAR(32) NOT NULL, `user` VARCHAR(64) NOT NULL, `timestamp` INT DEFAULT 0 NOT NULL, `object_type` VARCHAR(64) NOT NULL, `object_id` VARCHAR(64) NOT NULL, `subject` VARCHAR(64) NOT NULL, `subject_parameters` LONGTEXT DEFAULT NULL, `message` VARCHAR(64) DEFAULT NULL, `message_parameters` LONGTEXT DEFAULT NULL, `link` VARCHAR(4000) DEFAULT NULL, `actions` LONGTEXT DEFAULT NULL, INDEX oc_notifications_app (`app`), INDEX oc_notifications_user (`user`), INDEX oc_notifications_timestamp (`timestamp`), INDEX oc_notifications_object (`object_type`, `object_id`), PRIMARY KEY(`notification_id`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB':

SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘oc_notifications’ already exists

I had the same issues. I eventually did upgrade and all seems okay, but every update gives the same type of errors (oc_ is my tableprefix):

(the latest update - 9.0.52.0 --> 9.0.53.)

dav: 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[42S01]: Base table or view already exists: 1050 Table ‘oc_addressbooks’ already exists
notifications: An exception occurred while executing ‘CREATE TABLE oc_notifications (notification_id INT AUTO_INCREMENT NOT NULL, app VARCHAR(32) NOT NULL, user VARCHAR(64) NOT NULL, timestamp INT DEFAULT 0 NOT NULL, object_type VARCHAR(64) NOT NULL, object_id VARCHAR(64) NOT NULL, subject VARCHAR(64) NOT NULL, subject_parameters LONGTEXT DEFAULT NULL, message VARCHAR(64) DEFAULT NULL, message_parameters LONGTEXT DEFAULT NULL, link VARCHAR(4000) DEFAULT NULL, actions LONGTEXT DEFAULT NULL, INDEX oc_notifications_app (app), INDEX oc_notifications_user (user), INDEX oc_notifications_timestamp (timestamp), INDEX oc_notifications_object (object_type, object_id), PRIMARY KEY(notification_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB’:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘oc_notifications’ already exists
federation: An exception occurred while executing ‘CREATE TABLE oc_trusted_servers (id INT AUTO_INCREMENT NOT NULL, url VARCHAR(512) NOT NULL COMMENT ‘Url of trusted server’, url_hash VARCHAR(255) DEFAULT ‘’ NOT NULL COMMENT ‘sha1 hash of the url without the protocol’, token VARCHAR(128) DEFAULT NULL COMMENT ‘token used to exchange the shared secret’, shared_secret VARCHAR(256) DEFAULT NULL COMMENT ‘shared secret used to authenticate’, status INT DEFAULT 2 NOT NULL COMMENT ‘current status of the connection’, sync_token VARCHAR(512) DEFAULT NULL COMMENT ‘cardDav sync token’, UNIQUE INDEX url_hash (url_hash), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB’:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘oc_trusted_servers’ already exists

@lennard, which version of ownCloud 8.2.x did you upgrade from? I got the same errors you just posted when i attempted to upgrade from 8.2.1 to 9.0.52. it would not allow me to go in to Nextcloud due to these errors.

Hi, Sorry for the late reply.

From top of my head, I tried to upgrade from 8.2.1 to 9.0.50. I eventually managed to do so with a few manual hacks in the database. They are described somewhere on the forum. I do however know, that if these errors keep occurring with every future update/patch, I’ll just download all my files and do a fresh reinstall. (I only have a few users)