Thanks Tran, It is working with that correction. Sumudu
On Wed, Sep 17, 2014 at 6:13 AM, Tran Chau <tran.hispviet...@gmail.com> wrote: > 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