[Bug]: Appointment feature can't find a slot

[patzm]

⚠️ This issue respects the following points: ⚠️

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

Bug description

I created an appointment slot. See screenshots:

Saved it, tested it in a private Window (Firefox latest). Nothing happened. The logs then contain

[calendar] Warning: OCA\Calendar\Exception\NoSlotFoundException: Could not find slot for booking at <<closure>>

0. /data/userapps/calendar/lib/Controller/BookingController.php line 189
   OCA\Calendar\Service\Appointments\BookingService->book()
1. /var/www/lib/private/AppFramework/Http/Dispatcher.php line 225
   OCA\Calendar\Controller\BookingController->bookSlot()
2. /var/www/lib/private/AppFramework/Http/Dispatcher.php line 133
   OC\AppFramework\Http\Dispatcher->executeController()
3. /var/www/lib/private/AppFramework/App.php line 172
   OC\AppFramework\Http\Dispatcher->dispatch()
4. /var/www/lib/private/Route/Router.php line 298
   OC\AppFramework\App::main()
5. /var/www/lib/base.php line 1047
   OC\Route\Router->match()
6. /var/www/index.php line 36
   OC::handleRequest()

POST /apps/calendar/appointment/3/book
from 77.47.74.144 at 2023-03-06T09:40:27+01:00

raw

{"reqId":"PBE8JIXnpD91ZI2t5f6T","level":2,"time":"2023-03-06T09:40:27+01:00","remoteAddr":"77.47.74.144","user":"--","app":"calendar","method":"POST","url":"/apps/calendar/appointment/3/book","message":"No slot available for start: 1678174800, end: 1678176600, config id: 3","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:109.0) Gecko/20100101 Firefox/110.0","version":"25.0.3.2","exception":{"Exception":"OCA\\Calendar\\Exception\\NoSlotFoundException","Message":"Could not find slot for booking","Code":0,"Trace":[{"file":"/data/userapps/calendar/lib/Controller/BookingController.php","line":189,"function":"book","class":"OCA\\Calendar\\Service\\Appointments\\BookingService","type":"->"},{"file":"/var/www/lib/private/AppFramework/Http/Dispatcher.php","line":225,"function":"bookSlot","class":"OCA\\Calendar\\Controller\\BookingController","type":"->"},{"file":"/var/www/lib/private/AppFramework/Http/Dispatcher.php","line":133,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/lib/private/AppFramework/App.php","line":172,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/lib/private/Route/Router.php","line":298,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/lib/base.php","line":1047,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/index.php","line":36,"function":"handleRequest","class":"OC","type":"::"}],"File":"/data/userapps/calendar/lib/Service/Appointments/BookingService.php","Line":133,"message":"No slot available for start: 1678174800, end: 1678176600, config id: 3","exception":[],"CustomMessage":"No slot available for start: 1678174800, end: 1678176600, config id: 3"},"id":"6405a83cee572"}

Steps to reproduce

1. create an appointment
2. send the appointment link
3. book an appointment

Expected behavior

It works 🙈.

Installation method

Community Docker image

Operating system

Debian/Ubuntu

PHP engine version

PHP 8.1

Web server

Apache (supported)

Database engine version

MariaDB

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

Updated from a minor version (ex. 22.2.3 to 22.2.4)

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": {
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "tempdirectory": "\/data\/tmp",
        "supportedDatabases": [
            "sqlite",
            "mysql",
            "pgsql"
        ],
        "logtimezone": "Europe\/Berlin",
        "logdateformat": "Y-m-d H:i:s",
        "memcache.local": "\\OC\\Memcache\\APCu",
        "apps_paths": [
            {
                "path": "\/var\/www\/apps",
                "url": "\/apps",
                "writable": false
            },
            {
                "path": "\/data\/userapps",
                "url": "\/userapps",
                "writable": true
            }
        ],
        "default_locale": "de",
        "default_phone_region": "DE",
        "mail_smtpmode": "smtp",
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "cloud.patz.app"
        ],
        "trusted_proxies": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "25.0.3.2",
        "overwriteprotocol": "https",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_sendmailmode": "smtp",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpauthtype": "LOGIN",
        "mail_smtpsecure": "ssl",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "465",
        "mail_smtpauth": 1,
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "loglevel": 2,
        "maintenance": false,
        "app_install_overwrite": [
            "occweb",
            "drawio",
            "extract",
            "gpxpod",
            "electronicsignatures",
            "files_markdown",
            "files_mindmap",
            "socialsharing_email"
        ],
        "theme": "",
        "allow_local_remote_servers": true,
        "overwrite.cli.url": "https:\/\/cloud.patz.app"
    }
}

List of activated Apps

