Completed recurring tasks from Thunderbird re-appear after upgrade to Nextcloud 20.

dseomn commented 3 years ago

How to use GitHub

Please use the 👍 reaction to show that you are affected by the same issue.
Please don't comment if you have no relevant information to add. It's just extra noise for everyone subscribed to this issue.
Subscribe to receive notifications on status change and new comments.

Steps to reproduce

Using Nextcloud 19, create a repeating task in Thunderbird, and mark at least one instance as completed.
Upgrade to Nextcloud 20.

See https://github.com/nextcloud/tasks/issues/1402 for the original bug report and more info.

Expected behaviour

The task should still be marked as completed in Thunderbird.

Actual behaviour

All instances of the task show as uncompleted in Thunderbird.

Server configuration

Operating system: Debian GNU/Linux 10 (buster)

Web server: apache2 2.4.38-3+deb10u4

Database: mariadb-server-10.3 1:10.3.27-0+deb10u1

PHP version: libapache2-mod-php7.3 7.3.19-1~deb10u1

Nextcloud version: 20.0.5

Updated from an older Nextcloud/ownCloud or fresh install: updated

Where did you install Nextcloud from: It was a while ago and I don't remember.

Signing status:

Signing status

``` No errors have been found. ```

List of activated apps:

App list

``` Enabled: - accessibility: 1.6.0 - activity: 2.13.4 - admin_audit: 1.10.0 - apporder: 0.11.0 - bruteforcesettings: 2.0.1 - calendar: 2.1.3 - cloud_federation_api: 1.3.0 - comments: 1.10.0 - contacts: 3.4.3 - contactsinteraction: 1.1.0 - dashboard: 7.0.0 - dav: 1.16.2 - federatedfilesharing: 1.10.2 - federation: 1.10.1 - files: 1.15.0 - files_external: 1.11.1 - files_pdfviewer: 2.0.1 - files_rightclick: 0.17.0 - files_sharing: 1.12.2 - files_trashbin: 1.10.1 - files_versions: 1.13.0 - files_videoplayer: 1.9.0 - firstrunwizard: 2.9.0 - logreader: 2.5.0 - lookup_server_connector: 1.8.0 - metadata: 0.12.0 - nextcloud_announcements: 1.9.0 - notes: 4.0.2 - notifications: 2.8.0 - oauth2: 1.8.0 - ocsms: 2.2.0 - password_policy: 1.10.1 - photos: 1.2.3 - polls: 1.6.3 - privacy: 1.4.0 - provisioning_api: 1.10.0 - recommendations: 0.8.0 - serverinfo: 1.10.0 - settings: 1.2.0 - sharebymail: 1.10.0 - spreed: 10.0.5 - support: 1.3.0 - survey_client: 1.8.0 - systemtags: 1.10.0 - tasks: 0.13.6 - text: 3.1.0 - theming: 1.11.0 - twofactor_backupcodes: 1.9.0 - twofactor_u2f: 6.0.0 - updatenotification: 1.10.0 - user_status: 1.0.1 - viewer: 1.4.0 - weather_status: 1.0.0 - workflowengine: 2.2.0 Disabled: - encryption - ojsxc - telephoneprovider - user_ldap ```

Nextcloud configuration:

Config report

``` { "system": { "passwordsalt": "***REMOVED SENSITIVE VALUE***", "secret": "***REMOVED SENSITIVE VALUE***", "trusted_domains": [ "cloud.mandelberg.org" ], "datadirectory": "***REMOVED SENSITIVE VALUE***", "overwrite.cli.url": "https:\/\/cloud.mandelberg.org", "dbtype": "mysql", "version": "20.0.5.2", "dbname": "***REMOVED SENSITIVE VALUE***", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbport": "", "dbtableprefix": "oc_", "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "installed": true, "instanceid": "***REMOVED SENSITIVE VALUE***", "mysql.utf8mb4": true, "maintenance": false, "mail_smtpmode": "sendmail", "mail_smtpauthtype": "LOGIN", "mail_from_address": "***REMOVED SENSITIVE VALUE***", "mail_domain": "***REMOVED SENSITIVE VALUE***", "htaccess.RewriteBase": "\/", "memcache.local": "\\OC\\Memcache\\APCu", "lost_password_link": "disabled", "defaultapp": "apporder", "theme": "", "loglevel": 2, "app.mail.imaplog.enabled": true, "updater.release.channel": "stable", "mail_smtpsecure": "ssl", "twofactor_enforced": "true", "twofactor_enforced_groups": [], "twofactor_enforced_excluded_groups": [] } } ```

Are you using external storage, if yes which one: I don't remember, but can look it up if it's relevant.

Are you using encryption: no

Are you using an external user-backend, if yes which one: no

Client configuration

Browser: thunderbird 1:78.6.1-1

Operating system: Debian GNU/Linux bullseye/sid

dseomn commented 3 years ago

I did some digging around in my SQL backups. There was no difference in the oc_calendarobjects.calendardata column between a recurring event on nextcloud 19.0.4 and the same event on nextcloud 20.0.5. Comparing the current value in oc_calendarobjects.calendardata with the file returned over WebDAV, there might or might not have been a difference in line endings (I'm not sure how to see line endings in mysql), but there were no other differences.

Is there anything else that could have affected thunderbird's behavior? Maybe the Nextcloud upgrade was a coincidence for multiple people, and this is a bug in thunderbird?

dseomn commented 3 years ago

I just tested with thunderbird and davical, and had the same issue, so I strongly suspect this is a thunderbird issue. Sorry for the noise. I think the appropriate bug in thunderbird is https://bugzilla.mozilla.org/show_bug.cgi?id=1686466.

nextcloud / server