Error after Update

[bforpc]

Turned on maintenance mode
Failed to update database structure (MDB2 Error: unknown error, _doQuery: [Error message: Could not execute statement] [Last executed query: ALTER TABLE oc_locks CHANGE id id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, CHANGE timeout timeout INT UNSIGNED DEFAULT 0, CHANGE created created BIGINT DEFAULT 0, CHANGE scope scope TINYINT DEFAULT 0, CHANGE depth depth TINYINT DEFAULT 0] [Native code: 1068] [Native message: Multiple primary key defined] )

The update was unsuccessful. Please report this issue to the ownCloud community.

[ghost]

Hi,

seems this is a duplicate of #4085 and #4084 where you can find more infos about this issue.

[bforpc]

Ok... so what can i do?
Ihave manually executed this SQL statemenst like in issue 4085 described:
ALTER TABLE oc_locks DROP PRIMARY KEY;
ALTER TABLE oc_queuedtasks CHANGE id id INT( 11 ) NOT NULL;
ALTER TABLE oc_queuedtasks DROP PRIMARY KEY;
ALTER TABLE oc_vcategory CHANGE id id INT( 11 ) NOT NULL;
ALTER TABLE oc_vcategory DROP PRIMARY KEY;

I get now an emty page with this error:

Failed to upgrade "calendar". Exception="Failed to update database structure (MDB2 Error: unknown error, _doQuery: [Error message: Could not execute statement] [Last executed query: ALTER TABLE oc_calendar_objects RENAME TO oc_clndr_objects, CHANGE id id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, CHANGE calendarid calendarid INT UNSIGNED DEFAULT 0 NOT NULL, CHANGE startdate startdate DATETIME DEFAULT '1970-01-01 00:00:00', CHANGE enddate enddate DATETIME DEFAULT '1970-01-01 00:00:00'] [Native code: 1068] [Native message: Multiple primary key defined] )"

Jan

[DeepDiver1975]

the remaining problem is related to the calendar -> please report this issue in the calendar repo. THX

[ghost]

Hi,

the remaining one is already reported here: #4013