Enabled:
  - activity: 2.17.0
  - admin_audit: 1.15.0
  - calendar: 4.2.4
  - circles: 25.0.0
  - cloud_federation_api: 1.8.0
  - comments: 1.15.0
  - contacts: 5.1.0
  - contactsinteraction: 1.6.0
  - cospend: 1.5.8
  - dav: 1.24.0
  - deck: 1.8.3
  - drawio: 2.1.0
  - electronicsignatures: 2.0.3
  - extract: 1.3.5
  - federatedfilesharing: 1.15.0
  - federation: 1.15.0
  - files: 1.20.1
  - files_accesscontrol: 1.15.1
  - files_automatedtagging: 1.15.2
  - files_markdown: 2.3.6
  - files_mindmap: 0.0.27
  - files_pdfviewer: 2.6.0
  - files_rightclick: 1.4.0
  - files_sharing: 1.17.0
  - files_trashbin: 1.15.0
  - files_versions: 1.18.0
  - files_zip: 1.1.2
  - firstrunwizard: 2.14.0
  - forms: 3.1.0
  - gpxpod: 5.0.6
  - groupfolders: 13.1.1
  - integration_google: 1.0.9
  - integration_openproject: 2.3.1
  - logreader: 2.10.0
  - lookup_server_connector: 1.13.0
  - mail: 2.2.4
  - maps: 0.2.4
  - nextcloud_announcements: 1.14.0
  - notifications: 2.13.1
  - oauth2: 1.13.0
  - onlyoffice: 7.6.8
  - password_policy: 1.15.0
  - photos: 2.0.1
  - privacy: 1.9.0
  - provisioning_api: 1.15.0
  - recommendations: 1.4.0
  - related_resources: 1.0.4
  - serverinfo: 1.15.0
  - settings: 1.7.0
  - sharebymail: 1.15.0
  - socialsharing_email: 2.5.0
  - spreed: 15.0.4
  - support: 1.8.0
  - survey_client: 1.13.0
  - suspicious_login: 4.3.0
  - systemtags: 1.15.0
  - tasks: 0.14.5
  - text: 3.6.0
  - theming: 2.0.1
  - twofactor_backupcodes: 1.14.0
  - updatenotification: 1.15.0
  - user_oidc: 1.3.0
  - user_status: 1.5.0
  - viewer: 1.9.0
  - weather_status: 1.5.0
  - workflowengine: 2.7.0
Disabled:
  - bruteforcesettings: 2.4.0
  - dashboard: 7.0.0
  - encryption
  - files_external: 1.16.1
  - twofactor_totp
  - user_ldap

Nextcloud Signing status

No errors have been found.

Nextcloud Logs

[calendar] Warning: OCA\Calendar\Exception\NoSlotFoundException: Could not find slot for booking at <<closure>>

0. /data/userapps/calendar/lib/Controller/BookingController.php line 189
   OCA\Calendar\Service\Appointments\BookingService->book()
1. /var/www/lib/private/AppFramework/Http/Dispatcher.php line 225
   OCA\Calendar\Controller\BookingController->bookSlot()
2. /var/www/lib/private/AppFramework/Http/Dispatcher.php line 133
   OC\AppFramework\Http\Dispatcher->executeController()
3. /var/www/lib/private/AppFramework/App.php line 172
   OC\AppFramework\Http\Dispatcher->dispatch()
4. /var/www/lib/private/Route/Router.php line 298
   OC\AppFramework\App::main()
5. /var/www/lib/base.php line 1047
   OC\Route\Router->match()
6. /var/www/index.php line 36
   OC::handleRequest()

POST /apps/calendar/appointment/3/book
from 77.47.74.144 at 2023-03-06T09:40:27+01:00

Additional info

This repo contains my configuration: https://github.com/patzm/dockerfiles/tree/master/nextcloud

[miaulalala]

Do you use Thunderbird or do you have all day events in your calendar? (Even deleted ones could impact the slot availability - I had the case of all day events that had been deleted still blocking the appointments).

[patzm]

Thunderbird definitely not.

All-day events: Not that I know of. Is there an issue for that already?

[miaulalala]

I thought there was but I can't find it. Can you also please check your VAVAILABILITY on /settings/user/availability?

[patzm]

https://URL/settings/user/availability is an empty settings page. Is that expected as #2158 is still open?

We already talked about this in nextcloud/server#36245, I didn't respond to you yet sorry. Now did in nextcloud/server#36245 (comment). Does that help?

[ChristophWurst]

https://URL/settings/user/availability is an empty settings page

the page moved with nextcloud/server#34626

[patzm]

thx for the link. I am still on NextCloud 25.0.3, so I guess not affected, yet. I still have the Groupware setting. However, can't find the VAVAILABILITY there.