openemr running under xampp in windows, using Edge browser
I upgraded from 7.0.1(1) to 7.0.2 and now when I open a patient’s chart, I see the upper section down to the
“dashboard history reports documents . . .” line, but nothing else below that.
The error log has
Uncaught Error: Class “OpenEMR\Common\Database\QueryPagination” not found in C:\xampp\htdocs\openemr\src\Validators\ProcessingResult.php:40
Any ideas?
I did mistakenly run sql_upgrade.php before running sql_patch.php. Both reported success
How did you upgrade your instance? Is this docker? Or did you download the 7.0.2 release and just extract it? There is a patch released for the 7.0.2, but that file is in the core release and should be present. I just downloaded the unpatched 7.0.2 release and verified the file is there so I’m wondering if you didn’t fully extract all the files if you did this manually (non-docker upgrade).
I just tried it again, with the same result
I have a vm running windows server 2022 datacenter, and installed openemr manually on it a long time ago (no docker used). I am using xampp to host openemr
It was patched to 7.0.1(1)
I cloned the vm, and in the clone, verified that openEMR was working fine, and was 7.0.1(1)
I downloaded the 7.0.2 zip file, and copied the contents into my openemr root folder
I then ran sql_patch.php, which ran fine
Interestingly, sql_patch.php reported, at the top: “OpenEMR 7.0.1 Database Patch 1”, and at the bottom also gave this same verison #. No mention of 7.0.2.
So I’m thinking there is something not right with they way sql_patch.php is working.
After running sql_patch.php, I can open openEMR and it shows it is version 7.0.2, but I have the same issues as before: no tabs, and if I open a patient, no dashboard content. Same errors in the php error_log as before
Ideas?
This is getting more interesting
I ran sql_patch.php a second time, and this time it mentions 7.0.2(1) at both the top and bottom of the output
In openEMR, I again see it is version 7.0.2(1), and no tabs show
In admin | forms | lists, I do not see a default_open_tabs list pre-defined
Also, when I try to open Finder, I get
Error: Table ‘openemr.recent_patients’ doesn’t exist
I verified, in phpmyadmin, that this table does not exist in my openemr db
Yes, I followed the guide (what I describe above is consistent with the guide)
I just did some more actions:
I looked in the sql folder and found 7_0_1-to-7_0_2_upgrade.sql. I copied this and renamed it to patch.sql, and re-ran sql_patch.php and now things are a bit better, but not fixed.
I now have the recent_patients table, and the default_open_tabs list. I can open Finder and select a patient, but I do not get the dashboard displayed. I still do not get any tabs opened automatically, even after ensuring I have active and default tabs defined in admin | forms | lists
Look in the zip file you downloaded, does it have the OpenEMR\Common\Database\QueryPagination file?
This would be stored in src/Common/Database/QueryPagination.php. If the file is there, check your xampp installation and verify the file is there as well.
If both are there, it could be an issue with your composer install. You might need to do a composer dump-autoload from the root OpenEMR folder since you are doing this all manually.
Ok @stephenwaite , I see I did NOT follow the upgrade guide
I applied the 7.0.2 patch to a 7.0.1(1) system. I see that I need to first upgrade from 7.0.1(1) to 7.0.2, and then (I think) apply the 7.0.2 patch
Might be good if this page and this page indicated that the 7.0.2 patch can NOT be applied to a 7.0.1 system until it has been upgraded from 7.0.1 to 7.0.2. I am assuming that the 7.0.2 patch listed here, when applied to a 7.0.2 system, creates a 7.0.2(1) system. The pages do not make this at all clear.
Thanks
