search

nextcloud / server

☁️ Nextcloud server, a safe home for all your data
https://nextcloud.com
GNU Affero General Public License v3.0
26.24k stars 3.95k forks source link

[Bug]: Special character in ical url produce error when adding a new subscription #39892

Open Mat-DB opened 11 months ago

Mat-DB commented 11 months ago

⚠️ This issue respects the following points: ⚠️

Bug description

When I add a new subscription in the calendar app I get the following error. The ical url is from my university. The problem is that one of my professors has a "ë" in his name which creates the problem. Also google calendar has a problem with this and just displays a "�" instead, which is fine for me everything is better than an error.

I have tested using the linuxserver.io docker image. I tried the mariadb docker container from linuxserver.io and I tried the offical postgresql docker container. Both do not work and generate the same error. I also tried sqlite which does work. Always tested on a clean install.

Steps to reproduce

  1. Open the calendar app.
  2. Add a new subscription to a ical url. In the description of at least one appointment is a "é".
  3. The error appears.

Expected behavior

Like google display a "�" or something similar instead of giving an error.

Installation method

Community Docker image

Nextcloud Server version

27

Operating system

Debian/Ubuntu

PHP engine version

None

Web server

None

Database engine version

Other

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

Fresh Nextcloud Server install

Are you using the Nextcloud Server Encryption module?

Encryption is Disabled

What user-backends are you using?

Configuration report

root@f51a07aee6c7:/# occ config:list system
{
    "system": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "localhost:450"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "27.0.0.8",
        "overwrite.cli.url": "https:\/\/localhost:450",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true
    }
}

List of activated Apps

root@f51a07aee6c7:/# occ app:list
Enabled:
  - activity: 2.19.0
  - calendar: 4.4.4
  - circles: 27.0.0
  - cloud_federation_api: 1.10.0
  - comments: 1.17.0
  - contactsinteraction: 1.8.0
  - dashboard: 7.7.0
  - dav: 1.27.0
  - federatedfilesharing: 1.17.0
  - federation: 1.17.0
  - files: 1.22.0
  - files_pdfviewer: 2.8.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
  - logreader: 2.12.0
  - lookup_server_connector: 1.15.0
  - nextcloud_announcements: 1.16.0
  - notifications: 2.15.0
  - oauth2: 1.15.0
  - password_policy: 1.17.0
  - photos: 2.3.0
  - privacy: 1.11.0
  - provisioning_api: 1.17.0
  - recommendations: 1.6.0
  - related_resources: 1.2.0
  - serverinfo: 1.17.0
  - settings: 1.9.0
  - sharebymail: 1.17.0
  - support: 1.10.0
  - survey_client: 1.15.0
  - systemtags: 1.17.0
  - text: 3.8.0
  - theming: 2.2.0
  - twofactor_backupcodes: 1.16.0
  - updatenotification: 1.17.0
  - user_status: 1.7.0
  - viewer: 2.1.0
  - weather_status: 1.7.0
  - workflowengine: 2.9.0
Disabled:
  - admin_audit: 1.17.0
  - bruteforcesettings: 2.7.0
  - encryption: 2.15.0
  - files_external: 1.19.0
  - suspicious_login: 5.0.0
  - twofactor_totp: 9.0.0
  - user_ldap: 1.17.0

Nextcloud Signing status

No errors have been found.

Nextcloud Logs

[webdav] Error: OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xEBl Kee...' for column `nextcloud`.`oc_calendarobjects_props`.`value` at row 1 at <<closure>>

 0. /app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php line 328
    OC\DB\Exceptions\DbalException::wrap()
 1. /config/www/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php line 2974
    OC\DB\QueryBuilder\QueryBuilder->executeStatement()
 2. /app/www/public/lib/public/AppFramework/Db/TTransactional.php line 63
    OCA\DAV\CalDAV\CalDavBackend->OCA\DAV\CalDAV\{closure}("*** sensitive parameters replaced ***")
 3. /config/www/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php line 2932
    OCA\DAV\CalDAV\CalDavBackend->atomic()
 4. /config/www/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php line 1268
    OCA\DAV\CalDAV\CalDavBackend->updateProperties("*** sensitive parameters replaced ***")
 5. /app/www/public/lib/public/AppFramework/Db/TTransactional.php line 63
    OCA\DAV\CalDAV\CalDavBackend->OCA\DAV\CalDAV\{closure}("*** sensitive parameters replaced ***")
 6. /config/www/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php line 1217
    OCA\DAV\CalDAV\CalDavBackend->atomic()
 7. /config/www/nextcloud/apps/dav/lib/CalDAV/WebcalCaching/RefreshWebcalService.php line 129
    OCA\DAV\CalDAV\CalDavBackend->createCalendarObject("*** sensitive parameters replaced ***")
 8. /config/www/nextcloud/apps/dav/lib/Listener/SubscriptionListener.php line 61
    OCA\DAV\CalDAV\WebcalCaching\RefreshWebcalService->refreshSubscription()
 9. /app/www/public/lib/private/EventDispatcher/ServiceEventListener.php line 86
    OCA\DAV\Listener\SubscriptionListener->handle()
10. /app/www/public/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 251
    OC\EventDispatcher\ServiceEventListener->__invoke()
11. /app/www/public/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 73
    Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
12. /app/www/public/lib/private/EventDispatcher/EventDispatcher.php line 87
    Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
13. /app/www/public/lib/private/EventDispatcher/EventDispatcher.php line 99
    OC\EventDispatcher\EventDispatcher->dispatch()
14. /config/www/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php line 2479
    OC\EventDispatcher\EventDispatcher->dispatchTyped()
15. /app/www/public/3rdparty/sabre/dav/lib/CalDAV/CalendarHome.php line 249
    OCA\DAV\CalDAV\CalDavBackend->createSubscription("*** sensitive parameters replaced ***")
