Subscription Calendar Events are not returned by REPORT dav request

[Juergen-Vollmer]

trafficstars

Steps to reproduce

1. Add a new calender from an ical link
2. 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

[tcitworld]

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]

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]

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]

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]

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]

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

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]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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:[email protected] 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]

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]

Found the culprit in the upstream lib https://github.com/sabre-io/dav/pull/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]

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.

[Juergen-Vollmer]

In https://github.com/nextcloud/server/issues/42257 a " provisional fix" is shown, so the subscribed calenders are shown again. The originial problem is probably not solved yet

[SuperSandro2000]

Is there a timeline for a 28.0.2 release that contains this temporary fix?

[KastouriHazeeeem]

i got the same error :"could not find calendars" . and i noticed that if the user logs in to nexctloud and opens the calendar page, his calendars can be fetched ! so to solve that i used webscrapping when the user signs up to my web app . but will the problem get fixed in the next updates or should i implement a more performant and efficient solution ??

[dennysubke]

What @Juergen-Vollmer describes also applies to me. Attached is my log:

{"reqId":"DDcIWI33AfAicouNEPO8","level":2,"time":"2024-01-11T14:02:06+00:00","remoteAddr":"10.21.0.5","user":"--","app":"core","method":"POST","url":"/login","message":"Login failed: 'XXXX>
{"reqId":"DDcIWI33AfAicouNEPO8","level":2,"time":"2024-01-11T14:02:06+00:00","remoteAddr":"10.21.0.5","user":"--","app":"no app in context","method":"POST","url":"/login","message":"Login >
{"reqId":"4spbJZQufVwQ2VLbJu5t","level":2,"time":"2024-01-12T11:43:43+00:00","remoteAddr":"10.21.0.4","user":"XXXX","app":"dav","method":"MKCOL","url":"/remote.php/dav/calendars/XXXX/c>

Will this be fixed in version 28.0.2?

[miaulalala]

Is there a timeline for a 28.0.2 release that contains this temporary fix?

Unfortunately the temporary fix breaks other things: en- / disabling the subscription calendar breaks, and they can't be deleted any longer, so it's not a good solution to put this into a release.

[X-Raph-X]

HI all, I tried the #42144 patch and it didn't solve the issue. Is it possible to remove the "fixed by #42144 " attribute on this issue, please?

[mschmitt]

I take there is no fix in the 28.0.2 release candidates?

https://help.nextcloud.com/t/rc2s-of-28-0-2-27-1-6-and-26-0-11/179737

[miaulalala]

I take there is no fix in the 28.0.2 release candidates?

help.nextcloud.com/t/rc2s-of-28-0-2-27-1-6-and-26-0-11/179737

unfortunately I couldn't yet work out what the actual issue is. Changing the code so it always returns a CachedSubscription class is not a good fix as other things break (delete, visibility); the goal right now is to find out why the WebCalCaching Plugin is not initialised at the time of the request to fix the root cause.

[mschmitt]

unfortunately I couldn't yet work out what the actual issue is. Changing the code so it always returns a CachedSubscription class is not a good fix as other things break (delete, visibility); the goal right now is to find out why the WebCalCaching Plugin is not initialised at the time of the request to fix the root cause.

Thanks for the feedback. 👍

[Mat-DB]

Out of interest, how is the progress?