bug with availability update/read

  • yurro

    (@yurro)


    4 months, 4 weeks ago

    PHP 8.4.11 (LSPHP), Quill 1.21 + Pro

    When updating group meeting I got SQL error: Unknown column ‘Array’ in ‘SELECT’ (SQL: update prefix_quillbooking_availability set value’ = Array, prefix_quillbooking_availability. updated_at = 2025-09-24 16:43:43′ where “id’ =1)

    Also, in server logs this one repeats multiple times: [24-Sep-2025 15:01:09 UTC] PHP Warning: Undefined array key “users_availability” in /home/mywebsite.com/wp-content/plugins/quillbooking/includes/models/class-event-model.php on line 2256

    Also,

    /home/mywebsite.com/

    24-Sep-2025 15:01:10 UTC] Account ID: 104040464XXXXXXXX
    [24-Sep-2025 15:01:10 UTC] Cache time is before: 15
    [24-Sep-2025 15:01:10 UTC] Cache time is after: 900
    [24-Sep-2025 15:01:10 UTC] Current time: 1758726070, Cached time: , Cache valid: no, Cache time: 900
    [24-Sep-2025 15:01:10 UTC] Cache UPDATED for key slots_1758729600_1763935199 at time 1758726070
    [24-Sep-2025 15:01:10 UTC] PHP Fatal error: Uncaught TypeError: Cannot access offset of type string on string in /home/mywebsite.com/wp-content/plugins/QuillBooking-pro/includes/integration/class-accounts.php:90
    Stack trace: 0 /home/mywebsite.com/wp-content/plugins/QuillBooking-pro/includes/integrations/google/class-integration.php(775): QuillBooking_Pro\Integration\Accounts->get_cache_data(‘104040464745558853023’, ‘slots_1758729600_1763935199’, Object(Closure), 900) 1 /home/mywebsite.com/wp-content/plugins/QuillBooking-pro/includes/integrations/google/class-integration.php(729): QuillBooking_Pro\Integrations\Google\Integration->get_available_slots_for_host(Array, Object(QuillBooking\Models\Calendar_Model), 1758729600.0, 1763935199, ‘Europe/Kiev’, 5, ‘collective’) 2 /home/mywebsite.com/wp-includes/class-wp-hook.php(324): QuillBooking_Pro\Integrations\Google\Integration->get_available_slots(Array, Object(QuillBooking\Models\Event_Model), 1758729600.0, 1763935199, ‘Europe/Kiev’) 3 /home/mywebsite.com/wp-includes/plugin.php(205): WP_Hook->apply_filters(Array, Array) 4 /home/mywebsite.com/wp-content/plugins/quillbooking/includes/models/class-event-model.php(1072): apply_filters(‘quillbooking_get_available_slots’, Array, Object(QuillBooking\Models\Event_Model), 1758729600.0, 1763935199, ‘Europe/Kiev’) 5 /home/mywebsite.com/wp-content/plugins/quillbooking/includes/booking/class-booking-ajax.php(201): QuillBooking\Models\Event_Model->get_available_slots(1758729600.0, ‘Europe/Kiev’, 60, NULL) 6 /home/mywebsite.com/wp-includes/class-wp-hook.php(324): QuillBooking\Booking\Booking_Ajax->booking_details(”) 7 /home/mywebsite.com/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters(”, Array) 8 /home/mywebsite.com/wp-includes/plugin.php(517): WP_Hook->do_action(Array) 9 /home/mywebsite.com/wp-admin/admin-ajax.php(207): do_action(‘wp_ajax_nopriv_quillbooking_booking_slots’) 10 {main}

    thrown in /home/mywebsite.com/wp-content/plugins/QuillBooking-pro/includes/integration/class-accounts.php on line 90
    [24-Sep-2025 15:01:10 UTC] Cache UPDATED for key slots_1758729600_1763935199 at time 1758726070
    [24-Sep-2025 15:01:10 UTC] PHP Fatal error: Uncaught TypeError: Cannot access offset of type string on string in /home/mywebsite.com/wp-content/plugins/QuillBooking-pro/includes/integration/class-accounts.php:90
    Stack trace: 0 /home/mywebsite.com/wp-content/plugins/QuillBooking-pro/includes/integrations/google/class-integration.php(775): QuillBooking_Pro\Integration\Accounts->get_cache_data(‘104040464745558853023’, ‘slots_1758729600_1763935199’, Object(Closure), 900) 1 /home/mywebsite.com/wp-content/plugins/QuillBooking-pro/includes/integrations/google/class-integration.php(729): QuillBooking_Pro\Integrations\Google\Integration->get_available_slots_for_host(Array, Object(QuillBooking\Models\Calendar_Model), 1758729600.0, 1763935199, ‘Europe/Kiev’, 5, ‘collective’) 2 /home/mywebsite.com/wp-includes/class-wp-hook.php(324): QuillBooking_Pro\Integrations\Google\Integration->get_available_slots(Array, Object(QuillBooking\Models\Event_Model), 1758729600.0, 1763935199, ‘Europe/Kiev’) 3 /home/mywebsite.com/wp-includes/plugin.php(205): WP_Hook->apply_filters(Array, Array) 4 /home/mywebsite.com/wp-content/plugins/quillbooking/includes/models/class-event-model.php(1072): apply_filters(‘quillbooking_get_available_slots’, Array, Object(QuillBooking\Models\Event_Model), 1758729600.0, 1763935199, ‘Europe/Kiev’) 5 /home/mywebsite.com/wp-content/plugins/quillbooking/includes/booking/class-booking-ajax.php(201): QuillBooking\Models\Event_Model->get_available_slots(1758729600.0, ‘Europe/Kiev’, 60, NULL) 6 /home/mywebsite.com/wp-includes/class-wp-hook.php(324): QuillBooking\Booking\Booking_Ajax->booking_details(”) 7 /home/mywebsite.com/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters(”, Array) 8 /home/mywebsite.com/wp-includes/plugin.php(517): WP_Hook->do_action(Array) 9 /home/mywebsite.com/wp-admin/admin-ajax.php(207): do_action(‘wp_ajax_nopriv_quillbooking_booking_slots’) 10 {main}

    thrown in /home/mywebsite.com/wp-content/plugins/QuillBooking-pro/includes/integration/class-accounts.php on line 90

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Mohamed Magdy

    (@mdmag)

    4 months, 4 weeks ago

    Hello @yurro ,

    Thanks for reaching out!
    Regarding the group event issue, can you please confirm that this issue also happens with any new group event or does it only happen with existing ones?

    Regarding the other issue, can you please go to integrations tab and click on ‘Google’ and just please click on the save button to update cache time then please check if the error has been fixed now.

    Looking forward to your feedback.

    Best,
    Mohamed

    Thread Starter yurro

    (@yurro)

    4 months, 4 weeks ago

    Hi Mohamed,

    When going to Integrations, I’ve tried to save settings, changing Google sync/caching time from 15 min to 10 min. It worked only after several attempts, meanwhile I’ve got the following warning in error log: (it might be related to previous events but seems like it’s losing some key information along the way, like user IDs or something else)

    [25-Sep-2025 11:49:33 UTC] PHP Warning: Attempt to read property “user_id” on null in /home/website.com/wp-content/plugins/quillbooking/includes/models/class-event-model.php on line 600
    [25-Sep-2025 11:49:33 UTC] PHP Warning: Attempt to read property “user_id” on null in /home/website.com/wp-content/plugins/quillbooking/includes/models/class-event-model.php on line 600
    [25-Sep-2025 11:49:33 UTC] PHP Warning: Attempt to read property “user_id” on null in /home/website.com/wp-content/plugins/quillbooking/includes/models/class-event-model.php on line 600
    [25-Sep-2025 11:49:33 UTC] PHP Warning: Attempt to read property “user_id” on null in /home/website.com/wp-content/plugins/quillbooking/includes/models/class-event-model.php on line 600
    ………

    Then, in the exising Collective event with 3 hosts, when changing the host to take availability from:
    Unknown column ‘Array’ in ‘SELECT’ (SQL: update prefix_quillbooking_availability set value = Array, prefix_quillbooking_availability.updated_at = ‘2025-09-25 11:53:54’ where id = ‘2’)

    Then, I tried to create another Collective event with the same group of 3 hosts, and got the message: Upgrade to Pro to access Google Meet integration.
    Even though the pluing Displays proper license in Settings

    Every single issue is reproduceable, and I can give full log and/or record screen actions…

    Plugin Author Mohamed Magdy

    (@mdmag)

    4 months, 4 weeks ago

    Hello @yurro ,

    Thanks for your detailed response.
    That’s really weird.
    Can you please make sure you have the latest version of Quill Booking Pro version and that it is active from your admin dashboard -> plugins page?
    It would be super helpful if you can send us a record for the issue you are having with a confirmation that the pro plugin is active from plugins page.

    Best,
    Mohamed

    Thread Starter yurro

    (@yurro)

    4 months, 4 weeks ago

    Screenshots from plugins page with versions and plugin licensing page:

    https://drive.google.com/file/d/1ExOutEB2h1aOOMtofP3LXleQz8wM_sBm/view?usp=sharing

    https://drive.google.com/file/d/1oq9JpFetcWZW7xsPX5YumXXRcaw58cwN/view?usp=drive_link

    By the record you mean screen cast? Sure. Do you mind if I share it in a private channel (Slack or something else)

    What else could be of a help ? error log ? phpinfo? Is there a debug mode which I could enable ?

    Thanks

    Plugin Author Mohamed Magdy

    (@mdmag)

    4 months, 3 weeks ago

    Hello Yuro,

    Thanks for sending the screenshots. We have tried to contact you yesterday from our email address: [email protected] but no response received. Please feel free to login to quillbooking.com and open a support ticket with the screen video recording. It would be super helpful for our team to identify the issue.

    Best,
    Mohamed

Viewing 5 replies - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.