Upgrade to PHP 7.4 cause slowness in OPenEMR version 5..02

[mhicks21 (Matthew Hicks)]

Situation
After upgrading to PHP 7.4, openemr pages load slower and the Left_NAv menu loads even slower. Are there any settings that I need to make to Openemr for PHP7.4 that will improve performance.

OpenEMR Version
5.02

Browser:
Chrome

Operating System
I’m using: Centos

Logs

I see no errors in the logs. The following notifications are logged.
[Mon Jul 19 10:44:18.448475 2021] [php7:notice] [pid 10374] [client 10.192.24.23:60326] PHP Notice: Undefined variable: backpic in /var/www/html/openemr502/interface/globals.php on line 531, referer: https://mapehr.gmu.edu/
[Mon Jul 19 10:44:18.501324 2021] [php7:notice] [pid 10374] [client 10.192.24.23:60326] PHP Notice: Undefined index: language_direction in /var/www/html/openemr502/src/Core/Header.php on line 149, referer: https://mapehr.gmu.edu/
[Mon Jul 19 10:44:19.146841 2021] [php7:notice] [pid 10378] [client 10.192.24.23:62006] PHP Notice: Undefined variable: backpic in /var/www/html/openemr502/interface/globals.php on line 531, referer: https://mapehr.gmu.edu/openemr502/public/themes/style_forest_green.css?v=51
[Mon Jul 19 10:44:19.154297 2021] [php7:notice] [pid 10378] [client 10.192.24.23:62006] PHP Notice: Undefined index: authUser in /var/www/html/openemr502/library/auth.inc on line 79, referer: https://mapehr.gmu.edu/openemr502/public/themes/style_forest_green.css?v=51
[Mon Jul 19 10:44:19.154327 2021] [php7:notice] [pid 10378] [client 10.192.24.23:62006] PHP Notice: Undefined index: authProvider in /var/www/html/openemr502/library/auth.inc on line 79, referer: https://mapehr.gmu.edu/openemr502/public/themes/style_forest_green.css?v=51
[Mon Jul 19 10:44:19.430887 2021] [php7:notice] [pid 10378] [client 10.192.24.23:62006] PHP Notice: Undefined variable: backpic in /var/www/html/openemr502/interface/globals.php on line 531, referer: https://mapehr.gmu.edu/openemr502/interface/login/login.php?site=default
[Mon Jul 19 10:45:22.074787 2021] [php7:notice] [pid 14843] [client 10.192.24.23:56930] PHP Notice: Undefined variable: backpic in /var/www/html/openemr502/interface/globals.php on line 531, referer: https://mapehr.gmu.edu/openemr502/interface/login/login.php?site=default
[Mon Jul 19 10:45:22.082948 2021] [php7:notice] [pid 14843] [client 10.192.24.23:56930] PHP Notice: Undefined variable: forwardIp in /var/www/html/openemr502/library/sanitize.inc.php on line 31, referer: https://mapehr.gmu.edu/openemr502/interface/login/login.php?site=default
[Mon Jul 19 10:45:22.112613 2021] [php7:notice] [pid 14843] [client 10.192.24.23:56930] PHP Notice: Undefined variable: forwardIp in /var/www/html/openemr502/library/sanitize.inc.php on line 31, referer: https://mapehr.gmu.edu/openemr502/interface/login/login.php?site=default

Did you check the logs?
Was there anything pertinent in them?
Please paste them here (surround with three backticks (```) for readability.
You can also turn on User Debugging under Administration->Globals->Logging User Debugging Options=>All

[stephenwaite]

hi @mhicks21, would dbl check your php settings, might not help but Notices don’t need to be logged.

[mhicks21 (Matthew Hicks)]

I turned notices off. I am getting some error messages when I access some pages.

[stephenwaite]

do you have Admin->Globals-Logging->User Debugging Options turned on?

[mhicks21 (Matthew Hicks)]

Yes that is how I got the messages. Do these error messages have anything to do with the pages loading slowly?

[stephenwaite]

not sure, would turn them off for now

[stephenwaite]

could you send a clearer picture of the errors first though?

[mhicks21 (Matthew Hicks)]

error messages.docx (209.6 KB)

Here is a word doc of the three screens.

[juggernautsei (Sherwin Gaddis)]

I just experience this issue in a new upgrade from v5x to v7 and it was fixed with fixing the table collation.

How to change the collation for all tables

This has been a pain in my dairies. I finally came up with a script to run and it converts 98% of the tables. Drop this file into the interface folder and access it from the browser. https://mysite.com/interface/upgrade_collation.php upgrade_collation.php (728 Bytes) The reason for the 98% is that there are some tables that won’t convert if they have illegal columns and such like. There are other that just won’t convert. No reason found yet.