dhis2-devs team mailing list archive

[Abyot Gizaw <abyota@xxxxxxxxx>]

Yes the upgrade script was supposed to take care of that. Try to manually
clear and see if the error goed.

See here
https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/rename-patient-to-trackedentity.sql

-- relationship

ALTER TABLE relationship RENAME COLUMN patientaid TO
trackedentityinstanceaid;ALTER TABLE relationship RENAME COLUMN
patientbid TO trackedentityinstancebid;ALTER TABLE relationship RENAME
CONSTRAINT fk_relationship_patientida TO
fk_relationship_trackedentityinstanceida;ALTER TABLE relationship
RENAME CONSTRAINT fk_relationship_patientidb TO
fk_relationship_trackedentityinstanceidb;





On Thu, Jun 25, 2015 at 3:17 PM Jason Pickering <jason.p.pickering@xxxxxxxxx>
wrote:

> It has been upgraded from and earlier version. Maybe this needs to be
> deleted or missing in an upgrade script?
>
> On Thu, Jun 25, 2015, 15:12 Abyot Gizaw <abyota@xxxxxxxxx> wrote:
>
>> Hi Jason,
>>
>> Seems a database issue... it complains about missing "patientaid". Is
>> this really a 2.19 db?
>>
>> Thank you,
>> Abyot.
>>
>> On Thu, Jun 25, 2015 at 12:37 PM Jason Pickering <
>> jason.p.pickering@xxxxxxxxx> wrote:
>>
>>> I have posted the full stack trace here. Occurs when attempting to save
>>> a new relationship.
>>>
>>> http://pastebin.com/ap1XxWea
>>>
>>> Version:2.19Build revision:19247
>>> Regards,Jason
>>>
>>>
>>>  _______________________________________________
>>> 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
>>>
>> --
>> ----
>> Thank you,
>> Abyot
>>
> --
----
Thank you,
Abyot