16. /config/www/nextcloud/apps/dav/lib/CalDAV/CalendarHome.php line 93
    Sabre\CalDAV\CalendarHome->createExtendedCollection("*** sensitive parameters replaced ***")
17. /app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php line 1199
    OCA\DAV\CalDAV\CalendarHome->createExtendedCollection("*** sensitive parameters replaced ***")
18. /app/www/public/3rdparty/sabre/dav/lib/DAV/CorePlugin.php line 560
    Sabre\DAV\Server->createCollection("*** sensitive parameters replaced ***")
19. /app/www/public/3rdparty/sabre/event/lib/WildcardEmitterTrait.php line 89
    Sabre\DAV\CorePlugin->httpMkcol()
20. /app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php line 472
    Sabre\DAV\Server->emit()
21. /app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php line 253
    Sabre\DAV\Server->invokeMethod()
22. /app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php line 321
    Sabre\DAV\Server->start()
23. /config/www/nextcloud/apps/dav/lib/Server.php line 364
    Sabre\DAV\Server->exec()
24. /config/www/nextcloud/apps/dav/appinfo/v2/remote.php line 35
    OCA\DAV\Server->exec()
25. /app/www/public/remote.php line 172
    require_once("/config/www/nex ... p")

Caused by:

Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xEBl Kee...' for column `nextcloud`.`oc_calendarobjects_props`.`value` at row 1 at <<closure>>

 0. /app/www/public/3rdparty/doctrine/dbal/src/Connection.php line 1814
    Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
 1. /app/www/public/3rdparty/doctrine/dbal/src/Connection.php line 1749
    Doctrine\DBAL\Connection->handleDriverException()
 2. /app/www/public/3rdparty/doctrine/dbal/src/Connection.php line 1163
    Doctrine\DBAL\Connection->convertExceptionDuringQuery()
 3. /app/www/public/lib/private/DB/Connection.php line 295
    Doctrine\DBAL\Connection->executeStatement()
 4. /app/www/public/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 354
    OC\DB\Connection->executeStatement()
 5. /app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php line 280
    Doctrine\DBAL\Query\QueryBuilder->execute()
 6. /app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php line 326
    OC\DB\QueryBuilder\QueryBuilder->execute()
 7. /config/www/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php line 2974
    OC\DB\QueryBuilder\QueryBuilder->executeStatement()
 8. /app/www/public/lib/public/AppFramework/Db/TTransactional.php line 63
    OCA\DAV\CalDAV\CalDavBackend->OCA\DAV\CalDAV\{closure}("*** sensitive parameters replaced ***")
 9. /config/www/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php line 2932
    OCA\DAV\CalDAV\CalDavBackend->atomic()
10. /config/www/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php line 1268
    OCA\DAV\CalDAV\CalDavBackend->updateProperties("*** sensitive parameters replaced ***")
11. /app/www/public/lib/public/AppFramework/Db/TTransactional.php line 63
    OCA\DAV\CalDAV\CalDavBackend->OCA\DAV\CalDAV\{closure}("*** sensitive parameters replaced ***")
12. /config/www/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php line 1217
    OCA\DAV\CalDAV\CalDavBackend->atomic()
13. /config/www/nextcloud/apps/dav/lib/CalDAV/WebcalCaching/RefreshWebcalService.php line 129
    OCA\DAV\CalDAV\CalDavBackend->createCalendarObject("*** sensitive parameters replaced ***")
14. /config/www/nextcloud/apps/dav/lib/Listener/SubscriptionListener.php line 61
    OCA\DAV\CalDAV\WebcalCaching\RefreshWebcalService->refreshSubscription()
15. /app/www/public/lib/private/EventDispatcher/ServiceEventListener.php line 86
    OCA\DAV\Listener\SubscriptionListener->handle()
16. /app/www/public/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 251
    OC\EventDispatcher\ServiceEventListener->__invoke()
17. /app/www/public/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 73
    Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
18. /app/www/public/lib/private/EventDispatcher/EventDispatcher.php line 87
    Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
19. /app/www/public/lib/private/EventDispatcher/EventDispatcher.php line 99
    OC\EventDispatcher\EventDispatcher->dispatch()
20. /config/www/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php line 2479
    OC\EventDispatcher\EventDispatcher->dispatchTyped()
21. /app/www/public/3rdparty/sabre/dav/lib/CalDAV/CalendarHome.php line 249
    OCA\DAV\CalDAV\CalDavBackend->createSubscription("*** sensitive parameters replaced ***")
22. /config/www/nextcloud/apps/dav/lib/CalDAV/CalendarHome.php line 93
    Sabre\CalDAV\CalendarHome->createExtendedCollection("*** sensitive parameters replaced ***")
23. /app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php line 1199
    OCA\DAV\CalDAV\CalendarHome->createExtendedCollection("*** sensitive parameters replaced ***")
24. /app/www/public/3rdparty/sabre/dav/lib/DAV/CorePlugin.php line 560
    Sabre\DAV\Server->createCollection("*** sensitive parameters replaced ***")
25. /app/www/public/3rdparty/sabre/event/lib/WildcardEmitterTrait.php line 89
    Sabre\DAV\CorePlugin->httpMkcol()
26. /app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php line 472
    Sabre\DAV\Server->emit()
27. /app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php line 253
    Sabre\DAV\Server->invokeMethod()
28. /app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php line 321
    Sabre\DAV\Server->start()
29. /config/www/nextcloud/apps/dav/lib/Server.php line 364
    Sabre\DAV\Server->exec()
30. /config/www/nextcloud/apps/dav/appinfo/v2/remote.php line 35
    OCA\DAV\Server->exec()
31. /app/www/public/remote.php line 172
    require_once("/config/www/nex ... p")

