Unable to Add Insurance Provider Using Search/Add Button

I unstalled the latest development version, via Github. It was a clean install with a clean/new/blank database. The server is on MacOS. Browser is Firefox.

I don’t know if my issue is due to me or a bug in the latest development version. I’m not sure if this should have been posted in “OpenEMR Development”

I created a patient. And, I clicked to edit demographics. I pressed the “Search/Add” button next to Primary Insurance Provider. A new window opens to enter in the info. When I enter the info and press “Save as New”. The following shows up in the window:

the log shows:
‘2022-03-17 16:54 security-administration-Query Security administrator Default 0 1 Query username, fname, lname FROM users WHERE active = 1 AND ( info IS NULL OR info NOT LIKE ‘%Inactive%’ )
2022-03-17 16:54 security-administration-Query Security administrator Default 0 1 Query username, fname, lname FROM users WHERE active = 1 AND ( info IS NULL OR info NOT LIKE ‘%Inactive%’ )
2022-03-17 16:53 security-administration-insert Security administrator Default 0 0 INSERT INTO addresses SET id=?, line1=?, line2=?, city=?, state=?, zip=?, country=?, foreign_id=? (’’,’’,’’,’’,’’,’’,’’,‘3’,)
2022-03-17 16:53 security-administration-Query Security administrator Default 0 1 Query MAX(id)+1 AS id FROM addresses
2022-03-17 16:53 security-administration-insert Security administrator Default 0 1 INSERT INTO insurance_companies SET id=?, name=?, attn=?, cms_id=?, ins_type_code=?, x12_receiver_id=?, x12_default_partner_id=?, alt_cms_id=? (‘3’,‘ff’,’’,’’,‘1’,’’,’’,’’,)
2022-03-17 16:53 security-administration-Query Security administrator Default 0 1 Query MAX(id)+1 AS id FROM insurance_companies
2022-03-17 16:53 security-administration-Query Security administrator Default 0 1 Query type FROM insurance_type_codes
2022-03-17 16:53 security-administration-Query Security administrator Default 0 1 Query dr.pid, dr.dr_id, dr.dr_message_text,dr.dr_message_due_date,
u.fname ffname, u.mname fmname, u.lname flname FROM dated_reminders dr
JOIN users u ON dr.dr_from_ID = u.id
JOIN dated_reminders_link drl ON dr.dr_id = drl.dr_id
WHERE drl.to_id = ? AND dr.message_processed = 0
AND dr.dr_message_due_date < ADDDATE(NOW(), INTERVAL 30 DAY)
ORDER BY dr_message_due_date ASC , message_priority ASC LIMIT 0,5 (‘1’,)
2022-03-17 16:53 security-administration-Query Security administrator Default 0 1 Query id, name FROM x12_partners ORDER BY name
2022-03-17 16:53 security-administration-Query Security administrator Default 0 1 Query type FROM insurance_type_codes
2022-03-17 16:53 patient-record-Query Patient Demographics administrator Default 1 1 Query pnotes.id, pnotes.user, pnotes.pid, pnotes.title, pnotes.date, pnotes.message_status, pnotes.activity,
IF(pnotes.pid = 0 OR pnotes.user != pnotes.pid,users.fname,patient_data.fname) as users_fname,
IF(pnotes.pid = 0 OR pnotes.user != pnotes.pid,users.lname,patient_data.lname) as users_lname,
patient_data.fname as patient_data_fname, patient_data.lname as patient_data_lname
FROM ((pnotes LEFT JOIN users ON pnotes.user = users.username)
LEFT JOIN patient_data ON pnotes.pid = patient_data.pid) WHERE pnotes.message_status != ‘Done’ AND pnotes.activity = 1 AND
pnotes.deleted != ‘1’ AND pnotes.assigned_to LIKE ? (‘administrator’,)
2022-03-17 16:53 order-Query Medication administrator Default 0 1 Query id FROM prescriptions WHERE patient_id = ? ORDER BY active DESC, date_modified DESC, date_added DESC (‘1’,)
2022-03-17 16:53 security-administration-Query Security administrator Default 0 1 Query fname,lname,federaldrugid, specialty, npi, state_license_number FROM users where id =‘1’
2022-03-17 16:53 security-administration-Query Security administrator Default 0 1 Query state FROM facility
2022-03-17 16:53 patient-record-Query Patient Insurance administrator Default 1 1 Query insd., ic.name as provider_name from insurance_data as insd left join insurance_companies as ic on ic.id = insd.provider where pid = ? and type = ? order by date DESC limit 1 (‘1’,‘tertiary’,)
2022-03-17 16:53 patient-record-Query Patient Insurance administrator Default 1 1 Query insd.
, ic.name as provider_name from insurance_data as insd left join insurance_companies as ic on ic.id = insd.provider where pid = ? and type = ? order by date DESC limit 1 (‘1’,‘secondary’,)
2022-03-17 16:53 patient-record-Query Patient Insurance administrator Default 1 1 Query insd., ic.name as provider_name from insurance_data as insd left join insurance_companies as ic on ic.id = insd.provider where pid = ? and type = ? order by date DESC limit 1 (‘1’,‘primary’,)
2022-03-17 16:53 patient-record-Query Billing administrator Default 1 1 Query FAC.id, FAC.uuid, FAC.name, FAC.phone, FAC.fax, FAC.street, FAC.city, FAC.state, FAC.postal_code, FAC.country_code, FAC.federal_ein, FAC.website, FAC.email, FAC.service_location, FAC.billing_location, FAC.accepts_assignment, FAC.pos_code, FAC.x12_sender_id, FAC.attn, FAC.domain_identifier, FAC.facility_npi, FAC.facility_taxonomy, FAC.tax_id_type, FAC.color, FAC.primary_business_entity, FAC.facility_code, FAC.extra_validation, FAC.mail_street, FAC.mail_street2, FAC.mail_city, FAC.mail_state, FAC.mail_zip, FAC.oid, FAC.iban, FAC.info FROM facility FAC ORDER BY FAC.name ASC
2022-03-17 16:53 security-administration-Query Security administrator Default 0 1 Query id, fname, lname, specialty FROM users WHERE active = 1 AND ( info IS NULL OR info NOT LIKE ‘%Inactive%’ ) AND authorized = 1 ORDER BY lname, fname
2022-03-17 16:53 security-administration-Query Security administrator Default 0 1 Query d.id, d.name, a.line1, a.city, p.area_code, p.prefix, p.number FROM pharmacies AS d LEFT OUTER JOIN addresses AS a ON a.foreign_id = d.id LEFT OUTER JOIN phone_numbers AS p ON p.foreign_id = d.id AND p.type = 2 ORDER BY a.state, a.city, d.name, p.area_code, p.prefix, p.number
2022-03-17 16:53 security-administration-Query Security administrator Default 0 1 Query id, fname, lname, specialty FROM users WHERE active = 1 AND ( info IS NULL OR info NOT LIKE ‘%Inactive%’ ) AND ( authorized = 1 OR ( username = ‘’ AND npi != ‘’ ) ) ORDER BY lname, fname
2022-03-17 16:53 security-administration-Query Security administrator Default 0 1 Query id, fname, lname, specialty FROM users WHERE active = 1 AND ( info IS NULL OR info NOT LIKE ‘%Inactive%’ ) AND ( authorized = 1 OR ( username = ‘’ AND npi != ‘’ ) ) ORDER BY lname, fname
2022-03-17 16:53 patient-record-Query Billing administrator Default 1 1 Query grp_form_id, grp_seq, grp_title FROM layout_group_properties WHERE grp_form_id LIKE ? AND grp_group_id = ‘’ ORDER BY grp_seq, grp_title, grp_form_id (‘DEM’,)
2022-03-17 16:53 patient-record-Query Billing administrator Default 1 1 Query grp_form_id, grp_seq, grp_title FROM layout_group_properties WHERE grp_form_id LIKE ? AND grp_group_id = ‘’ ORDER BY grp_seq, grp_title, grp_form_id (‘DEM’,)
2022-03-17 16:53 patient-record-Query Billing administrator Default 1 1 Query grp_form_id, grp_seq, grp_title FROM layout_group_properties WHERE grp_form_id LIKE ? AND grp_group_id = ‘’ ORDER BY grp_seq, grp_title, grp_form_id (‘DEM’,)
2022-03-17 16:53 security-administration-Query Security administrator Default 0 1 Query insurance_companies.name, insurance_companies.id, insurance_companies.cms_id,
addresses.line1, addresses.line2, addresses.city, addresses.state, addresses.zip
FROM insurance_companies, addresses
WHERE addresses.foreign_id = insurance_companies.id
AND insurance_companies.inactive != 1
ORDER BY insurance_companies.name, addresses.zip
2022-03-17 16:53 patient-record-Query Billing administrator Default 1 1 Query fe.
, f.user, u.fname, u.mname, u.lname FROM form_encounter AS fe JOIN forms AS f ON f.pid = fe.pid AND f.encounter = fe.encounter AND f.formdir = ‘newpatient’ AND f.deleted = 0 LEFT JOIN users AS u ON u.id = fe.provider_id WHERE fe.pid = ? ORDER BY fe.date DESC, fe.id DESC LIMIT 0,20 (‘1’,)
2022-03-17 16:53 security-administration-Query Security administrator Default 0 1 Query authorized from users where id = ? (‘1’,)
2022-03-17 16:53 patient-record-Query Patient Demographics administrator Default 1 1 Query squad from patient_data where pid=? order by date DESC limit 0,1 (‘1’,)
2022-03-17 16:53 patient-record-Query Patient Demographics administrator Default 1 1 Query * from employer_data where pid=? order by date DESC limit 0,1 (‘1’,)
2022-03-17 16:53 patient-record-Query Patient Demographics administrator Default 1 1 Query *, DATE_FORMAT(DOB,’%Y-%m-%d’) as DOB_YMD from patient_data where pid=? order by date DESC limit 0,1 (‘1’,)
2022-03-17 16:53 patient-record-Query Immunization administrator Default 1 1 Query i1.id AS id, i1.immunization_id AS immunization_id, i1.cvx_code AS cvx_code, c.code_text_short AS cvx_text,
IF(i1.administered_date, concat(i1.administered_date,’ - ‘,c.code_text_short),
IF(i1.note,substring(i1.note,1,20),c.code_text_short)) AS immunization_data
FROM immunizations i1
LEFT JOIN code_types ct ON ct.ct_key = ‘CVX’
LEFT JOIN codes c ON c.code_type = ct.ct_id AND i1.cvx_code = c.code
WHERE i1.patient_id = ?
AND i1.added_erroneously = 0
ORDER BY i1.administered_date DESC (‘1’,)
2022-03-17 16:53 patient-record-Query Billing administrator Default 1 1 SHOW TABLES LIKE ‘form_injury_log’
2022-03-17 16:53 patient-record-Query Billing administrator Default 1 1 SHOW TABLES LIKE ‘form_treatment_protocols’
2022-03-17 16:53 patient-record-Query patient-record administrator Default 1 1 Query * FROM lists WHERE pid = ? AND type = ? AND (enddate IS NULL OR enddate= ‘0000-00-00’) ORDER BY begdate (‘1’,‘dental’,)
2022-03-17 16:53 patient-record-Query patient-record administrator Default 1 1 Query * FROM lists WHERE pid = ? AND type = ? AND (enddate IS NULL OR enddate= ‘0000-00-00’) ORDER BY begdate (‘1’,‘surgery’,)
2022-03-17 16:53 patient-record-Query patient-record administrator Default 1 1 Query * FROM lists WHERE pid = ? AND type = ? AND (enddate IS NULL OR enddate= ‘0000-00-00’) ORDER BY begdate (‘1’,‘medical_device’,)
2022-03-17 16:53 patient-record-Query Medication administrator Default 1 1 Query date FROM lists_touch WHERE pid=? AND type=? (‘1’,‘medication’,)
2022-03-17 16:53 patient-record-Query Medication administrator Default 1 1 Query * FROM lists WHERE pid = ? AND type = ? AND (enddate IS NULL OR enddate= ‘0000-00-00’) ORDER BY begdate (‘1’,‘medication’,)
2022-03-17 16:53 patient-record-Query Medication administrator Default 1 1 Query * FROM lists WHERE pid = ? AND type = ? AND (enddate IS NULL OR enddate= ‘0000-00-00’) ORDER BY begdate (‘1’,‘medication’,)’

I really don’t know much about MacOS, but be sure your have the PHP-MySQL/Mariadb connectors. Also, you need to be sure to use PHP 8.0, not 8.1

It’s a bug, thanks @psoas

1 Like

I’m using OpenEMR 6.1. I get the same SQL error as David. Is there is a work around to add an Insurance provider?

hi @LMoonsammy, was fixed in this PR and will be in next patch. You can add the insurance for now through Admin->Practice->Practice Settings->Insurance Companies.

Thanks. I’ll do that.

Adding Insurance worked. :sweat_smile: