search

nextcloud / calendar

📆 Calendar app for Nextcloud
https://apps.nextcloud.com/apps/calendar
GNU Affero General Public License v3.0
984 stars 241 forks source link

Resources/Rooms not showing up #4008

Open q-wertz opened 2 years ago

q-wertz commented 2 years ago

Steps to reproduce

  1. Add rooms using a resource backend
  2. Make sure that the cron job added them in the oc_calendar_rooms table
  3. Try to assign a room to the appointment

Expected behavior

All rooms are shown that fit the search term

Actual behaviour

I added now several rooms. The only one that I can find is the one with ID 38 when I type in test in the search field. Things like Bespr, Be, INS, … do not work. In the Firefox debugger I also get a error 404 when doing these request. Test gives status 207. No idea what's going on…

I came here after the fix for https://github.com/nextcloud/calendar/issues/3907 which seems to not cover everything…

Calendar app version

3.1.0

CalDAV-clients used

Webbrowser

Browser

Firefox 97.0

Client operating system

Ubuntu 21.10

Server operating system

Ubuntu 20.04

Web server

Nginx

Database engine version

MariaDB

PHP engine version

PHP 7.4

Nextcloud version

22.2.5

Updated from an older installed version or fresh install

Updated from an older version

List of activated apps

Enabled:
  - accessibility: 1.8.0
  - activity: 2.15.0
  - admin_audit: 1.12.0
  - appointments: 1.12.0
  - bruteforcesettings: 2.3.0
  - calendar: 3.1.0
  - calendar_resource_management: 0.1.0
  - circles: 22.2.0
  - cloud_federation_api: 1.5.0
  - comments: 1.12.0
  - contacts: 4.0.8
  - dashboard: 7.2.0
  - dav: 1.20.0
  - deck: 1.5.5
  - drawio: 1.0.2
  - federatedfilesharing: 1.12.0
  - federation: 1.12.0
  - files: 1.17.0
  - files_external: 1.13.1
  - files_pdfviewer: 2.3.1
  - files_rightclick: 1.1.0
  - files_sharing: 1.14.0
  - files_trashbin: 1.12.0
  - files_versions: 1.15.0
  - files_videoplayer: 1.11.0
  - firstrunwizard: 2.11.0
  - groupfolders: 10.0.2
  - integration_gitlab: 1.0.3
  - integration_openproject: 1.0.6
  - logreader: 2.7.0
  - lookup_server_connector: 1.10.0
  - news: 18.0.0
  - nextcloud_announcements: 1.11.0
  - notifications: 2.10.1
  - oauth2: 1.10.0
  - password_policy: 1.12.0
  - photos: 1.4.0
  - polls: 3.5.4
  - privacy: 1.6.0
  - provisioning_api: 1.12.0
  - quota_warning: 1.13.1
  - recommendations: 1.1.0
  - serverinfo: 1.12.0
  - settings: 1.4.0
  - sharebymail: 1.12.0
  - smb_test: 0.3.3
  - support: 1.5.0
  - systemtags: 1.12.0
  - tasks: 0.14.2
  - text: 3.3.0
  - theming: 1.13.0
  - twofactor_backupcodes: 1.11.0
  - updatenotification: 1.12.0
  - user_ldap: 1.12.2
  - user_status: 1.2.0
  - viewer: 1.6.0
  - weather_status: 1.2.0
  - workflowengine: 2.4.0
Disabled:
  - contactsinteraction: 1.2.0
  - encryption
  - mail: 1.11.7
  - ransomware_protection: 1.12.0
  - survey_client: 1.4.0

Nextcloud configuration

