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-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
