Problem to upgrade

Hello
I have a problem upgrading from openemr version 4.1.4
Sincerely

Sorry to hear that.

If you post maximum amount of information about steps and error(s), perhaps you may get some help here.

Best luck to you.

I have the vesrion of openemr 4.1.4 and when I try to upgrade it to 4.2.0 I get an error message

hi @kimi99 , I think you have to patch to 4.1.11 before upgrading.

how can patch it pls can you help me

https://www.open-emr.org/wiki/index.php/OpenEMR_Patches

https://www.open-emr.org/wiki/index.php/Old_Outdated_OpenEMR_Patches

i found patch for 4.1.7 and it still the some problem

did you try this one?
http://www.open-emr.org/patch/4-1-1-Patch-14.zip

I have test it and it shows the same problem

Do you use any of the ippf functions? Looks like after the upgrade it is trying to apply ippf upgrade and the statement causing error has not been upgraded to the latest layout_options columns.

If you do not need ippf functions, try the following :

  1. restore database
  2. Using Admin login, turn off ‘Specific Application’ that is currently using IPPF.
  3. Replace ippf_upgrade.sql by an empty file in case the sql_upgrade has that patch hardcoded.
  4. Run the upgrade again.

If you do want ippf stuff. You could try changing the statement to format Insert Into layout_options(colnames) values (colvalues);. However that is probably start of some other errors. Can’t help you with those.

Best luck.

1 Like

hay sir when i add an empty file i have this error

If you read the messages, patch.sql was the last step of main database upgrade. That was successful.

The error is related to language translations you may have put in or were old. Collation conversions are very time consuming to debug and fix. If you are ok with EMR’s standard translations, you will find it faster to delete 2 lang_* tables and recreate them with standard version. Maybe someone here may knows a better way.

Before anything you should use english login and test if everything is working ok.

Best.

1 Like