search

nextcloud / calendar

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

Appointments No slots available #5960

Open Tealk opened 6 months ago

Tealk commented 6 months ago

Steps to reproduce

1.Click on preview

  1. 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 commented 4 months ago

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

miaulalala commented 4 months ago

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

Tealk commented 4 months ago

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"}}
miaulalala commented 4 months ago

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

miaulalala commented 4 months ago

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.

Tealk commented 4 months ago

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"}}
howtobeadmin commented 3 months ago

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

howtobeadmin commented 3 months ago

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

Tealk commented 3 months ago

Not for me image