Upgrade problems

markthepharaoh wrote on Wednesday, February 03, 2010:

I made a new installation 3.1 and restored the data from 3.0, I am running ubuntu, When I look at the patients record I can see the patients notes’ link  created using a customized SOAP form, what when I click on them, I cannot see the notes themselves.  And the new entered vitals  appear twice.    I can not remember if the original installation was an upgrade from 2.9 or nor not.  Any idea where to start? Thanks.

Mark

ideaman911 wrote on Wednesday, February 03, 2010:

Mark;

Did you run the sql_upgrade.php file after you moved the data?  There are a few things between 3.0 and 3.1 which changed.

Joe Holzer    Idea Man    315-622-9241     im@holzerent.com  or  joe.im0602x@gmail.com
http://www.holzerent.com  or  http://www.EMRofCNY.com

markthepharaoh wrote on Monday, February 08, 2010:

Joe,

Thank you for answering me. I did ran the sql_upgrade.php.  The problem is I did not find the customised soap form in the directory of the upgraded OEMR.  The upgrade was done on a new computer with restoration of the data from 3.0 to 3.1.  I have not resolved the issue yet.  I am not sure if the backup program backs up the customised forms or not.  When I view an existing encounter I see the link of the customised soap form and it is registered an enabled in the restored  data even though the form folder does not exist and was not backed up.  If I click on the link I get a blank page instead of seeing the soap info stored.   I copied the folder that has the customised soap into interface/forms and the problem was not resolved.  Any ideas? Thanks.  I use Ubuntu!

bradymiller wrote on Tuesday, February 09, 2010:

hey,

Did you follow these instruction:
http://www.openmedsoftware.org/wiki/Linux_Upgrade_3.0.1_to_3.1.0

If you did not follow these instructions, and instead created a new 3.1.0 empty sql database, and then tried to migrate your old database to this, you will have encoding problems (since 3.1 is pure UTF-8 and the previous is not).

-brady

markthepharaoh wrote on Wednesday, February 10, 2010:

Brady,

Thank you that is very helpful!

Mark

markthepharaoh wrote on Wednesday, February 10, 2010:

Hey Brady

Is it possible to go around the system by making a new installation of 3.0, copy the customized forms, restore the data into the new installation, then do the upgrade?

bradymiller wrote on Thursday, February 11, 2010:

hey,
The key thing you can’t do is create the database with a new install of 3.1 (will create a pure UTF-8 database), and then try to import your sub 3.1 database into it. I think what your saying won’t break this rule, but it’s not entirely clear to me what your trying to do.
-brady