Error message when editing appointments

kylew1981 wrote on Tuesday, June 21, 2011:

I get the following error message when i click on an appointment to edit it on the calender:

ERROR: query failed: SELECT lname, fname, phone_home, phone_biz, DOB FROM patient_data WHERE pid = ‘1’

Error: Unknown column ‘phone_home’ in ‘field list’

Any ideas??

bradymiller wrote on Thursday, June 23, 2011:

Hi,
I’m guessing your removed this entry from Administrion->Layouts->DEM, which also removes it from the patient_data mysql table. This is why it’s good to be careful what you remove from the layouts (generally better to make it inactive rather than remove things). Can fix by adding the entry back to Administration->Layouts->DEM
-brady