{
    "system": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "nc.secret.de",
            "nc.secret.de"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "22.2.5.1",
        "overwrite.cli.url": "https:\/\/nc.secret.de",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "mysql.utf8mb4": true,
        "maintenance": false,
        "session_lifetime": 604800,
        "session_keepalive": true,
        "mail_smtpmode": "smtp",
        "mail_sendmailmode": "smtp",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "25",
        "default_language": "de_DE",
        "default_locale": "de",
        "default_phone_region": "DE",
        "skeletondirectory": "",
        "loglevel": 2,
        "updater.release.channel": "stable",
        "app_install_overwrite": [
            "drawio"
        ],
        "mail_smtpsecure": "tls",
        "ldapIgnoreNamingRules": false,
        "ldapProviderFactory": "OCA\\User_LDAP\\LDAPProviderFactory",
        "memcache.local": "\\OC\\Memcache\\APCu",
        "memcache.distributed": "\\OC\\Memcache\\Redis",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 0,
            "password": "***REMOVED SENSITIVE VALUE***"
        }
    }
}

Web server error log

In access.log:

141.58.121.86 - - [01/Mar/2022:16:41:20 +0100] "REPORT /remote.php/dav/ HTTP/2.0" 404 182 "-" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:97.0) Gecko/20100101 Firefox/97.0"

Log file

{"reqId":"sbkJDVhjyvEoHmHtnsk0","level":3,"time":"2022-03-01T12:10:01+00:00","remoteAddr":"","user":"--","app":"files_sharing","method":"","url":"--","message":"Must be logged in get the attachment folder","userAgent":"--","version":"22.2.5.1","exception":{"Exception":"OCA\\Deck\\NoPermissionException","Message":"Must be logged in get the attachment folder","Code":0,"Trace":[{"file":"/var/www/nextcloud/apps/deck/lib/Sharing/Listener.php","line":105,"function":"getAttachmentFolder","class":"OCA\\Deck\\Service\\ConfigService","type":"->"},{"file":"/var/www/nextcloud/apps/deck/lib/Sharing/Listener.php","line":62,"function":"overwriteMountPoint","class":"OCA\\Deck\\Sharing\\Listener","type":"->"},{"file":"/var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":251,"function":"listenVerifyMountPointEvent","class":"OCA\\Deck\\Sharing\\Listener","type":"::"},{"file":"/var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":73,"function":"callListeners","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":88,"function":"dispatch","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":100,"function":"dispatch","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/nextcloud/apps/files_sharing/lib/SharedMount.php","line":98,"function":"dispatchTyped","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/nextcloud/apps/files_sharing/lib/SharedMount.php","line":79,"function":"verifyMountPoint","class":"OCA\\Files_Sharing\\SharedMount","type":"->"},{"file":"/var/www/nextcloud/apps/files_sharing/lib/MountProvider.php","line":113,"function":"__construct","class":"OCA\\Files_Sharing\\SharedMount","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Config/MountProviderCollection.php","line":118,"function":"getMountsForUser","class":"OCA\\Files_Sharing\\MountProvider","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Filesystem.php","line":429,"function":"addMountForUser","class":"OC\\Files\\Config\\MountProviderCollection","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Filesystem.php","line":354,"function":"initMountPoints","class":"OC\\Files\\Filesystem","type":"::"},{"file":"/var/www/nextcloud/lib/private/legacy/OC_Util.php","line":325,"function":"init","class":"OC\\Files\\Filesystem","type":"::"},{"file":"/var/www/nextcloud/lib/private/Files/Utils/Scanner.php","line":115,"function":"setupFS","class":"OC_Util","type":"::"},{"file":"/var/www/nextcloud/lib/private/Files/Utils/Scanner.php","line":157,"function":"getMounts","class":"OC\\Files\\Utils\\Scanner","type":"->"},{"file":"/var/www/nextcloud/apps/files/lib/BackgroundJob/ScanFiles.php","line":84,"function":"backgroundScan","class":"OC\\Files\\Utils\\Scanner","type":"->"},{"file":"/var/www/nextcloud/apps/files/lib/BackgroundJob/ScanFiles.php","line":121,"function":"runScanner","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->"},{"file":"/var/www/nextcloud/lib/private/BackgroundJob/Job.php","line":51,"function":"run","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->"},{"file":"/var/www/nextcloud/lib/private/BackgroundJob/TimedJob.php","line":58,"function":"execute","class":"OC\\BackgroundJob\\Job","type":"->"},{"file":"/var/www/nextcloud/cron.php","line":127,"function":"execute","class":"OC\\BackgroundJob\\TimedJob","type":"->"}],"File":"/var/www/nextcloud/apps/deck/lib/Service/ConfigService.php","Line":173,"CustomMessage":"--"}}

