Uncaught isisException: isisDB: query failed, MySQL server has gone away
#0 /app/isislib/class.db.inc (192): isisDB->mysqli_query('SELECT e.id AS recurring_id, d.id,e.title, e.sub_title, e.registration_close, e.short_description, e.description AS long_description, d.new_event_id, d.start_time AS raw_start_time, d.end_time AS raw_end_time, d.changed_start_time AS changed_raw_start_time, d.changed_end_time AS changed_raw_end_time, LOWER(CONCAT(DATE_FORMAT(d.start_time, '%l:%i%p'),' - ', DATE_FORMAT(d.end_time, '%l:%i%p'))) AS time_string, LOWER(CONCAT(DATE_FORMAT(d.changed_start_time, '%l:%i%p'),' - ', DATE_FORMAT(d.changed_end_time, '%l:%i%p'))) AS changed_time_string, DATE_FORMAT(d.changed_start_time, '%W, %M %d') AS changed_datestring, LOWER(DATE_FORMAT(d.changed_start_time, '%l:%i%p')) AS changed_start_time, LOWER(DATE_FORMAT(d.changed_end_time, '%l:%i%p')) AS changed_end_time, LOWER(DATE_FORMAT(d.start_time, '%l:%i%p')) AS start_time, LOWER(DATE_FORMAT(d.end_time, '%l:%i%p')) AS end_time, UNIX_TIMESTAMP(d.start_time) AS ts, DATE_FORMAT(d.start_time, '%W, %M %d') AS datestring, d.start_time as event_start, d.end_time as event_end, e.location_id, e.event_image as image, GROUP_CONCAT(rm.title SEPARATOR ', ') AS room, d.venue_type, d.venue_name, d.venue_description, d.venue_room, CONCAT(u.first_name, ' ', u.last_name) AS event_contact, FROM_UNIXTIME(UNIX_TIMESTAMP(d.start_time)-(e.registration_close*60)) AS close_registration, e.staff_only_registration, e.allow_reg, e.max_attendee, e.allow_waitlist, e.force_series_registration, e.whole_serires_only, e.private_event, e.third_party_reg, e.reg_url, e.global_featured, e.branch_featured, e.max_waitlist, e.enable_billing, e.enable_multiple_types, COALESCE(e.open_registration_imidiatly, 1) open_registration_imidiatly, DATE_FORMAT(COALESCE(e.reg_opens, e.publish_date), '%Y-%m-%d %H:%i:%s') reg_opens, IF(e.reg_opens_relative_hours IS NOT NULL, 0, COALESCE(e.open_registration_imidiatly, 1) ) AS open_registration_imidiatly, IF(e.reg_opens_relative_hours IS NOT NULL, IF(e.force_series_registration, DATE_SUB((SELECT nd.start_time FROM events2_dates nd WHERE nd.event_id = e.id AND nd.client_id = e.client_id ORDER BY nd.start_time ASC LIMIT 1), INTERVAL e.reg_opens_relative_hours HOUR), DATE_SUB(d.start_time, INTERVAL e.reg_opens_relative_hours HOUR) ), COALESCE(e.reg_opens, e.publish_date) ) AS reg_opens, DATE_FORMAT( IF(e.reg_opens_relative_hours IS NOT NULL, IF(e.force_series_registration, DATE_SUB((SELECT nd.start_time FROM events2_dates nd WHERE nd.event_id = e.id AND nd.client_id = e.client_id ORDER BY nd.start_time ASC LIMIT 1), INTERVAL e.reg_opens_relative_hours HOUR), DATE_SUB(d.start_time, INTERVAL e.reg_opens_relative_hours HOUR) ), COALESCE(e.reg_opens, e.publish_date) ), '%W, %M %d %Y at %l:%i%p') AS reg_opens_string, e.event_image, e.event_image_alt_text, d.changed, d.changed_reason, COALESCE((SELECT SUM((SELECT COUNT(*) FROM events2_registrations WHERE master_id=r.id)+1) FROM events2_registrations r WHERE r.event_id=d.id AND r.regtype=1 AND r.master_id IS NULL), 0) AS total_registrants, COALESCE((SELECT SUM((SELECT COUNT(*) FROM events2_registrations WHERE master_id=r.id)+1) FROM events2_registrations r WHERE r.event_id=d.id AND r.regtype=2 AND r.master_id IS NULL), 0) AS total_waitlist, IFNULL(e.max_attendee_in_branch, 0) - COALESCE((SELECT SUM((SELECT COUNT(*) FROM events2_registrations WHERE master_id = r.id)+1) FROM events2_registrations r WHERE r.event_id=d.id AND r.attendance_type='INPERSON' AND r.master_id IS NULL AND r.regtype IN(1,2)), 0) AS inperson_event_seats_left, IFNULL(e.max_attendee_virtual, 0) - COALESCE((SELECT SUM((SELECT COUNT(*) FROM events2_registrations WHERE master_id = r.id)+1) FROM events2_registrations r WHERE r.event_id=d.id AND r.attendance_type='ONLINE' AND r.master_id IS NULL AND r.regtype IN(1,2)), 0) AS virtual_event_seats_left, (SELECT start_time FROM events2_dates WHERE e.id=event_id AND new_event_id IS NULL ORDER BY start_time ASC LIMIT 1) AS series_starts, (SELECT GROUP_CONCAT(type ORDER BY type DESC SEPARATOR '|') FROM events2_types WHERE event_id=e.id) as tags, (SELECT GROUP_CONCAT(age ORDER BY age DESC SEPARATOR '|') FROM events2_ages WHERE event_id=e.id) as ages, (SELECT GROUP_CONCAT(tag ORDER BY tag DESC SEPARATOR '|') FROM events2_tags WHERE event_id=e.id) as search_tags, e.in_branch_registration_enabled, e.virtual_registration_enabled, e.max_attendee_in_branch, e.max_attendee_virtual, d.event_type, e.virtual_event_settings, e.status FROM events2_drafts e JOIN events2_dates d ON e.id=d.event_id LEFT JOIN roombooking_bookings rb ON d.id=rb.time_id LEFT JOIN roombooking_rooms rm ON rm.id=rb.room_id LEFT JOIN users u ON u.id=e.contact_id WHERE e.id = 2361972 and d.id '8519940' AND e.client_id='248' AND d.start_time >= '2023-09-27 23:07:12'', false)
#1 /app/data/event.php (189): isisDB->query('SELECT e.id AS recurring_id, d.id,e.title, e.sub_title, e.registration_close, e.short_description, e.description AS long_description, d.new_event_id, d.start_time AS raw_start_time, d.end_time AS raw_end_time, d.changed_start_time AS changed_raw_start_time, d.changed_end_time AS changed_raw_end_time, LOWER(CONCAT(DATE_FORMAT(d.start_time, '%l:%i%p'),' - ', DATE_FORMAT(d.end_time, '%l:%i%p'))) AS time_string, LOWER(CONCAT(DATE_FORMAT(d.changed_start_time, '%l:%i%p'),' - ', DATE_FORMAT(d.changed_end_time, '%l:%i%p'))) AS changed_time_string, DATE_FORMAT(d.changed_start_time, '%W, %M %d') AS changed_datestring, LOWER(DATE_FORMAT(d.changed_start_time, '%l:%i%p')) AS changed_start_time, LOWER(DATE_FORMAT(d.changed_end_time, '%l:%i%p')) AS changed_end_time, LOWER(DATE_FORMAT(d.start_time, '%l:%i%p')) AS start_time, LOWER(DATE_FORMAT(d.end_time, '%l:%i%p')) AS end_time, UNIX_TIMESTAMP(d.start_time) AS ts, DATE_FORMAT(d.start_time, '%W, %M %d') AS datestring, d.start_time as event_start, d.end_time as event_end, e.location_id, e.event_image as image, GROUP_CONCAT(rm.title SEPARATOR ', ') AS room, d.venue_type, d.venue_name, d.venue_description, d.venue_room, CONCAT(u.first_name, ' ', u.last_name) AS event_contact, FROM_UNIXTIME(UNIX_TIMESTAMP(d.start_time)-(e.registration_close*60)) AS close_registration, e.staff_only_registration, e.allow_reg, e.max_attendee, e.allow_waitlist, e.force_series_registration, e.whole_serires_only, e.private_event, e.third_party_reg, e.reg_url, e.global_featured, e.branch_featured, e.max_waitlist, e.enable_billing, e.enable_multiple_types, COALESCE(e.open_registration_imidiatly, 1) open_registration_imidiatly, DATE_FORMAT(COALESCE(e.reg_opens, e.publish_date), '%Y-%m-%d %H:%i:%s') reg_opens, IF(e.reg_opens_relative_hours IS NOT NULL, 0, COALESCE(e.open_registration_imidiatly, 1) ) AS open_registration_imidiatly, IF(e.reg_opens_relative_hours IS NOT NULL, IF(e.force_series_registration, DATE_SUB((SELECT nd.start_time FROM events2_dates nd WHERE nd.event_id = e.id AND nd.client_id = e.client_id ORDER BY nd.start_time ASC LIMIT 1), INTERVAL e.reg_opens_relative_hours HOUR), DATE_SUB(d.start_time, INTERVAL e.reg_opens_relative_hours HOUR) ), COALESCE(e.reg_opens, e.publish_date) ) AS reg_opens, DATE_FORMAT( IF(e.reg_opens_relative_hours IS NOT NULL, IF(e.force_series_registration, DATE_SUB((SELECT nd.start_time FROM events2_dates nd WHERE nd.event_id = e.id AND nd.client_id = e.client_id ORDER BY nd.start_time ASC LIMIT 1), INTERVAL e.reg_opens_relative_hours HOUR), DATE_SUB(d.start_time, INTERVAL e.reg_opens_relative_hours HOUR) ), COALESCE(e.reg_opens, e.publish_date) ), '%W, %M %d %Y at %l:%i%p') AS reg_opens_string, e.event_image, e.event_image_alt_text, d.changed, d.changed_reason, COALESCE((SELECT SUM((SELECT COUNT(*) FROM events2_registrations WHERE master_id=r.id)+1) FROM events2_registrations r WHERE r.event_id=d.id AND r.regtype=1 AND r.master_id IS NULL), 0) AS total_registrants, COALESCE((SELECT SUM((SELECT COUNT(*) FROM events2_registrations WHERE master_id=r.id)+1) FROM events2_registrations r WHERE r.event_id=d.id AND r.regtype=2 AND r.master_id IS NULL), 0) AS total_waitlist, IFNULL(e.max_attendee_in_branch, 0) - COALESCE((SELECT SUM((SELECT COUNT(*) FROM events2_registrations WHERE master_id = r.id)+1) FROM events2_registrations r WHERE r.event_id=d.id AND r.attendance_type='INPERSON' AND r.master_id IS NULL AND r.regtype IN(1,2)), 0) AS inperson_event_seats_left, IFNULL(e.max_attendee_virtual, 0) - COALESCE((SELECT SUM((SELECT COUNT(*) FROM events2_registrations WHERE master_id = r.id)+1) FROM events2_registrations r WHERE r.event_id=d.id AND r.attendance_type='ONLINE' AND r.master_id IS NULL AND r.regtype IN(1,2)), 0) AS virtual_event_seats_left, (SELECT start_time FROM events2_dates WHERE e.id=event_id AND new_event_id IS NULL ORDER BY start_time ASC LIMIT 1) AS series_starts, (SELECT GROUP_CONCAT(type ORDER BY type DESC SEPARATOR '|') FROM events2_types WHERE event_id=e.id) as tags, (SELECT GROUP_CONCAT(age ORDER BY age DESC SEPARATOR '|') FROM events2_ages WHERE event_id=e.id) as ages, (SELECT GROUP_CONCAT(tag ORDER BY tag DESC SEPARATOR '|') FROM events2_tags WHERE event_id=e.id) as search_tags, e.in_branch_registration_enabled, e.virtual_registration_enabled, e.max_attendee_in_branch, e.max_attendee_virtual, d.event_type, e.virtual_event_settings, e.status FROM events2_drafts e JOIN events2_dates d ON e.id=d.event_id LEFT JOIN roombooking_bookings rb ON d.id=rb.time_id LEFT JOIN roombooking_rooms rm ON rm.id=rb.room_id LEFT JOIN users u ON u.id=e.contact_id WHERE e.id = 2361972 and d.id '8519940' AND e.client_id='248' AND d.start_time >= '2023-09-27 23:07:12'')
#2 /app/shared/inc/class.anywherecommon.inc (11): include('/app/data/event.php')
#3 /app/inc/class.anywhereme.inc (725): anywherecommon->includePage('event')
#4 /app/inc/class.anywhereme.inc (337): anywhereme->processPage()
#5 /app/htdocs/index.php (12): anywhereme->__construct('isisDB object: connected to production.cluster-cmjmkqt1tgkh.us-east-2.rds.amazonaws.com as cloud ', 'hpl', 'hamilton')