server icon indicating copy to clipboard operation
server copied to clipboard

[Bug]: Calendar subscriptions don't refresh

Open StefanGebhardt opened this issue 1 year ago • 1 comments

⚠️ This issue respects the following points: ⚠️

Bug description

In 28.0.1 I added a correct calendar subscription. Entries are in the database. But calendar does not refresh. I activated the refresh rate by occ command (occ config:app:set dav calendarSubscriptionRefreshRate --value "PT15M") and got a positive return. Nothing happened, log told: Subscription 11 could not be refreshed, refreshrate in database is invalid InvalidDataException: The supplied iCalendar duration value is incorrect: “PT15M” Exception thrown: Sabre\VObject\InvalidDataException

When I inspected the database I found in the table "calendarsubscriptions" a field "refreshrate" which was empty for the subscription. I added the value "PT15M" in this field - and it worked.

Seems, the occ command does not fill the correct fields.

Steps to reproduce

  1. new subscription
  2. set refresh rate via occ
  3. see that nothing happens

Expected behavior

subscription of all subscribed calendars after setting with the occ command

Installation method

Community Web installer on a VPS or web space

Nextcloud Server version

28

Operating system

Other

PHP engine version

PHP 8.1

Web server

Other

Database engine version

MariaDB

Is this bug present after an update or on a fresh install?

None

Are you using the Nextcloud Server Encryption module?

Encryption is Disabled

What user-backends are you using?

  • [ ] Default user-backend (database)
  • [ ] LDAP/ Active Directory
  • [ ] SSO - SAML
  • [X] Other

Configuration report

{
    "system": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "url",
            "url"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "tempdirectory": "\/www\/htdocs\/w013d860\/url\/data\/tmp",
        "dbtype": "mysql",
        "version": "28.0.1.1",
        "overwrite.cli.url": "http:\/\/url",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "H9PtA_",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "mail_smtpmode": "smtp",
        "mail_sendmailmode": "pipe",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "default_phone_region": "DE",
        "updater.release.channel": "stable",
        "maintenance": false,
        "theme": "",
        "loglevel": 2,
        "app_install_overwrite": [
            "backup",
            "mail_roundcube"
        ],
        "twofactor_enforced": "true",
        "twofactor_enforced_groups": [],
        "twofactor_enforced_excluded_groups": [
            "Externe"
        ],
        "trashbin_retention_obligation": "auto",
        "mail_smtpauth": 1,
        "mail_smtpauthtype": "LOGIN",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***"
    }
}

List of activated Apps

Enabled:
  - activity: 2.20.0
  - admin_audit: 1.18.0
  - bruteforcesettings: 2.8.0
  - calendar: 4.6.4
  - cloud_federation_api: 1.11.0
  - comments: 1.18.0
  - contacts: 5.5.1
  - contactsinteraction: 1.9.0
  - dashboard: 7.8.0
  - dav: 1.29.1
  - event_update_notification: 2.3.0
  - federatedfilesharing: 1.18.0
  - files: 2.0.0
  - 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
  - logreader: 2.13.0
  - lookup_server_connector: 1.16.0
  - nextcloud_announcements: 1.17.0
  - notifications: 2.16.0
  - oauth2: 1.16.3
  - password_policy: 1.18.0
  - photos: 2.4.0
  - privacy: 1.12.0
  - provisioning_api: 1.18.0
  - quota_warning: 1.18.0
  - recommendations: 2.0.0
  - related_resources: 1.3.0
  - serverinfo: 1.18.0
  - settings: 1.10.1
  - sharebymail: 1.18.0
  - survey_client: 1.16.0
  - systemtags: 1.18.0
  - text: 3.9.1
  - theming: 2.3.0
  - twofactor_backupcodes: 1.17.0
  - 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:
  - circles: 28.0.0-dev (installed 23.0.0)
  - encryption: 2.16.0
  - federation: 1.18.0 (installed 1.18.0)
  - files_external: 1.20.0 (installed 1.15.0)
  - files_rightclick: 0.15.1 (installed 1.6.0)
  - mail: 3.5.5 (installed 3.5.5)
  - support: 1.11.0 (installed 1.6.0)
  - suspicious_login: 6.0.0
  - user_ldap: 1.19.0

Nextcloud Signing status

No errors have been found.

Nextcloud Logs

{"reqId":"ZbqXhfElqgrkOyZTGKCQ0wAASC8","level":3,"time":"2024-01-31T18:55:01+00:00","remoteAddr":"85.13.165.5","user":"--","app":"dav","method":"GET","url":"/cron.php","message":"Exception thrown: Sabre\\VObject\\InvalidDataException","userAgent":"cronBROWSE v1.1","version":"28.0.1.1","exception":{"Exception":"Sabre\\VObject\\InvalidDataException","Message":"The supplied iCalendar duration value is incorrect: \u201cPT15M\u201d","Code":0,"Trace":[{"file":"/www/htdocs/w/url/apps/dav/lib/BackgroundJob/RefreshWebcalJob.php","line":96,"function":"parseDuration","class":"Sabre\\VObject\\DateTimeParser","type":"::","args":["\u201cPT15M\u201d"]},{"file":"/www/htdocs/w/url/cron.php","line":177,"function":"execute","class":"OCA\\DAV\\BackgroundJob\\RefreshWebcalJob","type":"->","args":[["OC\\BackgroundJob\\JobList"],["OC\\Log"]]}],"File":"/www/htdocs/w/url/3rdparty/sabre/vobject/lib/DateTimeParser.php","Line":101,"CustomMessage":"Exception thrown: Sabre\\VObject\\InvalidDataException"}}
{"reqId":"ZbqXhfElqgrkOyZTGKCQ0wAASC8","level":2,"time":"2024-01-31T18:55:01+00:00","remoteAddr":"xxxxxxxx","user":"--","app":"dav","method":"GET","url":"/cron.php","message":"Subscription 11 could not be refreshed, refreshrate in database is invalid","userAgent":"cronBROWSE v1.1","version":"28.0.1.1","data":{"app":"dav"}}

Additional info

No response

StefanGebhardt avatar Jan 31 '24 23:01 StefanGebhardt

In 28.0.1 I added a correct calendar subscription. Entries are in the database. But calendar does not refresh.

This should be the following issue: https://github.com/nextcloud/server/issues/42143

About the "PT15M" refresh value not be valid. It might be because the value was taken with the double commas (i.e "PT15M", not PT15M). Setting this value seems to work properly for me. You should reset the configuration value to a sane one (or it will stay the same for all future subscriptions), either by resetting it or removing it to have the default value :

occ config:app:set dav calendarSubscriptionRefreshRate --value PT15M
occ config:app:delete dav calendarSubscriptionRefreshRate

tcitworld avatar Feb 01 '24 08:02 tcitworld

This issue has been automatically marked as stale because it has not had recent activity and seems to be missing some essential information. It will be closed if no further activity occurs. Thank you for your contributions.

nextcloud-command avatar Mar 11 '24 00:03 nextcloud-command