[Bug]: Error when adding calendar subscription

[madsmh]

⚠️ 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

When I try add a calendar subscription from a URL in the Nextcloud Calendar
I get an error "An error occured. THe calendar could not be created" and an empty calendar appears in the list.

The log shows:

[webdav] Error: An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'uid' at row 1
MKCOL /remote.php/dav/calendars/mads/personligtskemakudk-1
from by mads 17. feb. 2025, 10.33.55

Steps to reproduce

1. Click on the calendar app on the navigation bar
2. Click the + to the right of the "Calendars" header
3. Select "New subscription from link (read-only)"
4. Enter URL
5. Click the arrow/press enter

Expected behavior

The subscribed calendar and its events should be displayed

Nextcloud Server version

30

Operating system

RHEL/CentOS

PHP engine version

PHP 8.3

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. 32.0.1 to 32.0.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": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "cloud.eccentric.dk"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "30.0.6.2",
        "overwrite.cli.url": "https:\/\/cloud.eccentric.dk",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "maintenance": false,
        "filelocking.enabled": true,
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 6379,
            "timeout": 0,
            "password": "***REMOVED SENSITIVE VALUE***"
        },
        "memcache.local": "\\OC\\Memcache\\APCu",
        "default_phone_region": "DK",
        "mail_smtpmode": "smtp",
        "mail_sendmailmode": "smtp",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpsecure": "ssl",
        "mail_smtpport": "465",
        "theme": "",
        "loglevel": 2,
        "updater.secret": "***REMOVED SENSITIVE VALUE***",
        "maintenance_window_start": 1,
        "forbidden_filename_characters": [
            "\\",
            "\/"
        ],
        "forbidden_filename_extensions": [
            ".filepart",
            ".part"
        ],
        "mail_smtpauth": 1,
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "twofactor_enforced": "true",
        "twofactor_enforced_groups": [
            "admin"
        ],
        "twofactor_enforced_excluded_groups": []
    }
}

List of activated Apps

Enabled:
  - activity: 3.0.0
  - admin_audit: 1.20.0
  - announcementcenter: 7.1.0
  - app_api: 4.0.6
  - calendar: 5.0.10
  - circles: 30.0.0
  - cloud_federation_api: 1.13.0
  - comments: 1.20.1
  - contacts: 6.1.3
  - contactsinteraction: 1.11.0
  - dashboard: 7.10.0
  - dav: 1.31.1
  - deck: 1.14.3
  - dicomviewer: 2.3.0
  - federatedfilesharing: 1.20.0
  - federation: 1.20.0
  - files: 2.2.0
  - files_downloadlimit: 3.0.0
  - files_pdfviewer: 3.0.0
  - files_reminders: 1.3.0
  - files_sharing: 1.22.0
  - files_trashbin: 1.20.1
  - files_versions: 1.23.0
  - firstrunwizard: 3.0.0
  - logreader: 3.0.0
  - lookup_server_connector: 1.18.0
  - mail: 4.1.2
  - nextcloud_announcements: 2.0.0
  - notes: 4.11.0
  - notifications: 3.0.0
  - oauth2: 1.18.1
  - password_policy: 2.0.0
  - photos: 3.0.2
  - privacy: 2.0.0
  - provisioning_api: 1.20.0
  - recommendations: 3.0.0
  - related_resources: 1.5.0
  - richdocumentscode: 24.4.1103
  - serverinfo: 2.0.0
  - settings: 1.13.0
  - sharebymail: 1.20.0
  - socialsharing_diaspora: 3.3.0
  - support: 2.0.0
  - survey_client: 2.0.0
  - systemtags: 1.20.0
  - theming: 2.6.0
  - twofactor_backupcodes: 1.19.0
  - twofactor_nextcloud_notification: 4.0.0
  - twofactor_totp: 12.0.0-dev
  - twofactor_webauthn: 2.1.0
  - updatenotification: 1.20.0
  - user_status: 1.10.0
  - viewer: 3.0.0
  - webhook_listeners: 1.1.0-dev
  - workflowengine: 2.12.0
