dhis2-devs team mailing list archive

[Juma Lungo <jlungo@xxxxxxxxx>]

Brajesh

Thanks, a lot!

Let me give it a try

Lungo




________________________________
 From: Brajesh Murari <brajesh2murari@xxxxxxxxx>
To: Juma Lungo <jlungo@xxxxxxxxx> 
Cc: Lars Helge Øverland <larshelge@xxxxxxxxx>; dhis2-devs <dhis2-devs@xxxxxxxxxxxxxxxxxxx>; Jason Pickering <jason.p.pickering@xxxxxxxxx>; Morten Olav Hansen <mortenoh@xxxxxxxxx>; mithilesh.hisp@xxxxxxxxx 
Sent: Wednesday, January 16, 2013 10:33 PM
Subject: Re: [Dhis2-devs] DHIS2.10 Report Table Errors
 

My Dear Friend Lungo,

Wish you a very happy new year 2013. Hope you would be doing fine.
You can find required mysql-dhis-upgrade-2.3.sql script on the link given below

http://bazaar.launchpad.net/~dhis2-devs-core/dhis2/2.10/view/head:/resources/sql/mysql-dhis-upgrade-2.3.sql

It was last updated on 2011-07-08 by one of great DHIS 2 core developer and might include updates according to DHIS 2.10 mile stone release, but i am not pretty much sure actually, lets it should be more clear by Jason, Morten and Mithilesh Kumar Thakur, one of open source Indian DHIS2 Core Developer, we can aspect Mithilesh might be faced such scenario given in trail mail during functional / technical testing of DHIS 2.10 release in India overseas.

Regards,
Brajesh



On Wed, Jan 16, 2013 at 10:49 PM, Juma Lungo <jlungo@xxxxxxxxx> wrote:

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
>>
>>
>>
No doubt Lungo, in both massages pretty beautiful exception thrown is the same actually.

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


-- 
Regards,
Brajesh