Dear Markus, After a closer look, I found this table:
public | program_userroles | table | dhis Is it the same? All the best, Bernard 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: <mailto:lib....@pu-ami.org> 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] On Behalf Of Bernard Sadaka (IM Advisor) Sent: Friday, March 9, 2018 3:17 PM To: 'Markus Bekken' <mar...@dhis2.org> Cc: dhis2-us...@lists.launchpad.net; 'DHIS 2 Developers list' <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 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: <mailto:lib....@pu-ami.org> 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] 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: <mailto:lib....@pu-ami.org> lib....@pu-ami.org Cell: +961 71 004 881 (208) Skype: imapuami Website: <https://www.pu-ami.org/> https://www.pu-ami.org <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=icon> Virus-free. <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=link> www.avast.com _______________________________________________ Mailing list: <https://launchpad.net/~dhis2-devs> https://launchpad.net/~dhis2-devs Post to : <mailto:dhis2-devs@lists.launchpad.net> 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 --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
_______________________________________________ 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