Caused by:

Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xEBl Kee...' for column `nextcloud`.`oc_calendarobjects_props`.`value` at row 1 at <<closure>>

 0. /app/www/public/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php line 103
    Doctrine\DBAL\Driver\PDO\Exception::new()
 1. /app/www/public/3rdparty/doctrine/dbal/src/Connection.php line 1153
    Doctrine\DBAL\Driver\PDO\Statement->execute()
 2. /app/www/public/lib/private/DB/Connection.php line 295
    Doctrine\DBAL\Connection->executeStatement()
 3. /app/www/public/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 354
    OC\DB\Connection->executeStatement()
 4. /app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php line 280
    Doctrine\DBAL\Query\QueryBuilder->execute()
 5. /app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php line 326
    OC\DB\QueryBuilder\QueryBuilder->execute()
 6. /config/www/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php line 2974
    OC\DB\QueryBuilder\QueryBuilder->executeStatement()
 7. /app/www/public/lib/public/AppFramework/Db/TTransactional.php line 63
    OCA\DAV\CalDAV\CalDavBackend->OCA\DAV\CalDAV\{closure}("*** sensitive parameters replaced ***")
 8. /config/www/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php line 2932
    OCA\DAV\CalDAV\CalDavBackend->atomic()
 9. /config/www/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php line 1268
    OCA\DAV\CalDAV\CalDavBackend->updateProperties("*** sensitive parameters replaced ***")
10. /app/www/public/lib/public/AppFramework/Db/TTransactional.php line 63
    OCA\DAV\CalDAV\CalDavBackend->OCA\DAV\CalDAV\{closure}("*** sensitive parameters replaced ***")
11. /config/www/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php line 1217
    OCA\DAV\CalDAV\CalDavBackend->atomic()
12. /config/www/nextcloud/apps/dav/lib/CalDAV/WebcalCaching/RefreshWebcalService.php line 129
    OCA\DAV\CalDAV\CalDavBackend->createCalendarObject("*** sensitive parameters replaced ***")
13. /config/www/nextcloud/apps/dav/lib/Listener/SubscriptionListener.php line 61
    OCA\DAV\CalDAV\WebcalCaching\RefreshWebcalService->refreshSubscription()
14. /app/www/public/lib/private/EventDispatcher/ServiceEventListener.php line 86
    OCA\DAV\Listener\SubscriptionListener->handle()
15. /app/www/public/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 251
    OC\EventDispatcher\ServiceEventListener->__invoke()
16. /app/www/public/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 73
    Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
17. /app/www/public/lib/private/EventDispatcher/EventDispatcher.php line 87
    Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
18. /app/www/public/lib/private/EventDispatcher/EventDispatcher.php line 99
    OC\EventDispatcher\EventDispatcher->dispatch()
19. /config/www/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php line 2479
    OC\EventDispatcher\EventDispatcher->dispatchTyped()
20. /app/www/public/3rdparty/sabre/dav/lib/CalDAV/CalendarHome.php line 249
    OCA\DAV\CalDAV\CalDavBackend->createSubscription("*** sensitive parameters replaced ***")
21. /config/www/nextcloud/apps/dav/lib/CalDAV/CalendarHome.php line 93
    Sabre\CalDAV\CalendarHome->createExtendedCollection("*** sensitive parameters replaced ***")
22. /app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php line 1199
    OCA\DAV\CalDAV\CalendarHome->createExtendedCollection("*** sensitive parameters replaced ***")
23. /app/www/public/3rdparty/sabre/dav/lib/DAV/CorePlugin.php line 560
    Sabre\DAV\Server->createCollection("*** sensitive parameters replaced ***")
24. /app/www/public/3rdparty/sabre/event/lib/WildcardEmitterTrait.php line 89
    Sabre\DAV\CorePlugin->httpMkcol()
25. /app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php line 472
    Sabre\DAV\Server->emit()
26. /app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php line 253
    Sabre\DAV\Server->invokeMethod()
27. /app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php line 321
    Sabre\DAV\Server->start()
28. /config/www/nextcloud/apps/dav/lib/Server.php line 364
    Sabre\DAV\Server->exec()
29. /config/www/nextcloud/apps/dav/appinfo/v2/remote.php line 35
    OCA\DAV\Server->exec()
30. /app/www/public/remote.php line 172
    require_once("/config/www/nex ... p")

Caused by:

PDOException: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xEBl Kee...' for column `nextcloud`.`oc_calendarobjects_props`.`value` at row 1 at <<closure>>

 0. /app/www/public/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php line 101
    PDOStatement->execute()
 1. /app/www/public/3rdparty/doctrine/dbal/src/Connection.php line 1153
    Doctrine\DBAL\Driver\PDO\Statement->execute()
 2. /app/www/public/lib/private/DB/Connection.php line 295
    Doctrine\DBAL\Connection->executeStatement()
 3. /app/www/public/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 354
    OC\DB\Connection->executeStatement()
 4. /app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php line 280
    Doctrine\DBAL\Query\QueryBuilder->execute()
 5. /app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php line 326
    OC\DB\QueryBuilder\QueryBuilder->execute()
 6. /config/www/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php line 2974
    OC\DB\QueryBuilder\QueryBuilder->executeStatement()
 7. /app/www/public/lib/public/AppFramework/Db/TTransactional.php line 63
    OCA\DAV\CalDAV\CalDavBackend->OCA\DAV\CalDAV\{closure}("*** sensitive parameters replaced ***")
 8. /config/www/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php line 2932
    OCA\DAV\CalDAV\CalDavBackend->atomic()
 9. /config/www/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php line 1268
    OCA\DAV\CalDAV\CalDavBackend->updateProperties("*** sensitive parameters replaced ***")
