Subscription Calendar Events are not returned by REPORT dav request #42143

Juergen-Vollmer · 2023-12-06T15:31:05Z

Steps to reproduce

Add a new calender from an ical link
the dates does not show anymore

Expected behavior

The dates shpoud show, it workded until approx 2 weeks ago.

Actual behaviour

the dates does not show anymore in the webinterface of nextcloud

Calendar app version

4.6.0

CalDAV-clients used

davx5

Browser

firefox, chromium actual versions

Client operating system

opensuse 15.5

Server operating system

opensuse 15.5

Web server

Apache

Database engine version

MariaDB

PHP engine version

None

Nextcloud version

28.0.0 rc2

Updated from an older installed version or fresh install

Updated from an older version

List of activated apps

No response

Nextcloud configuration

Enabled:
- activity: 2.20.0
- admin_audit: 1.18.0
- calendar: 4.6.0
- circles: 28.0.0-dev
- cloud_federation_api: 1.11.0
- comments: 1.18.0
- contacts: 5.5.0-rc.2
- cookbook: 0.10.4
- dav: 1.29.1
- deck: 1.12.0-beta.4
- federatedfilesharing: 1.18.0
- federation: 1.18.0
- files: 2.0.0
- files_external: 1.20.0
- files_markdown: 2.4.1
- files_mindmap: 0.0.30
- files_pdfviewer: 2.9.0
- files_reminders: 1.1.0
- files_sharing: 1.20.0
- files_trashbin: 1.18.0
- files_versions: 1.21.0
- firstrunwizard: 2.17.0
- forms: 4.0.0-alpha.2
- groupfolders: 16.0.0
- keeweb: 0.6.13
- logreader: 2.13.0
- lookup_server_connector: 1.16.0
- mail: 3.5.0-rc.2
- nextcloud_announcements: 1.17.0
- notes: 4.9.0-beta.3
- notifications: 2.16.0
- oauth2: 1.16.3
- password_policy: 1.18.0
- photos: 2.4.0
- polls: 6.0.0-rc1
- previewgenerator: 5.4.0
- privacy: 1.12.0
- provisioning_api: 1.18.0
- recommendations: 2.0.0
- related_resources: 1.3.0
- richdocuments: 8.3.0-beta.1
- serverinfo: 1.18.0
- settings: 1.10.0
- sharebymail: 1.18.0
- spreed: 18.0.0-rc.2
- support: 1.11.0
- survey_client: 1.16.0
- suspicious_login: 6.0.0
- systemtags: 1.18.0
- tasks: 0.15.0
- text: 3.9.1
- theming: 2.3.0
- twofactor_admin: 4.4.0
- twofactor_backupcodes: 1.17.0
- twofactor_email: 2.7.4
- twofactor_totp: 10.0.0-beta.2
- updatenotification: 1.18.0
- user_status: 1.8.1
- viewer: 2.2.0
- weather_status: 1.8.0
- workflowengine: 2.10.0
Disabled:
- afterlogic: 2.0.8 (installed 2.0.8)
- audioplayer: 3.4.0 (installed 3.4.0)
- bruteforcesettings: 2.8.0
- calendar_resource_management: 0.6.0-alpha.1 (installed 0.6.0-alpha.1)
- contactsinteraction: 1.9.0 (installed 1.2.0)
- customproperties: 2.0.4 (installed 2.0.4)
- dashboard: 7.8.0 (installed 7.6.0)
- drawio: 2.1.4 (installed 2.1.4)
- encryption: 2.16.0
- files_readmemd: 2.0.0 (installed 2.0.0)
- files_rightclick: 0.15.1 (installed 1.6.0)
- files_videoplayer: 1.14.0
- integration_collaboard: 1.0.6 (installed 1.0.6)
- phonetrack: 0.7.6 (installed 0.7.6)
- user_ldap: 1.19.0

Web server error log

No response

Log file

No response

Browser log

No response

Additional info

No response

The text was updated successfully, but these errors were encountered:

tcitworld · 2023-12-06T16:50:12Z

Please fill the issue template, we can't help without some details!

In particular, check the output of your nextcloud.log file when removing and re-adding the subscription, as well as your browser logs when loading the calendar app.

Juergen-Vollmer · 2023-12-10T12:36:27Z

Just a short update:
The problem still exists (28.0.0 RC4). The following works:

1) Downloading the ICAL file and store in a file
2) Adding a new caleander and import that file
3) The dates are shown in Nextcloud calender
This shows that the ical file is ok, and display of ical-dates works.
For me it seems that the direct ical-mport via an URL (calender subscription) does not work.

Bye
Jürgen

Juergen-Vollmer · 2023-12-10T13:52:03Z

Now I tried to add the URL again, and I checked the nextlog file. But nothing was written to the log file about adding and deleting the ICAL-subscription. Other messages occur from time to time in the log file.

Jürgen

miaulalala · 2023-12-11T10:02:47Z

