[kronolith] Changing event start date/time

[Jan Schneider]

Zitat von Philipp Faeustlin <Philipp.Faeustlin at uni-hohenheim.de>:

> Am 28.04.2016 um 16:48 schrieb Philipp Faeustlin:
>> Am 27.04.2016 um 17:42 schrieb Michael J Rubinsky:
>>>
>>> Quoting Philipp Faeustlin <Philipp.Faeustlin at uni-hohenheim.de>:
>>>
>>>> Am 14.04.2016 um 15:11 schrieb Michael J Rubinsky:
>>>>>
>>>>> Quoting Test <philipp.faeustlin at uni-hohenheim.de>:
>>>>>
>>>>>> Am 13.04.2016 um 14:37 schrieb Michael J Rubinsky:
>>>>>>>
>>>>>>> Quoting Philipp Faeustlin <Philipp.Faeustlin at uni-hohenheim.de>:
>>>>>>>
>>>>>>>> Hi,
>>>>>>>>
>>>>>>>> I think found an fault or at least an unwanted behaviour.
>>>>>>>>
>>>>>>>> When editing an existing event start to empty fields and saving that
>>>>>>>> event.
>>>>>>>>
>>>>>>>> The results is an event that starts probably at day 0 in year 0. I
>>>>>>>> didn't scroll back that far, but the database entry for that event
>>>>>>>> says event_start = "0000-00-00 00:00:00".
>>>>>>>> The problem now is, as user your don't have a possibility to resolve
>>>>>>>> your mistake, because you're unable to edit or remove this event.
>>>>>>>>
>>>>>>>> As admin I had to change the event_start on database layer, to be
>>>>>>>> able
>>>>>>>> to edit the event again.
>>>>>>>>
>>>>>>>> I think it shouldn't be possible to save an event with empty
>>>>>>>> date, or
>>>>>>>> it should automatically save an working date (for example midnight
>>>>>>>> same day).
>>>>>>>>
>>>>>>>> Regards
>>>>>>>>
>>>>>>>> Philipp
>>>>>>>>
>>>>>>>> PS.: Tested with current firefox, chrome and up-to-date version of
>>>>>>>> horde.
>>>>>>>
>>>>>>> Can you describe how you are emptying the event start field(s)? We
>>>>>>> already have code in place that prevents saving the event when the
>>>>>>> date
>>>>>>> field doesn't validate. I can't reproduce this locally - I get the
>>>>>>> expected error message in a notification bubble when trying to save.
>>>>>>>
>>>>>>>
>>>>>> In the edit event window I remove the content of "From","at" per
>>>>>> keyboard. On my system there is no notification bubble.
>>>>>>
>>>>>> How is the date field validated?
>>>>>
>>>>> It's validated in javascript when the field loses focus and checked
>>>>> again when the event is saved. If the form field is not parse-able into
>>>>> a date value, the event is not allowed to be saved. I just tested this
>>>>> again on the demo site at demo.horde.org and it works as expected.
>>>>
>>>> I can reproduce it, also on the demo site.
>>>> I tested it with user "demo".
>>>> I added a new calender "ChangingEvent" in this calendar I add an event
>>>> "Event unable to change" with empty startdate and starttime.
>>>
>>> That's the thing, I can't add an event with an empty startdate and/or
>>> starttime. There is a bubble notification in the lower left that tells
>>> me what is wrong, and the event form won't save/close until this is
>>> fixed. I just tried this on the demo site. I don't know how you are
>>> saving the event, though it obviously did save since I see the event
>>> there.
>>>
>>> Tested on latest FF, Chrome, and Safari.
>> As you can see I did some more testing and had no problem repeating that
>> fault.
>>
>> Test System was Win 7 Enterprise SP1 with Firefox 43 and later updated
>> to Firefox 46. I disable any Popup Blocking and there are no Plugins.
>>
>> The problem is only located on from date field.
>> I can enter "xyz" then I get a message in the lower right about bad
>> format and then I'm unable to save it until I insert some valid date.
>> After entering the valid date switching focus to description and then
>> marking the "from date field" and pressing "DEL" on Keyboard. I can
>> focus where ever I want there is no more error message and the event
>> will save in this faulty state.
>>
>
> I found some events in my kronolith_events table with event_start  
> and/or event_end set as "0000-00-00 00:00:00".
>
> Are these events all faulty events, which there are by accident?
> Or is there an event type which uses that zero event time for some  
> special purpose?

No, there shouldn't be any events with an empty start/end date.

-- 
Jan Schneider
The Horde Project
http://www.horde.org/