10. /app/www/public/lib/public/AppFramework/Db/TTransactional.php line 63
    OCA\DAV\CalDAV\CalDavBackend->OCA\DAV\CalDAV\{closure}("*** sensitive parameters replaced ***")
11. /config/www/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php line 1217
    OCA\DAV\CalDAV\CalDavBackend->atomic()
12. /config/www/nextcloud/apps/dav/lib/CalDAV/WebcalCaching/RefreshWebcalService.php line 129
    OCA\DAV\CalDAV\CalDavBackend->createCalendarObject("*** sensitive parameters replaced ***")
13. /config/www/nextcloud/apps/dav/lib/Listener/SubscriptionListener.php line 61
    OCA\DAV\CalDAV\WebcalCaching\RefreshWebcalService->refreshSubscription()
14. /app/www/public/lib/private/EventDispatcher/ServiceEventListener.php line 86
    OCA\DAV\Listener\SubscriptionListener->handle()
15. /app/www/public/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 251
    OC\EventDispatcher\ServiceEventListener->__invoke()
16. /app/www/public/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 73
    Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
17. /app/www/public/lib/private/EventDispatcher/EventDispatcher.php line 87
    Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
18. /app/www/public/lib/private/EventDispatcher/EventDispatcher.php line 99
    OC\EventDispatcher\EventDispatcher->dispatch()
19. /config/www/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php line 2479
    OC\EventDispatcher\EventDispatcher->dispatchTyped()
20. /app/www/public/3rdparty/sabre/dav/lib/CalDAV/CalendarHome.php line 249
    OCA\DAV\CalDAV\CalDavBackend->createSubscription("*** sensitive parameters replaced ***")
21. /config/www/nextcloud/apps/dav/lib/CalDAV/CalendarHome.php line 93
    Sabre\CalDAV\CalendarHome->createExtendedCollection("*** sensitive parameters replaced ***")
22. /app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php line 1199
    OCA\DAV\CalDAV\CalendarHome->createExtendedCollection("*** sensitive parameters replaced ***")
23. /app/www/public/3rdparty/sabre/dav/lib/DAV/CorePlugin.php line 560
    Sabre\DAV\Server->createCollection("*** sensitive parameters replaced ***")
24. /app/www/public/3rdparty/sabre/event/lib/WildcardEmitterTrait.php line 89
    Sabre\DAV\CorePlugin->httpMkcol()
25. /app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php line 472
    Sabre\DAV\Server->emit()
26. /app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php line 253
    Sabre\DAV\Server->invokeMethod()
27. /app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php line 321
    Sabre\DAV\Server->start()
28. /config/www/nextcloud/apps/dav/lib/Server.php line 364
    Sabre\DAV\Server->exec()
29. /config/www/nextcloud/apps/dav/appinfo/v2/remote.php line 35
    OCA\DAV\Server->exec()
30. /app/www/public/remote.php line 172
    require_once("/config/www/nex ... p")

MKCOL /remote.php/dav/calendars/admin/-
from 172.22.0.1 by admin at 2023-08-15T19:50:46+00:00

Additional info

I hope I gave all the necessary information.

kesselb commented 11 months ago

Thanks for your bug report :+1:

First, please make sure your sql server is configured properly for utf8mb4: https://docs.nextcloud.com/server/latest/admin_manual/configuration_database/mysql_4byte_support.html. mysql.utf8mb4 => true is in your configuration file, we usually set it during installation if 4byte support is there.

Second, please connect to your sql server and check that the table oc_calendarobjects_props has the right collation: utf8mb4_bin

cc @ChristophWurst @miaulalala

Mat-DB commented 11 months ago

config.php, this is a clean install just to test.

<?php
$CONFIG = array (
  'instanceid' => 'REMOVED',
  'passwordsalt' => 'REMOVED',
  'secret' => 'REMOVED',
  'trusted_domains' => 
  array (
    0 => 'localhost:450',
  ),
  'datadirectory' => '/data',
  'dbtype' => 'mysql',
  'version' => '27.0.0.8',
  'overwrite.cli.url' => 'https://localhost:450',
  'dbname' => 'nextcloud',
  'dbhost' => 'nextcloud-db',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => 'oc_admin',
  'dbpassword' => 'REMOVED',
  'installed' => true,
  'memcache.local' => '\\OC\\Memcache\\APCu',
  'filelocking.enabled' => 'true',
  'memcache.locking' => '\\OC\\Memcache\\APCu',
);

So that is fine. How do I check this in the database, mariadb? Edit: I found it:

MariaDB [(none)]> SELECT      DEFAULT_CHARACTER_SET_NAME,      DEFAULT_COLLATION_NAME  FROM      INFORMATION_SCHEMA.SCHEMATA  WHERE      SCHEMA_NAME = 'nextcloud';
+----------------------------+------------------------+
| DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME |
+----------------------------+------------------------+
| utf8mb4                    | utf8mb4_bin            |
+----------------------------+------------------------+
1 row in set (0.001 sec)
w1n5l0w commented 10 months ago

Same error here, also all db-table with charset utf8mb4.

sigfriedseldeslachts commented 9 months ago

Also experiencing something similar on Nextcloud 27.1.1 with postgres 14 and an UTF8 db. The ical calendar contains an invalid character in some calendar items which causes an error.

