6.0.0-beta1
8/1/25

[#1034] creation of new event fails on SQL error
Summary creation of new event fails on SQL error
Queue Kronolith
Queue Version 2.0
Type Bug
State Not A Bug
Priority 2. Medium
Owners
Requester imp (at) mavetju (dot) org
Created 12/30/2004 (7519 days ago)
Due
Updated 01/03/2005 (7515 days ago)
Assigned 12/31/2004 (7518 days ago)
Resolved 01/03/2005 (7515 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
01/03/2005 03:05:43 AM Chuck Hagenbuch State ⇒ Not A Bug
 
01/03/2005 03:01:07 AM imp (at) mavetju (dot) org Comment #3 Reply to this comment
Please close this one, it was caused by the invalid permissions to 
add/update/delete events in the kronolith application.

Sorry for the noise.


12/31/2004 04:48:50 AM Chuck Hagenbuch Comment #2
State ⇒ Feedback
Reply to this comment
This doesn't make much sense - why does a SELECT statement cause 
adding an event to fail? Are you sure these two things are related?
12/30/2004 12:01:16 PM imp (at) mavetju (dot) org Comment #1
State ⇒ Unconfirmed
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ creation of new event fails on SQL error
Queue ⇒ Kronolith
Reply to this comment
When trying to add a new event (Organizing -> Calendar -> New Event), 
it fails because of a bad SQL statement with regarding to the 
event_end statements:



SELECT event_id, event_uid, event_description, event_location, event_s

tatus, event_attendees, event_keywords, event_title, event_category, event_

recurtype, event_recurenddate, event_recurinterval, event_recurdays, event_

start, event_end, event_alarm, event_modified, event_exceptions, event_crea

tor_id FROM kronolith_events WHERE calendar_id = 'edwin' AND ((event_end >

'-001-11-27 00:00:00' AND event_start < '2004-01-02 00:00:00') OR (event_re

curenddate >= '-001-11-27 00:00:00' AND event_start <= '2004-01-02 00:00:00

' AND event_recurtype != 0)).



Invalid input syntax for type timestamp: "-001-11-27 00:00:00"



(this error is shown in the log of the database server, it doesn't 
show up in Kronolith itself)



This is with a PostgreSQL database backend.



If you need more information please let me know.


Saved Queries