dhis2-devs team mailing list archive

[Juma Lungo <jlungo@xxxxxxxxx>]

Dear Lars

Where can i access the database schema upgrade commands so that i can update the database manually by issueing those SQL commands one by one.

Lungo



________________________________
 From: Lars Helge Øverland <larshelge@xxxxxxxxx>
To: Juma Lungo <jlungo@xxxxxxxxx> 
Cc: dhis2-devs <dhis2-devs@xxxxxxxxxxxxxxxxxxx>; bharath kumar <chbharathk@xxxxxxxxx> 
Sent: Wednesday, January 16, 2013 1:36 PM
Subject: Re: [Dhis2-devs] DHIS2.10 Report Table Errors
 


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
>
>