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

ℹ️ Support
1

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

2

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

3

@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.

4

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)