dhis2-devs team mailing list archive

[sumudu weerasinghe <sumuduw00@xxxxxxxxx>]

Thanks Tran,
It is working with that correction.

Sumudu

On Wed, Sep 17, 2014 at 6:13 AM, Tran Chau <tran.hispvietnam@xxxxxxxxx>
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.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
>>>>>
>>>>
>>>>
>>>
>>
>