Juergen-Vollmer commented 10 months ago

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

tcitworld commented 10 months ago

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 commented 10 months ago

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 commented 10 months ago

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 commented 10 months ago

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 commented 10 months ago

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 commented 10 months ago

@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 commented 9 months ago

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 commented 9 months ago

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 commented 9 months ago

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 commented 9 months ago

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 commented 9 months ago

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 commented 9 months ago

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 commented 9 months ago

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 commented 9 months ago

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 commented 9 months ago

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 commented 9 months ago

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 commented 9 months ago

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 commented 9 months ago

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 commented 9 months ago

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 commented 9 months ago

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 commented 9 months ago

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 commented 9 months ago

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

KastouriHazeeeem commented 9 months ago

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 commented 8 months ago

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 commented 8 months ago

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 commented 8 months ago

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 commented 8 months ago

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 commented 8 months ago

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 commented 8 months ago

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 commented 8 months ago

Out of interest, how is the progress?

LuCu11 commented 8 months ago

I have installed the upgrade to 28.0.2, and the issue exists anymore, can anyone help? Thank you very much in advance :-)

Bugsbane commented 7 months ago

This issue also seems to affect subscribing to holiday based calendars (New calendar > Add public holiday calendar > Area > Subscribe). Subscribing to these calendars doesn't seem to show any events either.

simonspa commented 7 months ago

Could this maybe be added to the 28.0.3 milestone and be fixed with high priority? A calendar with entries missing is almost as good as no calendar... :grimacing:

artfulrobot commented 7 months ago

Yep, I'm going to skip 27 completely - nobody (who relies on the calendar) wants an upgrade that causes such a key groupware function to go missing!

dennysubke commented 7 months ago

High priority please for 28.0.3! 🙏

Unfortunately, the calendar is currently completely useless...

doitux commented 7 months ago

Same problem here! I've multiple calendar subscriptions for my business and didn't expect that updating to a stable version (28.0.2) will break this feature :-(

Zaxooy commented 7 months ago

I totally agree, this should be high priority since a key function is broken. Specially since there is not even a workaround yet. The only mentioned "solution" breaks other things like being able to hide a calendar - and it doesn't update the entrys in the webinterface anymore (even though it updates in the background as you can validate through using your nextcloud calendars via caldav).

SteveDinn commented 7 months ago

I upgraded to v28.x shortly after I started using NextCloud, and prior to starting to use the Calendar app. For me, migrating away from Google Calendars starts with subscribing to existing Google Calendars from within NextCloud. Unfortunately, this initial step left me dead in the water with acceptance from the people who would be using my NextCloud instance. I have to be able to offer them a working calendar.

brrrrrrrt commented 7 months ago

+1 here, users with external calendars had to move away from using the calendar in the webinterface, as it is impossible to manage events with missing calendars (luckily everything works in thunderbird).

lspagnol commented 7 months ago

Hi. I have exactly the same issue. I've upgraded my own/personnal Nextcloud from 27 to 28. iCal feeds now shows nothing in Nextcloud but it works on Thunderbird anyway. I manage 1 big professional instance of Nextcloud (storage for research on one University, we have a subscription for Nextcloud). Fortunately i discover the bug on my own Nextcloud, so did'nt upgraded the university one ... We can't upgrade to Nextcloud 28 with this bug !

simonspa commented 7 months ago

Hej @lspagnol, since you have a subscription with NC GmbH, maybe that would be a good way to get some traction if you contact them over the official support channel you have?

lspagnol commented 7 months ago

@simonspa i did'nt because i did'nt upgraded my professional instance (the subscribed one). The NC GmbH support is for subscribed instances, if i send them information for debug, they will see that informations not come from subscribed instance !

lspagnol commented 7 months ago

@simonspa but i have nothing to loose, i can try to open an issue anyway ...

Enrico204 commented 7 months ago

@simonspa i did'nt because i did'nt upgraded my professional instance (the subscribed one). The NC GmbH support is for subscribed instances, if i send them information for debug, they will see that informations not come from subscribed instance !

That's right, but this is a blocker for the upgrade to a newer version for your university/subscribed instance. So, in some sense, you experience this bug.

lspagnol commented 7 months ago

@simonspa @Enrico204 i've just opened an issue to our French integrator (he's a partner/contributor of NC GmbH)

miaulalala commented 7 months ago

Should be fixed by https://github.com/sabre-io/dav/pull/1545 but I haven't tested it yet.

gnilebein commented 7 months ago

I can confirm that it works!

kavol commented 7 months ago

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 commented 7 months ago

can confirm aswell

Juergen-Vollmer commented 7 months ago

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 -> https://github.com/nextcloud/server/issues/42257)

Jürgen

nextcloud / server

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

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

deleting a calender

adding a calendar

then I get