Re: [Health] Upgrading GNU Health

[Raformatico Rodgom]

Hi Axel,

I’ve tried the upgrade first using trytond-admin command (as I understood following the wiki) and also trying the upgrade script. For doing this last option again (first upgrade script)  I’ve followed the following steps:

1.- Drop previous Database

$ psql

-- DROP DATABASE dabasename;

2.- Import exported database (in order to try the upgrade in a virtual machine)

$ createdb DATABASENAME

$ psql DATABASENAME < backup_BD

3.- Script to 3.2 gives me this error:

$ psql DATABASENAME < upgrade_32.sql

ALTER TABLE

UPDATE 0

UPDATE 0

ERROR:  column "active" of relation "gnuhealth_patient" does not exist

LINE 3: update gnuhealth_patient set active=True;

                                     ^

ERROR:  column "active" of relation "gnuhealth_medicament" does not exist

LINE 2: update gnuhealth_medicament set active=True;

                                        ^

ERROR:  column "active" of relation "gnuhealth_healthprofessional" does not exist

LINE 2: update gnuhealth_healthprofessional set active=True;

                                                ^

ERROR:  column "active" of relation "gnuhealth_lab_test_type" does not exist

LINE 2: update gnuhealth_lab_test_type  set active=True;

                                            ^

ERROR:  column "active" of relation "gnuhealth_imaging_test" does not exist

LINE 2: update gnuhealth_imaging_test set active=True;

                                          ^

ERROR:  relation "gnuhealth_ambulance" does not exist

LINE 2: update gnuhealth_ambulance set active=True;

 

Thank you again!

On Sun, Sep 1, 2019 at 6:03 AM Axel Braun <address@hidden> wrote:

Hello Rafa,

Am Samstag, 31. August 2019, 18:06:45 CEST schrieb Raformatico Rodgom:

> I tried the command with database and path to the config file and it gives
> me this error:
....

> No idea what to do...

One step back - did you apply the patches from tryton 3.0 series to 3.2 and
from 3.2 to 3.4?

--

Rafa