Just wondering, you mentioned that acl_upgrade.php “does not appear to be in the openemr root directory”. That should not be the case, I just re-checked the Version 7.0.3 release tarball, and that file is most definitely there. Maybe some files were not properly copied or extracted correctly? Might be part of the problem…
Thanks for the reply, @Penguin8R - I really appreciate it. I’ll check again when I get home (I’m currently wired up to machines in a hospital bed), but sql_upgrade.php wasn’t in the ARM64 docker image (7.0.3) on the Pi5 and I had to copy it over from mt x86_64 desktop. - but it would not finish running on the Pi5. It did run on the x86_64 and that implementation works. So I dumped the uograded mysql data from the x86_64 and loaded it into the Pi5 mariadb docker container and copied the …/sites/documents folder from the x86_64 instance to the Pi5 openemr dicer container - and it now works.
However, when I logged in to oemr on the Pi5 - in the ‘About OpenEMR’ menu option it says it is running version 7.0.4-dev (which is the x86_64 version running in the development-easy docker). The data in the ‘version’ table of the Pi5 mariadb database also shows 7.0.4-dev (naturally, since the database was copied from there). I haven’t checked for any differences, but maybe the sql_upgrade.php from 7.0.4-dev is different to what should have been in the 7.0.3 docker image and that is why it wouldn’t run to completion in the Pi5.
There will be differences in the sql_upgrade.php and acl_upgrade.php files between version 7.0.3 and version 7.0.4(dev), yes, but PHP is PHP , regardless of the processor architecture. Those files should still be there, unless it’s an accidental omission from the Docker development-easy image. Be aware, those files are very much version specific, so mixing & matching from different versions of OpenEMR is going to give you trouble. One of the last things that “sql_upgrade.php” does as part of a version upgrade is to update the version tag in the database, but ARM versus X86_64 makes no difference as far as PHP is concerned.
Agreed, but it didn’t occur to me that I had mixed and matched until after I had done it! I’ll probably blow it all away and repeat with matching versions now that I have the data working in a docker transferred from an old 5.0.3 WAMP installation.