Missing commit notification emails from launchpad

Hi all,

As you have probably noticed there haven’t been any emails to our mailing list on code commits to the trunk branch since January 7th.

That doesn’t mean we are not coding on DHIS 2 any more!

Launchpad seems to have upgraded and are experiencing some issues at the moment.

Our dhis2-devs team (the mailing list team) is no longer subscribed to the trunk branch and for some odd reason is not allowed to subscribe there any more.

I have contacted the launchpad team and hope for a quick solution.

In the meantime you can follow all changes to the trunk branch here:

https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk

And if you are inpatient, you can also subscribe your own user (email) to receive notifications, on that same page.

Sorry for the trouble,

Ola

···

Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link

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

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@yahoo.com 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

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@gmail.com
To: Juma Lungo jlungo@yahoo.com
Cc: dhis2-devs dhis2-devs@lists.launchpad.net; bharath kumar chbharathk@gmail.com
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@yahoo.com 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

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

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@gmail.com

To: Juma Lungo jlungo@yahoo.com
Cc: dhis2-devs dhis2-devs@lists.launchpad.net; bharath kumar chbharathk@gmail.com

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

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.

···

On Wed, Jan 16, 2013 at 10:49 PM, Juma Lungo jlungo@yahoo.com wrote:

On Tue, Jan 15, 2013 at 9:41 PM, Juma Lungo jlungo@yahoo.com wrote:

Please help

Lungo


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Regards,
Brajesh

Brajesh

Thanks, a lot!

Let me give it a try

Lungo

···

From: Brajesh Murari brajesh2murari@gmail.com
To: Juma Lungo jlungo@yahoo.com
Cc: Lars Helge Øverland larshelge@gmail.com; dhis2-devs dhis2-devs@lists.launchpad.net; Jason Pickering jason.p.pickering@gmail.com; Morten Olav Hansen mortenoh@gmail.com; mithilesh.hisp@gmail.com
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@yahoo.com 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@gmail.com

To: Juma Lungo jlungo@yahoo.com
Cc: dhis2-devs dhis2-devs@lists.launchpad.net; bharath kumar chbharathk@gmail.com

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@yahoo.com 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Regards,
Brajesh