Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Bug]: Error when adding calendar subscription #50847

Open
5 of 8 tasks
madsmh opened this issue Feb 17, 2025 · 4 comments
Open
5 of 8 tasks

[Bug]: Error when adding calendar subscription #50847

madsmh opened this issue Feb 17, 2025 · 4 comments
Labels
0. Needs triage Pending check for reproducibility or if it fits our roadmap 30-feedback bug feature: caldav Related to CalDAV internals

Comments

@madsmh
Copy link

madsmh commented Feb 17, 2025 •
edited
Loading

⚠️ This issue respects the following points: ⚠️

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
@madsmh madsmh added 0. Needs triage Pending check for reproducibility or if it fits our roadmap bug labels Feb 17, 2025
@joshtrichards
Copy link
Member

What's the source of the subscription?

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

@madsmh
Copy link
Author

madsmh commented Feb 17, 2025

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

@joshtrichards
Copy link
Member

joshtrichards commented Feb 17, 2025 •
edited
Loading

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

@joshtrichards joshtrichards changed the title [Bug]: Error when adding calendar subsription [Bug]: Error when adding calendar subscription Feb 18, 2025
@madsmh
Copy link
Author

madsmh commented Feb 18, 2025

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

UID:641442D91EB082302E81042B073AE391

and

UID:734E8D221AFB646C004037C40B142214

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
0. Needs triage Pending check for reproducibility or if it fits our roadmap 30-feedback bug feature: caldav Related to CalDAV internals
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@joshtrichards @madsmh