New Patient Registration in OpenEMR

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.

sunsetsystems wrote on Friday, May 22, 2009:

You don’t need to post the same inquiry in multiple forums.  Also the Developers forum is not the place for support requests.  Most developers subscribe to all of the OpenEMR forums.

Rod
www.sunsetsystems.com

ideaman911 wrote on Sunday, May 24, 2009:

Just a cursory glance suggests that you have somehow disabled the auto-assign of the ID, or somehow overridden it with a blank.

Joe Holzer    Idea Man
http://www.holzerent.com