Disabled:
  - bruteforcesettings: 3.0.0 (installed 3.0.0)
  - encryption: 2.18.0 (installed 2.18.0)
  - end_to_end_encryption: 1.16.2 (installed 1.16.2)
  - files_external: 1.22.0
  - geoblocker: 0.5.15
  - richdocuments: 8.5.3 (installed 8.5.3)
  - spreed: 20.1.4 (installed 20.1.4)
  - suspicious_login: 8.0.0
  - text: 4.1.0 (installed 4.1.0)
  - unsplash: 3.0.3 (installed 3.0.3)
  - user_ldap: 1.21.0
  - user_migration: 7.0.1
  - weather_status: 1.10.0 (installed 1.10.0)

Nextcloud Signing status

No errors have been found.

Nextcloud Logs

{"reqId":"Z7MCg-mEK0KwSiS_ky0nIQAAUQs","level":3,"time":"2025-02-17T09:33:55+00:00","remoteAddr":"85.215.181.183","user":"mads","app":"webdav","method":"MKCOL","url":"/remote.php/dav/calendars/mads/personligtskemakudk-1","message":"An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'uid' at row 1","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0","version":"30.0.6.2","exception":{"Exception":"OC\\DB\\Exceptions\\DbalException","Message":"An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'uid' at row 1","Code":1406,"Trace":[{"file":"/srv/eccentric/cloud/public_html/lib/private/DB/ConnectionAdapter.php","line":69,"function":"wrap","class":"OC\\DB\\Exceptions\\DbalException","type":"::"},{"file":"/srv/eccentric/cloud/public_html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":306,"function":"executeStatement","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/srv/eccentric/cloud/public_html/apps/dav/lib/CalDAV/CalDavBackend.php","line":1308,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/srv/eccentric/cloud/public_html/lib/public/AppFramework/Db/TTransactional.php","line":45,"function":"OCA\\DAV\\CalDAV\\{closure}","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/eccentric/cloud/public_html/apps/dav/lib/CalDAV/CalDavBackend.php","line":1259,"function":"atomic","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->"},{"file":"/srv/eccentric/cloud/public_html/apps/dav/lib/CalDAV/WebcalCaching/RefreshWebcalService.php","line":133,"function":"createCalendarObject","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/eccentric/cloud/public_html/apps/dav/lib/Listener/SubscriptionListener.php","line":45,"function":"refreshSubscription","class":"OCA\\DAV\\CalDAV\\WebcalCaching\\RefreshWebcalService","type":"->"},{"file":"/srv/eccentric/cloud/public_html/lib/private/EventDispatcher/ServiceEventListener.php","line":68,"function":"handle","class":"OCA\\DAV\\Listener\\SubscriptionListener","type":"->"},{"file":"/srv/eccentric/cloud/public_html/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":220,"function":"__invoke","class":"OC\\EventDispatcher\\ServiceEventListener","type":"->"},{"file":"/srv/eccentric/cloud/public_html/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":56,"function":"callListeners","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/srv/eccentric/cloud/public_html/lib/private/EventDispatcher/EventDispatcher.php","line":67,"function":"dispatch","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/srv/eccentric/cloud/public_html/lib/private/EventDispatcher/EventDispatcher.php","line":79,"function":"dispatch","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/srv/eccentric/cloud/public_html/apps/dav/lib/CalDAV/CalDavBackend.php","line":2644,"function":"dispatchTyped","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/srv/eccentric/cloud/public_html/3rdparty/sabre/dav/lib/CalDAV/CalendarHome.php","line":249,"function":"createSubscription","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/eccentric/cloud/public_html/apps/dav/lib/CalDAV/CalendarHome.php","line":77,"function":"createExtendedCollection","class":"Sabre\\CalDAV\\CalendarHome","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/eccentric/cloud/public_html/3rdparty/sabre/dav/lib/DAV/Server.php","line":1199,"function":"createExtendedCollection","class":"OCA\\DAV\\CalDAV\\CalendarHome","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/eccentric/cloud/public_html/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":560,"function":"createCollection","class":"Sabre\\DAV\\Server","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/eccentric/cloud/public_html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpMkcol","class":"Sabre\\DAV\\CorePlugin","type":"->"},{"file":"/srv/eccentric/cloud/public_html/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/srv/eccentric/cloud/public_html/apps/dav/lib/Connector/Sabre/Server.php","line":43,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/srv/eccentric/cloud/public_html/apps/dav/lib/Server.php","line":371,"function":"start","class":"OCA\\DAV\\Connector\\Sabre\\Server","type":"->"},{"file":"/srv/eccentric/cloud/public_html/apps/dav/appinfo/v2/remote.php","line":19,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/srv/eccentric/cloud/public_html/remote.php","line":146,"args":["/srv/eccentric/cloud/public_html/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/srv/eccentric/cloud/public_html/lib/private/DB/Exceptions/DbalException.php","Line":54,"Previous":{"Exception":"Doctrine\\DBAL\\Exception\\DriverException","Message":"An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'uid' at row 1","Code":1406,"Trace":[{"file":"/srv/eccentric/cloud/public_html/3rdparty/doctrine/dbal/src/Connection.php","line":1976,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter","type":"->"},{"file":"/srv/eccentric/cloud/public_html/3rdparty/doctrine/dbal/src/Connection.php","line":1918,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/srv/eccentric/cloud/public_html/3rdparty/doctrine/dbal/src/Connection.php","line":1218,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/srv/eccentric/cloud/public_html/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/srv/eccentric/cloud/public_html/lib/private/DB/Connection.php","line":462,"function":"executeStatement","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->"},{"file":"/srv/eccentric/cloud/public_html/lib/private/DB/ConnectionAdapter.php","line":67,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/srv/eccentric/cloud/public_html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":306,"function":"executeStatement","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/srv/eccentric/cloud/public_html/apps/dav/lib/CalDAV/CalDavBackend.php","line":1308,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/srv/eccentric/cloud/public_html/lib/public/AppFramework/Db/TTransactional.php","line":45,"function":"OCA\\DAV\\CalDAV\\{closure}","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/eccentric/cloud/public_html/apps/dav/lib/CalDAV/CalDavBackend.php","line":1259,"function":"atomic","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->"},{"file":"/srv/eccentric/cloud/public_html/apps/dav/lib/CalDAV/WebcalCaching/RefreshWebcalService.php","line":133,"function":"createCalendarObject","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/eccentric/cloud/public_html/apps/dav/lib/Listener/SubscriptionListener.php","line":45,"function":"refreshSubscription","class":"OCA\\DAV\\CalDAV\\WebcalCaching\\RefreshWebcalService","type":"->"},{"file":"/srv/eccentric/cloud/public_html/lib/private/EventDispatcher/ServiceEventListener.php","line":68,"function":"handle","class":"OCA\\DAV\\Listener\\SubscriptionListener","type":"->"},{"file":"/srv/eccentric/cloud/public_html/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":220,"function":"__invoke","class":"OC\\EventDispatcher\\ServiceEventListener","type":"->"},{"file":"/srv/eccentric/cloud/public_html/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":56,"function":"callListeners","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/srv/eccentric/cloud/public_html/lib/private/EventDispatcher/EventDispatcher.php","line":67,"function":"dispatch","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/srv/eccentric/cloud/public_html/lib/private/EventDispatcher/EventDispatcher.php","line":79,"function":"dispatch","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/srv/eccentric/cloud/public_html/apps/dav/lib/CalDAV/CalDavBackend.php","line":2644,"function":"dispatchTyped","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/srv/eccentric/cloud/public_html/3rdparty/sabre/dav/lib/CalDAV/CalendarHome.php","line":249,"function":"createSubscription","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/eccentric/cloud/public_html/apps/dav/lib/CalDAV/CalendarHome.php","line":77,"function":"createExtendedCollection","class":"Sabre\\CalDAV\\CalendarHome","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/eccentric/cloud/public_html/3rdparty/sabre/dav/lib/DAV/Server.php","line":1199,"function":"createExtendedCollection","class":"OCA\\DAV\\CalDAV\\CalendarHome","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/eccentric/cloud/public_html/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":560,"function":"createCollection","class":"Sabre\\DAV\\Server","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/eccentric/cloud/public_html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpMkcol","class":"Sabre\\DAV\\CorePlugin","type":"->"},{"file":"/srv/eccentric/cloud/public_html/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/srv/eccentric/cloud/public_html/apps/dav/lib/Connector/Sabre/Server.php","line":43,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/srv/eccentric/cloud/public_html/apps/dav/lib/Server.php","line":371,"function":"start","class":"OCA\\DAV\\Connector\\Sabre\\Server","type":"->"},{"file":"/srv/eccentric/cloud/public_html/apps/dav/appinfo/v2/remote.php","line":19,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/srv/eccentric/cloud/public_html/remote.php","line":146,"args":["/srv/eccentric/cloud/public_html/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/srv/eccentric/cloud/public_html/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php","Line":118,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'uid' at row 1","Code":1406,"Trace":[{"file":"/srv/eccentric/cloud/public_html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":132,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::"},{"file":"/srv/eccentric/cloud/public_html/3rdparty/doctrine/dbal/src/Connection.php","line":1212,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->"},{"file":"/srv/eccentric/cloud/public_html/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/srv/eccentric/cloud/public_html/lib/private/DB/Connection.php","line":462,"function":"executeStatement","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->"},{"file":"/srv/eccentric/cloud/public_html/lib/private/DB/ConnectionAdapter.php","line":67,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/srv/eccentric/cloud/public_html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":306,"function":"executeStatement","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/srv/eccentric/cloud/public_html/apps/dav/lib/CalDAV/CalDavBackend.php","line":1308,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/srv/eccentric/cloud/public_html/lib/public/AppFramework/Db/TTransactional.php","line":45,"function":"OCA\\DAV\\CalDAV\\{closure}","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/eccentric/cloud/public_html/apps/dav/lib/CalDAV/CalDavBackend.php","line":1259,"function":"atomic","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->"},{"file":"/srv/eccentric/cloud/public_html/apps/dav/lib/CalDAV/WebcalCaching/RefreshWebcalService.php","line":133,"function":"createCalendarObject","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/eccentric/cloud/public_html/apps/dav/lib/Listener/SubscriptionListener.php","line":45,"function":"refreshSubscription","class":"OCA\\DAV\\CalDAV\\WebcalCaching\\RefreshWebcalService","type":"->"},{"file":"/srv/eccentric/cloud/public_html/lib/private/EventDispatcher/ServiceEventListener.php","line":68,"function":"handle","class":"OCA\\DAV\\Listener\\SubscriptionListener","type":"->"},{"file":"/srv/eccentric/cloud/public_html/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":220,"function":"__invoke","class":"OC\\EventDispatcher\\ServiceEventListener","type":"->"},{"file":"/srv/eccentric/cloud/public_html/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":56,"function":"callListeners","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/srv/eccentric/cloud/public_html/lib/private/EventDispatcher/EventDispatcher.php","line":67,"function":"dispatch","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/srv/eccentric/cloud/public_html/lib/private/EventDispatcher/EventDispatcher.php","line":79,"function":"dispatch","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/srv/eccentric/cloud/public_html/apps/dav/lib/CalDAV/CalDavBackend.php","line":2644,"function":"dispatchTyped","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/srv/eccentric/cloud/public_html/3rdparty/sabre/dav/lib/CalDAV/CalendarHome.php","line":249,"function":"createSubscription","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/eccentric/cloud/public_html/apps/dav/lib/CalDAV/CalendarHome.php","line":77,"function":"createExtendedCollection","class":"Sabre\\CalDAV\\CalendarHome","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/eccentric/cloud/public_html/3rdparty/sabre/dav/lib/DAV/Server.php","line":1199,"function":"createExtendedCollection","class":"OCA\\DAV\\CalDAV\\CalendarHome","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/eccentric/cloud/public_html/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":560,"function":"createCollection","class":"Sabre\\DAV\\Server","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/eccentric/cloud/public_html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpMkcol","class":"Sabre\\DAV\\CorePlugin","type":"->"},{"file":"/srv/eccentric/cloud/public_html/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/srv/eccentric/cloud/public_html/apps/dav/lib/Connector/Sabre/Server.php","line":43,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/srv/eccentric/cloud/public_html/apps/dav/lib/Server.php","line":371,"function":"start","class":"OCA\\DAV\\Connector\\Sabre\\Server","type":"->"},{"file":"/srv/eccentric/cloud/public_html/apps/dav/appinfo/v2/remote.php","line":19,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/srv/eccentric/cloud/public_html/remote.php","line":146,"args":["/srv/eccentric/cloud/public_html/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/srv/eccentric/cloud/public_html/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":24,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'uid' at row 1","Code":"22001","Trace":[{"file":"/srv/eccentric/cloud/public_html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":130,"function":"execute","class":"PDOStatement","type":"->"},{"file":"/srv/eccentric/cloud/public_html/3rdparty/doctrine/dbal/src/Connection.php","line":1212,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->"},{"file":"/srv/eccentric/cloud/public_html/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/srv/eccentric/cloud/public_html/lib/private/DB/Connection.php","line":462,"function":"executeStatement","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->"},{"file":"/srv/eccentric/cloud/public_html/lib/private/DB/ConnectionAdapter.php","line":67,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/srv/eccentric/cloud/public_html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":306,"function":"executeStatement","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/srv/eccentric/cloud/public_html/apps/dav/lib/CalDAV/CalDavBackend.php","line":1308,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/srv/eccentric/cloud/public_html/lib/public/AppFramework/Db/TTransactional.php","line":45,"function":"OCA\\DAV\\CalDAV\\{closure}","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/eccentric/cloud/public_html/apps/dav/lib/CalDAV/CalDavBackend.php","line":1259,"function":"atomic","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->"},{"file":"/srv/eccentric/cloud/public_html/apps/dav/lib/CalDAV/WebcalCaching/RefreshWebcalService.php","line":133,"function":"createCalendarObject","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/eccentric/cloud/public_html/apps/dav/lib/Listener/SubscriptionListener.php","line":45,"function":"refreshSubscription","class":"OCA\\DAV\\CalDAV\\WebcalCaching\\RefreshWebcalService","type":"->"},{"file":"/srv/eccentric/cloud/public_html/lib/private/EventDispatcher/ServiceEventListener.php","line":68,"function":"handle","class":"OCA\\DAV\\Listener\\SubscriptionListener","type":"->"},{"file":"/srv/eccentric/cloud/public_html/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":220,"function":"__invoke","class":"OC\\EventDispatcher\\ServiceEventListener","type":"->"},{"file":"/srv/eccentric/cloud/public_html/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":56,"function":"callListeners","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/srv/eccentric/cloud/public_html/lib/private/EventDispatcher/EventDispatcher.php","line":67,"function":"dispatch","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/srv/eccentric/cloud/public_html/lib/private/EventDispatcher/EventDispatcher.php","line":79,"function":"dispatch","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/srv/eccentric/cloud/public_html/apps/dav/lib/CalDAV/CalDavBackend.php","line":2644,"function":"dispatchTyped","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/srv/eccentric/cloud/public_html/3rdparty/sabre/dav/lib/CalDAV/CalendarHome.php","line":249,"function":"createSubscription","class":"OCA\\DAV\\CalDAV\\CalDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/eccentric/cloud/public_html/apps/dav/lib/CalDAV/CalendarHome.php","line":77,"function":"createExtendedCollection","class":"Sabre\\CalDAV\\CalendarHome","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/eccentric/cloud/public_html/3rdparty/sabre/dav/lib/DAV/Server.php","line":1199,"function":"createExtendedCollection","class":"OCA\\DAV\\CalDAV\\CalendarHome","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/eccentric/cloud/public_html/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":560,"function":"createCollection","class":"Sabre\\DAV\\Server","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/eccentric/cloud/public_html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpMkcol","class":"Sabre\\DAV\\CorePlugin","type":"->"},{"file":"/srv/eccentric/cloud/public_html/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/srv/eccentric/cloud/public_html/apps/dav/lib/Connector/Sabre/Server.php","line":43,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/srv/eccentric/cloud/public_html/apps/dav/lib/Server.php","line":371,"function":"start","class":"OCA\\DAV\\Connector\\Sabre\\Server","type":"->"},{"file":"/srv/eccentric/cloud/public_html/apps/dav/appinfo/v2/remote.php","line":19,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/srv/eccentric/cloud/public_html/remote.php","line":146,"args":["/srv/eccentric/cloud/public_html/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/srv/eccentric/cloud/public_html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":130}}},"message":"An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'uid' at row 1","exception":[],"CustomMessage":"An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'uid' at row 1"},"id":"67b311714dda5"}

Additional info

No response

[joshtrichards]

What's the source of the subscription?

The error suggests the UID field in the iCalendar file is out-of-spec.

[madsmh]

It is a calendar feed my of my class schedule my university makes available.

[joshtrichards]

Can you download the URL and see what the UID field value is?

We accept up to 255 characters, which is what the standard states.

Related: #42360

[madsmh]

There are 88 matches for the string "UID" and they seem to have several different values, examples are

UID:641442D91EB082302E81042B073AE391

and

UID:734E8D221AFB646C004037C40B142214

[madsmh]

It seems that the whole UID filed is:

UID:7C37BE8BDE5423A4BA17A86249BAE774 20250604T13000020250615T100039

and changing the uid field in oc_calendarobjects to varchar(355) seems to fix it.