anonymous wrote on Sunday, February 19, 2012:
Hello!
I’ve just installed the OpenEMR on Hostgator VPS.
However, i have not been able to add new patient or facilities. The error message is like this:
ERROR: insert failed: INSERT INTO patient_data SET pid = ‘1’, date = NOW(), `title` = ‘’, `fname` = ‘Steve’, `mname` = ‘’, `lname` = ‘Jobs’, `pubpid` = ‘1’, `DOB` = ‘1950-01-01’, `sex` = ‘Male’, `ss` = ‘’, `drivers_license` = ‘’, `status` = ‘’, `genericname1` = ‘’, `genericval1` = ‘’, `genericname2` = ‘’, `genericval2` = ‘’, `street` = ‘’, `city` = ‘’, `state` = ‘’, `postal_code` = ‘’, `country_code` = ‘’, `mothersname` = ‘’, `guardiansname` = ‘’, `contact_relationship` = ‘’, `phone_contact` = ‘’, `phone_home` = ‘’, `phone_biz` = ‘’, `phone_cell` = ‘’, `email` = ‘’, `providerID` = ‘’, `pharmacy_id` = ‘0’, `hipaa_notice` = ‘’, `hipaa_voice` = ‘’, `hipaa_message` = ‘’, `hipaa_mail` = ‘’, `hipaa_allowsms` = ‘’, `hipaa_allowemail` = ‘’, `allow_imm_reg_use` = ‘’, `allow_imm_info_share` = ‘’, `allow_health_info_ex` = ‘’, `allow_patient_portal` = ‘’, `occupation` = ‘’, `language` = ‘’, `ethnicity` = ‘’, `race` = ‘’, `financial_review` = ‘’, `family_size` = ‘’, `monthly_income` = ‘’, `homeless` = ‘’, `interpretter` = ‘’, `migrantseasonal` = ‘’, `referral_source` = ‘’, `vfc` = ‘’, `deceased_date` = ‘’, `deceased_reason` = ’
Could someone enlighten me with this Add Patient / Facilities problem?
Thanks a lot.