Situation
I’m setting up openEMR for a client. The client says she does not want to have all the data fields in the demographic Layout Based Form where a new client is created. I deleted the fields she did not want using “edit the layout” but then when I did this the error below appeared when I tried to add a new patient.
Query Error
ERROR: query failed: select pid, id, lname, fname, mname, providerID, DATE_FORMAT(DOB,’%m/%d/%Y’) as DOB_TS from patient_data where pid = ‘1’ order by lname ASC, fname ASC
Error: Unknown column ‘providerID’ in ‘field list’
C:\xampp\htdocs\openemr\library\patient.inc at 810:sqlStatement
C:\xampp\htdocs\openemr\library\patient.inc at 825:getPatientPID(Array)
C:\xampp\htdocs\openemr\interface\patient_file\summary\demographics.php at 652:getPatientName(1)
Or is there a way I can hide the fields I do not require instead of deleting them.
Kindly help.
Regards
OpenEMR Version
I’m using OpenEMR version 5.0.1
Browser:
I’m using google chrome
Operating System
I’m using windows 10