Cannot View Portal Audits

Support
#1

Situation
As an administrator, when i click on the Portal Audit, i have a popup which shows a stack trace. The error is placed under the logs session. Here is a screenshot.

Screen Shot 2021-12-06 at 9.24.58 AM
Screen Shot 2021-12-06 at 9.24.58 AM2226×708 183 KB

OpenEMR Version
I’m using OpenEMR version 6.0.3 (patch 3 installed)

Browser:
I’m using: Google Chrome

Operating System
I’m using: Linux (Centos 7)

Logs

path_to_directory\/portal\/patient\/index.php(59): Dispatcher::Dispatch(Object(Phreezer), Object(SavantRenderEngine), '', NULL, Object(GenericRouter))","4 {main}"]}{"orderBy":"Date","orderDesc":true,"rows":[],"totalResults":"0","totalPages":0,"pageSize":20,"currentPage":"1"}```
#2

Looks like you don’t have database permissions to create views.

#3

Thanks for the response. Will check check that out and get back to you

#4

Please i have enabled all privileges for the user in the DB but error still persists
Kindly find the attached screenshot of the privileges.

Screen Shot 2021-12-06 at 3.04.34 PM
Screen Shot 2021-12-06 at 3.04.34 PM1562×904 20 KB

#5

There may be a chance during upgrade or move of DB that the view has been converted to a table.
Delete the onsite_activity_view in your database and give it a try. Code will auto create after delete.

1 Like
#6

Sorry for the late response.

I tried deleting the onsite_activity_view as sjpadgett suggested. You were right. It was converted into a table. It worked after deleting.

Thanks a million

#7

You’re welcome however with inflation such as it is today, a million thanks is not what it used to be.
Perhaps: Thanks a billion is more appropriate!:slight_smile:

#8

:smiley::smiley:Thanks a billion then.

KKAppiah