{"reqId":"sbkJDVhjyvEoHmHtnsk0","level":4,"time":"2022-03-01T12:10:01+00:00","remoteAddr":"","user":"--","app":"files_sharing","method":"","url":"--","message":"Error while trying to create shared mount","userAgent":"--","version":"22.2.5.1"}

{"reqId":"R8NqMH5513n7BCa4CA3q","level":3,"time":"2022-03-01T12:25:02+00:00","remoteAddr":"","user":"--","app":"files_sharing","method":"","url":"--","message":"Must be logged in get the attachment folder","userAgent":"--","version":"22.2.5.1","exception":{"Exception":"OCA\\Deck\\NoPermissionException","Message":"Must be logged in get the attachment folder","Code":0,"Trace":[{"file":"/var/www/nextcloud/apps/deck/lib/Sharing/Listener.php","line":105,"function":"getAttachmentFolder","class":"OCA\\Deck\\Service\\ConfigService","type":"->"},{"file":"/var/www/nextcloud/apps/deck/lib/Sharing/Listener.php","line":62,"function":"overwriteMountPoint","class":"OCA\\Deck\\Sharing\\Listener","type":"->"},{"file":"/var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":251,"function":"listenVerifyMountPointEvent","class":"OCA\\Deck\\Sharing\\Listener","type":"::"},{"file":"/var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":73,"function":"callListeners","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":88,"function":"dispatch","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":100,"function":"dispatch","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/nextcloud/apps/files_sharing/lib/SharedMount.php","line":98,"function":"dispatchTyped","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/nextcloud/apps/files_sharing/lib/SharedMount.php","line":79,"function":"verifyMountPoint","class":"OCA\\Files_Sharing\\SharedMount","type":"->"},{"file":"/var/www/nextcloud/apps/files_sharing/lib/MountProvider.php","line":113,"function":"__construct","class":"OCA\\Files_Sharing\\SharedMount","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Config/MountProviderCollection.php","line":118,"function":"getMountsForUser","class":"OCA\\Files_Sharing\\MountProvider","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Filesystem.php","line":429,"function":"addMountForUser","class":"OC\\Files\\Config\\MountProviderCollection","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Filesystem.php","line":354,"function":"initMountPoints","class":"OC\\Files\\Filesystem","type":"::"},{"file":"/var/www/nextcloud/lib/private/legacy/OC_Util.php","line":325,"function":"init","class":"OC\\Files\\Filesystem","type":"::"},{"file":"/var/www/nextcloud/lib/private/Files/Utils/Scanner.php","line":115,"function":"setupFS","class":"OC_Util","type":"::"},{"file":"/var/www/nextcloud/lib/private/Files/Utils/Scanner.php","line":157,"function":"getMounts","class":"OC\\Files\\Utils\\Scanner","type":"->"},{"file":"/var/www/nextcloud/apps/files/lib/BackgroundJob/ScanFiles.php","line":84,"function":"backgroundScan","class":"OC\\Files\\Utils\\Scanner","type":"->"},{"file":"/var/www/nextcloud/apps/files/lib/BackgroundJob/ScanFiles.php","line":121,"function":"runScanner","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->"},{"file":"/var/www/nextcloud/lib/private/BackgroundJob/Job.php","line":51,"function":"run","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->"},{"file":"/var/www/nextcloud/lib/private/BackgroundJob/TimedJob.php","line":58,"function":"execute","class":"OC\\BackgroundJob\\Job","type":"->"},{"file":"/var/www/nextcloud/cron.php","line":127,"function":"execute","class":"OC\\BackgroundJob\\TimedJob","type":"->"}],"File":"/var/www/nextcloud/apps/deck/lib/Service/ConfigService.php","Line":173,"CustomMessage":"--"}}