Hi @Juergen-Vollmer , have you enabled debug mode? If not, can you try to do so and try adding the calendar again please?

Juergen-Vollmer · 2023-12-11T10:20:53Z

Hi,
I added debug=true and log_level = 0 in the config.php (I just replaced unser and domain names)

Here the logfile output when I add a calendar:

{"reqId":"DPo5OEN8p06AYGN9ag6n","level":0,"time":"2023-12-11T10:14:45+00:00","remoteAddr":"192.168.0.1","user":"j.....","app":"dav","method":"MKCOL","url":"/remote.php/dav/calendars/j...../rapladhbw-karlsruhede-1","message":"Refreshing webcal data for subscription 47","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:120.0) Gecko/20100101 Firefox/120.0","version":"28.0.0.10","data":{"app":"dav"}}
{"reqId":"DPo5OEN8p06AYGN9ag6n","level":2,"time":"2023-12-11T10:14:45+00:00","remoteAddr":"192.168.0.1","user":"j.....","app":"no app in context","method":"MKCOL","url":"/remote.php/dav/calendars/j...../rapladhbw-karlsruhede-1","message":"Using where() on non-empty WHERE part, please verify it is intentional to not call andWhere() or orWhere() instead. Otherwise consider creating a new query builder object or call resetQueryPart('where') first.","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:120.0) Gecko/20100101 Firefox/120.0","version":"28.0.0.10","exception":{"Exception":"Doctrine\\DBAL\\Query\\QueryException","Message":"Using where() on non-empty WHERE part, please verify it is intentional to not call andWhere() or orWhere() instead. Otherwise consider creating a new query builder object or call resetQueryPart('where') first.","Code":0,"Trace":[{"file":"/srv/www/example.domain/www/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php","line":3096,"function":"where","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/srv/www/example.domain/www/nextcloud/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OCA\\DAV\\CalDAV\\{closure}","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/www/example.domain/www/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php","line":3075,"function":"atomic","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->"},{"file":"/srv/www/example.domain/www/nextcloud/apps/dav/lib/CalDAV/WebcalCaching/RefreshWebcalService.php","line":101,"function":"purgeAllCachedEventsForSubscription","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->"},{"file":"/srv/www/example.domain/www/nextcloud/apps/dav/lib/Listener/SubscriptionListener.php","line":61,"function":"refreshSubscription","class":"OCA\\DAV\\CalDAV\\WebcalCaching\\RefreshWebcalService","type":"->"},{"file":"/srv/www/example.domain/www/nextcloud/lib/private/EventDispatcher/ServiceEventListener.php","line":86,"function":"handle","class":"OCA\\DAV\\Listener\\SubscriptionListener","type":"->"},{"file":"/srv/www/example.domain/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":230,"function":"__invoke","class":"OC\\EventDispatcher\\ServiceEventListener","type":"->"},{"file":"/srv/www/example.domain/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":59,"function":"callListeners","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/srv/www/example.domain/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":94,"function":"dispatch","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/srv/www/example.domain/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":106,"function":"dispatch","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/srv/www/example.domain/www/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php","line":2522,"function":"dispatchTyped","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/srv/www/example.domain/www/nextcloud/3rdparty/sabre/dav/lib/CalDAV/CalendarHome.php","line":249,"function":"createSubscription","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/www/example.domain/www/nextcloud/apps/dav/lib/CalDAV/CalendarHome.php","line":94,"function":"createExtendedCollection","class":"Sabre\\CalDAV\\CalendarHome","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/www/example.domain/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1199,"function":"createExtendedCollection","class":"OCA\\DAV\\CalDAV\\CalendarHome","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/www/example.domain/www/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":560,"function":"createCollection","class":"Sabre\\DAV\\Server","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/www/example.domain/www/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpMkcol","class":"Sabre\\DAV\\CorePlugin","type":"->"},{"file":"/srv/www/example.domain/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/srv/www/example.domain/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":253,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/srv/www/example.domain/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":321,"function":"start","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/srv/www/example.domain/www/nextcloud/apps/dav/lib/Server.php","line":370,"function":"exec","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/srv/www/example.domain/www/nextcloud/apps/dav/appinfo/v2/remote.php","line":35,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/srv/www/example.domain/www/nextcloud/remote.php","line":172,"args":["/srv/www/example.domain/www/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/srv/www/example.domain/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","Line":869,"message":"Using where() on non-empty WHERE part, please verify it is intentional to not call andWhere()or orWhere() instead. Otherwise consider creating a new query builder object or call resetQueryPart('where') first.","exception":{},"CustomMessage":"Using where() on non-empty WHERE part, please verify it is intentional to not call andWhere() or orWhere() instead. Otherwise consider creating a new query builder object or call resetQueryPart('where') first."}}
{"reqId":"DPo5OEN8p06AYGN9ag6n","level":2,"time":"2023-12-11T10:14:45+00:00","remoteAddr":"192.168.0.1","user":"j.....","app":"no app in context","method":"MKCOL","url":"/remote.php/dav/calendars/j...../rapladhbw-karlsruhede-1","message":"Using where() on non-empty WHERE part, please verify it is intentional to not call andWhere() or orWhere() instead. Otherwise consider creating a new query builder object or call resetQueryPart('where') first.","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:120.0) Gecko/20100101 Firefox/120.0","version":"28.0.0.10","exception":{"Exception":"Doctrine\\DBAL\\Query\\QueryException","Message":"Using where() on non-empty WHERE part, please verify it is intentional to not call andWhere() or orWhere() instead. Otherwise consider creating a new query builder object or call resetQueryPart('where') first.","Code":0,"Trace":[{"file":"/srv/www/example.domain/www/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php","line":3101,"function":"where","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/srv/www/example.domain/www/nextcloud/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OCA\\DAV\\CalDAV\\{closure}","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/www/example.domain/www/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php","line":3075,"function":"atomic","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->"},{"file":"/srv/www/example.domain/www/nextcloud/apps/dav/lib/CalDAV/WebcalCaching/RefreshWebcalService.php","line":101,"function":"purgeAllCachedEventsForSubscription","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->"},{"file":"/srv/www/example.domain/www/nextcloud/apps/dav/lib/Listener/SubscriptionListener.php","line":61,"function":"refreshSubscription","class":"OCA\\DAV\\CalDAV\\WebcalCaching\\RefreshWebcalService","type":"->"},{"file":"/srv/www/example.domain/www/nextcloud/lib/private/EventDispatcher/ServiceEventListener.php","line":86,"function":"handle","class":"OCA\\DAV\\Listener\\SubscriptionListener","type":"->"},{"file":"/srv/www/example.domain/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":230,"function":"__invoke","class":"OC\\EventDispatcher\\ServiceEventListener","type":"->"},{"file":"/srv/www/example.domain/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":59,"function":"callListeners","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/srv/www/example.domain/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":94,"function":"dispatch","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/srv/www/example.domain/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":106,"function":"dispatch","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/srv/www/example.domain/www/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php","line":2522,"function":"dispatchTyped","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/srv/www/example.domain/www/nextcloud/3rdparty/sabre/dav/lib/CalDAV/CalendarHome.php","line":249,"function":"createSubscription","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/www/example.domain/www/nextcloud/apps/dav/lib/CalDAV/CalendarHome.php","line":94,"function":"createExtendedCollection","class":"Sabre\\CalDAV\\CalendarHome","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/www/example.domain/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1199,"function":"createExtendedCollection","class":"OCA\\DAV\\CalDAV\\CalendarHome","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/www/example.domain/www/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":560,"function":"createCollection","class":"Sabre\\DAV\\Server","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/www/example.domain/www/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpMkcol","class":"Sabre\\DAV\\CorePlugin","type":"->"},{"file":"/srv/www/example.domain/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/srv/www/example.domain/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":253,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/srv/www/example.domain/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":321,"function":"start","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/srv/www/example.domain/www/nextcloud/apps/dav/lib/Server.php","line":370,"function":"exec","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/srv/www/example.domain/www/nextcloud/apps/dav/appinfo/v2/remote.php","line":35,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/srv/www/example.domain/www/nextcloud/remote.php","line":172,"args":["/srv/www/example.domain/www/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/srv/www/example.domain/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","Line":869,"message":"Using where() on non-empty WHERE part, please verify it is intentional to not call andWhere()or orWhere() instead. Otherwise consider creating a new query builder object or call resetQueryPart('where') first.","exception":{},"CustomMessage":"Using where() on non-empty WHERE part, please verify it is intentional to not call andWhere() or orWhere() instead. Otherwise consider creating a new query builder object or call resetQueryPart('where') first."}}
{"reqId":"DPo5OEN8p06AYGN9ag6n","level":0,"time":"2023-12-11T10:14:46+00:00","remoteAddr":"192.168.0.1","user":"j.....","app":"dav","method":"MKCOL","url":"/remote.php/dav/calendars/j...../rapladhbw-karlsruhede-1","message":"Scheduling webcal data refreshment for subscription 47","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:120.0) Gecko/20100101 Firefox/120.0","version":"28.0.0.10","data":{"app":"dav"}}

Now I see here a warning

"File":"/srv/www/example.domain/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","Line":869,"message":"Using where() on non-empty WHERE part, please verify it is intentional to not call andWhere()or orWhere() instead. Otherwise consider creating a new query builder object or call resetQueryPart('where') first."......

May be this helps

Jürgen

miaulalala · 2023-12-11T11:54:05Z

@Juergen-Vollmer can you try to add the patch from #42144 to see if that fixes things? Otherwise I have to dig deeper.

Juergen-Vollmer · 2023-12-11T12:55:27Z

I added two times the line (in source 3095 and 3101)
$query = $this->db->getQueryBuilder();
Is that what you meant?

But still the calender does not show up

But still I get the following in the logfile

deleting a calender

{"Reqidx":"rk9Hex6BwGCD67IPBKMz","level":2,"time":"2023-12-11T12:48:13+00:00","remoteAddr":"192.168.0.1","user":"j.....","app":"no app in context","method":"DELETE","url":"/remote.php/dav/calendars/j...../rapladhbw-karlsruhede-1/","message":"Using where() on non-empty WHERE part, pleaseverify it is intentional to not call andWhere() or orWhere() instead. Otherwise consider creating a new query builder object or call resetQueryPart('where') first.","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:120.0) Gecko/20100101 Firefox/120.0","version":"28.0.0.10","exception":{"Exception":"Doctrine\\DBAL\\Query\\QueryException","Message":"Using where() on non-empty WHERE part, please verify it is intentional to not call andWhere() or orWhere() instead. Otherwise consider creating a new query builder object or call resetQueryPart('where') first.","Code":0,"Trace":[{"file":"/srv/www/example.daomain/www/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php","line":2599,"function":"where","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/srv/www/example.daomain/www/nextcloud/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OCA\\DAV\\CalDAV\\{closure}","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/www/example.daomain/www/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php","line":2584,"function":"atomic","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->"},{"file":"/srv/www/example.daomain/www/nextcloud/3rdparty/sabre/dav/lib/CalDAV/Subscriptions/Subscription.php","line":92,"function":"deleteSubscription","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->"},{"file":"/srv/www/example.daomain/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Tree.php","line":185,"function":"delete","class":"Sabre\\CalDAV\\Subscriptions\\Subscription","type":"->"},{"file":"/srv/www/example.daomain/www/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":281,"function":"delete","class":"Sabre\\DAV\\Tree","type":"->"},{"file":"/srv/www/example.daomain/www/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpDelete","class":"Sabre\\DAV\\CorePlugin","type":"->"},{"file":"/srv/www/example.daomain/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/srv/www/example.daomain/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":253,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/srv/www/example.daomain/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":321,"function":"start","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/srv/www/example.daomain/www/nextcloud/apps/dav/lib/Server.php","line":370,"function":"exec","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/srv/www/example.daomain/www/nextcloud/apps/dav/appinfo/v2/remote.php","line":35,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/srv/www/example.daomain/www/nextcloud/remote.php","line":172,"args":["/srv/www/example.daomain/www/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/srv/www/example.daomain/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","Line":869,"message":"Using where() on non-empty WHERE part, please verify it is intentional to not call andWhere() or orWhere() instead. Otherwise consider creating a new query builder object or call resetQueryPart('where') first.","exception":{},"CustomMessage":"Using where() on non-empty WHERE part, please verify it is intentional to not call andWhere() or orWhere() instead. Otherwise consider creating a new query builder object or call resetQueryPart('where') first."}}
{"reqId":"rk9Hex6BwGCD67IPBKMz","level":2,"time":"2023-12-11T12:48:13+00:00","remoteAddr":"192.168.0.1","user":"j.....","app":"no app in context","method":"DELETE","url":"/remote.php/dav/calendars/j...../rapladhbw-karlsruhede-1/","message":"Using where() on non-empty WHERE part, pleaseverify it is intentional to not call andWhere() or orWhere() instead. Otherwise consider creating a new query builder object or call resetQueryPart('where') first.","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:120.0) Gecko/20100101 Firefox/120.0","version":"28.0.0.10","exception":{"Exception":"Doctrine\\DBAL\\Query\\QueryException","Message":"Using where() on non-empty WHERE part, please verify it is intentional to not call andWhere() or orWhere() instead. Otherwise consider creating a new query builder object or call resetQueryPart('where') first.","Code":0,"Trace":[{"file":"/srv/www/example.daomain/www/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php","line":2604,"function":"where","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/srv/www/example.daomain/www/nextcloud/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OCA\\DAV\\CalDAV\\{closure}","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/www/example.daomain/www/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php","line":2584,"function":"atomic","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->"},{"file":"/srv/www/example.daomain/www/nextcloud/3rdparty/sabre/dav/lib/CalDAV/Subscriptions/Subscription.php","line":92,"function":"deleteSubscription","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->"},{"file":"/srv/www/example.daomain/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Tree.php","line":185,"function":"delete","class":"Sabre\\CalDAV\\Subscriptions\\Subscription","type":"->"},{"file":"/srv/www/example.daomain/www/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":281,"function":"delete","class":"Sabre\\DAV\\Tree","type":"->"},{"file":"/srv/www/example.daomain/www/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpDelete","class":"Sabre\\DAV\\CorePlugin","type":"->"},{"file":"/srv/www/example.daomain/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/srv/www/example.daomain/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":253,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/srv/www/example.daomain/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":321,"function":"start","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/srv/www/example.daomain/www/nextcloud/apps/dav/lib/Server.php","line":370,"function":"exec","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/srv/www/example.daomain/www/nextcloud/apps/dav/appinfo/v2/remote.php","line":35,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/srv/www/example.daomain/www/nextcloud/remote.php","line":172,"args":["/srv/www/example.daomain/www/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/srv/www/example.daomain/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","Line":869,"message":"Using where() on non-empty WHERE part, please verify it is intentional to not call andWhere() or orWhere() instead. Otherwise consider creating a new query builder object or call resetQueryPart('where') first.","exception":{},"CustomMessage":"Using where() on non-empty WHERE part, please verify it is intentional to not call andWhere() or orWhere() instead. Otherwise consider creating a new query builder object or call resetQueryPart('where') first."}}
{"reqId":"rk9Hex6BwGCD67IPBKMz","level":0,"time":"2023-12-11T12:48:13+00:00","remoteAddr":"192.168.0.1","user":"j.....","app":"dav","method":"DELETE","url":"/remote.php/dav/calendars/j...../rapladhbw-karlsruhede-1/","message":"Removing refresh webcal job for subscription 49","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:120.0) Gecko/20100101 Firefox/120.0","version":"28.0.0.10","data":{"app":"dav"}}
{"reqId":"rk9Hex6BwGCD67IPBKMz","level":0,"time":"2023-12-11T12:48:13+00:00","remoteAddr":"192.168.0.1","user":"j.....","app":"dav","method":"DELETE","url":"/remote.php/dav/calendars/j...../rapladhbw-karlsruhede-1/","message":"Cleaning all reminders for subscription 49","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:120.0) Gecko/20100101 Firefox/120.0","version":"28.0.0.10","data":{"app":"dav"}}

adding a calendar

{"reqId":"EwoycRjx7YZGRnqmruKD","level":0,"time":"2023-12-11T12:51:17+00:00","remoteAddr":"192.168.0.1","user":"j....","app":"dav","method":"MKCOL","url":"/remote.php/dav/calendars/j..../rapladhbw-karlsruhede-1","message":"Refreshing webcal data for subscription 51","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:120.0) Gecko/20100101 Firefox/120.0","version":"28.0.0.10","data":{"app":"dav"}}
{"reqId":"EwoycRjx7YZGRnqmruKD","level":0,"time":"2023-12-11T12:51:19+00:00","remoteAddr":"192.168.0.1","user":"j....","app":"dav","method":"MKCOL","url":"/remote.php/dav/calendars/j..../rapladhbw-karlsruhede-1","message":"Scheduling webcal data refreshment for subscription 51","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:120.0) Gecko/20100101 Firefox/120.0","version":"28.0.0.10","data":{"app":"dav"}}

Jürgen

miaulalala · 2023-12-11T15:29:48Z

So the warnings were removed, that's good. Since there is no other error message, can you please check your database?

SELECT * FROM oc_calendarsubscriptions where id = 51;

Juergen-Vollmer · 2023-12-11T15:33:51Z

Hi
here the results (just removed some URL and user details)

MariaDB [nextcloud]> SELECT * FROM oc_calendarsubscriptions where id = 51;
+----+-------------------------+----------------------------------+-------------------------+-------------+---------------+---------------+------------+-------------+------------------+--------------+-----------+---------------------------------------------------------------------------+
| id | uri | principaluri | displayname | refreshrate | calendarorder | calendarcolor | striptodos | stripalarms | stripattachments | lastmodified | synctoken | source |
+----+-------------------------+----------------------------------+-------------------------+-------------+---------------+---------------+------------+-------------+------------------+--------------+-----------+---------------------------------------------------------------------------+
| 51 | rapladhbw..........de-1 | principals/users/j.... | rapla.example.domain | NULL | 0 | #B8BE68 | NULL | NULL | NULL | 1702299077 | 11989 | https://rapla.example.domain/.... |
+----+-------------------------+----------------------------------+-------------------------+-------------+---------------+---------------+------------+-------------+------------------+--------------+-----------+---------------------------------------------------------------------------+
1 row in set (0.000 sec)

miaulalala · 2023-12-11T15:37:19Z

Hi here the results (just removed some URL and user details)

MariaDB [nextcloud]> SELECT * FROM oc_calendarsubscriptions where id = 51; +----+-------------------------+----------------------------------+-------------------------+-------------+---------------+---------------+------------+-------------+------------------+--------------+-----------+---------------------------------------------------------------------------+ | id | uri | principaluri | displayname | refreshrate | calendarorder | calendarcolor | striptodos | stripalarms | stripattachments | lastmodified | synctoken | source | +----+-------------------------+----------------------------------+-------------------------+-------------+---------------+---------------+------------+-------------+------------------+--------------+-----------+---------------------------------------------------------------------------+ | 51 | rapladhbw..........de-1 | principals/users/j.... | rapla.example.domain | NULL | 0 | #B8BE68 | NULL | NULL | NULL | 1702299077 | 11989 | rapla.example.domain.... | +----+-------------------------+----------------------------------+-------------------------+-------------+---------------+---------------+------------+-------------+------------------+--------------+-----------+---------------------------------------------------------------------------+ 1 row in set (0.000 sec)

Can you try and add the webcal uri to thunderbird or evolution to see if it produces data? Or you should be able to visit the uri directly if you remove the webcal:// prefix for the uri, which should give you a download of the full calendar data. Can you check if it contains any future VEVENTs?

Juergen-Vollmer · 2023-12-11T20:17:45Z

Here a link to the ical

https://rapla.dhbw-karlsruhe.de/rapla?page=calendar&user=vollmer&file=tinf21b3

The dates are show in other calendar tools, as well as nextcloud 27 but not in 28

Jürgen

miaulalala · 2023-12-12T11:46:50Z

Here a link to the ical

rapla.dhbw-karlsruhe.de/rapla?page=calendar&user=vollmer&file=tinf21b3

The dates are show in other calendar tools, as well as nextcloud 27 but not in 28

Jürgen

Can you please share the uri format that is in the db? I'm not sure yet what changed, but I think it might be the webcal uri not being able to be resolved.

Did the format for the subscription calendar change on your end recently?

Edit: tried with Thunderbird:

Juergen-Vollmer · 2023-12-12T13:28:23Z

I'm sorry, the ical URL given above is wrong, the correct one is

https://rapla.dhbw-karlsruhe.de/rapla?page=ical&user=vollmer&file=Termine

Using this URL, the ical file is read and synced by thunderbird

I used this correct URL in my nextcloud calender.

miaulalala · 2023-12-13T13:35:40Z

I've been seeing this on my instance now too. Can you take a look at your db?

select id from oc_calendarsubscriptions where source LIKE '%rapla.dhbw-karlsruhe.de/rapla?page=ical&user=vollmer&file=Termine%'

And then take that id and run:

select count(*) from oc_calendarobjects where calendarid = YOUR_ID

to see if there's any rows in the database

Juergen-Vollmer · 2023-12-13T13:57:40Z

select id from oc_calendarsubscriptions where source LIKE '%rapla.dhbw-karlsruhe.de/rapla?page=ical&user=vollmer&file=Termine%'
=> 54

and then

select count(*) from oc_calendar_objects where calendarid = 54;
=> ERROR 1146 (42S02): Table 'nextcloud.oc_calendar_objects' doesn't exist

Jürgen

miaulalala · 2023-12-13T13:59:54Z

select id from oc_calendarsubscriptions where source LIKE '%rapla.dhbw-karlsruhe.de/rapla?page=ical&user=vollmer&file=Termine%' => 54

and then

select count(*) from oc_calendar_objects where calendarid = 54; => ERROR 1146 (42S02): Table 'nextcloud.oc_calendar_objects' doesn't exist

Jürgen

sorry, typo on my end: oc_calendarobjects (wthout the underscore).

Juergen-Vollmer · 2023-12-13T14:12:35Z

here the result:
select id from oc_calendarsubscriptions where source LIKE '%rapla.dhbw-karlsruhe.de/rapla?page=ical&user=vollmer&file=Termine%' => 54

select count(*) from oc_calendarobjects where calendarid = 54;
=> 328

an if I ask:

select * from oc_calendarobjects where calendarid = 54 limit 1;

then I get

| 104922515 | BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Sabre//Sabre VObject 4.5.4//EN
CALSCALE:GREGORIAN
BEGIN:VTIMEZONE
TZID:Europe/Berlin
..... (stuff deleted, the rest of that event)
ATTENDEE;ROLE=REQ-PARTICIPANT;CN="Li, Nuo";PARTSTAT=ACCEPTED:MAILTO:somebody@example.domain
END:VEVENT
END:VCALENDAR
| 006f6b86-2d23-4683-9989-d1612c7c7537.ics | 54 | 1702476302 | ad546e88b10a07f7ca1e0180994f1c4b | 3544 | VEVENT | 1578294000 | 1862413200 | a3ab92de-20a1-4c67-9c81-17d05eeff52a | 0 | 1 | NULL |
+-----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+------------+--------------+----------------------------------+------+---------------+----------------+---------------+--------------------------------------+----------------+--------------+------------+

Jürgen

miaulalala · 2023-12-13T14:20:58Z

Okay same for me locally. The subscription still works but when I look at my frontend requests in calendar, the REPORT returns an empty result.

miaulalala · 2023-12-13T16:09:13Z

Found the culprit in the upstream lib sabre-io/dav#1060

I haven't found the decided issue yet, suffice to say that not all plugins are loaded at the point of evaluation of $node->getChild so the CalendarHome is unaware that is has caching support via \OCA\DAV\CalDAV\WebcalCaching\Plugin, returning a \Sabre\CalDAV\Subscriptions\Subscription instead of a \OCA\DAV\CalDAV\CachedSubscription

miaulalala · 2023-12-13T17:01:29Z

I think this might be down to a combination of caching of paths and the code change that doesn't fully iterate over all subtrees for each node. So we're missing out on calls to all plugins for each child as well. Just a suspicion at this point.

miaulalala · 2024-02-20T14:41:20Z

Should be fixed by sabre-io/dav#1545 but I haven't tested it yet.

gnilebein · 2024-02-20T15:03:58Z

I can confirm that it works!

kavol · 2024-02-20T15:04:59Z

I've applied the patch onto my NC instance and the events from external ICS calendar are shown now; I haven't observed any other breakage so far ... thanks!

tknaller · 2024-02-20T15:08:59Z

can confirm aswell

Juergen-Vollmer · 2024-02-20T16:42:25Z

By adding the code mentioned in here: https://github.com/sabre-io/dav/pull/1545/files
ical-import worked for me again! Thanks a lot!

(Note: I had to remove the "temporary fix" proposed for the file apps/dav/lib/CalDAV/CalendarHome.php -> #42257)

Jürgen

mschmitt · 2024-02-20T18:50:50Z

Rolled back the manual workaround.

$ cp htdocs/3rdparty/sabre/dav/lib/DAV/Tree.php htdocs/3rdparty/sabre/dav/lib/DAV/Tree.php.bak
$ curl https://raw.githubusercontent.com/sabre-io/dav/0bf4dc687a66713727eb86cd562249de27853814/lib/DAV/Tree.php > htdocs/3rdparty/sabre/dav/lib/DAV/Tree.php

Works for me:

Subscribed calendars are displayed.
Calendars can be toggled on and off in the side bar.

Thanks a lot!

rikmeijer · 2024-02-20T19:29:08Z

I applied the fix manually, and it looks fixed! Grazie mille!

FDHoho007 · 2024-02-20T19:44:50Z

Thanks @mschmitt for the fix.

dennysubke · 2024-02-20T21:28:58Z

Thank you so much! It works as it should! 💃🏻

rikmeijer · 2024-02-21T07:09:39Z

Is this issue related to the subscribed events not showing up in my dashboard calendar widgit?

MrRulf · 2024-02-21T07:50:25Z

@rikmeijer yes it is, the events are not in your calender and therefore cant be showed in the widgef, which accesses ur calendar.

I see the issue is closed now and there's a fix, but when/in which version can we expect the fix to arrive, instead of having to apply it manually?

rikmeijer · 2024-02-21T08:08:50Z

@MrRulf , I applier the patch manually, but the events are still missing from the calendar widget

Juergen-Vollmer · 2024-02-21T08:15:27Z

If you applied the temporary fixes for the file apps/dav/lib/CalDAV/CalendarHome.php as proposed by #42257, you have to undo that code changes. If a modified CalendarHome.php ist used, the now proposed fix won't work. Therfore use the original file CalendarHome.php
Jürgen

rikmeijer · 2024-02-21T08:20:57Z

I have only changed Tree.php, other files are still originals

SteveDinn · 2024-02-21T12:52:31Z

I have only changed Tree.php, other files are still originals

I also had to restart all applicable services to allow the change to be picked up. It didn't take effect after simply modifying the file

rikmeijer · 2024-02-21T14:04:00Z

I have no idea what you mean by "applicable services". Docker containers? Linux daemons? Clearing caches? What services did you restart?

SteveDinn · 2024-02-21T14:06:30Z

I was being general on purpose. In my case, I restarted the docker containers, because that's how I'm running nextcloud, but for somebody running on bare metal, I can imagine that the same would apply to the daemons. I'm not sure if clearing caches is necessary or not.

rikmeijer · 2024-02-21T14:40:03Z

Too bad, but restarting the containers did not work either...

AbelLykens · 2024-02-21T14:52:13Z

All:

This issue is CLOSED since the fix seems to work (for at least 33 people I see here)
For your individual problems (@rikmeijer) maybe make a different issue, or wait for the update
As many others have done, feel free to reacji to the solution post to indicate it works, adding "it works for me too" is not very useful.

Please be aware dozens of people get notifications when sending messages. I do understand this applies to me, too.

markusd112 · 2024-03-09T07:07:34Z

Today's update to NC 28.0.3 solves the problem for me: external calendar events are now displayed in the NC calender web app, it seems that the patch has been implemented there.

* As many others have done, feel free to [reacji to the solution post](https://github.com/nextcloud/server/issues/42143#issuecomment-1954359982) to indicate it works, adding _"it works for me too"_ is not very useful.
Please be aware dozens of people get notifications when sending messages. I do understand this applies to me, too.

I haven't found a posting here where I can say: "works with NC 28.0.3", because I don't really see if the fix mentioned above has been implemented there or there is some other fix. So please forgive me this post here, clearly say that it works with this NC update

lspagnol · 2024-03-09T10:51:10Z

I confirm: NC 28.0.3 has solved the issue for me

murdikog · 2024-03-19T16:13:16Z

28.0.3 has not solved the issue for me

murdikog · 2024-04-01T14:51:25Z

Still not working in 28.0.4 .

alkanex-xyz · 2024-04-01T16:39:50Z

Still not working in 28.0.4 .

You should open your own issue, as this issue is solved and closed

Juergen-Vollmer added the bug label Dec 6, 2023

miaulalala transferred this issue from nextcloud/calendar Dec 11, 2023

miaulalala mentioned this issue Dec 11, 2023

fix(caldav): don't reuse query builder objects #42144

Merged

5 tasks

szaimen added the 28-feedback label Dec 11, 2023

miaulalala closed this as completed in #42144 Dec 11, 2023

miaulalala reopened this Dec 11, 2023

szaimen added the 2. developing Work in progress label Dec 11, 2023

miaulalala changed the title ~~ical subscription does not work anymore~~ Subscription Calendar Events are not returned by REPORT dav request Dec 13, 2023

miaulalala mentioned this issue Dec 14, 2023

NC28 events of newly subscribed public calendars are not shown nextcloud/calendar#5629

Closed

miaulalala added the regression label Dec 14, 2023

This was referenced Feb 20, 2024

fix(DAV): fix getNodeForPath cache nextcloud/3rdparty#1737

Merged

fix(dav): fix getNodeForPath cache #43698

Merged

patrickTUD mentioned this issue Feb 20, 2024

fix getNodeForPath caching sabre-io/dav#1545

Open

miaulalala closed this as completed in nextcloud/3rdparty#1737 Feb 20, 2024

This was referenced Feb 23, 2024

Appointments from subscribed calendars are not displayed nextcloud/calendar#5794

Closed

Events from subscribed calendar not showing up in Upcoming widget. nextcloud/calendar#5628

Closed

Subscription Calendar Events are not returned by REPORT dav request #42143

Subscription Calendar Events are not returned by REPORT dav request #42143

Comments

Juergen-Vollmer commented Dec 6, 2023

Steps to reproduce

Expected behavior

Actual behaviour

Calendar app version

CalDAV-clients used

Browser

Client operating system

Server operating system

Web server

Database engine version

PHP engine version

Nextcloud version

Updated from an older installed version or fresh install

List of activated apps

Nextcloud configuration

Web server error log

Log file

Browser log

Additional info

tcitworld commented Dec 6, 2023 • edited

Juergen-Vollmer commented Dec 10, 2023 • edited

Juergen-Vollmer commented Dec 10, 2023

miaulalala commented Dec 11, 2023

Juergen-Vollmer commented Dec 11, 2023 • edited by miaulalala

miaulalala commented Dec 11, 2023

Juergen-Vollmer commented Dec 11, 2023 • edited by miaulalala

deleting a calender

adding a calendar

miaulalala commented Dec 11, 2023

Juergen-Vollmer commented Dec 11, 2023

miaulalala commented Dec 11, 2023

Juergen-Vollmer commented Dec 11, 2023

miaulalala commented Dec 12, 2023 • edited

Juergen-Vollmer commented Dec 12, 2023

miaulalala commented Dec 13, 2023 • edited

Juergen-Vollmer commented Dec 13, 2023

miaulalala commented Dec 13, 2023

Juergen-Vollmer commented Dec 13, 2023

then I get

miaulalala commented Dec 13, 2023 • edited

miaulalala commented Dec 13, 2023 • edited

miaulalala commented Dec 13, 2023

miaulalala commented Feb 20, 2024

gnilebein commented Feb 20, 2024

kavol commented Feb 20, 2024

tknaller commented Feb 20, 2024 • edited

Juergen-Vollmer commented Feb 20, 2024

mschmitt commented Feb 20, 2024

rikmeijer commented Feb 20, 2024

FDHoho007 commented Feb 20, 2024

dennysubke commented Feb 20, 2024

rikmeijer commented Feb 21, 2024

MrRulf commented Feb 21, 2024

rikmeijer commented Feb 21, 2024

Juergen-Vollmer commented Feb 21, 2024

rikmeijer commented Feb 21, 2024

SteveDinn commented Feb 21, 2024

rikmeijer commented Feb 21, 2024

SteveDinn commented Feb 21, 2024

rikmeijer commented Feb 21, 2024

AbelLykens commented Feb 21, 2024

markusd112 commented Mar 9, 2024 • edited

lspagnol commented Mar 9, 2024

murdikog commented Mar 19, 2024

murdikog commented Apr 1, 2024

alkanex-xyz commented Apr 1, 2024

tcitworld commented Dec 6, 2023 •

edited

Juergen-Vollmer commented Dec 10, 2023 •

edited

Juergen-Vollmer commented Dec 11, 2023 •

edited by miaulalala

Juergen-Vollmer commented Dec 11, 2023 •

edited by miaulalala

miaulalala commented Dec 12, 2023 •

edited

miaulalala commented Dec 13, 2023 •

edited

miaulalala commented Dec 13, 2023 •

edited

miaulalala commented Dec 13, 2023 •

edited

tknaller commented Feb 20, 2024 •

edited

markusd112 commented Mar 9, 2024 •

edited