Calendar is not showing anymore

jurgenhaas · December 5, 2016, 9:37am

I’m on Nextcloud 10.0.1 and the calendar app 1.4.1 and the calendar stopped showing up this morning with the following javascript error in the browser console:

TypeError: props[(("{" + DavClient.NS_IETF) + "}calendar-home-set")][0] is undefined

This is thrown in /apps/calendar/js/public/app.js in line 4499 This is happening in both Chrome and Firefox, both latest versions on Ubuntu.

But I’m not sure if that is the root of the problem because the CalDav in Thunderbird stopped working this morning as well. To my knowledge, nothing has changed server side but the clients got updated.

In Firefox I get some Content Security Poilcy errors as well. But not in Chrome.

georgehrke · December 5, 2016, 9:58pm

Hm, if Thunderbird stopped working as well, this is probably not related to the calendar app (which is only a CalDAV client running in your browser.)

Did you make any changes to the Nextcloud instance itself or the configuration of the webserver (or any reverse proxy in front of it)?

jurgenhaas · December 6, 2016, 8:23am

I had tried Spreed.ME before the weekend but when I saw the problem I reverted back to the state before then. I know that this is exactly what it was before, because I’m making changes through Ansible, so there is no manual editing of config files, it’s all driven by scripts.

What I realized though was that the /apps/calendar directory had a time stamp of Dec 1st, so the app miust have been updated and here I admit I don’t know which version I had before.

So I went back to version 1.4.0, ran the occ update and got the same issue. Then I went back to version 1.3.3, same problem. Back to 1.4.1 and every time running occ update without issues, the problem is still there,

However, I do think that it is a CalDav problem, as the problem from the browser happens in a section that is communicating with the DavClient as well, so something with CalDav might have screwed up.

But I can’t find anything in the logs, unfortunately.

georgehrke · December 6, 2016, 8:25pm

Have you tried enabling the debug mode?
The log files should be more verbose then.

jurgenhaas · December 7, 2016, 7:05am

Still no luck. I guess you meant the debugging in index.php/settings/admin/logging

Just for clarity, the calendar loads but stays empty and the two spinning wheels on the left never stop spinning:

In the Apache access lof, there are plenty of entries like these:

217.8.58.12 - jurgenhaas [07/Dec/2016:07:52:35 +0100] "PROPFIND /remote.php/webdav/ HTTP/1.1" 207 1300 "-" "Mozilla/5.0 (Linux) mirall/2.2.4"

The 207 response header means “Mixed response” but I can’t find any more details about those responses.

I even did a complete re-install, whiping the directory before hand. Still no luck.

georgehrke · December 8, 2016, 4:42pm

Do you see some logs with PROPFIND /remote.php/dav/principals/users/username ?

Can you post one of theses if possible?

jurgenhaas · December 8, 2016, 4:49pm

Here is the full log of access log when I try to open the calendar:

