Hi Luis, > Gesendet: Montag, 19. Juni 2017 um 23:08 Uhr > Von: "Luis Falcon" <fal...@gnu.org> > An: "Axel Braun" <axel.br...@gmx.de> > Cc: health-dev@gnu.org > Betreff: Re: [Health-dev] error on DB-upgrade > > Hi again, Axel ! > > Looking more closely at your output ... > > On Mon, 19 Jun 2017 22:03:32 +0100 > Luis Falcon <fal...@gnu.org> wrote: > > > > > > > > Please report any issues on this mailing list. > > > I'm getting error messages on upgrading an existing 3.0 database: > > > > postgres@linux-0t17:/mnt> psql gnuhealth30 > > > FEHLER: Spalte »active« von Relation »gnuhealth_medicament« > > > existiert nicht LINE 3: update gnuhealth_medicament set active=True; > > medicament and health_professional are core models, so it looks to me > that the DB you're trying to upgrade has not been loaded, or you don't > have the permissions to those tables.
Good pont - the update should not be made as user psotgres (under whom postgresql runs) but under the owner of the database - gnuhealth or tryton. Then it works. I could migrate the 3.0 demo-DB to 3.2. trytond-admin ran...forever ;-) Cheers Axel
