I remember from other threads that blank space = permission problems.
Suggest:
Back up again.
Follow this Guideto the letter (I should know, from bitter experience).
Log into your Windows 7 laptop as Adminstrator to avoid permission problems.
In step 1 of the Guide, be certain to move 4.1.2 to a place other than C-drive, e.g., an external hard drive. If you leave it on C-drive, 4.2.0 will not copy over 4.1.2.
Unfortunately this has not solved my problem. I have followed the guide exactly, and for some reason the menu sidebar remains blank. Interestingly, it does not provide an error message, just a blank space.
I have successfully upgraded many times over the past few years and have never encountered this. When I roll back to the previous version and run the sql_upgrade.php I have no issue.
I am curious if it is a compatibility issue with XAMPP, as I am running the version that installed when I first started with OpenEMR many years ago.
Could this be the case? Or is there something else I am missing?
Also, I have always been curious as to what point #4 from the upgrade guide actually means:
Record the openemr/sites/default/sqlconf.php file variables from your old 4.1.2 version, and type these into the openemr/sites/default/sqlconf.php file in new openemr version.
Which variables in the sqlconf.php are required? I’ve always just copied and pasted my old sqlconf.php file and never had an issue.
Perhaps this is my problem?
I feel like such a hack when I’m working with OpenEMR. I have no clue what anything means, and just follow the instruction like a recipe. Is there anyone in Canada who is fluent in this program that is available for hire to properly maintain OpenEMR systems??
Stephen & Terry are excellent developers. If we are unable to walk you through this problem, there is always the option of joining their respective client list.
With patience you will learn the rationale & purpose of what you are doing. For now we must take the “cookbook” approach. If you can follow instructions to the the letter, you are far ahead of many users.
What version of XAMPP are you on? If you don’t know, what version of OpenEMR was it packaged with?
Regarding the sql.conf.php, it’s the login credentials to your MySQL database. The upgrade need them to “talk” to your database.
Let’s try to get the fatal error messages so that we can get a sense of what’s gone wrong (differential diagnoses).
Suggestion:
Backup yet again.
repeat steps 2-5 from above.
log in, note the time & immediately go to C-drive\xampp\php\logs\php_error_log & note errors.
go to xampp\mysql\data\mysql.error & note errors for the time in 3.
post errors logs as attachments so that we can take a look.
I am using XAMPP 1.7.1. I believe it was packaged with version 4.0.0. I have tried to upgrade XAMPP a few times in the past to no avail.
For some reason, the file “c:\xampp\php\logs\php_error_log” does not exist for me. My install does not contain a ‘logs’ folder within the ‘php’ folder. I found “C:\xampp\php\PEAR\Log\error_log” but it does not contain any pertinent error messages. Is there somewhere else to look for fatal errors (besides in the mirror…haha)?
Working diagnosis: problem exists between keyboard and chair.
When you tried to upgrade the XAMPP did you use the .exe upgrade file?
Thanks
Terry
From: mlong drlong@users.sf.net
To: [openemr:discussion] 202505@discussion.openemr.p.re.sf.net
Sent: Monday, January 5, 2015 3:53 PM
Subject: [openemr:discussion] Left Sidebar Absent After Upgrade to 4.2
I am using XAMPP 1.7.1. I believe it was packaged with version 4.0.0. I have tried to upgrade XAMPP a few times in the past to no avail.
For some reason, the file “c:\xampp\php\logs\php_error_log” does not exist for me. My install does not contain a ‘logs’ folder within the ‘php’ folder. I found “C:\xampp\php\PEAR\Log\error_log” but it does not contain any pertinent error messages. Is there somewhere else to look for fatal errors (besides in the mirror…haha)?
Working diagnosis: problem exists between keyboard and chair.
We’re going change tactics. Because XAMPP is outdated, let’s update both by installing the 4.2.0 XAMPP Package.
It’s easier if we break this task down into bite sized pieces.
We need to transfer data from the xampp/htdocs/openmer folder & the database before we can install the package.
Firstly, backup to another drive.
Second, copy the xampp/htdocs/openemr folder to another drive.
The third task will involve the use of Command Prompt. To this day, it still makes me a bit queasy, but it is the method least likely to give errors while copying the database.
You will need the MySQL rootpassword, found in C:\xampp\security\security\mysqlrootpassword.txt if you don’t have it written down.
Remember to insert the rootpassword, allowing no space after the p. The dumpfile should appear in C-drive. It will take time to create this .sql file if you have a large database.
Sixth task would import your default folder & database into the new package.
Copy old xampp\htdocs\openemr\sites\default folder replacing the new default folder. Right click the default in the other drive to copy it. Right click the new sites folder & choose paste. Say yes to copy & replace.
Import the old database via Command Prompt with the dumpfile in C-drive into the new database with these 2 commands:
I’m not exaggerating when I say this is the most outstanding forum support I’ve ever received. I will follow your guidance tomorrow in office and report back. Thanks again, this is amazing!
The only issue I have encountered in your guide is that sqlconf.php from the fresh install cannot be replaced by the sqlconf.php from the old install. Namely, the password variable must remain ‘escargot’ as it is listed by default, and not be replaced by my previous password.
When I replace with the old sqlconf.php variables it provides the error message “Check that mysqld is running.” Reverting back appears to work, and I am assuming this should not have any negative effect?
Thanks again. The support I’ve received in this thread goes above and beyond.
BTW, real good job on getting upgraded to the new xampp package. You will find you like some things a good bit better. The database (via phpmyadmin) might look a little different when listing tables (does ‘pages’) and the bookmarked queries you had will no longer be available (but they still exist).
Having your system upgraded to the new (er) PHP is a very good thing.