[Bug]: Dashboard Upcoming Events widget sorts events descending

[mrtumnus]

⚠️ This issue respects the following points: ⚠️

• This is a bug, not a question or a configuration/webserver/proxy issue.
• This issue is not already reported on Github OR Nextcloud Community Forum (I've searched it).
• Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
• I agree to follow Nextcloud's Code of Conduct.

Bug description

The "Upcoming Events" widget on the Dashboard app shows old events first (sorted in descending date order). Newer events are cut off at the bottom. Here is an example of what I see:

Steps to reproduce

1. Upgrade to Nextcloud 27.1.x
2. Enable Dashboard and Upcoming Events widget
3. Add 5 calendar events spaced evenly from a year ago to the current week

Expected behavior

Events should appear with the newest at the top and oldest at the bottom, with the very oldest (5th) not shown.

Installation method

Community Manual installation with Archive

Nextcloud Server version

27

Operating system

Debian/Ubuntu

PHP engine version

PHP 8.2

Web server

Apache (supported)

Database engine version

MariaDB

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

Updated from a MINOR version (ex. 22.1 to 22.2)

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
• Other

Configuration report

{
    "system": {
        "updatechecker": false,
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": ["***REMOVED SENSITIVE VALUE***"
        ],
        "trusted_proxies": "***REMOVED SENSITIVE VALUE***",
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "version": "27.1.1.0",
        "overwrite.cli.url": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "memcache.local": "\\OC\\Memcache\\APCu",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "memcache.distributed": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": "6379"
        },
        "mail_smtpmode": "smtp",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "maintenance": false,
        "loglevel": 3,
        "logtimezone": "America\/New_York",
        "theme": "",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "25",
        "mail_smtpdebug": false,
        "mail_sendmailmode": "smtp",
        "mysql.utf8mb4": true,
        "updater.release.channel": "stable",
        "encryption.legacy_format_support": false,
        "encryption.key_storage_migrated": false,
        "default_phone_region": "US",
        "default_language": "en",
        "memories.exiftool": "\/var\/www\/nextcloud\/apps\/memories\/exiftool-bin\/exiftool-amd64-glibc",
        "memories.vod.path": "\/var\/www\/nextcloud\/apps\/memories\/exiftool-bin\/go-vod-amd64",
        "memories.vod.ffmpeg": "\/usr\/bin\/ffmpeg",
        "memories.vod.ffprobe": "\/usr\/bin\/ffprobe",
        "memories.gis_type": 1,
        "memories.vod.disable": false,
        "mail_smtpstreamoptions": {
            "ssl": {
                "allow_self_signed": true,
                "verify_peer": false,
                "verify_peer_name": false
            }
        },
        "updater.secret": "***REMOVED SENSITIVE VALUE***"
    }
}

List of activated Apps

Enabled:
  - activity: 2.19.0
  - admin_audit: 1.17.0
  - bookmarks: 13.1.1
  - bruteforcesettings: 2.7.0
  - calendar: 4.5.1
  - circles: 27.0.1
  - cloud_federation_api: 1.10.0
  - comments: 1.17.0
  - contacts: 5.4.2
  - contactsinteraction: 1.8.0
  - dashboard: 7.7.0
  - dav: 1.27.0
  - drawio: 2.1.2
  - federatedfilesharing: 1.17.0
  - federation: 1.17.0
  - files: 1.22.0
  - files_automatedtagging: 1.17.0
  - files_external: 1.19.0
  - files_pdfviewer: 2.8.0
  - files_photospheres: 1.27.0
  - files_reminders: 1.0.0
  - files_rightclick: 1.6.0
  - files_sharing: 1.19.0
  - files_trashbin: 1.17.0
  - files_versions: 1.20.0
  - firstrunwizard: 2.16.0
  - flow_notifications: 1.7.0
  - integration_dropbox: 2.0.1
  - integration_google: 2.0.2
  - logreader: 2.12.0
  - lookup_server_connector: 1.15.0
  - mail: 3.4.0
  - maps: 1.1.1
  - memories: 5.4.1
  - news: 23.0.0
  - nextcloud_announcements: 1.16.0
  - notes: 4.8.1
  - notifications: 2.15.0
  - oauth2: 1.15.1
  - password_policy: 1.17.0
  - passwords: 2023.9.30
  - phonetrack: 0.7.6
  - photos: 2.3.0
  - polls: 5.3.2
  - previewgenerator: 5.3.0
  - privacy: 1.11.0
  - provisioning_api: 1.17.0
  - recognize: 4.3.2
  - recommendations: 1.6.0
  - registration: 2.2.0
  - related_resources: 1.2.0
  - richdocuments: 8.2.0
  - richdocumentscode: 23.5.402
  - serverinfo: 1.17.0
  - settings: 1.9.0
  - sharebymail: 1.17.0
  - spreed: 17.1.1
  - support: 1.10.0
  - survey_client: 1.15.0
  - systemtags: 1.17.0
  - tasks: 0.15.0
  - text: 3.8.0
  - theming: 2.2.0
  - twofactor_backupcodes: 1.16.0
  - twofactor_nextcloud_notification: 3.7.0
  - twofactor_totp: 9.0.0
  - updatenotification: 1.17.0
  - user_status: 1.7.0
  - viewer: 2.1.0
  - weather_status: 1.7.0
  - workflow_ocr: 1.27.4
  - workflow_script: 1.12.0
  - workflowengine: 2.9.0
Disabled:
  - analytics: 4.10.0 (installed 4.10.0)
  - deck: 1.11.0 (installed 1.11.0)
  - encryption: 2.15.0 (installed 2.2.0)
  - end_to_end_encryption: 1.13.1 (installed 1.13.1)
  - files_fulltextsearch_tesseract: 27.0.0 (installed 27.0.0)
  - richdocumentscode_arm64: 23.5.402
  - suspicious_login: 5.0.0 (installed 4.4.0)
  - theming_customcss: 1.14.0 (installed 1.14.0)
  - user_ldap: 1.17.0

Nextcloud Signing status

No errors have been found.

Nextcloud Logs

No relevant entries

Additional info

Originally reported on Nextcloud Community Forum here:
https://help.nextcloud.com/t/dashboard-upcoming-events-show-x-years-ago/170313

[mrtumnus]

I think I mistakenly put this in nextcloud/server instead of nextcloud/calendar. I didn't realize the dashboard widgets are defined in each app.

[ChristophWurst]

Fixed by nextcloud/server#40541

[sihui62]

Fixed by nextcloud/server#40541

Unfortunately there seems to be still an error on this task if the fix has been backported to 27.1.2:

https://help.nextcloud.com/t/dashboard-upcoming-events-show-x-years-ago/170313/14?u=sihui

[mrtumnus]

Upgrading to 27.1.2 fixed this for me:

[sihui62]

Upgrading to 27.1.2 fixed this for me

The reason it did not work for me was one of my calendars was corrupted.
After I fed it through an ics validator and fixed the errors, everything seems to be fine now with 27.1.2.

[scgf]

Still not working for me - and others have also reported it as a problem.

[sihui62]

Still not working for me

Yes, same here again, it worked for a couple of hours, but after inserting new calendar entries the dashboard is messed up again.

[Mich-es]

Same problem here with 28.0.2

[3dmanipulator]

weekend events are also not displayed - 29.0.0