calendar icon indicating copy to clipboard operation
calendar copied to clipboard
verified publisher icon nextcloud

Appointments No slots available

Open Tealk opened this issue 1 year ago • 9 comments

Steps to reproduce

1.Click on preview 2. Choose a day off

Expected behavior

free times are displayed

Actual behaviour

Only “No slots available” is displayed

Calendar app version

4.7.1

CalDAV-clients used

No response

Browser

Firefox 125.0.2 (64-bit)

Client operating system

Arch Linux

Server operating system

Debian

Web server

Nginx

Database engine version

PostgreSQL

PHP engine version

PHP 8.2

Nextcloud version

Hub 8 (29.0.0)

Updated from an older installed version or fresh install

Updated from an older version

List of activated apps

Enabled:
  - activity: 2.21.1
  - admin_audit: 1.19.0
  - approval: 1.2.0
  - calendar: 4.7.1
  - circles: 29.0.0-dev
  - cloud_federation_api: 1.12.0
  - collectives: 2.10.1
  - comments: 1.19.0
  - contacts: 6.0.0
  - dashboard: 7.9.0
  - dav: 1.30.1
  - deck: 1.13.0
  - drop_account: 2.5.0
  - end_to_end_encryption: 1.15.2
  - event_update_notification: 2.4.0
  - federatedfilesharing: 1.19.0
  - federation: 1.19.0
  - files: 2.1.0
  - files_antivirus: 5.5.0
  - files_downloadlimit: 2.0.0
  - files_linkeditor: 1.1.20
  - files_lock: 29.0.0
  - files_pdfviewer: 2.10.0
  - files_reminders: 1.2.0
  - files_sharing: 1.21.0
  - files_trashbin: 1.19.0
  - files_versions: 1.22.0
  - fileslibreofficeedit: 1.1.0
  - firstrunwizard: 2.18.0
  - forms: 4.2.3
  - groupfolders: 17.0.0-beta.1
  - guests: 3.1.0
  - integration_openai: 2.0.0
  - integration_openstreetmap: 1.0.12
  - integration_replicate: 3.0.0
  - logreader: 2.14.0
  - lookup_server_connector: 1.17.0
  - mail: 3.6.0
  - nextcloud_announcements: 1.18.0
  - notes: 4.10.0
  - notifications: 2.17.0
  - oauth2: 1.17.0
  - oidc_login: 3.0.2
  - password_policy: 1.19.0
  - photos: 2.5.0
  - polls: 7.0.3
  - privacy: 1.13.0
  - provisioning_api: 1.19.0
  - qownnotesapi: 24.4.0
  - quota_warning: 1.19.0
  - recommendations: 2.1.0
  - registration: 2.4.0
  - related_resources: 1.4.0
  - richdocuments: 8.4.0
  - serverinfo: 1.19.0
  - settings: 1.12.0
  - sharebymail: 1.19.0
  - socialsharing_email: 3.1.0
  - spreed: 19.0.0
  - survey_client: 1.17.0
  - systemtags: 1.19.0
  - tables: 0.7.0
  - text: 3.10.0
  - text_templates: 1.0.5
  - theming: 2.4.0
  - translate: 2.1.0
  - twofactor_backupcodes: 1.18.0
  - twofactor_nextcloud_notification: 3.9.0
  - twofactor_totp: 11.0.0-dev
  - twofactor_webauthn: 1.4.0
  - updatenotification: 1.19.1
  - user_migration: 6.0.0
  - user_retention: 1.12.0
  - user_status: 1.9.0
  - viewer: 2.3.0
  - workflowengine: 2.11.0
Disabled:
  - bruteforcesettings: 2.9.0 (installed 1.3.0)
  - contactsinteraction: 1.10.0 (installed 1.3.0)
  - encryption: 2.17.0
  - files_external: 1.21.0
  - maps: 1.3.1 (installed 1.3.1)
  - support: 1.12.0 (installed 1.5.0)
  - suspicious_login: 7.0.0 (installed 5.0.0)
  - tasks: 0.15.0 (installed 0.15.0)
  - twofactor_email: 2.7.4 (installed 2.7.4)
  - user_ldap: 1.20.0
  - weather_status: 1.9.0 (installed 1.0.0)

Nextcloud configuration