217.8.58.12 - - [08/Dec/2016:17:47:30 +0100] "GET /index.php/apps/calendar/ HTTP/1.1" 200 11195 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.75 Safari/537.36"
217.8.58.12 - - [08/Dec/2016:17:47:31 +0100] "GET /apps/calendar/js/vendor/fullcalendar/dist/fullcalendar.css?v=1cec7d9b0055fbec9f815488c35974e9 HTTP/1.1" 200 8463 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.75 Safari/537.36"
217.8.58.12 - - [08/Dec/2016:17:47:31 +0100] "GET /apps/calendar/js/vendor/jquery-timepicker/jquery.ui.timepicker.css?v=1cec7d9b0055fbec9f815488c35974e9 HTTP/1.1" 200 1524 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.75 Safari/537.36"
217.8.58.12 - - [08/Dec/2016:17:47:31 +0100] "GET /apps/calendar/css/public/app.css?v=1cec7d9b0055fbec9f815488c35974e9 HTTP/1.1" 200 5078 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.75 Safari/537.36"
217.8.58.12 - - [08/Dec/2016:17:47:31 +0100] "GET /apps/calendar/l10n/de.js?v=1cec7d9b0055fbec9f815488c35974e9 HTTP/1.1" 200 4154 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.75 Safari/537.36"
217.8.58.12 - - [08/Dec/2016:17:47:31 +0100] "GET /apps/calendar/js/vendor/jstzdetect/jstz.js?v=1cec7d9b0055fbec9f815488c35974e9 HTTP/1.1" 200 4807 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.75 Safari/537.36"
217.8.58.12 - - [08/Dec/2016:17:47:31 +0100] "GET /apps/calendar/js/vendor/jquery-timepicker/jquery.ui.timepicker.js?v=1cec7d9b0055fbec9f815488c35974e9 HTTP/1.1" 200 15077 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.75 Safari/537.36"
217.8.58.12 - - [08/Dec/2016:17:47:31 +0100] "GET /apps/calendar/js/vendor/ical.js/build/ical.js?v=1cec7d9b0055fbec9f815488c35974e9 HTTP/1.1" 200 59834 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.75 Safari/537.36"
217.8.58.12 - - [08/Dec/2016:17:47:31 +0100] "GET /apps/calendar/js/vendor/angular-bootstrap/ui-bootstrap.js?v=1cec7d9b0055fbec9f815488c35974e9 HTTP/1.1" 200 53178 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.75 Safari/537.36"
217.8.58.12 - - [08/Dec/2016:17:47:31 +0100] "GET /apps/calendar/js/vendor/angular-bootstrap/ui-bootstrap-tpls.js?v=1cec7d9b0055fbec9f815488c35974e9 HTTP/1.1" 200 56866 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.75 Safari/537.36"
217.8.58.12 - - [08/Dec/2016:17:47:31 +0100] "GET /apps/calendar/js/vendor/fullcalendar/dist/locale-all.js?v=1cec7d9b0055fbec9f815488c35974e9 HTTP/1.1" 200 33793 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.75 Safari/537.36"
217.8.58.12 - - [08/Dec/2016:17:47:31 +0100] "GET /apps/calendar/js/vendor/davclient.js/lib/client.js?v=1cec7d9b0055fbec9f815488c35974e9 HTTP/1.1" 200 3677 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.75 Safari/537.36"
217.8.58.12 - - [08/Dec/2016:17:47:31 +0100] "GET /apps/calendar/js/vendor/hsl_rgb_converter/converter.js?v=1cec7d9b0055fbec9f815488c35974e9 HTTP/1.1" 200 1233 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.75 Safari/537.36"
217.8.58.12 - - [08/Dec/2016:17:47:31 +0100] "GET /apps/calendar/js/vendor/fullcalendar/dist/fullcalendar.js?v=1cec7d9b0055fbec9f815488c35974e9 HTTP/1.1" 200 100527 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.75 Safari/537.36"
217.8.58.12 - - [08/Dec/2016:17:47:31 +0100] "GET /apps/calendar/js/public/app.js?v=1cec7d9b0055fbec9f815488c35974e9 HTTP/1.1" 200 41369 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.75 Safari/537.36"
217.8.58.12 - - [08/Dec/2016:17:47:31 +0100] "GET /apps/calendar/js/vendor/angular/angular.js?v=1cec7d9b0055fbec9f815488c35974e9 HTTP/1.1" 200 293979 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.75 Safari/537.36"
217.8.58.12 - - [08/Dec/2016:17:47:31 +0100] "GET /index.php/core/js/oc.js?v=1cec7d9b0055fbec9f815488c35974e9 HTTP/1.1" 200 3395 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.75 Safari/537.36"
217.8.58.12 - - [08/Dec/2016:17:47:31 +0100] "GET /apps/calendar/img/rightarrow.svg HTTP/1.1" 304 263 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.75 Safari/537.36"
217.8.58.12 - - [08/Dec/2016:17:47:31 +0100] "GET /apps/calendar/img/leftarrow.svg HTTP/1.1" 304 263 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.75 Safari/537.36"
217.8.58.12 - - [08/Dec/2016:17:47:32 +0100] "GET /apps/calendar/templates/colorpicker.html HTTP/1.1" 200 923 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.75 Safari/537.36"
217.8.58.12 - - [08/Dec/2016:17:47:31 +0100] "GET /index.php/avatar/jurgenhaas/32 HTTP/1.1" 200 1907 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.75 Safari/537.36"
217.8.58.12 - - [08/Dec/2016:17:47:32 +0100] "POST /index.php/apps/calendar/v1/config HTTP/1.1" 200 799 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.75 Safari/537.36"
217.8.58.12 - - [08/Dec/2016:17:47:32 +0100] "GET /index.php/apps/calendar/v1/timezones/EUROPE/BERLIN.ics HTTP/1.1" 200 1193 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.75 Safari/537.36"
217.8.58.12 - - [08/Dec/2016:17:47:32 +0100] "PROPFIND /remote.php/dav HTTP/1.1" 207 1538 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.75 Safari/537.36"
217.8.58.12 - - [08/Dec/2016:17:47:34 +0100] "PROPFIND /remote.php/dav/principals/users/jurgenhaas/ HTTP/1.1" 207 1472 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.75 Safari/537.36"

Does that tell you anything?

jurgenhaas · December 11, 2016, 10:41am

I have upgraded to version 10.0.2 and now my calendar is working again. I have no idea what went wrong before and I guess we’ll never find out.

steffen · March 21, 2017, 10:47pm

We have the same error in version 11.

10.0.2 it´s OK but Update to 11.0.2 “the calendar loads but stays empty and the two spinning wheels on the left never stop spinning”

steffen · May 24, 2017, 6:39am

This is my solution

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.

ALTER TABLE oc_dav_shares ADD publicuri VARCHAR(255) NOT NULL AFTER principaluri;

Thank You

Aaron_Mandel · April 8, 2019, 2:47pm

So @steffen, the full set of columns should be:
id, principaluri, type, access, resourceid, publicuri

Correct?

Thank you!