This is a new discovery today. My billing manage has informed me since the recent updates that she can no longer query pt names within the Billing Manager. This is a big issue for her. Error message below:
ERROR: query failed: select distinct billing.id, form_encounter.date, billing.pid, billing.code_type, billing.code, billing.user from form_encounter, billing, patient_data, claims, insurance_data where billing.encounter = form_encounter.encounter and billing.pid = form_encounter.pid and patient_data.pid = form_encounter.pid and claims.patient_id = form_encounter.pid and claims.encounter_id = form_encounter.encounter and insurance_data.pid = form_encounter.pid and insurance_data.type = ‘primary’ AND (billing.billed = ‘0’ or (billing.billed = ‘1’ and billing.bill_process = ‘3’)) AND (patient_data.fname like ‘ternes%’ or patient_data.lname like ‘ternes%’) and billing.code_type like ? and billing.activity = 1 order by billing.pid, billing.date ASC
This looks a lot like my posted error on the second page of this thread. In that case an apostrophe was read as an attempt to inject code and is avoided by 2 apostrophes.
Hi,
Which billing manager (Fees->Billing->EOB or Fees->Batch Payments). Does it happen with every name or special names (as cverk eludes to, does the name contain special characters such as apostrophe?)
-brady OpenEMR
Fees -> Billing -> under Choose Criteria click on Patient Name type in any patient name regardless of apostrophe. For example, I typed in “Griffin” and got this error message:
ERROR: query failed: select distinct billing.id, form_encounter.date, billing.pid, billing.code_type, billing.code, billing.user from form_encounter, billing, patient_data, claims, insurance_data where billing.encounter = form_encounter.encounter and billing.pid = form_encounter.pid and patient_data.pid = form_encounter.pid and claims.patient_id = form_encounter.pid and claims.encounter_id = form_encounter.encounter and insurance_data.pid = form_encounter.pid and insurance_data.type = ‘primary’ AND (billing.billed = ‘0’ or (billing.billed = ‘1’ and billing.bill_process = ‘3’)) AND (form_encounter.date between ‘2012-09-20 00:00:00’ and ‘2012-09-20 23:59:59’) AND (patient_data.fname like ‘griffin%’ or patient_data.lname like ‘griffin%’) and billing.code_type like ? and billing.activity = 1 order by billing.pid, billing.date ASC