dhis2-devs team mailing list archive

[sumudu weerasinghe <sumuduw00@xxxxxxxxx>]

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.hispvietnam@xxxxxxxxx>
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.hispvietnam@xxxxxxxxx
>
> On Tue, Sep 16, 2014 at 8:56 PM, sumudu weerasinghe <sumuduw00@xxxxxxxxx>
> 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 <sumuduw00@xxxxxxxxx>
>> 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
>>>
>>
>>
>