Ugrade database 4.1.1 to 4.1.2

Management and Administration
1

doggmd wrote on Sunday, August 18, 2013:

The ‘sql_upgrade.php’ when run from Firefox in Windows does not work(step 6 in the instructions). The drop down menu show “$version” instead of 4.1.1. Running mysqulcheck seems ti indicate the database is there.

Any ideas on getting the database updraged to 4.1.2 from 4.1.1?

2

bradymiller wrote on Sunday, August 18, 2013:

Hi,
Just tested this script on current xammp windows package for OpenEMR 4.1.2 and can not reproduce this error. This sounds like a server side issue, so what Operating system is OpenEMR on (ie. the server part) and what php (or xampp) version are you using? That script is relatively straightforward to hard-code the 4.1.1, if needed, but will be good to know if newer php version are breaking this script.
-brady
OpenEMR

3

doggmd wrote on Monday, August 19, 2013:

It runs on Windows Server 2003. I am going t try so set up 4.1.1 with patch 14 on Windows 7 and try it there.

4

doggmd wrote on Monday, August 19, 2013:

Is there a way to get OpenEMR working again after removing the 4.1.1 directory and failing to get 4.1.2 to work.

Installing 4.1.1 then moving the openemr directory back then installing patch 14 does not seem to work.

Installing xamp 4.1.2 and trying to upgrade the 4.1.1 openemr directory is not working either.

The more I read the directions the more confused I get.