[webdav] Error: OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[22021]: Character not in repertoire: 7 ERROR:  invalid byte sequence for encoding "UTF8": 0xe3 0x6f 0x20 at <<closure>>

 0. /var/www/ols_nextcloud/public_html/lib/private/DB/QueryBuilder/QueryBuilder.php line 328
    OC\DB\Exceptions\DbalException::wrap()
 1. /var/www/ols_nextcloud/public_html/apps/dav/lib/CalDAV/CalDavBackend.php line 3002
    OC\DB\QueryBuilder\QueryBuilder->executeStatement()
 2. /var/www/ols_nextcloud/public_html/lib/public/AppFramework/Db/TTransactional.php line 63
    OCA\DAV\CalDAV\CalDavBackend->OCA\DAV\CalDAV\{closure}("*** sensitive parameters replaced ***")
 3. /var/www/ols_nextcloud/public_html/apps/dav/lib/CalDAV/CalDavBackend.php line 3025
    OCA\DAV\CalDAV\CalDavBackend->atomic()
 4. /var/www/ols_nextcloud/public_html/apps/dav/lib/CalDAV/CalDavBackend.php line 1280
    OCA\DAV\CalDAV\CalDavBackend->updateProperties("*** sensitive parameters replaced ***")
 5. /var/www/ols_nextcloud/public_html/lib/public/AppFramework/Db/TTransactional.php line 63
    OCA\DAV\CalDAV\CalDavBackend->OCA\DAV\CalDAV\{closure}("*** sensitive parameters replaced ***")
 6. /var/www/ols_nextcloud/public_html/apps/dav/lib/CalDAV/CalDavBackend.php line 1298
    OCA\DAV\CalDAV\CalDavBackend->atomic()
 7. /var/www/ols_nextcloud/public_html/apps/dav/lib/CalDAV/WebcalCaching/RefreshWebcalService.php line 129
    OCA\DAV\CalDAV\CalDavBackend->createCalendarObject("*** sensitive parameters replaced ***")
 8. /var/www/ols_nextcloud/public_html/apps/dav/lib/Listener/SubscriptionListener.php line 63
    OCA\DAV\CalDAV\WebcalCaching\RefreshWebcalService->refreshSubscription()
 9. /var/www/ols_nextcloud/public_html/lib/private/EventDispatcher/ServiceEventListener.php line 86
    OCA\DAV\Listener\SubscriptionListener->handle()
10. /var/www/ols_nextcloud/public_html/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 251
    OC\EventDispatcher\ServiceEventListener->__invoke()
11. /var/www/ols_nextcloud/public_html/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 73
    Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
12. /var/www/ols_nextcloud/public_html/lib/private/EventDispatcher/EventDispatcher.php line 94
    Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
13. /var/www/ols_nextcloud/public_html/lib/private/EventDispatcher/EventDispatcher.php line 106
    OC\EventDispatcher\EventDispatcher->dispatch()
14. /var/www/ols_nextcloud/public_html/apps/dav/lib/CalDAV/CalDavBackend.php line 2499
    OC\EventDispatcher\EventDispatcher->dispatchTyped()
15. /var/www/ols_nextcloud/public_html/3rdparty/sabre/dav/lib/CalDAV/CalendarHome.php line 249
    OCA\DAV\CalDAV\CalDavBackend->createSubscription("*** sensitive parameters replaced ***")
16. /var/www/ols_nextcloud/public_html/apps/dav/lib/CalDAV/CalendarHome.php line 94
    Sabre\CalDAV\CalendarHome->createExtendedCollection("*** sensitive parameters replaced ***")
17. /var/www/ols_nextcloud/public_html/3rdparty/sabre/dav/lib/DAV/Server.php line 1199
    OCA\DAV\CalDAV\CalendarHome->createExtendedCollection("*** sensitive parameters replaced ***")
18. /var/www/ols_nextcloud/public_html/3rdparty/sabre/dav/lib/DAV/CorePlugin.php line 560
    Sabre\DAV\Server->createCollection("*** sensitive parameters replaced ***")
19. /var/www/ols_nextcloud/public_html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php line 89
    Sabre\DAV\CorePlugin->httpMkcol()
20. /var/www/ols_nextcloud/public_html/3rdparty/sabre/dav/lib/DAV/Server.php line 472
    Sabre\DAV\Server->emit()
21. /var/www/ols_nextcloud/public_html/3rdparty/sabre/dav/lib/DAV/Server.php line 253
    Sabre\DAV\Server->invokeMethod()
22. /var/www/ols_nextcloud/public_html/3rdparty/sabre/dav/lib/DAV/Server.php line 321
    Sabre\DAV\Server->start()
23. /var/www/ols_nextcloud/public_html/apps/dav/lib/Server.php line 365
    Sabre\DAV\Server->exec()
24. /var/www/ols_nextcloud/public_html/apps/dav/appinfo/v2/remote.php line 35
    OCA\DAV\Server->exec()
25. /var/www/ols_nextcloud/public_html/remote.php line 172
    require_once("/var/www/ols_ne ... p")

Caused by:

Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[22021]: Character not in repertoire: 7 ERROR:  invalid byte sequence for encoding "UTF8": 0xe3 0x6f 0x20 at <<closure>>

 0. /var/www/ols_nextcloud/public_html/3rdparty/doctrine/dbal/src/Connection.php line 1814
    Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert()
 1. /var/www/ols_nextcloud/public_html/3rdparty/doctrine/dbal/src/Connection.php line 1749
    Doctrine\DBAL\Connection->handleDriverException()
 2. /var/www/ols_nextcloud/public_html/3rdparty/doctrine/dbal/src/Connection.php line 1163
    Doctrine\DBAL\Connection->convertExceptionDuringQuery()
 3. /var/www/ols_nextcloud/public_html/lib/private/DB/Connection.php line 295
    Doctrine\DBAL\Connection->executeStatement()
 4. /var/www/ols_nextcloud/public_html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 354
    OC\DB\Connection->executeStatement()
 5. /var/www/ols_nextcloud/public_html/lib/private/DB/QueryBuilder/QueryBuilder.php line 280
    Doctrine\DBAL\Query\QueryBuilder->execute()
 6. /var/www/ols_nextcloud/public_html/lib/private/DB/QueryBuilder/QueryBuilder.php line 326
    OC\DB\QueryBuilder\QueryBuilder->execute()
 7. /var/www/ols_nextcloud/public_html/apps/dav/lib/CalDAV/CalDavBackend.php line 3002
    OC\DB\QueryBuilder\QueryBuilder->executeStatement()
 8. /var/www/ols_nextcloud/public_html/lib/public/AppFramework/Db/TTransactional.php line 63
    OCA\DAV\CalDAV\CalDavBackend->OCA\DAV\CalDAV\{closure}("*** sensitive parameters replaced ***")
 9. /var/www/ols_nextcloud/public_html/apps/dav/lib/CalDAV/CalDavBackend.php line 3025
    OCA\DAV\CalDAV\CalDavBackend->atomic()
