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

[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. UPDATE @brady.miller I updated the script to s…