dhis2-devs team mailing list archive

[Tran Chau <tran.hispvietnam@xxxxxxxxx>]

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.hispvietnam@xxxxxxxxx

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