chart not saving

Yes thats odd. TableAlteror has "executeSql( "ALTER TABLE chart
RENAME COLUMN title TO name" );" which should have done the trick.

Copying to devs list to see if anyone else has seen a problem like
this before filing a bug report.

Bob

···

On 9 March 2012 06:34, Bob Jolliffe <bobjolliffe@gmail.com> wrote:

Thanks.

On 9 March 2012 00:05, Jan Henrik Øverland <janhenrik.overland@gmail.com> wrote:

Hi Bragg, the "title" column is outdated so you can just delete it. Dunno
why it wasn't fixed by TableAlteror on startup. Say hello to Randy.

Jan

On Thu, Mar 8, 2012 at 16:54, Bob Jolliffe <bobjolliffe@gmail.com> wrote:

Hi Jan

I am here with randy making charts. When we tried to save favoites we
get a constraint violation:

* ERROR 2012-03-08 17:39:52,213 Batch entry 0 insert into chart (name,
uid, lastUpdated, domainAxisLabel, rangeAxisLabel, type, series,
category, filter, hideLegend, regression, hideSubtitle,
targetLineValue, targetLineLabel, reportingMonth, reportingQuarter,
lastSixMonth, thisYear, last12Months, last4Quarters, last2SixMonths,
lastYear, last5Years, userOrganisationUnit, userid, chartid) values
('test', 'I79zztW4r88', '2012-03-08 17:39:52.209000 +02:00:00',
'Month', 'Value', 'COLUMN', 'DATA', 'PERIOD', 'ORGANISATIONUNIT', '0',
'0', '0', NULL, '', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0',
'15168', '20180') was aborted. Call getNextException to see the
cause. (JDBCExceptionReporter.java [ajp-bio-8009-exec-6])
* WARN 2012-03-08 17:39:52,214 SQL Error: 0, SQLState: 23502
(JDBCExceptionReporter.java [ajp-bio-8009-exec-6])
* ERROR 2012-03-08 17:39:52,214 ERROR: null value in column "title"
violates not-null constraint (JDBCExceptionReporter.java
[ajp-bio-8009-exec-6])

Strange, I thought I dis this 2 days ago on my machine and it worked.

Anyway .. we can't see a place to enter a title (besides name). When
we remove the constraint of TITRLE NOT NULL everything seems to work
ok.

It seems strange that nobody has reported this. Is there some aspect
of the UI we have missed? Using dhis 2.7 from March 5.

Regards
Bob

Hi, don't think its a bug rather some mishap due to upgrade then
downgrade of versions.

Lars

···

On Fri, Mar 9, 2012 at 5:49 AM, Bob Jolliffe <bobjolliffe@gmail.com> wrote:

Yes thats odd. TableAlteror has "executeSql( "ALTER TABLE chart
RENAME COLUMN title TO name" );" which should have done the trick.

Copying to devs list to see if anyone else has seen a problem like
this before filing a bug report.

Bob

On 9 March 2012 06:34, Bob Jolliffe <bobjolliffe@gmail.com> wrote:

Thanks.

On 9 March 2012 00:05, Jan Henrik Øverland <janhenrik.overland@gmail.com> wrote:

Hi Bragg, the "title" column is outdated so you can just delete it. Dunno
why it wasn't fixed by TableAlteror on startup. Say hello to Randy.

Jan

On Thu, Mar 8, 2012 at 16:54, Bob Jolliffe <bobjolliffe@gmail.com> wrote:

Hi Jan

I am here with randy making charts. When we tried to save favoites we
get a constraint violation:

* ERROR 2012-03-08 17:39:52,213 Batch entry 0 insert into chart (name,
uid, lastUpdated, domainAxisLabel, rangeAxisLabel, type, series,
category, filter, hideLegend, regression, hideSubtitle,
targetLineValue, targetLineLabel, reportingMonth, reportingQuarter,
lastSixMonth, thisYear, last12Months, last4Quarters, last2SixMonths,
lastYear, last5Years, userOrganisationUnit, userid, chartid) values
('test', 'I79zztW4r88', '2012-03-08 17:39:52.209000 +02:00:00',
'Month', 'Value', 'COLUMN', 'DATA', 'PERIOD', 'ORGANISATIONUNIT', '0',
'0', '0', NULL, '', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0',
'15168', '20180') was aborted. Call getNextException to see the
cause. (JDBCExceptionReporter.java [ajp-bio-8009-exec-6])
* WARN 2012-03-08 17:39:52,214 SQL Error: 0, SQLState: 23502
(JDBCExceptionReporter.java [ajp-bio-8009-exec-6])
* ERROR 2012-03-08 17:39:52,214 ERROR: null value in column "title"
violates not-null constraint (JDBCExceptionReporter.java
[ajp-bio-8009-exec-6])

Strange, I thought I dis this 2 days ago on my machine and it worked.

Anyway .. we can't see a place to enter a title (besides name). When
we remove the constraint of TITRLE NOT NULL everything seems to work
ok.

It seems strange that nobody has reported this. Is there some aspect
of the UI we have missed? Using dhis 2.7 from March 5.

Regards
Bob

_______________________________________________
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

I think it might actually have been a series of upgrades through 2.6
snaphots. There must have been a short window where title and name
both existed. After which it was no longer possible to rename title
to name. No problem .. all is good.

···

On 9 March 2012 11:03, Lars Helge Øverland <larshelge@gmail.com> wrote:

Hi, don't think its a bug rather some mishap due to upgrade then
downgrade of versions.

Lars

On Fri, Mar 9, 2012 at 5:49 AM, Bob Jolliffe <bobjolliffe@gmail.com> wrote:

Yes thats odd. TableAlteror has "executeSql( "ALTER TABLE chart
RENAME COLUMN title TO name" );" which should have done the trick.

Copying to devs list to see if anyone else has seen a problem like
this before filing a bug report.

Bob

On 9 March 2012 06:34, Bob Jolliffe <bobjolliffe@gmail.com> wrote:

Thanks.

On 9 March 2012 00:05, Jan Henrik Øverland <janhenrik.overland@gmail.com> wrote:

Hi Bragg, the "title" column is outdated so you can just delete it. Dunno
why it wasn't fixed by TableAlteror on startup. Say hello to Randy.

Jan

On Thu, Mar 8, 2012 at 16:54, Bob Jolliffe <bobjolliffe@gmail.com> wrote:

Hi Jan

I am here with randy making charts. When we tried to save favoites we
get a constraint violation:

* ERROR 2012-03-08 17:39:52,213 Batch entry 0 insert into chart (name,
uid, lastUpdated, domainAxisLabel, rangeAxisLabel, type, series,
category, filter, hideLegend, regression, hideSubtitle,
targetLineValue, targetLineLabel, reportingMonth, reportingQuarter,
lastSixMonth, thisYear, last12Months, last4Quarters, last2SixMonths,
lastYear, last5Years, userOrganisationUnit, userid, chartid) values
('test', 'I79zztW4r88', '2012-03-08 17:39:52.209000 +02:00:00',
'Month', 'Value', 'COLUMN', 'DATA', 'PERIOD', 'ORGANISATIONUNIT', '0',
'0', '0', NULL, '', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0',
'15168', '20180') was aborted. Call getNextException to see the
cause. (JDBCExceptionReporter.java [ajp-bio-8009-exec-6])
* WARN 2012-03-08 17:39:52,214 SQL Error: 0, SQLState: 23502
(JDBCExceptionReporter.java [ajp-bio-8009-exec-6])
* ERROR 2012-03-08 17:39:52,214 ERROR: null value in column "title"
violates not-null constraint (JDBCExceptionReporter.java
[ajp-bio-8009-exec-6])

Strange, I thought I dis this 2 days ago on my machine and it worked.

Anyway .. we can't see a place to enter a title (besides name). When
we remove the constraint of TITRLE NOT NULL everything seems to work
ok.

It seems strange that nobody has reported this. Is there some aspect
of the UI we have missed? Using dhis 2.7 from March 5.

Regards
Bob

_______________________________________________
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