Can someone clarify the seven steps?

  1. I assume you copy the 4.1.1 to somewhere else and delete the original.
  2. I assume web directory is C:\xampp\htdocs and the folder renamed to openemr is openenr-412
  3. Are the document,edi,era and letter_templates placed in the openemr folder or the openemr/sites/default/* 4 separate folders like they came from? I went with 4 keeping them lite they were.
    4-7 not confusing
    As you see I am lost.
5

fsgl wrote on Tuesday, August 20, 2013:

I am going on the assumption that you don’t need to upgrade XAMPP and that you are only interested in upgrading from 4.1.1(14) to 4.1.2.

  1. C-drive->xampp->htdocs->openemr, copy the openemr folder to backup media, don’t delete anything.
  2. download the openemr-4.1.2.zip file and extract to openemr (C-drive.->xampp->htdocs->openemr). Rename the 4.1.2 openemr as openemr.
  3. Go to the backup medium->xampp->htdocs->openemr->sites->default; copy each of these folders: documents, edi, era and letter_templates and paste to the default folder in C-drive.
  4. complete.
  5. complete.
  6. Open Firefox and click the link in step 6. The drop down menu has the default of 4.1.1 from which you will be upgrading. Instead of the usual note that the upgrade has been sucessful, there is quite a bit of information about skipping as noted in this thread, which might be quite disconcerting but Brady explained why it is not so.
  7. complete.

Do you have a working copy of 4.1.1?

6

doggmd wrote on Tuesday, August 20, 2013:

Thanks fsgl. I was able to restore my opememr 4.1.1(14)that was destroyed by my failed upgrade and attempt at repair with a mysql restore. Here are my results so far.

  1. Good. Openemr directory was copied.
  2. My extraction was to the htdocs directory leaving openemer and openemr4.1.2 in the same directory. Since 4.1.2 has to be renamed to openemr, something is wrong and why the delete of the original openemr directory.
    If the extraction is to the openemr directory that leaves openemr4.1.2 as a sub directory of openemr. Clearly I am lost.
  3. Sounds confusing. The documents,edi,era and letter_templates are placed in the same relative positions in the new openemr folder, in the openemr\sites\default folder as the were in the openemr folder. Right?
    4.complete
    5.compltee
    6.So no message of upgrading 4.1.1 is ok?
    7.Help please.
7

blankev wrote on Tuesday, August 20, 2013:

What seems to be confusing is just a matter of wording. OpenEMR is called OpenEMR, this said you might understand the wording of Moving, Delete and my preference for Copy and Rename.

Step 1. Rename the old OpenEMR folder/map, make it OpenEMRV11118 (Version 4.1.1 with 18th patch, or give it the date you Rename your working version20130820). For Windows Upper case characters and Lower case characters is the same. For Linux you have to use exact the same characters for the Map name or Linux won’t see what you tried to type. Linux sees the difference between Upper and Lower case)

For the Software-structure of OpenEMR this is the same as moving and deleting but for your safety the working version of OpenEMR can be renamed back again and is still working. (If needed you can open the old version and use the new directory-name that is changed from OpenEMR into http://localhost/OpenEMRV41118).

Now import the new version of OpenEMR. Place this version in the root directory, the Directory where you find the map with Version 4.1.1 that used to be named openemr comes up with the name OpenEMRV4.1.2 after extracting. The new map is in the same place has the name OpenEMRV4.1.2 to get it working you have to Rename this folder into openemr.

What I do is FOLLOW the advise for Version upgrading with Copy <=> Paste. (Using this method of working you only have to correct the name of the map before pasting. Copy …/localhost/openemrv11118/sites/default/… into Paste …/localhost/openemr/sites/default…

(This works for Local personal computer settings and also for Linux Website Servers)

Be sure to change the “0” (Zero) in the steps mentioned into “1” without this step it won’t work. If you do it to late you can’t get OpenEMR to work without a reinstall. (Redo all steps following the instructions “UPGRADE VERSION” again will cover any mistakes.)

Now follow the steps indicating the latest upgrade …sql-file. Upgrade from Version 4.1.1 to Version 4.1.2 (This is for Version update not for Patch updates)

This did do the trick for me … almost… I had some tables that were not complete, for example I could not work in my local version with LBV-Forms as in the Demo Version. But by careful comparison of the Tables, there was a difference of one field missing. (Comparison can be done with two open PhPMyAdmin open. One for LocalVersion one for DemoVersion) Added the field in local version and the V4.2.1 is working flow-less.

Hope this Copy <=> Paste solution solves your upgrade problems, as it did for me. Once the New version is working, you can if needed delete the old renamed version. I do this after two month working without problems and the first few new patches have taken place. Every new version has it Patches due to problems encountered. This even while many testers did their work and added corrections before publication of the new version. (The first correction will follow within a week is my guess, the date in Vitals is not working as should and this is going to be corrected)

(I did this review and explanation to re-define the steps. I also had my trial and error following the official steps with Move and Delete and had to do my re-installs many times to get thing working. I started somewhere back with V3.1 and that was not as nice as the few steps to take with latest upgrade. Might include these steps in the WIKI-Upgrade version instructions, if so is indicated by the Deciders)

8

fsgl wrote on Tuesday, August 20, 2013:

You are most welcome, Larry.

It’s great that you were able to recover. There is nothing worse than a failed upgrade and a working copy that had been toasted by the attempt.

Pimm is correct that confusion arises from the semantics.

Using the analogy of dressing a person in new clothes, the new garments are the openemr and sql upgrades. The person remains the same, namely your personal data, some of which is stored in the 4 sites/default folder.

In Step 2, after you click to extract the zip file to C-drive, Windows will ask you if you want to copy and replace a folder with the same name and there will be a check box to do the same for other folders as well. You want to copy and replace and to check the box. When this is done, the 4.1.1 openemr folder has been replaced with the 4.1.2 folder. Rename the 4.1.2 folder to openemr if Windows did not do it for you.

In Steps 3, you want to put your personal data back into 4.1.2, such as forms, billing, remittance information. Again Windows will ask if you want to copy and replace and you do. Now some of the new clothes is on the same person.

For Steps 4, 5 & 7, open these files with Note++. Each line of code is numbered, so you won’t go cross-eyed as with plain Notepad. Files in Steps 4 & 7 are customizations that you made, therefore you want them in 4.1.2.

For Step 6, open Firefox, click the link, go with flow and don’t be intimidated by all the wording. This is some more of the new garments.

9

blankev wrote on Tuesday, August 20, 2013:

fsgl,

tnx for the additional info.

Question: Do you know if there is much difference in Note++ or EDITPAD Pro

BTW: I must say for this small file Notepad did work for me as expected. With the file open, at the end it is obvious where the “0” is located. But indeed after so many Do- and Re-dos you get used to your own great software. And don’t try to open the file wit a program that adds extra characters to make it more readable. Also the extension of the file should not be changed into something like MyFile.php.txt

10

doggmd wrote on Tuesday, August 20, 2013:

Thanks for the fast responses but still no love for me. Can someone review these steps and tell me my error(s) on a Windows 7 Ultimate system from a xamp4.1.1(14) install?

  1. Rename current(4.1.1) /openemr directory to a backup directory i.e. openemr41182013
  2. Unzip 4.1.2 update for openemr into c:\xampp\htdocs\ directory and rename the openemr-4.1.2 directory to openemr
  3. Move following directories from old 4.1.1 version (openemr41182013) to the openemr directory:
    openemr/sites/default/documents
    openemr/sites/default/edi
    openemr/sites/default/era
    openemr/sites/default/letter_templates
  4. Record the openemr/sites/default/sqlconf.php file variables from your old 4.1.1 version, and enter those into the openemr/sites/default/sqlconf.php file in new openemr version
  5. In the openemr/sites/default/sqlconf.php file, set the $config variable (found near bottom of file within bunch of slashes) to 1 ($config = 1;) if it is zero(it has always been 1).
  6. Open openemr/sql_upgrade.php (http://localhost/openemr/sql_upgrade.php) in Firefox, choose 4.1.1(if offered) and click ‘Upgrade Database’
  7. Open openemr/acl_upgrade.php (http://localhost/openemr/acl_upgrade.php) in Firefox
  8. Configure optional settings in openemr/sites/default/config.php files
    Thanks
11

fsgl wrote on Tuesday, August 20, 2013:

You want the 4.1.2 Upgrade not the 4.1.1 Upgrade.

12

blankev wrote on Tuesday, August 20, 2013:

Step 5 can’t be correct if you do a clean upgrade. It is “0” Zero for the new V4.1.2 openemr/sites/default/sqlconf.php.

The best thing to do is delete map/ OpenEMR4.1.2 and be sure it is empty.

Than extract the downloaded fresh version V.4.1.2 and extract and follow the guide lines.

If possible, check if the last available used version is still in working order. Since Copy Paste gives to the new version, the mistakes… if there are mistakes in the replaced version.

13

fsgl wrote on Tuesday, August 20, 2013:

Sorry, Pimm, no experience with EditPad Pro, which does not sound like freeware. It is very difficult for money to leave the wallet.

14

blankev wrote on Tuesday, August 20, 2013:

May be you do something wrong in step 4… don’t copy the file into the new version.

Make a comparison between the two files, the old and the new one. Include only the lines of the old file that are different or not included in the new file.

15

yehster wrote on Tuesday, August 20, 2013:

Are you moving from one machine (with Server 2003) to another (with Win 7). If this is the case, how did you move the database tables from one to the other? It sounds like you only moved the web server files.

16

blankev wrote on Tuesday, August 20, 2013:

This …Pro sounds like PAY, but it is for a Pro for free, if you are poor. Or you can try the EditPad and that piece of software has almost the same options and is definitely free. Suppose it has the same options as Note++. In due time I will give it a try.

It imports any file and you can change that file into many readable file constructions. CSV, MSWORD, MSExcell, OpenOffice, SQL, etc. Or make reading character by character possible. So many options that you can keep experimenting day after day…

17

jackffuit501 wrote on Wednesday, August 21, 2013:

I have not been able to upgrade version 4-1.1 to 4.1.2 on my Fedora 19 machine.
I could not complete the upgrade and neither could I install a fresh 4.1.2 version after deleting the corrupted v4.1.1. I could however fresh install back v 4.1.1 (without the data entered before the upgrade). Any help is welcome.

Jack

18

fsgl wrote on Wednesday, August 21, 2013:

Hi Jack,

Do you have a working copy of 4.1.1(14)?

Where in the sequence of the upgrade steps did you encountered the problem and what was the error message?

Where did you have a problem with the installation of 4.1.2 Linux?

I am totally unfamiliar with Linux; but if you give more specific details, other forum members can hone into the problems.

19

jackffuit501 wrote on Wednesday, August 21, 2013:

Hi fsgl,

I went up to stage 7 as in the post by larryxp. At the openemr login I cannot access the program with admin or other user. It just looped back. I will try again tomorrow in the office using the backup 4.1.1 with patch 14.

Jack

20

jackfruit501 wrote on Thursday, August 22, 2013:

Hi fsgl,

I have tried to upgrade again using the backup of version 4.1.1. but it seems to get stuck at the browser (firefox) for localhost/openemr/sql_upgrade.php . It states “check if mysqld is running”. I have checked and mysql has started and I can test phpmyadmin and even wordpress on localhost. I can fresh reinstall v 4.1.1 without changing anything on Mysql.

Jack