dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

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