10. /var/www/ols_nextcloud/public_html/apps/dav/lib/CalDAV/CalDavBackend.php line 1280
    OCA\DAV\CalDAV\CalDavBackend->updateProperties("*** sensitive parameters replaced ***")
11. /var/www/ols_nextcloud/public_html/lib/public/AppFramework/Db/TTransactional.php line 63
    OCA\DAV\CalDAV\CalDavBackend->OCA\DAV\CalDAV\{closure}("*** sensitive parameters replaced ***")
12. /var/www/ols_nextcloud/public_html/apps/dav/lib/CalDAV/CalDavBackend.php line 1298
    OCA\DAV\CalDAV\CalDavBackend->atomic()
13. /var/www/ols_nextcloud/public_html/apps/dav/lib/CalDAV/WebcalCaching/RefreshWebcalService.php line 129
    OCA\DAV\CalDAV\CalDavBackend->createCalendarObject("*** sensitive parameters replaced ***")
14. /var/www/ols_nextcloud/public_html/apps/dav/lib/Listener/SubscriptionListener.php line 63
    OCA\DAV\CalDAV\WebcalCaching\RefreshWebcalService->refreshSubscription()
15. /var/www/ols_nextcloud/public_html/lib/private/EventDispatcher/ServiceEventListener.php line 86
    OCA\DAV\Listener\SubscriptionListener->handle()
16. /var/www/ols_nextcloud/public_html/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 251
    OC\EventDispatcher\ServiceEventListener->__invoke()
17. /var/www/ols_nextcloud/public_html/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 73
    Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
18. /var/www/ols_nextcloud/public_html/lib/private/EventDispatcher/EventDispatcher.php line 94
    Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
19. /var/www/ols_nextcloud/public_html/lib/private/EventDispatcher/EventDispatcher.php line 106
    OC\EventDispatcher\EventDispatcher->dispatch()
20. /var/www/ols_nextcloud/public_html/apps/dav/lib/CalDAV/CalDavBackend.php line 2499
    OC\EventDispatcher\EventDispatcher->dispatchTyped()
21. /var/www/ols_nextcloud/public_html/3rdparty/sabre/dav/lib/CalDAV/CalendarHome.php line 249
    OCA\DAV\CalDAV\CalDavBackend->createSubscription("*** sensitive parameters replaced ***")
22. /var/www/ols_nextcloud/public_html/apps/dav/lib/CalDAV/CalendarHome.php line 94
    Sabre\CalDAV\CalendarHome->createExtendedCollection("*** sensitive parameters replaced ***")
23. /var/www/ols_nextcloud/public_html/3rdparty/sabre/dav/lib/DAV/Server.php line 1199
    OCA\DAV\CalDAV\CalendarHome->createExtendedCollection("*** sensitive parameters replaced ***")
24. /var/www/ols_nextcloud/public_html/3rdparty/sabre/dav/lib/DAV/CorePlugin.php line 560
    Sabre\DAV\Server->createCollection("*** sensitive parameters replaced ***")
25. /var/www/ols_nextcloud/public_html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php line 89
    Sabre\DAV\CorePlugin->httpMkcol()
26. /var/www/ols_nextcloud/public_html/3rdparty/sabre/dav/lib/DAV/Server.php line 472
    Sabre\DAV\Server->emit()
27. /var/www/ols_nextcloud/public_html/3rdparty/sabre/dav/lib/DAV/Server.php line 253
    Sabre\DAV\Server->invokeMethod()
28. /var/www/ols_nextcloud/public_html/3rdparty/sabre/dav/lib/DAV/Server.php line 321
    Sabre\DAV\Server->start()
29. /var/www/ols_nextcloud/public_html/apps/dav/lib/Server.php line 365
    Sabre\DAV\Server->exec()
30. /var/www/ols_nextcloud/public_html/apps/dav/appinfo/v2/remote.php line 35
    OCA\DAV\Server->exec()
31. /var/www/ols_nextcloud/public_html/remote.php line 172
    require_once("/var/www/ols_ne ... p")

Caused by:

Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[22021]: Character not in repertoire: 7 ERROR:  invalid byte sequence for encoding "UTF8": 0xe3 0x6f 0x20 at <<closure>>

 0. /var/www/ols_nextcloud/public_html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php line 103
    Doctrine\DBAL\Driver\PDO\Exception::new()
 1. /var/www/ols_nextcloud/public_html/3rdparty/doctrine/dbal/src/Connection.php line 1153
    Doctrine\DBAL\Driver\PDO\Statement->execute()
 2. /var/www/ols_nextcloud/public_html/lib/private/DB/Connection.php line 295
    Doctrine\DBAL\Connection->executeStatement()
 3. /var/www/ols_nextcloud/public_html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 354
    OC\DB\Connection->executeStatement()
 4. /var/www/ols_nextcloud/public_html/lib/private/DB/QueryBuilder/QueryBuilder.php line 280
    Doctrine\DBAL\Query\QueryBuilder->execute()
 5. /var/www/ols_nextcloud/public_html/lib/private/DB/QueryBuilder/QueryBuilder.php line 326
    OC\DB\QueryBuilder\QueryBuilder->execute()
 6. /var/www/ols_nextcloud/public_html/apps/dav/lib/CalDAV/CalDavBackend.php line 3002
    OC\DB\QueryBuilder\QueryBuilder->executeStatement()
 7. /var/www/ols_nextcloud/public_html/lib/public/AppFramework/Db/TTransactional.php line 63
    OCA\DAV\CalDAV\CalDavBackend->OCA\DAV\CalDAV\{closure}("*** sensitive parameters replaced ***")
 8. /var/www/ols_nextcloud/public_html/apps/dav/lib/CalDAV/CalDavBackend.php line 3025
    OCA\DAV\CalDAV\CalDavBackend->atomic()
 9. /var/www/ols_nextcloud/public_html/apps/dav/lib/CalDAV/CalDavBackend.php line 1280
    OCA\DAV\CalDAV\CalDavBackend->updateProperties("*** sensitive parameters replaced ***")
