dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Hi,

is there any of the Indian developers who have experienced something
similar on MySQL and have something to share?

The tracker modules still see some database changes and I am not sure if
the upgrade scripts are well tested on mysql.


Lars


On Tue, Jan 15, 2013 at 9:41 PM, Juma Lungo <jlungo@xxxxxxxxx> wrote:

> Dear all
>
> I have made upgrade from 2.9 to 2.10 Build version 9124 of Jan 12, 2013.
>
> Surprisingly, some of report tables are not pulling out data values. As a
> results i get blank reports.
>
> I have also got many errors when the system is getting started. See the
> errors messages here http://pastebin.com/E5Z4Ayxt
>
> Specifically, i am worried by these two error messages:
> (1) 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
> ',`zimbabwerbf`.`organisationunit`.`comment`=null,`zimbabwerbf`.`organisationuni'
> at line 1
>
> and
>
> (2) 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
> ',`zimbabwerbf`.`dataelement`.`valuetype`='int',`zimbabwerbf`.`dataelement`.`num'
> at line 1
>
> Please help
>
> Lungo
>
>
> _______________________________________________
> 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
>
>