juggernautsei wrote on Wednesday, February 16, 2011:
Hi,
I am getting an error that I can’t seem to run down. I am using version 3.2 on a windows machine.
I was editing the History form and now when I try to save I get the error message below.
ERROR: insert failed: insert into history_data set `id` = ‘’, `last_breast_exam` = ‘’, `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_exam_results` = ‘’, `history_mother` = ‘’, `history_father` = ‘none’, `history_siblings` = ‘’, `history_offspring` = ‘’, `history_spouse` = ‘’, `relatives_cancer` = ‘’, `relatives_tuberculosis` = ‘single’, `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` = ‘807’, `usertext12` = ‘’, `usertext13` = ‘’, `usertext14` = ‘’, `usertext15` = ‘’, `usertext16` = ‘’, `usertext17` = ‘’, `usertext18` = ‘’, `usertext19` = ‘’, `usertext20` = ‘’, `usertext21` = ‘’, `usertext22` = ‘’, `usertext23` = ‘’, `usertext24` = ‘’, `usertext25` = ‘’, `usertext26` = ‘’, `usertext27` = ‘’, `usertext28` = ‘’, `usertext29` = ‘’, `usertext30` = ‘’, `userdate11` = ‘’, `userdate12` = ‘’, `userdate13` = ‘’, `userdate14` = ‘’, `userdate15` = ‘’, `history_problem` = ‘’, `hpi_history` = ‘’, `ros_history` = ‘’, `pfsh_history` = ‘’, `Constitutional` = ‘’, `Skin` = ‘’, `All_Imm` = ‘’, `ENT` = ‘’, `Resp` = ‘’, `CV` = ‘’, `GI` = ‘’, `GU` = ‘’, `Endo` = ‘’, `Musclosk` = ‘’, `Neuro` = ‘’, `Psych` = ‘’, `Hemo` = ‘’, `All_Other` = ‘’, `Name` = ‘’, `Reviewed` = ‘’, `OS_EVAL` = ‘’, `Date` = ‘’, `date` = ‘’+NOW()+’’
Error: Column ‘Date’ specified twice
Where would I go to find the date that it is showing me? I have tried to find the LBF code itself to manually remove it but I cannot seem to find the hard code for the History form. (BTW I am not a real programmer).
Any hints would be great. I know from reading the coded pages that Rod at rod@sunsetsystems.com wrote most of this original code.
Thanks!