Error message when creating New Patient

Management and Administration
1

anonymous wrote on Thursday, February 02, 2012:

Good morning to all of you,
I tried a new fresh installation of Oemer v. 4.1 and although things did work out rather well, but when trying to create a new patient, I get these mysterious Error Message:

ERROR: insert failed: INSERT INTO insurance_data SET type = ‘primary’, provider = ‘’, policy_number = ‘’, group_number = ‘’, plan_name = ‘’, subscriber_lname = ‘’, subscriber_mname = ‘’, subscriber_fname = ‘’, subscriber_relationship = ‘’, subscriber_ss = ‘’, subscriber_DOB = ‘0000-00-00’, subscriber_street = ‘’, subscriber_postal_code = ‘’, subscriber_city = ‘’, subscriber_state = ‘’, subscriber_country = ‘’, subscriber_phone = ‘’, subscriber_employer = ‘’, subscriber_employer_city = ‘’, subscriber_employer_street = ‘’, subscriber_employer_postal_code = ‘’, subscriber_employer_state = ‘’, subscriber_employer_country = ‘’, copay = ‘’, subscriber_sex = ‘’, pid = ‘2’, date = ‘0000-00-00’, accept_assignment = ‘TRUE’, policy_type = ‘’

Subsequently, if I go and search for such a patient, it has already been created! So, I can not really figure out why on earth does the program give me such ennoying messages…
Any ideas please???

Thanks a lot

Constantine

2

bradymiller wrote on Thursday, February 02, 2012:

Hi,
What operating system and OpenEMR package are you using?
-brady

3

kosmous wrote on Saturday, February 25, 2012:

Ubuntu server 10.04, fully updated, using OpenEMR 4.1 (also fully updated). I am still getting the above mentioned problem. Thank you form your assistance. (if you think that the exact version of my PHP and my SQL matters, then of course I could also send these details over to you)

4

yehster wrote on Saturday, February 25, 2012:

My hunch is that your insurance_data table is incomplete/missing a field, which is probably policy_type (the most recent addition to the table).
As part of up your updating did you run the sql_upgrade scripts?

5

kosmous wrote on Tuesday, March 06, 2012:

Yes, we have now run the sql_upgrade script but it still gives me the funny message like it did before:

ERROR: insert failed: INSERT INTO insurance_data SET type = ‘primary’, provider = ‘’, policy_number = ‘’, group_number = ‘’, plan_name = ‘’, subscriber_lname = ‘’, subscriber_mname = ‘’, subscriber_fname = ‘’, subscriber_relationship = ‘’, subscriber_ss = ‘’, subscriber_DOB = ‘0000-00-00’, subscriber_street = ‘’, subscriber_postal_code = ‘’, subscriber_city = ‘’, subscriber_state = ‘’, subscriber_country = ‘’, subscriber_phone = ‘’, subscriber_employer = ‘’, subscriber_employer_city = ‘’, subscriber_employer_street = ‘’, subscriber_employer_postal_code = ‘’, subscriber_employer_state = ‘’, subscriber_employer_country = ‘’, copay = ‘’, subscriber_sex = ‘’, pid = ‘4’, date = ‘0000-00-00’, accept_assignment = ‘’, policy_type = ‘’

Regarding your impression that maybe the insurance_data table is incomplete/missing a field (probably policy_type), does this mean that I should create it manually??? And how can I do it??

In actual fact, when one goes to check afterwards, the new patient has effectively been created. So, I presume that it should not be a serious problem, but it still remains enoying.
Any ideas???

6

anonymous wrote on Tuesday, March 06, 2012:

Be sure to also run sql_patch. That should add the missing database fields.