{"reqId":"R8NqMH5513n7BCa4CA3q","level":4,"time":"2022-03-01T12:25:02+00:00","remoteAddr":"","user":"--","app":"files_sharing","method":"","url":"--","message":"Error while trying to create shared mount","userAgent":"--","version":"22.2.5.1"}

{"reqId":"AoPdGxa1C00X8IgjFOOt","level":3,"time":"2022-03-01T14:55:02+00:00","remoteAddr":"","user":"--","app":"files_sharing","method":"","url":"--","message":"Must be logged in get the attachment folder","userAgent":"--","version":"22.2.5.1","exception":{"Exception":"OCA\\Deck\\NoPermissionException","Message":"Must be logged in get the attachment folder","Code":0,"Trace":[{"file":"/var/www/nextcloud/apps/deck/lib/Sharing/Listener.php","line":105,"function":"getAttachmentFolder","class":"OCA\\Deck\\Service\\ConfigService","type":"->"},{"file":"/var/www/nextcloud/apps/deck/lib/Sharing/Listener.php","line":62,"function":"overwriteMountPoint","class":"OCA\\Deck\\Sharing\\Listener","type":"->"},{"file":"/var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":251,"function":"listenVerifyMountPointEvent","class":"OCA\\Deck\\Sharing\\Listener","type":"::"},{"file":"/var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":73,"function":"callListeners","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":88,"function":"dispatch","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":100,"function":"dispatch","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/nextcloud/apps/files_sharing/lib/SharedMount.php","line":98,"function":"dispatchTyped","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/nextcloud/apps/files_sharing/lib/SharedMount.php","line":79,"function":"verifyMountPoint","class":"OCA\\Files_Sharing\\SharedMount","type":"->"},{"file":"/var/www/nextcloud/apps/files_sharing/lib/MountProvider.php","line":113,"function":"__construct","class":"OCA\\Files_Sharing\\SharedMount","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Config/MountProviderCollection.php","line":118,"function":"getMountsForUser","class":"OCA\\Files_Sharing\\MountProvider","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Filesystem.php","line":429,"function":"addMountForUser","class":"OC\\Files\\Config\\MountProviderCollection","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Filesystem.php","line":354,"function":"initMountPoints","class":"OC\\Files\\Filesystem","type":"::"},{"file":"/var/www/nextcloud/lib/private/legacy/OC_Util.php","line":325,"function":"init","class":"OC\\Files\\Filesystem","type":"::"},{"file":"/var/www/nextcloud/lib/private/Files/Utils/Scanner.php","line":115,"function":"setupFS","class":"OC_Util","type":"::"},{"file":"/var/www/nextcloud/lib/private/Files/Utils/Scanner.php","line":157,"function":"getMounts","class":"OC\\Files\\Utils\\Scanner","type":"->"},{"file":"/var/www/nextcloud/apps/files/lib/BackgroundJob/ScanFiles.php","line":84,"function":"backgroundScan","class":"OC\\Files\\Utils\\Scanner","type":"->"},{"file":"/var/www/nextcloud/apps/files/lib/BackgroundJob/ScanFiles.php","line":121,"function":"runScanner","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->"},{"file":"/var/www/nextcloud/lib/private/BackgroundJob/Job.php","line":51,"function":"run","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->"},{"file":"/var/www/nextcloud/lib/private/BackgroundJob/TimedJob.php","line":58,"function":"execute","class":"OC\\BackgroundJob\\Job","type":"->"},{"file":"/var/www/nextcloud/cron.php","line":127,"function":"execute","class":"OC\\BackgroundJob\\TimedJob","type":"->"}],"File":"/var/www/nextcloud/apps/deck/lib/Service/ConfigService.php","Line":173,"CustomMessage":"--"}}
{"reqId":"AoPdGxa1C00X8IgjFOOt","level":4,"time":"2022-03-01T14:55:02+00:00","remoteAddr":"","user":"--","app":"files_sharing","method":"","url":"--","message":"Error while trying to create shared mount","userAgent":"--","version":"22.2.5.1"}

