dhis2-devs team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

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@xxxxxxxxx> 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@xxxxxxxxx> 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@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
>>>>
>>>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp