For about a week now I have been unable to access about 10% of my patient charts. I get the following error when selecting these patients from the patient list or from the search results:
ERROR: query failed: SELECT * FROM `` WHERE `pid`=?
Error: Incorrect table name ''
The only change I tried to make prior to this was to change the layout form>demographics by adding a field for primary care physician. The error messages persist despite undoing this change.
This EMR behavior is just too erratic for a mission as critical as the integrity of the patient chart.
What could have I done that is so egregious as to get such a disabling and penalizing error message!
Any help would be appreciated before I throw in the towel on openEMR
Qus : Did u add or change anything ob Admin=>Rules?
sure I did - I am trying to set up a set of rules to track my patients through a clinical pathway. How could this cause such havoc?
Any suggestions gratefully accepted
First we need to make sure ont thing? Is the rules really create the problems,
To verify that go to administration -> rules ->choose the new rules you created ->on clinical target ->set the inclusion no,then try to open a patient and let me know,how this is works
Please let me know
you are a genius - that fixed the problem! I would never have guessed.
Thank you so much - you saved me so much angst.
So what is the connection?
Here is the flow,
When you try to open a patient in openemr,it checks and bring all the data that related to patients,
So here CDR is one of the main thing for the patient,if you are not properly set an rules,surely it will breaks the app
Please let me know,if you need any help