kumarxi wrote on Friday, May 22, 2009:
Hi All,
Good evening…
I have installed PHP 5.2.6.6 and MySql 5.1 versions to access OpenEMR 3.0.0.1.
When i am trying to create a new patient, i got the following error.
ERROR: insert failed: replace into patient_data set id=’’, title=‘Mr.’, fname=‘Janardhan’, lname=‘Beddtedu’, mname=‘Jana’, sex=‘Male’, DOB=‘1954-07-22’, 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-05-22’, pricelevel=‘standard’, date=NOW()
Error: Incorrect integer value: ‘’ for column ‘id’ at row 1
Any body came across this error, please let me know the solution.
I am very thankful to you in advance.
Thanks & Regards,
Nagarjuna.