Not urgent / not even proven to be a bug and not causing us any current issues since it seems to be resolved for now, but just in case anyone else runs into the same issue:
(OpenEMR 7.0.2 Patch 3)
Still not 100% sure what was going on here and it may have been my fault / caused by some other setting, but today we were unable to delete “Current” or “Future” reoccurring calendar events, would throw pop-up errors like:
Input array has 1 params, does not match query: 'UPDATE openemr_postcalendar_events SET pc_enddate = ? WHERE pc_multiple = ?'
Query Error
ERROR: query failed: UPDATE openemr_postcalendar_events SET pc_enddate = ? WHERE pc_multiple = ?
/var/www/localhost/htdocs/openemr/src/Services/AppointmentService.php at 405:sqlStatement
/var/www/localhost/htdocs/openemr/interface/main/calendar/add_edit_event.php at 765:deleteAppointment(518,future,2025-03-10)
When checking OpenEMR logs:
... # cd /var/www/logs && ls -l && ls -lt error.log* | head -n 1 | awk '{print $9}' | xargs cat
...
[Sun Feb 16 22:32:54.028279 2025] [php:warn] [pid 7460] [client 107.77.208.50:47288] PHP Warning: Undefined array key "group" in /var/www/localhost/htdocs/openemr/interface/main/calendar/add_edit_event.php on line 138, referer: https://emr.ontrackpediatrictherapy.com/interface/main/tabs/main.php?token_main=mEbrCczjUSI06RE3zhI0WmK4qKeq55aaZl6ONHZq
[Sun Feb 16 22:32:54.029741 2025] [php:warn] [pid 7460] [client 107.77.208.50:47288] PHP Warning: Undefined array key "group" in /var/www/localhost/htdocs/openemr/interface/main/calendar/add_edit_event.php on line 154, referer: https://emr.ontrackpediatrictherapy.com/interface/main/tabs/main.php?token_main=mEbrCczjUSI06RE3zhI0WmK4qKeq55aaZl6ONHZq
[Sun Feb 16 22:32:54.147277 2025] [php:warn] [pid 7460] [client 107.77.208.50:47288] PHP Warning: Undefined array key "group" in /var/www/localhost/htdocs/openemr/interface/main/calendar/add_edit_event.php on line 956, referer: https://emr.ontrackpediatrictherapy.com/interface/main/tabs/main.php?token_main=mEbrCczjUSI06RE3zhI0WmK4qKeq55aaZl6ONHZq
[Sun Feb 16 22:32:54.215563 2025] [php:warn] [pid 7460] [client 107.77.208.50:47288] PHP Warning: Undefined array key "group" in /var/www/localhost/htdocs/openemr/interface/main/calendar/add_edit_event.php on line 1311, referer: https://emr.ontrackpediatrictherapy.com/interface/main/tabs/main.php?token_main=mEbrCczjUSI06RE3zhI0WmK4qKeq55aaZl6ONHZq
[Sun Feb 16 22:32:54.307358 2025] [php:warn] [pid 7460] [client 107.77.208.50:47288] PHP Warning: Undefined array key "group" in /var/www/localhost/htdocs/openemr/interface/main/calendar/add_edit_event.php on line 1453, referer: https://emr.ontrackpediatrictherapy.com/interface/main/tabs/main.php?token_main=mEbrCczjUSI06RE3zhI0WmK4qKeq55aaZl6ONHZq
[Sun Feb 16 22:32:54.307384 2025] [php:warn] [pid 7460] [client 107.77.208.50:47288] PHP Warning: Undefined array key "group" in /var/www/localhost/htdocs/openemr/interface/main/calendar/add_edit_event.php on line 1479, referer: https://emr.ontrackpediatrictherapy.com/interface/main/tabs/main.php?token_main=mEbrCczjUSI06RE3zhI0WmK4qKeq55aaZl6ONHZq
[Sun Feb 16 22:32:54.372418 2025] [php:warn] [pid 7460] [client 107.77.208.50:47288] PHP Warning: Undefined array key "group" in /var/www/localhost/htdocs/openemr/interface/main/calendar/add_edit_event.php on line 1709, referer: https://emr.ontrackpediatrictherapy.com/interface/main/tabs/main.php?token_main=mEbrCczjUSI06RE3zhI0WmK4qKeq55aaZl6ONHZq
[Sun Feb 16 22:33:01.866306 2025] [php:warn] [pid 7412] [client 107.77.208.50:50765] PHP Warning: Undefined array key "group" in /var/www/localhost/htdocs/openemr/interface/main/calendar/add_edit_event.php on line 138, referer: https://emr.ontrackpediatrictherapy.com/interface/main/calendar/add_edit_event.php?date=20250310&eid=518&prov=
[Sun Feb 16 22:33:01.867263 2025] [php:warn] [pid 7412] [client 107.77.208.50:50765] PHP Warning: Undefined array key "group" in /var/www/localhost/htdocs/openemr/interface/main/calendar/add_edit_event.php on line 154, referer: https://emr.ontrackpediatrictherapy.com/interface/main/calendar/add_edit_event.php?date=20250310&eid=518&prov=
[Sun Feb 16 22:33:01.974703 2025] [php:notice] [pid 7412] [client 107.77.208.50:50765] SQL Error with statement:query failed: UPDATE openemr_postcalendar_events SET pc_enddate = ? WHERE pc_multiple = ?==>/var/www/localhost/htdocs/openemr/src/Services/AppointmentService.php at 405:sqlStatement, referer: https://emr.ontrackpediatrictherapy.com/interface/main/calendar/add_edit_event.php?date=20250310&eid=518&prov=
/var/www/logs #
Unchecking Support Multi-Provider Events fixed it.