Browser log

Failing request (with e.g. Bespr which should fit all rooms):

<x0:principal-property-search xmlns:x0="DAV:" test="allof">
<x0:property-search>
<x0:prop>
<x0:displayname/></x0:prop>
<x0:match>Bespr</x0:match></x0:property-search>
<x0:prop>
<x0:displayname/>
<x1:calendar-user-type xmlns:x1="urn:ietf:params:xml:ns:caldav"/>
<x1:calendar-user-address-set xmlns:x1="urn:ietf:params:xml:ns:caldav"/>
<x0:principal-URL/>
<x0:alternate-URI-set/>
<x2:email-address xmlns:x2="http://sabredav.org/ns"/>
<x3:language xmlns:x3="http://nextcloud.com/ns"/>
<x1:calendar-home-set xmlns:x1="urn:ietf:params:xml:ns:caldav"/>
<x1:schedule-inbox-URL xmlns:x1="urn:ietf:params:xml:ns:caldav"/>
<x1:schedule-outbox-URL xmlns:x1="urn:ietf:params:xml:ns:caldav"/>
<x3:resource-type xmlns:x3="http://nextcloud.com/ns"/>
<x3:resource-vehicle-type xmlns:x3="http://nextcloud.com/ns"/>
<x3:resource-vehicle-make xmlns:x3="http://nextcloud.com/ns"/>
<x3:resource-vehicle-model xmlns:x3="http://nextcloud.com/ns"/>
<x3:resource-vehicle-is-electric xmlns:x3="http://nextcloud.com/ns"/>
<x3:resource-vehicle-range xmlns:x3="http://nextcloud.com/ns"/>
<x3:resource-vehicle-seating-capacity xmlns:x3="http://nextcloud.com/ns"/>
<x3:resource-contact-person xmlns:x3="http://nextcloud.com/ns"/>
<x3:resource-contact-person-vcard xmlns:x3="http://nextcloud.com/ns"/>
<x3:room-type xmlns:x3="http://nextcloud.com/ns"/>
<x3:room-seating-capacity xmlns:x3="http://nextcloud.com/ns"/>
<x3:room-building-address xmlns:x3="http://nextcloud.com/ns"/>
<x3:room-building-story xmlns:x3="http://nextcloud.com/ns"/>
<x3:room-building-room-number xmlns:x3="http://nextcloud.com/ns"/>
<x3:room-features xmlns:x3="http://nextcloud.com/ns"/></x0:prop>
<x0:apply-to-principal-collection-set/></x0:principal-property-search>

Response:

<?xml version="1.0" encoding="utf-8"?>
<d:error xmlns:d="DAV:" xmlns:s="http://sabredav.org/ns">
  <s:exception>Sabre\DAV\Exception\NotFound</s:exception>
  <s:message>Principal with name 38 not found</s:message>
</d:error>

Additional info

Output of the resource backend:

