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')