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.hispviet...@gmail.com On Sat, Aug 30, 2014 at 3:35 AM, Yemi Awe <j2y...@gmail.com> 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@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ 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
