[kronolith] still having problems with inability to save events

[Eric S. Johansson]

looking at the log from postgresql I see this error message after an 
attempt to insert data:

ExecInsert: Fail to add null value in not null attribute event_creator_id

googling for a subset of the error message gave me a bunch of database 
specific stuff that looked more like instructions on debugging code than 
something that was wrong.

In any case, the statements that led up to the error:

Nov 10 12:29:07 relay2 postgres[447]: [14-1] LOG:  query: SELECT 
DISTINCT e.event_id, e.event_recurtype FROM kronolith_events e WHERE 
e.calendar_id = 'esj at harvee.org'
Nov 10 12:29:07 relay2 postgres[447]: [14-2]  AND ((e.event_alarm > 0)) 
AND ((e.event_end > '2003-11-10 00:00:00' AND e.event_start < 
'2003-11-11 00:00:00') OR
Nov 10 12:29:07 relay2 postgres[447]: [14-3]  (e.event_recurenddate >= 
'2003-11-10 00:00:00' AND e.event_start <= '2003-11-11 00:00:00' AND 
e.event_recurtype != 0))
Nov 10 12:29:07 relay2 postgres[433]: [21] LOG:  query: BEGIN;ROLLBACK;
Nov 10 12:29:07 relay2 postgres[447]: [15] LOG:  query: BEGIN;ROLLBACK;
Nov 10 12:29:07 relay2 postgres[451]: [16] LOG:  query: BEGIN;ROLLBACK;
Nov 10 12:29:55 relay2 postgres[449]: [14] LOG:  query: SELECT 
NEXTVAL('kronolith_events_seq')
Nov 10 12:29:55 relay2 postgres[449]: [15-1] LOG:  query: INSERT INTO 
kronolith_events (event_id, event_title, event_description, 
event_category, event_location,
Nov 10 12:29:55 relay2 postgres[449]: [15-2]  event_keywords, 
event_exceptions, event_modified, event_start, event_end, event_alarm, 
event_recurtype, calendar_id)values
Nov 10 12:29:55 relay2 postgres[449]: [15-3]  ('5','Jefferson 
airplane','absolutely 
nondescript','2','Westford','','',1068485395,'2003-11-12 
09:00:00','2003-11-12
Nov 10 12:29:55 relay2 postgres[449]: [15-4] 
10:00:00',0,'0','esj at harveee.org')
Nov 10 12:29:55 relay2 postgres[449]: [16] ERROR:  ExecInsert: Fail to 
add null value in not null attribute event_creator_id
Nov 10 12:29:55 relay2 postgres[449]: [17] LOG:  query: BEGIN;ROLLBACK;
Nov 10 12:29:55 relay2 postgres[796]: [8-1] LOG:  query: SELECT DISTINCT 
e.event_id, e.event_recurtype FROM kronolith_events e WHERE 
e.calendar_id = 'esj at harvee.org'
Nov 10 12:29:55 relay2 postgres[796]: [8-2]  AND ((e.event_alarm > 0)) 
AND ((e.event_end > '2003-11-10 00:00:00' AND e.event_start < 
'2003-11-11 00:00:00') OR
Nov 10 12:29:55 relay2 postgres[796]: [8-3]  (e.event_recurenddate >= 
'2003-11-10 00:00:00' AND e.event_start <= '2003-11-11 00:00:00' AND 
e.event_recurtype != 0))
Nov 10 12:29:55 relay2 postgres[796]: [9-1] LOG:  query: SELECT DISTINCT 
e.event_id, e.event_recurtype FROM kronolith_events e WHERE 
e.calendar_id = 'esj at harvee.org'
Nov 10 12:29:55 relay2 postgres[796]: [9-2]  AND ((e.event_end > 
'2003-11-01 00:00:00' AND e.event_start < '2003-12-01 00:00:00') OR 
(e.event_recurenddate >= '2003-11-01
Nov 10 12:29:55 relay2 postgres[796]: [9-3]  00:00:00' AND e.event_start 
<= '2003-12-01 00:00:00' AND e.event_recurtype != 0))
Nov 10 12:29:55 relay2 postgres[796]: [10] LOG:  query: BEGIN;ROLLBACK;
Nov 10 12:29:56 relay2 postgres[450]: [35] LOG:  query: BEGIN;ROLLBACK;
Nov 10 12:29:56 relay2 postgres[432]: [20] LOG:  query: BEGIN;ROLLBACK;

looking at this error it seems like the database is complaining about 
kronolith giving it null values.  configuration problem or bug?

---eric