Calendar und Contacts funktionieren nicht mehr nach Update auf OC10.0

lefherz · April 27, 2017, 2:28pm

Es gibt jetzt ein github issue für den bug:

github.com/owncloud/core

missing databasefield "publicuri" in oc_dav_shares after upgrade to 10.0.0 (stable) from 9.1.5

opened 12:10PM - 27 Apr 17 UTC

closed 11:25AM - 03 May 17 UTC

mkeller0815

Type:Bug status/STALE

Using ubuntu 14.04 and the official repo: http://download.owncloud.org/download…/repositories/stable/Ubuntu_14.04/ I upgraded from 9.1.5 to 10.0.0 (stable). I also upgraded to php5.6. The "occ upgrade" went fine without any issues. I had also run the "repair" command to possibly fix the issue. The problem is the calendar app. After upgrading to the version for 10.0.0. it shows no calendars, only the rotating "load icon". Checking the ajax-calls it seems that the call to "/remote.php/dav/calendars/mario/" fails with ``` <?xml version="1.0" encoding="utf-8"?> <d:error xmlns:d="DAV:" xmlns:s="http://sabredav.org/ns"> <s:exception>Doctrine\DBAL\Exception\InvalidFieldNameException</s:exception> <s:message>An exception occurred while executing 'SELECT `publicuri` FROM `oc_dav_shares` WHERE (`resourceid` = ?) AND (`access` = ?)' with params ["1", 4]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'publicuri' in 'field list'</s:message> </d:error> ``` checking the database this field seems to be missing: ``` mysql> describe oc_dav_shares; │··· +--------------+---------------------+------+-----+---------+----------------+ │··· | Field | Type | Null | Key | Default | Extra | │··· +--------------+---------------------+------+-----+---------+----------------+ │··· | id | bigint(20) unsigned | NO | PRI | NULL | auto_increment | │··· | principaluri | varchar(255) | YES | MUL | NULL | | │··· | type | varchar(255) | YES | | NULL | | │··· | access | smallint(6) | YES | | NULL | | │··· | resourceid | int(10) unsigned | NO | | NULL | | │··· +--------------+---------------------+------+-----+---------+----------------+ │··· 5 rows in set (0.00 sec) ``` I found an migration-Script in apps/dav/appinfo/Migrations/Version20170116150538.php that should add this field, but it seems that is was not running or it hasn'tnt added the field.