Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Appointments No slots available #5960

Open
Tealk opened this issue Apr 26, 2024 · 9 comments
Open

Appointments No slots available #5960

Tealk opened this issue Apr 26, 2024 · 9 comments
Labels
bug

Comments

@Tealk
Copy link

Tealk commented Apr 26, 2024

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 Tealk added the bug label Apr 26, 2024
@Tealk
Copy link
Author

Tealk commented Jun 5, 2024

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

@miaulalala
Copy link
Contributor

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
Copy link
Author

Tealk commented Jun 5, 2024

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
Copy link
Contributor

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

@miaulalala
Copy link
Contributor

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

#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
Copy link
Author

Tealk commented Jun 6, 2024 •
edited
Loading

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
Copy link

howtobeadmin commented Jul 23, 2024 •
edited
Loading

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

@howtobeadmin
Copy link

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

@Tealk
Copy link
Author

Tealk commented Jul 23, 2024

Not for me
image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@miaulalala @Tealk @howtobeadmin