i am not able to edit patient history.
i added some custom fields, and when i add data to edit and click save, i get the following error:
Query Error
ERROR: insert failed: insert into history_data set date
= NOW(), id
= ?, coffee
= ?, tobacco
= ?, alcohol
= ?, sleep_patterns
= ?, exercise_patterns
= ?, seatbelt_use
= ?, counseling
= ?, hazardous_activities
= ?, recreational_drugs
= ?, last_breast_exam
= ?, last_mammogram
= ?, last_gynocological_exam
= ?, last_rectal_exam
= ?, last_prostate_exam
= ?, last_physical_exam
= ?, last_sigmoidoscopy_colonoscopy
= ?, last_ecg
= ?, last_cardiac_echo
= ?, last_retinal
= ?, last_fluvax
= ?, last_pneuvax
= ?, last_ldl
= ?, last_hemoglobin
= ?, last_psa
= ?, last_exam_results
= ?, history_mother
= ?, dc_mother
= ?, history_father
= ?, dc_father
= ?, history_siblings
= ?, dc_siblings
= ?, history_offspring
= ?, dc_offspring
= ?, history_spouse
= ?, dc_spouse
= ?, relatives_cancer
= ?, relatives_tuberculosis
= ?, relatives_diabetes
= ?, relatives_high_blood_pressure
= ?, relatives_heart_problems
= ?, relatives_stroke
= ?, relatives_epilepsy
= ?, relatives_mental_illness
= ?, relatives_suicide
= ?, cataract_surgery
= ?, tonsillectomy
= ?, cholecystestomy
= ?, heart_surgery
= ?, hysterectomy
= ?, hernia_repair
= ?, hip_replacement
= ?, knee_replacement
= ?, appendectomy
= ?, pid
= ?, right_breast_skin
= ?, palpation_right_breast
= ?, palpation_left_breast
= ?, Clinical_breast_exam_result
= ?, additional_history
= ?, exams
= ?, usertext11
= ?, usertext12
= ?, usertext13
= ?, usertext14
= ?, usertext15
= ?, usertext16
= ?, usertext17
= ?, usertext18
= ?, usertext19
= ?, usertext20
= ?, usertext21
= ?, usertext22
= ?, usertext23
= ?, usertext24
= ?, usertext25
= ?, usertext26
= ?, usertext27
= ?, usertext28
= ?, usertext29
= ?, usertext30
= ?, userdate11
= ?, userdate12
= ?, userdate13
= ?, userdate14
= ?, userdate15
= ?, userarea11
= ?, userarea12
= ?, Date_of_last_menses
= ?, vaginal_bleeding
= ?, last_child_birth
= ?, pregnancies
= ?, Age_at_first_sexual_contact
= ?, previous_breast_exam
= ?, Date_of_Breast_E
= ?, Any_previous_CLINICAL_breast_exam
= ?, Date_of_Clinical_Breast_E
= ?, previous_VIA_exam
= ?, Date_of_last_VIA_Exam
= ?, Any_previous_Pap_smear
= ?, Date_of_Last_PAP_Exam
= ?, History_of_HIV_Infection
= ?, Date_of_HIV_Diagnosis
= ?, history_of_cervical_cancer
= ?, positive_family_cervical_cancer
= ?, family_history_of_breast_cancer
= ?, history_of_breast_cancer
= ?, history_of_bloody_breast_discharge
= ?, testttt
= ?, right_breast_finding
= ?, history_of_bloody_breast_discha
= ?, Any_previous_CLINICAL_breast_ex
= ?
Error: Unknown column ‘history_of_bloody_breast_discha’ in ‘field list’
/library/patient.inc at 1470:sqlInsert
/interface/patient_file/history/history_save.php at 60:updateHistoryData(4,Array)
OpenEMR Version
I’m using OpenEMR version 5.0.2(1)
Browser:
I’m using: google chrome
Operating System
I’m using: windows 10
please i need help
Thank you