Warning (512): SQL Error: 1054: Unknown column 'BookingEventDetail.other_instructions' in 'field list' [CORE/cake/libs/model/datasources/dbo_source.php, line 684]
Query: SELECT `BookingEvent`.`id`, `BookingEvent`.`programme_id`, `BookingEvent`.`version`, `BookingEvent`.`creator_id`, `BookingEvent`.`venue_id`, `BookingEvent`.`parent_booking_event_id`, `BookingEvent`.`parent_activity_id`, `BookingEvent`.`begins`, `BookingEvent`.`ends`, `BookingEvent`.`type`, `BookingEvent`.`booking_package_category_id`, `BookingEvent`.`activity_category_id`, `BookingEvent`.`created`, `BookingEvent`.`modified`, `BookingEvent`.`name`, `BookingEvent`.`alt_search_terms`, `BookingEvent`.`active`, `BookingEvent`.`is_published`, `BookingEvent`.`enrolment_enabled`, `BookingEvent`.`deleted`, `BookingEvent`.`days`, `BookingEvent`.`accept_bookings_for`, `BookingEvent`.`close_of_bookings`, `BookingEvent`.`bookings_close_date`, `BookingEvent`.`bookings_close_mins`, `BookingEvent`.`max_persons_per_session`, `BookingEvent`.`add_to_waiting_if_maxed_out`, `BookingEvent`.`is_fixed_due_date`, `BookingEvent`.`email_enrolment_only`, `BookingEvent`.`has_subsidies`, `BookingEvent`.`enable_subsidy_process`, `BookingEvent`.`enable_ncs_invocing_caps`, `BookingEvent`.`enable_invocing_caps`, `BookingEvent`.`has_subsidy_deposit`, `BookingEvent`.`subsidy_deposit_perc`, `BookingEvent`.`subsidy_accounting_app_account_id`, `BookingEvent`.`has_deposit_requests`, `BookingEvent`.`has_multi_day_pricing`, `BookingEvent`.`allow_pro_rata_rate`, `BookingEvent`.`invoice_type`, `BookingEvent`.`invoice_due_in_days`, `BookingEvent`.`invoice_due_date`, `BookingEvent`.`invoice_in_advance`, `BookingEvent`.`invoice_items_group_by`, `BookingEvent`.`invoice_interval`, `BookingEvent`.`invoice_after_team_confirmation`, `BookingEvent`.`is_subscription`, `BookingEvent`.`is_incursion_activity`, `BookingEvent`.`invoice_in_advance_with_interval`, `BookingEvent`.`deposit_request_mode`, `BookingEvent`.`deposit_request_interval`, `BookingEvent`.`deposit_request_retention_date`, `BookingEvent`.`restricted_period`, `BookingEvent`.`restrictions_begin`, `BookingEvent`.`recurring_restrictions`, `BookingEvent`.`recurring_restrictions_for_casual`, `BookingEvent`.`subsidy_restrictions`, `BookingEvent`.`booking_reduction_restriction_rule`, `BookingEvent`.`booking_reduction_restriction_threshold`, `BookingEvent`.`schoolterm_id`, `BookingEvent`.`include_holidays`, `BookingEvent`.`is_enrol_form_required`, `BookingEvent`.`bookings_require_confirmation`, `BookingEvent`.`is_tournament`, `BookingEvent`.`tournament_allows_free_agents`, `BookingEvent`.`use_team_sorter`, `BookingEvent`.`is_clonable_by_other_orgs`, `BookingEvent`.`pay_by_credit_card_only`, `BookingEvent`.`is_recurring_only`, `BookingEvent`.`enabled_booking_calendars`, `BookingEvent`.`disable_recurring_calendar`, `BookingEvent`.`close_recurring_bookings`, `BookingEvent`.`enable_recurring_constraints`, `BookingEvent`.`enable_addon_items`, `BookingEvent`.`has_free_trials`, `BookingEvent`.`trial_session_type`, `BookingEvent`.`enable_free_trial_bookings`, `BookingEvent`.`free_trial_charge_on_continuation`, `BookingEvent`.`free_trial_availability`, `BookingEvent`.`max_free_trials_per_session`, `BookingEvent`.`no_of_free_trial_sessions`, `BookingEvent`.`free_trials_reduce_cap`, `BookingEvent`.`allow_discount_vouchers`, `BookingEvent`.`enable_nsw_vouchers`, `BookingEvent`.`nsw_voucher_type`, `BookingEvent`.`enable_payment_option_cc`, `BookingEvent`.`separate_signins_by_category`, `BookingEvent`.`description`, `BookingEvent`.`promo_pic`, `BookingEvent`.`downloads`, `BookingEvent`.`start_times_description`, `BookingEvent`.`redirect_url`, `BookingEvent`.`redirect_only`, `BookingEvent`.`xero_tracking_option_id`, `BookingEvent`.`roster_is_enabled`, `BookingEvent`.`roster_ratio_default`, `BookingEvent`.`roster_template_id`, `BookingEvent`.`roster_approval_period`, `BookingEvent`.`roster_start_time`, `BookingEvent`.`roster_finish_time`, `BookingEvent`.`flexi_plan_first_installment_amount`, `BookingEvent`.`flexi_plan_second_installment_delay_rule`, `BookingEvent`.`flexi_plan_installment_due_in_days`, `BookingEvent`.`flexi_plan_independant_invoice_due_date`, `BookingEvent`.`message_waiting_on_cap_increase`, `BookingEvent`.`straight_to_waiting_list`, `BookingEvent`.`waiting_list_confirmation_period`, `BookingEvent`.`render_pdf_preview`, `BookingEvent`.`email_confirmation_download`, `BookingEvent`.`message_waiting_on_cancellation`, `BookingEvent`.`activity_tag_id`, `BookingEvent`.`kiosk_mode`, `BookingEvent`.`package_sort_order`, (( CASE WHEN `BookingEvent`.`active` = 0 THEN "ARCHIVED" WHEN `BookingEvent`.`begins` > "2026-05-22" THEN "FUTURE" WHEN `BookingEvent`.`ends` < "2026-05-22" THEN "CONCLUDED" ELSE "CURRENT" END )) AS `BookingEvent__status`, ( CASE WHEN `BookingEvent`.`activity_type` = "freeform" AND `BookingEvent`.`type` = "SHORTFORM" THEN "holiday_programme" WHEN `BookingEvent`.`activity_type` = "freeform" AND `BookingEvent`.`type` = "LONGFORM" THEN "asc_bsc" WHEN `BookingEvent`.`activity_type` = "freeform" AND `BookingEvent`.`type` = "CLINIC" AND `BookingEvent`.`use_team_sorter` = 1 THEN "team" WHEN `BookingEvent`.`activity_type` = "freeform" AND `BookingEvent`.`type` = "CLINIC" THEN "lessons" ELSE `BookingEvent`.`activity_type` END ) AS `BookingEvent__activity_type`, ( IF( ( # has venue? IF(`BookingEvent`.`venue_id` != 0, 1, 0) + # has session packages / add ons? ( CASE # "redirect activities" have no prices or sessions WHEN `BookingEvent`.`activity_type` = "redirect_activity" THEN 1 # "registration" activities must have addon items WHEN `BookingEvent`.`type` = "REGISTRATION" THEN IF((SELECT id FROM booking_addon_items WHERE booking_event_id = `BookingEvent`.`id` AND active = 1 LIMIT 1) IS NOT NULL, 1, 0) # all other activity types must have sessions ELSE IF((SELECT id FROM booking_event_packages WHERE booking_event_id = `BookingEvent`.`id` AND active = 1 LIMIT 1) IS NOT NULL, 1, 0) END ) + # sessions have prices? ( CASE # "redirect activities" have no prices or sessions WHEN `BookingEvent`.`type` = "REGISTRATION" OR `BookingEvent`.`activity_type` = "redirect_activity" THEN 1 # before and after school care need casual and recurring prices WHEN `BookingEvent`.`type` = "LONGFORM" THEN IF((SELECT id FROM booking_event_packages WHERE booking_event_id = `BookingEvent`.`id` AND active = 1 AND (price IS NULL OR casual_price IS NULL) LIMIT 1) IS NOT NULL, 0, 1) ELSE IF((SELECT id FROM booking_event_packages WHERE booking_event_id = `BookingEvent`.`id` AND active = 1 AND price IS NULL LIMIT 1) IS NOT NULL, 0, 1) END ) + # Has calendar dates? # "REGISTRATION" activities do not requrie dates IF(`BookingEvent`.`type` = "REGISTRATION" OR (SELECT id FROM booking_calendars WHERE booking_event_id = `BookingEvent`.`id` AND active_day = 1 LIMIT 1) IS NOT NULL, 1, 0) ) < 4, 0, 1 )) AS `BookingEvent__is_setup_complete`, `EventCreator`.`id`, `EventCreator`.`email`, `EventCreator`.`group_id`, (CONCAT(COALESCE(`EventCreator`.`first_name`,""), " ", CONCAT(COALESCE(`EventCreator`.`last_name`,""), IF(`EventCreator`.`flags` IS NOT NULL, CONCAT(" [", REPLACE(`EventCreator`.`flags`, ",", "] ["), "]"), "")))) AS `EventCreator__full_name`, `ParentBookingEvent`.`id`, `ParentBookingEvent`.`is_tournament`, `ParentBookingEvent`.`name`, `Venue`.`id`, `Venue`.`name`, `Venue`.`latitude`, `Venue`.`longitude`, `Venue`.`timezone`, `Venue`.`parking_directions`, `Venue`.`room_directions`, `Venue`.`uk_ofsted_number`, `BookingEventDetail`.`id`, `BookingEventDetail`.`booking_event_id`, `BookingEventDetail`.`age_min`, `BookingEventDetail`.`age_max`, `BookingEventDetail`.`show_as_year_level`, `BookingEventDetail`.`impose_strict_age_range`, `BookingEventDetail`.`summary`, `BookingEventDetail`.`important_message`, `BookingEventDetail`.`discounts_freetext`, `BookingEventDetail`.`description`, `BookingEventDetail`.`other_instructions`, `BookingEventDetail`.`room_directions`, `BookingEventDetail`.`accessiblity`, `BookingEventDetail`.`coeducational`, `BookingEventDetail`.`venue_hire`, `BookingEventDetail`.`venue_hire_fixed_period`, `BookingEventDetail`.`venue_hire_fixed`, `BookingEventDetail`.`venue_hire_perc` FROM `booking_events` AS `BookingEvent` LEFT JOIN (SELECT * FROM (SELECT bep.* FROM booking_event_packages AS bep WHERE bep.active = 1 ORDER BY bep.start_time ASC) AS sub GROUP BY booking_event_id) AS `FirstPackage` ON (`FirstPackage`.`booking_event_id` = `BookingEvent`.`id`) LEFT JOIN `users` AS `EventCreator` ON (`BookingEvent`.`creator_id` = `EventCreator`.`id`) LEFT JOIN `booking_events` AS `ParentBookingEvent` ON (`BookingEvent`.`parent_booking_event_id` = `ParentBookingEvent`.`id`) LEFT JOIN `venues` AS `Venue` ON (`BookingEvent`.`venue_id` = `Venue`.`id`) LEFT JOIN `booking_event_details` AS `BookingEventDetail` ON (`BookingEventDetail`.`booking_event_id` = `BookingEvent`.`id`) WHERE `BookingEvent`.`active` = '1' AND `BookingEvent`.`is_published` IN (0, 1) AND `BookingEvent`.`deleted` = '' AND ( CASE WHEN `BookingEvent`.`activity_type` = "freeform" AND `BookingEvent`.`type` = "SHORTFORM" THEN "holiday_programme" WHEN `BookingEvent`.`activity_type` = "freeform" AND `BookingEvent`.`type` = "LONGFORM" THEN "asc_bsc" WHEN `BookingEvent`.`activity_type` = "freeform" AND `BookingEvent`.`type` = "CLINIC" AND `BookingEvent`.`use_team_sorter` = 1 THEN "team" WHEN `BookingEvent`.`activity_type` = "freeform" AND `BookingEvent`.`type` = "CLINIC" THEN "lessons" ELSE `BookingEvent`.`activity_type` END ) != 'school_event' AND `BookingEvent`.`ends` >= '2026-05-22' AND `BookingEvent`.`id` = 178 ORDER BY `BookingEvent`.`begins` ASC, `FirstPackage`.`start_time` ASC, `BookingEvent`.`name` ASC LIMIT 1
Warning (2): Cannot modify header information - headers already sent by (output started at /usr/lib/cakephp/cake_1.3.x/cake/basics.php:375) [APP/app_controller.php, line 241]
