Hi Sumudu, I am sorry I sent wrong statements by mistake. The *status *column should be change to* varchar(25)*. Could you please run the statements below and re-start tomcat ?
*ALTER TABLE programstageinstance MODIFY status varchar(25);* *UPDATE programstageinstance SET status='ACTIVE' WHERE status='0';* *UPDATE programstageinstance SET status='COMPLETED' WHERE status='1';* *UPDATE programstageinstance SET status='SKIPPED' WHERE status='5';* Best regards, ------------------------------------------------ Châu Thu Trân HISP Viet Nam Email: tran.hispviet...@gmail.com On Tue, Sep 16, 2014 at 10:37 PM, sumudu weerasinghe <sumudu...@gmail.com> wrote: > Hi Tran, > I tried it but there is error in some query. My database "status" is a > integer. > I got following error? > > > > > > > > > > > > > > > > *mysql> ALTER TABLE programstageinstance MODIFY status INTEGER;Query OK, 0 > rows affected (0.10 sec)Records: 0 Duplicates: 0 Warnings: 0mysql> UPDATE > programstageinstance SET status='ACTIVE' WHERE status='0';ERROR 1366 > (HY000): Incorrect integer value: 'ACTIVE' for column 'status' at > row 2mysql> UPDATE programstageinstance SET status='COMPLETED' WHERE > status='1';ERROR 1366 (HY000): Incorrect integer value: 'COMPLETED' for > column 'status' atrow 1mysql> UPDATE programstageinstance SET > status='SKIPPED' WHERE status='5';Query OK, 0 rows affected (0.00 sec)Rows > matched: 0 Changed: 0 Warnings: 0mysql>* > > Sumudu > > > On Tue, Sep 16, 2014 at 7:47 PM, Tran Chau <tran.hispviet...@gmail.com> > wrote: > >> Hi Sumudu, >> >> Could you please run these statements below in your database directly to >> fix this bug ? Then restart tomcat again ? >> >> *ALTER TABLE programstageinstance MODIFY status INTEGER;* >> *UPDATE programstageinstance SET status='ACTIVE' WHERE status='0';* >> *UPDATE programstageinstance SET status='COMPLETED' WHERE status='1';* >> *UPDATE programstageinstance SET status='SKIPPED' WHERE status='5';* >> >> >> Best regards, >> ------------------------------------------------ >> Châu Thu Trân >> HISP Viet Nam >> Email: tran.hispviet...@gmail.com >> >> On Tue, Sep 16, 2014 at 8:56 PM, sumudu weerasinghe <sumudu...@gmail.com> >> wrote: >> >>> Sorry, my system detail as follow >>> *Version: 2.16**Build revision:16414**Database type:MySQL* >>> *Java version:1.7.0_04**OS name:Windows 7* >>> >>> >>> On Tue, Sep 16, 2014 at 7:23 PM, sumudu weerasinghe <sumudu...@gmail.com >>> > wrote: >>> >>>> Dear all , >>>> I have updated my instance from 2.15 to 2.16 over the old mysql >>>> database. Then i list the clinic patient . But it was unable to go for >>>> patient dashboard through the list and give error as exception occur (shown >>>> in screen shot). Log also show some error. Log and screenshots are attached >>>> here. >>>> >>>> Regards, >>>> Sumudu >>>> >>> >>> >> >
_______________________________________________ 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
