dhis2-devs team mailing list archive

[Tran Chau <tran.hispvietnam@xxxxxxxxx>]

Hi Yemi,

The 1st and 2st bugs are fixed. Please test them again in your side.

For the 3rd, please stop your web-server and run the statement below in
your database directly. And then start your server again.

*ALTER TABLE programstageinstance MODIFY status varchar(25);*



Best regards,
------------------------------------------------
Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@xxxxxxxxx


On Sat, Aug 30, 2014 at 3:35 AM, Yemi Awe <j2yemi@xxxxxxxxx> wrote:

> Dear Developers,
> This error is on dhis2.16
>
> *1. Program Stage Completeness*
> *Running Program stage completeness returns this error*
>
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You
> have an error in your SQL syntax; check the manual that corresponds to your
> MySQL server version for the right syntax to use near 'by ou.name, ps.name,
> psi.completeduser, psi.completeddate, psi.status having psi' at line 1
>
>
>
> *2. Manual Aggregation (On 2.15 and 2.16)*
>
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You
> have an error in your SQL syntax; check the manual that corresponds to your
> MySQL server version for the right syntax to use near 'DOUBLE PRECISION ) )
> FROM trackedentitydatavalue pdv     INNER JOIN programstage' at line 1
>
> *3. Error ON Individual Records (2.16)*
> ProgramStageInstace Table with column 'STATUS' has a datatype 'INT' but
> inserts 'String' like 'ACTIVE', 'COMPLETED'
> Workaround is to change the data type to of 'STATUS' column.
> With this you data type mismatch getInt(1) error is thrown when running
> Program Stage Completeness.
>
>
>  Any quick fix for the above?
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>