10. /var/www/ols_nextcloud/public_html/lib/public/AppFramework/Db/TTransactional.php line 63
    OCA\DAV\CalDAV\CalDavBackend->OCA\DAV\CalDAV\{closure}("*** sensitive parameters replaced ***")
11. /var/www/ols_nextcloud/public_html/apps/dav/lib/CalDAV/CalDavBackend.php line 1298
    OCA\DAV\CalDAV\CalDavBackend->atomic()
12. /var/www/ols_nextcloud/public_html/apps/dav/lib/CalDAV/WebcalCaching/RefreshWebcalService.php line 129
    OCA\DAV\CalDAV\CalDavBackend->createCalendarObject("*** sensitive parameters replaced ***")
13. /var/www/ols_nextcloud/public_html/apps/dav/lib/Listener/SubscriptionListener.php line 63
    OCA\DAV\CalDAV\WebcalCaching\RefreshWebcalService->refreshSubscription()
14. /var/www/ols_nextcloud/public_html/lib/private/EventDispatcher/ServiceEventListener.php line 86
    OCA\DAV\Listener\SubscriptionListener->handle()
15. /var/www/ols_nextcloud/public_html/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 251
    OC\EventDispatcher\ServiceEventListener->__invoke()
16. /var/www/ols_nextcloud/public_html/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 73
    Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
17. /var/www/ols_nextcloud/public_html/lib/private/EventDispatcher/EventDispatcher.php line 94
    Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
18. /var/www/ols_nextcloud/public_html/lib/private/EventDispatcher/EventDispatcher.php line 106
    OC\EventDispatcher\EventDispatcher->dispatch()
19. /var/www/ols_nextcloud/public_html/apps/dav/lib/CalDAV/CalDavBackend.php line 2499
    OC\EventDispatcher\EventDispatcher->dispatchTyped()
20. /var/www/ols_nextcloud/public_html/3rdparty/sabre/dav/lib/CalDAV/CalendarHome.php line 249
    OCA\DAV\CalDAV\CalDavBackend->createSubscription("*** sensitive parameters replaced ***")
21. /var/www/ols_nextcloud/public_html/apps/dav/lib/CalDAV/CalendarHome.php line 94
    Sabre\CalDAV\CalendarHome->createExtendedCollection("*** sensitive parameters replaced ***")
22. /var/www/ols_nextcloud/public_html/3rdparty/sabre/dav/lib/DAV/Server.php line 1199
    OCA\DAV\CalDAV\CalendarHome->createExtendedCollection("*** sensitive parameters replaced ***")
23. /var/www/ols_nextcloud/public_html/3rdparty/sabre/dav/lib/DAV/CorePlugin.php line 560
    Sabre\DAV\Server->createCollection("*** sensitive parameters replaced ***")
24. /var/www/ols_nextcloud/public_html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php line 89
    Sabre\DAV\CorePlugin->httpMkcol()
25. /var/www/ols_nextcloud/public_html/3rdparty/sabre/dav/lib/DAV/Server.php line 472
    Sabre\DAV\Server->emit()
26. /var/www/ols_nextcloud/public_html/3rdparty/sabre/dav/lib/DAV/Server.php line 253
    Sabre\DAV\Server->invokeMethod()
27. /var/www/ols_nextcloud/public_html/3rdparty/sabre/dav/lib/DAV/Server.php line 321
    Sabre\DAV\Server->start()
28. /var/www/ols_nextcloud/public_html/apps/dav/lib/Server.php line 365
    Sabre\DAV\Server->exec()
29. /var/www/ols_nextcloud/public_html/apps/dav/appinfo/v2/remote.php line 35
    OCA\DAV\Server->exec()
30. /var/www/ols_nextcloud/public_html/remote.php line 172
    require_once("/var/www/ols_ne ... p")

Caused by:

PDOException: SQLSTATE[22021]: Character not in repertoire: 7 ERROR:  invalid byte sequence for encoding "UTF8": 0xe3 0x6f 0x20 at <<closure>>

 0. /var/www/ols_nextcloud/public_html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php line 101
    PDOStatement->execute()
 1. /var/www/ols_nextcloud/public_html/3rdparty/doctrine/dbal/src/Connection.php line 1153
    Doctrine\DBAL\Driver\PDO\Statement->execute()
 2. /var/www/ols_nextcloud/public_html/lib/private/DB/Connection.php line 295
    Doctrine\DBAL\Connection->executeStatement()
 3. /var/www/ols_nextcloud/public_html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 354
    OC\DB\Connection->executeStatement()
 4. /var/www/ols_nextcloud/public_html/lib/private/DB/QueryBuilder/QueryBuilder.php line 280
    Doctrine\DBAL\Query\QueryBuilder->execute()
 5. /var/www/ols_nextcloud/public_html/lib/private/DB/QueryBuilder/QueryBuilder.php line 326
    OC\DB\QueryBuilder\QueryBuilder->execute()
 6. /var/www/ols_nextcloud/public_html/apps/dav/lib/CalDAV/CalDavBackend.php line 3002
    OC\DB\QueryBuilder\QueryBuilder->executeStatement()
 7. /var/www/ols_nextcloud/public_html/lib/public/AppFramework/Db/TTransactional.php line 63
    OCA\DAV\CalDAV\CalDavBackend->OCA\DAV\CalDAV\{closure}("*** sensitive parameters replaced ***")
 8. /var/www/ols_nextcloud/public_html/apps/dav/lib/CalDAV/CalDavBackend.php line 3025
    OCA\DAV\CalDAV\CalDavBackend->atomic()
 9. /var/www/ols_nextcloud/public_html/apps/dav/lib/CalDAV/CalDavBackend.php line 1280
    OCA\DAV\CalDAV\CalDavBackend->updateProperties("*** sensitive parameters replaced ***")
