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 <[email protected]> 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 <[email protected]> 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 < >> [email protected]> 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 : [email protected] >>> Unsubscribe : https://launchpad.net/~dhis2-devs >>> More help : https://help.launchpad.net/ListHelp >>> >> -- >> ---- >> Thank you, >> Abyot >> > -- ---- Thank you, Abyot
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
