dhis2-devs team mailing list archive

[Morten Olav Hansen <mortenoh@xxxxxxxxx>]

Hi

You need to first run DHIS2 2.19 one time, so it can create the column
(this was new in 2.19), and then you can run the script to update legacy
data (we now have a orgUnit pointer on enrollment/programInstance)

--
Morten

On Thu, May 14, 2015 at 3:18 AM, 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
>
>