dhis2-devs team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

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@xxxxxxxxx> wrote:
> Thanks.
>
> On 9 March 2012 00:05, Jan Henrik Øverland <janhenrik.overland@xxxxxxxxx> 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@xxxxxxxxx> 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
>>
>>