root@asterix:/var/www/nextcloud# sudo -u www-data ./occ calendar-resource:resources:list
Buildings:
+----+------+---------------------------------------------+-------------+-----------------------+
| ID | Name | Address                                     | Description | Wheelchair Accessible |
+----+------+---------------------------------------------+-------------+-----------------------+
| 6  | Br2  | secret                                      |             | yes                   |
+----+------+---------------------------------------------+-------------+-----------------------+
Rooms:
+----+------------------------------+----------------------+------------+-------------------------------------------+--------------+-------------------+----------+-------------+-------+--------------------+----+-----------+------------+-----------------------+
| ID | UID                          | Name                 | Located in | Email                                     | Room Type    | Contact Person    | Capacity | Room Number | Phone | Video Conferencing | TV | Projector | Whiteboard | Wheelchair Accessible |
+----+------------------------------+----------------------+------------+-------------------------------------------+--------------+-------------------+----------+-------------+-------+--------------------+----+-----------+------------+-----------------------+
| 37 | Besprechungsraum-INS_3/38    | Besprechungsraum INS | Br2, 3     | besprechungsraum3-38@secret.de            | meeting-room | +49 711 685-83401 | 20       | 3/38        | yes   | yes                | no | yes       | no         | yes                   |
| 39 | Besprechungsraum-INS338      | Besprechungsraum INS | Br2, 3     | besprechungsraum338@secret.de             | meeting-room | +49 711 685-83401 | 20       | 3/38        | yes   | yes                | no | yes       | no         | yes                   |
| 40 | Besprechungsraum-INS338-test | BesprechungsraumINS  | Br2, 3     | besprechungsraum338t@secret.de            | meeting-room | +49 711 685-83401 | 20       | 3/38        | yes   | yes                | no | yes       | no         | yes                   |
| 38 | Besprechungsraumtest         | Besprechungsraumtest | Br2, 3     | besprechungsraumtest@secret.de            | meeting-room | +49 711 685-83401 | 20       | 3/38        | yes   | yes                | no | yes       | no         | yes                   |
+----+------------------------------+----------------------+------------+-------------------------------------------+--------------+-------------------+----------+-------------+-------+--------------------+----+-----------+------------+-----------------------+
Resources:
+----+-----+------+------------+----------------+------+
| ID | UID | Name | Located in | Contact Person | Type |
+----+-----+------+------------+----------------+------+
Vehicles:
+----+-----+------+------------+-------+----------------+------+------+-------+----------+-------+----------+
| ID | UID | Name | Located in | Email | Contact Person | Type | Make | Model | Electric | Range | Capacity |
+----+-----+------+------------+-------+----------------+------+------+-------+----------+-------+----------+
Restrictions:
+----+--------+-----------+---------------+
| ID | Entity | Entity ID | Restricted To |
+----+--------+-----------+---------------+

Content of the calendar_rooms sql table

MariaDB [nextcloud]> SELECT * FROM oc_calendar_rooms;
+----+------------------------------+------------------------------+-------------------------------------------+----------------------+--------------------+
| id | backend_id                   | resource_id                  | email                                     | displayname          | group_restrictions |
+----+------------------------------+------------------------------+-------------------------------------------+----------------------+--------------------+
|  9 | calendar_resource_management | Besprechungsraum-INS_3/38    | besprechungsraum3-38@secret.de            | Besprechungsraum INS | []                 |
| 10 | calendar_resource_management | Besprechungsraumtest         | besprechungsraumtest@secret.de            | Besprechungsraumtest | []                 |
| 11 | calendar_resource_management | Besprechungsraum-INS338      | besprechungsraum338@secret.de             | Besprechungsraum INS | []                 |
| 12 | calendar_resource_management | Besprechungsraum-INS338-test | besprechungsraum338t@secret.de            | BesprechungsraumINS  | []                 |
+----+------------------------------+------------------------------+-------------------------------------------+----------------------+--------------------+
4 rows in set (0.000 sec)
q-wertz commented 2 years ago

Is the search looking in the displayname field or somewhere else?

q-wertz commented 2 years ago

I think I found the issue. I had two rooms with the same display name Besprechungsraum INS. The app seems to malfunction in this case with "unpredictable" behavior.

Maybe someone could double check that behavior. If it is intended to disallow two same display names an error should be raised just like with e.g. duplicate email addresses.