drpwayne wrote on Sunday, August 16, 2009:
Hi. I downloaded OpenEMR 3.0.1 and got it going, but when I try to add a new patient, I get a SQL error that the id is invalid. It doesn’t matter whether I autoassign the ID or put in “1”, I get the same error message:
ERROR: insert failed: replace into patient_data set id=’’, title=‘Mr.’, fname=‘Peter’, lname=‘WAYNE’, mname=‘K’, sex=‘Male’, DOB=‘2000-08-15’, street=’’, postal_code=’’, city=’’, state=’’, country_code=’’, drivers_license=’’, ss=’’, occupation=’’, phone_home=’’, phone_biz=’’, phone_contact=’’, status=’’, contact_relationship=’’, referrer=’’, referrerID=’’, email=’’, language=’’, ethnoracial=’’, interpretter=’’, migrantseasonal=’’, family_size=’’, monthly_income=’’, homeless=’’, financial_review=’’, pubpid=‘1’, pid = 1, providerID = ‘’, genericname1 = ‘’, genericval1 = ‘’, genericname2 = ‘’, genericval2 = ‘’, phone_cell = ‘’, pharmacy_id = ‘0’, hipaa_mail = ‘’, hipaa_voice = ‘’, hipaa_notice = ‘’, hipaa_message = ‘’, squad = ‘0’, fitness=’’, referral_source=’’, regdate=‘2009-08-15’, pricelevel=‘standard’, date=NOW()
Error: Incorrect integer value: ‘’ for column ‘id’ at row 1
Thanks for any guidance.