kumarxi wrote on Saturday, May 23, 2009:
Hi Brady,
Thanks for your great response.
My problem is :
have installed 3.0.0.1 with PHP 5.2.6.6 and MySQL 5.1 versions.
But, when I am trying to create a new patient, i got this error.
ERROR: insert failed: replace into patient_data set id=’’, title=‘Mr.’, fname=‘Janardhan’, lname=‘Bettedu’, 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=‘12345’, 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-23’, pricelevel=‘standard’, date=NOW()
Error: Incorrect integer value: ‘’ for column ‘id’ at row 1
Can you guess what proble this is? Please let me know if you find the solution.
Your response will be very helpful and valueble.
I am very thankful to you in advance.
Thanks & Regards,
Nagarjuna.