Dear Bernard, You are absolutely right. The program_userroles table is the correct one, and the userroleprogram table is a legacy table not used anymore. We just fixed the script, please try again with the latest version.
Best regards, Markus > 9. mar. 2018 kl. 14:21 skrev Bernard Sadaka (IM Advisor) <lib....@pu-ami.org>: > > Dear Markus, > After a closer look, I found this table: > public | program_userroles | table | dhis > Is it the same? > > All the best, > Bernard > > <image001.png> > Bernard Sadaka > Information Management Advisor > Première Urgence - Aide Médicale Internationale > Nehmeh Building, Sanine Street, Chiyah, 3rd Floor > Ain el Remmaneh, Beirut, Lebanon > E-mail: lib....@pu-ami.org <mailto:lib....@pu-ami.org> > Cell: +961 71 004 881 (208) > Skype: imapuami > Website: https://www.pu-ami.org <https://www.pu-ami.org/> > > > From: Dhis2-users > [mailto:dhis2-users-bounces+lib.ima=pu-ami....@lists.launchpad.net > <mailto:dhis2-users-bounces+lib.ima=pu-ami....@lists.launchpad.net>] On > Behalf Of Bernard Sadaka (IM Advisor) > Sent: Friday, March 9, 2018 3:17 PM > To: 'Markus Bekken' <mar...@dhis2.org <mailto:mar...@dhis2.org>> > Cc: dhis2-us...@lists.launchpad.net <mailto:dhis2-us...@lists.launchpad.net>; > 'DHIS 2 Developers list' <dhis2-devs@lists.launchpad.net > <mailto:dhis2-devs@lists.launchpad.net>> > Subject: Re: [Dhis2-users] [Dhis2-devs] 2.29 upgrade script error > > Hello Markus, > Unfortunately I don’t have that table: > dhisdb=# \dt userrole* > List of relations > Schema | Name | Type | Owner > --------+---------------------------+-------+------- > public | userrole | table | dhis > public | userroleauthorities | table | dhis > public | userroledataset | table | dhis > public | userrolemembers | table | dhis > public | userroletranslations | table | dhis > public | userroleuseraccesses | table | dhis > public | userroleusergroupaccesses | table | dhis > (7 rows) > Is there any maintenance scripts I need to run in order to create that table? > > All the best, > Bernard > > <image001.png> > Bernard Sadaka > Information Management Advisor > Première Urgence - Aide Médicale Internationale > Nehmeh Building, Sanine Street, Chiyah, 3rd Floor > Ain el Remmaneh, Beirut, Lebanon > E-mail: lib....@pu-ami.org <mailto:lib....@pu-ami.org> > Cell: +961 71 004 881 (208) > Skype: imapuami > Website: https://www.pu-ami.org <https://www.pu-ami.org/> > > > From: Markus Bekken [mailto:mar...@dhis2.org <mailto:mar...@dhis2.org>] > Sent: Friday, March 9, 2018 2:32 PM > To: Bernard Sadaka (IM Advisor) <lib....@pu-ami.org > <mailto:lib....@pu-ami.org>> > Cc: dhis2-us...@lists.launchpad.net <mailto:dhis2-us...@lists.launchpad.net>; > DHIS 2 Developers list <dhis2-devs@lists.launchpad.net > <mailto:dhis2-devs@lists.launchpad.net>> > Subject: Re: [Dhis2-devs] 2.29 upgrade script error > > Hi there Bernard, > that was strange - your 2.28 database should have contained the table > userroleprogram. > Assuming you are running 2.28, can you try running this query on your command > line? > \dt userrole* > Expecting that one of the lines output is: > public | userroleprogram | table | dhis > > > Best regards, > Markus > > >> 9. mar. 2018 kl. 10:04 skrev Bernard Sadaka (IM Advisor) <lib....@pu-ami.org >> <mailto:lib....@pu-ami.org>>: >> >> Dear All, >> I am trying to migrate from 2.28 (aff610f) to 2.29, by first running the >> upgrade script and then updating the .war file. >> However I am stuck at the upgrade script with this error: >> <image001.png> >> Please advise. >> >> All the best, >> Bernard >> >> <image002.png> >> Bernard Sadaka >> Information Management Advisor >> Première Urgence - Aide Médicale Internationale >> Nehmeh Building, Sanine Street, Chiyah, 3rd Floor >> Ain el Remmaneh, Beirut, Lebanon >> E-mail: lib....@pu-ami.org <mailto:lib....@pu-ami.org> >> Cell: +961 71 004 881 (208) >> Skype: imapuami >> Website: https://www.pu-ami.org <https://www.pu-ami.org/> >> >> >> >> <image002.jpg> >> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=icon> >> >> Virus-free. www.avast.com >> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=link> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-devs >> <https://launchpad.net/~dhis2-devs> >> Post to : dhis2-devs@lists.launchpad.net >> <mailto:dhis2-devs@lists.launchpad.net> >> Unsubscribe : https://launchpad.net/~dhis2-devs >> <https://launchpad.net/~dhis2-devs> >> More help : https://help.launchpad.net/ListHelp >> <https://help.launchpad.net/ListHelp> >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
