← Back to team overview

dhis2-devs team mailing list archive

Re: Error When Running 2.19 SQL Update Script

 

Hi Dan,

I've added an additional statement to the script now which adds the column,
please try again.

Lars


On Wed, May 13, 2015 at 11:18 PM, Dan Cocos <dan@xxxxxxxxxxxx> wrote:

> Hi All,
>
> When updating servers to run 2.19 running the update SQL (
> https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/upgrade-219.sql
> )
>
> I get the following error.
>
> psql:update219.sql:8: ERROR:  column pi.organisationunitid does not exist
> LINE 5: where pi.organisationunitid is null;
>
>
> Is this expected?
>
> Thanks,
> Dan
>
>
>
>
>
> *Dan Cocos*
> BAO Systems
> www.baosystems.com
> T: +1 202-352-2671 | skype: dancocos
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>

References