I’m testing version 2.9.0 and when I select the “Print Four Panel” from the Rx menu, I get the following error when trying to print a prescription:
Select CAMOS Entries for printing
ERROR: query failed: select x.id as id, x.category, x.subcategory, x.item from form_CAMOS as x join forms as y on (x.id = y.form_id) where y.encounter = and x.pid = 1 and x.activity = 1
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘and x.pid = 1 and x.activity = 1’ at line 1
_________
The unusual thing is that sometimes it works, but most of the time it does not.
Well, I spoke too soon. It is broken again, even after installing the new CAMOS.tar.gz and changing the owner to apache:apache. It’s weird because the problem is intermittent. I even grabbed the latest openemr from the CVS.
You would get that error when there is no active encounter. This is should not be problem when used from within an encounter.
Is there a screen where you find that link and you are not in an encounter?
Either way, you should not have to worry about this happening. I’m going to fix this. Does it seem like a useful feature? I don’t know if it was appropriate to put a link in the main program to a feature built into a plug-in form.
Ok, I went to "Encounter" and CAMOS printing worked from there. Interesting enough, when I went back to the "Rx" form which list the prescriptions, CAMOS printing also worked. I guess that the initialization of CAMOS in "Encounter" fixed the problem ir "Rx".
As far as being a link in other forms, it shows up in “Rx”. As far as a useful feature, I am still trying to understand how CAMOS is used in the business process of this program. I’ve only been evaluation Openemr for the last 5 days.
Thanks for your help and quick response. I am evaluating this program for use in a Health Care and Corrections environment. It will need to have a MAR (Medication Administration Record) component as well as the ability to link to a mainframe for tracking of inmate location at anytime.
I think I figured out why you get this error so easily and I never get it.
I use the Old-style layout, just because it’s what I am used to. You are most likely using the radio button navigation left menu. I think this is the default with a new installation.
I just tried out the radio button layout (the concurrent layout) which you are probably using, and it is easy to go to the rx list page without being in an encounter. This causes the error.
With the old style layout, which I use, it is impossible to get to the rx list page without being in an encounter.
I will take a look and try to fix it so it works either way. In the mean time, make sure you are in a patient encounter first.