Situation
The following error is showing when accessing OpenEMR and they didn’t show before.
ERROR: query failed: SELECT e.pc_eventDate, e.pc_endDate, e.pc_startTime, e.pc_endTime, e.pc_duration, e.pc_recurrtype, e.pc_recurrspec, e.pc_recurrfreq, e.pc_catid, e.pc_eid, e.pc_title, e.pc_hometext, e.pc_apptstatus, p.fname, p.mname, p.lname, p.pid, p.pubpid, p.phone_home, p.phone_cell, u.fname AS ufname, u.mname AS umname, u.lname AS ulname, u.id AS uprovider_id, f.name, e.pc_room, e.pc_pid, t.id, t.date, t.apptdate, t.appttime, t.eid, t.pid, t.original_user, t.encounter, t.lastseq, t.random_drug_test, t.drug_screen_completed, q.pt_tracker_id, q.start_datetime, q.room, q.status, q.seq, q.user, s.toggle_setting_1, s.toggle_setting_2, s.option_id, c.pc_catname, c.pc_catid FROM openemr_postcalendar_events AS e LEFT OUTER JOIN patient_tracker AS t ON t.pid = e.pc_pid AND t.apptdate = e.pc_eventDate AND t.appttime = e.pc_starttime AND t.eid = e.pc_eid LEFT OUTER JOIN patient_tracker_element AS q ON q.pt_tracker_id = t.id AND q.seq = t.lastseq LEFT OUTER JOIN list_options AS s ON s.list_id = 'apptstat' AND s.option_id = q.status AND s.activity = 1 LEFT OUTER JOIN facility AS f ON e.pc_facility = f.id LEFT OUTER JOIN patient_data AS p ON p.pid = e.pc_pid LEFT OUTER JOIN users AS u ON u.id = e.pc_aid LEFT OUTER JOIN openemr_postcalendar_categories AS c ON c.pc_catid = e.pc_catid WHERE ((e.pc_endDate >= ? AND e.pc_eventDate <= ? AND e.pc_recurrtype > '0') OR (e.pc_eventDate >= ? AND e.pc_eventDate <= ?)) AND e.pc_aid = ? AND e.pc_pid != '' ORDER BY e.pc_eventDate, e.pc_startTime
Error: Unknown column 'p.phone_cell' in 'field list'
/var/app/current/openemr/library/appointments.inc.php at 159:sqlStatement
/var/app/current/openemr/library/appointments.inc.php at 376:fetchEvents(2018-05-22,2018-05-22, AND e.pc_aid = ? AND e.pc_pid != '',,1,0,Array)
/var/app/current/openemr/library/patient_tracker.inc.php at 153:fetchAppointments(2018-05-22,2018-05-22,,4,,,,,,1)
/var/app/current/openemr/interface/patient_tracker/patient_tracker.php at 73:fetch_Patient_Tracker_Events(2018-05-22,2018-05-22,4,,,)
OpenEMR Version
I’m using OpenEMR version Version Number: v5.0.0 (5)
Browser:
I’m using: Chrome
Operating System
I’m using: Windows 10
Logs
Did you check the logs? Was there anything pertinent in them? Paste them here (surround with three backticks (```) for readability
