Re: [Dhis2-devs] dhis2.16 SQLSyntax Error

2014-08-31 Thread Tran Chau
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, -

Re: [Dhis2-devs] dhis2.16 SQLSyntax Error

2014-08-30 Thread Yemi Awe
I am adding to the above... Running Analytics Report Data truncation for column messagetext.. The table message defaults messagetext to 255 char. The column not given a length value in the jpa entity...please check. 2.16 will not throw any error in the log but will continue to update event table

[Dhis2-devs] dhis2.16 SQLSyntax Error

2014-08-29 Thread Yemi Awe
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 ver