Demographics not authorized

lboone99999 wrote on Thursday, July 14, 2011:

I imported a bunch of records with a SQL query. I can see all of the patient data. However, when I click on the patient name, I get an error message that says “demographics not authorized”. Although, if I manually enter a new patient, I can view the demographics without any problem.

I’ve looked at previous posts. I edited the php,ini as specified. I looked at demographics_full.php and it’s settings are correct.

I’m trying to avoid hand-typing 400+ patients. Do anyone have ideas on how to resolve this issue? Any help is highly appreciated.

Thanks,
Linda

jcahn2 wrote on Friday, July 15, 2011:

Ahoy Linda,

This sound like a “permission” issue.  Was the sql query done by “root”, or a user with different mysql rights than the openemr user?

Jack

lboone99999 wrote on Friday, July 15, 2011:

Jack,

Thanks for your response.

I was logged in as a user, with admin permissions. I can try it again using the admin login ID. I’ll let you know if that worked.

Linda

lboone99999 wrote on Friday, July 15, 2011:

Jack,

Nope, that didn’t work. Any other suggestions?

Linda

jcahn2 wrote on Friday, July 15, 2011:

Sorry, you’ve maxed out my knowledge here.  Can someone else chime in?
Jack

jcahn2 wrote on Tuesday, July 19, 2011:

Ahoy.
Here is a DID (damsel in distress).  Anyone else dare to be the knight in shining armor?
Jack

tmccormi wrote on Tuesday, July 19, 2011:

The only time this should happen is if the logged in user is not authorized for demographics or they are authorized, the system is set up for ‘squads’ (custom atheletic teams) and the user is not authorized for demographics + squads.

I suspect that squads it turned on accidentally somewhere.  This happened to me.
 
The code is in the following file:  interface/patient_file/summary/demographics.php

$thisauth = acl_check('patients', 'demo');
 if ($thisauth) {
  if ($result['squad'] && ! acl_check('squads', $result['squad']))
   $thisauth = 0;
 }
 if (!$thisauth) {
  echo "<p>(" . htmlspecialchars(xl('Demographics not authorized'),ENT_NOQUOTES) . ")</p>\n";
  echo "</body>\n</html>\n";
  exit();
 }

hakemz100220 wrote on Wednesday, February 01, 2012:

It happened to me also, just turn Layout/Demographics>>> squad team to “unused” and it will work again.

torcapio wrote on Wednesday, March 14, 2012:

Hello to all, and how to restrict the OpenEMR have the receptionist do not have access to the Demographics in the patient, because the receptionist can see the records of the patient, no longer part of Demographics, how do I get this access to it without taking a patient’s access to records

thanks for attention.