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