10. /var/www/ols_nextcloud/public_html/lib/public/AppFramework/Db/TTransactional.php line 63
    OCA\DAV\CalDAV\CalDavBackend->OCA\DAV\CalDAV\{closure}("*** sensitive parameters replaced ***")
11. /var/www/ols_nextcloud/public_html/apps/dav/lib/CalDAV/CalDavBackend.php line 1298
    OCA\DAV\CalDAV\CalDavBackend->atomic()
12. /var/www/ols_nextcloud/public_html/apps/dav/lib/CalDAV/WebcalCaching/RefreshWebcalService.php line 129
    OCA\DAV\CalDAV\CalDavBackend->createCalendarObject("*** sensitive parameters replaced ***")
13. /var/www/ols_nextcloud/public_html/apps/dav/lib/Listener/SubscriptionListener.php line 63
    OCA\DAV\CalDAV\WebcalCaching\RefreshWebcalService->refreshSubscription()
14. /var/www/ols_nextcloud/public_html/lib/private/EventDispatcher/ServiceEventListener.php line 86
    OCA\DAV\Listener\SubscriptionListener->handle()
15. /var/www/ols_nextcloud/public_html/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 251
    OC\EventDispatcher\ServiceEventListener->__invoke()
16. /var/www/ols_nextcloud/public_html/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 73
    Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
17. /var/www/ols_nextcloud/public_html/lib/private/EventDispatcher/EventDispatcher.php line 94
    Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
18. /var/www/ols_nextcloud/public_html/lib/private/EventDispatcher/EventDispatcher.php line 106
    OC\EventDispatcher\EventDispatcher->dispatch()
19. /var/www/ols_nextcloud/public_html/apps/dav/lib/CalDAV/CalDavBackend.php line 2499
    OC\EventDispatcher\EventDispatcher->dispatchTyped()
20. /var/www/ols_nextcloud/public_html/3rdparty/sabre/dav/lib/CalDAV/CalendarHome.php line 249
    OCA\DAV\CalDAV\CalDavBackend->createSubscription("*** sensitive parameters replaced ***")
21. /var/www/ols_nextcloud/public_html/apps/dav/lib/CalDAV/CalendarHome.php line 94
    Sabre\CalDAV\CalendarHome->createExtendedCollection("*** sensitive parameters replaced ***")
22. /var/www/ols_nextcloud/public_html/3rdparty/sabre/dav/lib/DAV/Server.php line 1199
    OCA\DAV\CalDAV\CalendarHome->createExtendedCollection("*** sensitive parameters replaced ***")
23. /var/www/ols_nextcloud/public_html/3rdparty/sabre/dav/lib/DAV/CorePlugin.php line 560
    Sabre\DAV\Server->createCollection("*** sensitive parameters replaced ***")
24. /var/www/ols_nextcloud/public_html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php line 89
    Sabre\DAV\CorePlugin->httpMkcol()
25. /var/www/ols_nextcloud/public_html/3rdparty/sabre/dav/lib/DAV/Server.php line 472
    Sabre\DAV\Server->emit()
26. /var/www/ols_nextcloud/public_html/3rdparty/sabre/dav/lib/DAV/Server.php line 253
    Sabre\DAV\Server->invokeMethod()
27. /var/www/ols_nextcloud/public_html/3rdparty/sabre/dav/lib/DAV/Server.php line 321
    Sabre\DAV\Server->start()
28. /var/www/ols_nextcloud/public_html/apps/dav/lib/Server.php line 365
    Sabre\DAV\Server->exec()
29. /var/www/ols_nextcloud/public_html/apps/dav/appinfo/v2/remote.php line 35
    OCA\DAV\Server->exec()
30. /var/www/ols_nextcloud/public_html/remote.php line 172
    require_once("/var/www/ols_ne ... p")

MKCOL /remote.php/dav/calendars/*** sensitive parameters replaced ***/*** sensitive parameters replaced ***
from *** sensitive parameters replaced *** by *** sensitive parameters replaced *** at 2023-09-26T07:23:07+00:00
miaulalala commented 9 months ago

Character not in repertoire: 7 ERROR: invalid byte sequence for encoding "UTF8": 0xe3 0x6f 0x20 Looks like we might need to encode the query before running it. Uff... encoding issues in PHP shudder

miaulalala commented 8 months ago

I will test this tomorrow - the idea is to create a new public calendar in NC and modify the public link token to contain one of those special chars that cause issues.

miaulalala commented 2 months ago

I can't reproduce, but as far as I can tell it's the calendarobjects_props table that is causing issues. There's code in the CalDavBackend that's supposed to replace chars that aren't supported

https://github.com/nextcloud/server/blob/ab6afe0111b25bd2d764bb807f086808ae7a5534/apps/dav/lib/CalDAV/CalDavBackend.php#L3096-L3098

But it might not be effective