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 <[email protected]> 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 <[email protected]> > *To:* Juma Lungo <[email protected]> > *Cc:* dhis2-devs <[email protected]>; bharath kumar < > [email protected]> > *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 <[email protected]> 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 : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > > > > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- Regards, Brajesh
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