{
    "system": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "rollenspiel.cloud",
            "192.168.100.11",
            "localhost"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "overwrite.cli.url": "https:\/\/rollenspiel.cloud",
        "overwriteprotocol": "https",
        "htaccess.RewriteBase": "\/",
        "dbtype": "pgsql",
        "version": "29.0.0.19",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "mysql.utf8mb4": true,
        "installed": true,
        "maintenance": false,
        "default_language": "de",
        "default_locale": "de",
        "default_phone_region": "DE",
        "allow_user_to_change_display_name": true,
        "knowledgebaseenabled": true,
        "theme": "",
        "defaultapp": "",
        "skeletondirectory": "\/mnt\/hdd\/skeleton",
        "trashbin_retention_obligation": "120, auto",
        "versions_retention_obligation": "120, auto",
        "appcodechecker": true,
        "updatechecker": true,
        "updater.release.channel": "stable",
        "check_for_working_webdav": true,
        "maintenance_window_start": 1,
        "loglevel": 2,
        "logdateformat": "d.m.Y H:i:s",
        "logtimezone": "Europe\/Berlin",
        "log_rotate_size": 10485760,
        "mail_smtpmode": "smtp",
        "mail_smtpauthtype": "PLAIN",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpsecure": "ssl",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "465",
        "mail_smtpauth": 1,
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "enable_previews": true,
        "preview_max_x": 2048,
        "preview_max_y": 2048,
        "preview_max_filesize_image": 50,
        "preview_max_scale_factor": 10,
        "data-fingerprint": "d76fcffe3970dd2910ea5d733e3ed673",
        "memcache.local": "\\OC\\Memcache\\APCu",
        "memcache.distributed": "\\OC\\Memcache\\APCu",
        "memcache.locking": "\\OC\\Memcache\\APCu",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 6379,
            "dbindex": 1,
            "timeout": 1.5
        },
        "filelocking.enabled": "true",
        "twofactor_enforced": false,
        "twofactor_enforced_groups": [
            "admin"
        ],
        "twofactor_enforced_excluded_groups": [],
        "mail_sendmailmode": "smtp",
        "migrate_guest_user_data": true,
        "remove_guest_account_on_conversion": true,
        "keep_users_without_login": "no",
        "trusted_proxies": "***REMOVED SENSITIVE VALUE***",
        "app_install_overwrite": [
            "gpgmailer",
            "oidc_login",
            "registration",
            "files_downloadactivity"
        ],
        "oidc_login_provider_url": "https:\/\/auth.rollenspiel.monster\/application\/o\/nextcloud\/",
        "oidc_login_client_id": "TjkzVgMvkHJnbZriUAGn9YsqyE0xzWwoa84hzlAk",
        "oidc_login_client_secret": "tqTH4KAbGLyYRFO7hyIHyJAMcEKWO2goMLUWQ3tslWUIiwjkstwqJ6r9yXDMUpwQ",
        "oidc_login_button_text": "Log in with Authentik",
        "memories.exiftool": "\/var\/www\/nextcloud\/apps\/memories\/bin-ext\/exiftool-amd64-glibc",
        "memories.vod.path": "\/var\/www\/nextcloud\/apps\/memories\/bin-ext\/go-vod-amd64"
    }
}

Web server error log

no entries

Log file

no entries

Browser log

no entries

Additional info

I know that it still worked with v28.0.4.

Tealk avatar Apr 26 '24 06:04 Tealk

Even after several updates it still doesn't work, is there anything I can do to help?

Tealk avatar Jun 05 '24 06:06 Tealk

Can you share your appointment configuration? Do you have any all day events in your calendar? Can you enable debug logging and share your logfile entries for the calendar app?

You can enable conditional logging for the Calendar app only: https://docs.nextcloud.com/server/latest/admin_manual/configuration_server/config_sample_php_parameters.html#log-condition

miaulalala avatar Jun 05 '24 10:06 miaulalala

Can you share your appointment configuration?

image image

Do you have any all day events in your calendar?

in the past yes, but none in the next few weeks.

I did not enter any appointments on the 6th. image

Logs:

{"reqId":"xZAOBOq4bqZ5DuLTCcyC","level":0,"time":"05.06.2024 17:56:25","remoteAddr":"192.168.100.11","user":"Tealk","app":"calendar-appointments","method":"GET","url":"/apps/calendar/appointment/7/slots?startTime=1717624800&timeZone=Europe%2FBerlin","message":"Maximum end time: 1722786985","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:126.0) Gecko/20100101 Firefox/126.0","version":"29.0.1.1","data":{"app":"calendar-appointments"}}
{"reqId":"xZAOBOq4bqZ5DuLTCcyC","level":0,"time":"05.06.2024 17:56:25","remoteAddr":"192.168.100.11","user":"Tealk","app":"calendar-appointments","method":"GET","url":"/apps/calendar/appointment/7/slots?startTime=1717624800&timeZone=Europe%2FBerlin","message":"Found 4 applicable slot(s) after date filtering","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:126.0) Gecko/20100101 Firefox/126.0","version":"29.0.1.1","data":{"app":"calendar-appointments"}}
{"reqId":"xZAOBOq4bqZ5DuLTCcyC","level":0,"time":"05.06.2024 17:56:25","remoteAddr":"192.168.100.11","user":"Tealk","app":"calendar-appointments","method":"GET","url":"/apps/calendar/appointment/7/slots?startTime=1717624800&timeZone=Europe%2FBerlin","message":"Intervals before extrapolating:0","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:126.0) Gecko/20100101 Firefox/126.0","version":"29.0.1.1","data":{"app":"calendar-appointments"}}
{"reqId":"xZAOBOq4bqZ5DuLTCcyC","level":0,"time":"05.06.2024 17:56:25","remoteAddr":"192.168.100.11","user":"Tealk","app":"calendar-appointments","method":"GET","url":"/apps/calendar/appointment/7/slots?startTime=1717624800&timeZone=Europe%2FBerlin","message":"Slots before daily limit filtering:0","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:126.0) Gecko/20100101 Firefox/126.0","version":"29.0.1.1","data":{"app":"calendar-appointments"}}
{"reqId":"xZAOBOq4bqZ5DuLTCcyC","level":0,"time":"05.06.2024 17:56:25","remoteAddr":"192.168.100.11","user":"Tealk","app":"calendar-appointments","method":"GET","url":"/apps/calendar/appointment/7/slots?startTime=1717624800&timeZone=Europe%2FBerlin","message":"Slots before event conflict filtering:0","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:126.0) Gecko/20100101 Firefox/126.0","version":"29.0.1.1","data":{"app":"calendar-appointments"}}
{"reqId":"xZAOBOq4bqZ5DuLTCcyC","level":0,"time":"05.06.2024 17:56:25","remoteAddr":"192.168.100.11","user":"Tealk","app":"calendar-appointments","method":"GET","url":"/apps/calendar/appointment/7/slots?startTime=1717624800&timeZone=Europe%2FBerlin","message":"Appointment config QRN8KA49fYkq has 0 intervals that result in 0 possible slots. 0 slots remain after the daily limit. 0 available slots remain after conflict checking.","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:126.0) Gecko/20100101 Firefox/126.0","version":"29.0.1.1","data":{"app":"calendar-appointments"}}

Tealk avatar Jun 05 '24 15:06 Tealk

Can you remove your conflict calendars and try again to see if that changes anything?

miaulalala avatar Jun 06 '24 08:06 miaulalala

Would you be willing to patch your instance? You can apply the patch from this branch:

https://github.com/nextcloud/calendar/pull/6051 as as diff from here: https://patch-diff.githubusercontent.com/raw/nextcloud/calendar/pull/6051.diff

https://docs.nextcloud.com/server/latest/admin_manual/issues/applying_patch.html#patching-apps gives you instructions on how to apply a patch to your Nextcloud.

miaulalala avatar Jun 06 '24 08:06 miaulalala

the patch alone has not brought any change

even without a conflict calendar, the selection remains empty grafik

Would you be willing to patch your instance? You can apply the patch from this branch:

sure đź‘Ť

log after patch:

{"reqId":"IbG89i5I1zltkjUwsQIS","level":0,"time":"06.06.2024 12:43:11","remoteAddr":"192.168.100.11","user":"Tealk","app":"calendar-appointments","method":"GET","url":"/apps/calendar/appointment/7/slots?startTime=1717670592&timeZone=Europe%2FBerlin","message":"Maximum end time: 1722854591","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:126.0) Gecko/20100101 Firefox/126.0","version":"29.0.1.1","data":{"app":"calendar-appointments"}}
{"reqId":"IbG89i5I1zltkjUwsQIS","level":0,"time":"06.06.2024 12:43:11","remoteAddr":"192.168.100.11","user":"Tealk","app":"calendar-appointments","method":"GET","url":"/apps/calendar/appointment/7/slots?startTime=1717670592&timeZone=Europe%2FBerlin","message":"Earliest start: 1717670700, latest end: 1717711199","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:126.0) Gecko/20100101 Firefox/126.0","version":"29.0.1.1","data":{"app":"calendar-appointments"}}
{"reqId":"IbG89i5I1zltkjUwsQIS","level":0,"time":"06.06.2024 12:43:11","remoteAddr":"192.168.100.11","user":"Tealk","app":"calendar-appointments","method":"GET","url":"/apps/calendar/appointment/7/slots?startTime=1717670592&timeZone=Europe%2FBerlin","message":"Found 4 applicable slot(s) after date filtering","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:126.0) Gecko/20100101 Firefox/126.0","version":"29.0.1.1","data":{"app":"calendar-appointments"}}
{"reqId":"IbG89i5I1zltkjUwsQIS","level":0,"time":"06.06.2024 12:43:11","remoteAddr":"192.168.100.11","user":"Tealk","app":"calendar-appointments","method":"GET","url":"/apps/calendar/appointment/7/slots?startTime=1717670592&timeZone=Europe%2FBerlin","message":"Slot start: 1717513200, slot end: 1717452000","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:126.0) Gecko/20100101 Firefox/126.0","version":"29.0.1.1","data":{"app":"calendar-appointments"}}
{"reqId":"IbG89i5I1zltkjUwsQIS","level":0,"time":"06.06.2024 12:43:11","remoteAddr":"192.168.100.11","user":"Tealk","app":"calendar-appointments","method":"GET","url":"/apps/calendar/appointment/7/slots?startTime=1717670592&timeZone=Europe%2FBerlin","message":"Slot start: 1717599600, slot end: 1717538400","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:126.0) Gecko/20100101 Firefox/126.0","version":"29.0.1.1","data":{"app":"calendar-appointments"}}
{"reqId":"IbG89i5I1zltkjUwsQIS","level":0,"time":"06.06.2024 12:43:11","remoteAddr":"192.168.100.11","user":"Tealk","app":"calendar-appointments","method":"GET","url":"/apps/calendar/appointment/7/slots?startTime=1717670592&timeZone=Europe%2FBerlin","message":"Slot start: 1717686000, slot end: 1717624800","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:126.0) Gecko/20100101 Firefox/126.0","version":"29.0.1.1","data":{"app":"calendar-appointments"}}
{"reqId":"IbG89i5I1zltkjUwsQIS","level":0,"time":"06.06.2024 12:43:11","remoteAddr":"192.168.100.11","user":"Tealk","app":"calendar-appointments","method":"GET","url":"/apps/calendar/appointment/7/slots?startTime=1717670592&timeZone=Europe%2FBerlin","message":"Slot start: 1717768800, slot end: 1717711200","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:126.0) Gecko/20100101 Firefox/126.0","version":"29.0.1.1","data":{"app":"calendar-appointments"}}
{"reqId":"IbG89i5I1zltkjUwsQIS","level":0,"time":"06.06.2024 12:43:11","remoteAddr":"192.168.100.11","user":"Tealk","app":"calendar-appointments","method":"GET","url":"/apps/calendar/appointment/7/slots?startTime=1717670592&timeZone=Europe%2FBerlin","message":"Intervals before extrapolating:0","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:126.0) Gecko/20100101 Firefox/126.0","version":"29.0.1.1","data":{"app":"calendar-appointments"}}
{"reqId":"IbG89i5I1zltkjUwsQIS","level":0,"time":"06.06.2024 12:43:11","remoteAddr":"192.168.100.11","user":"Tealk","app":"calendar-appointments","method":"GET","url":"/apps/calendar/appointment/7/slots?startTime=1717670592&timeZone=Europe%2FBerlin","message":"Slots before daily limit filtering:0","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:126.0) Gecko/20100101 Firefox/126.0","version":"29.0.1.1","data":{"app":"calendar-appointments"}}
{"reqId":"IbG89i5I1zltkjUwsQIS","level":0,"time":"06.06.2024 12:43:11","remoteAddr":"192.168.100.11","user":"Tealk","app":"calendar-appointments","method":"GET","url":"/apps/calendar/appointment/7/slots?startTime=1717670592&timeZone=Europe%2FBerlin","message":"Slots before event conflict filtering:0","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:126.0) Gecko/20100101 Firefox/126.0","version":"29.0.1.1","data":{"app":"calendar-appointments"}}
{"reqId":"IbG89i5I1zltkjUwsQIS","level":0,"time":"06.06.2024 12:43:11","remoteAddr":"192.168.100.11","user":"Tealk","app":"calendar-appointments","method":"GET","url":"/apps/calendar/appointment/7/slots?startTime=1717670592&timeZone=Europe%2FBerlin","message":"Appointment config QRN8KA49fYkq has 0 intervals that result in 0 possible slots. 0 slots remain after the daily limit. 0 available slots remain after conflict checking.","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:126.0) Gecko/20100101 Firefox/126.0","version":"29.0.1.1","data":{"app":"calendar-appointments"}}

Tealk avatar Jun 06 '24 10:06 Tealk

The same issue on my server, few minutes ago updated to 29.0.4 and still no avaiable slots.

howtobeadmin avatar Jul 23 '24 13:07 howtobeadmin

Actually this works fine, the trick is: FIRST SELECT DATE and then you can pickup slots: image

howtobeadmin avatar Jul 23 '24 20:07 howtobeadmin

Not for me image

Tealk avatar Jul 23 '24 22:07 Tealk