Event: Prevent SQL errors with events without end

[friendica.git] / include / event.php

diff --git a/include/event.php b/include/event.php
index 0b6eb1020fccd452a28dbf6daac273c2e7827cc5..45fa7bcd59a15d738ddf28f86bff8900aab63942 100644 (file)
--- a/include/event.php
+++ b/include/event.php
@@ -243,12 +243,18 @@ function event_store($arr) {
 
        $arr['created'] = (($arr['created'])     ? DateTimeFormat::utc($arr['created']) : DateTimeFormat::utcNow());
        $arr['edited']  = (($arr['edited'])      ? DateTimeFormat::utc($arr['edited'])  : DateTimeFormat::utcNow());
+       $arr['start']   = (($arr['start'])       ? DateTimeFormat::utc($arr['start'])   : NULL_DATE);
+       $arr['finish']  = (($arr['finish'])      ? DateTimeFormat::utc($arr['finish'])  : NULL_DATE);
        $arr['type']    = (($arr['type'])        ? $arr['type']            : 'event' );
        $arr['cid']     = ((intval($arr['cid'])) ? intval($arr['cid'])     : 0);
        $arr['uri']     = (x($arr, 'uri')        ? $arr['uri']             : item_new_uri($a->get_hostname(), $arr['uid']));
        $arr['private'] = ((x($arr, 'private'))  ? intval($arr['private']) : 0);
        $arr['guid']    = get_guid(32);
 
+       if ($arr['finish'] < NULL_DATE) {
+               $arr['finish'] = NULL_DATE;
+       }
+
        if ($arr['cid']) {
                $c = q("SELECT * FROM `contact` WHERE `id` = %d AND `uid` = %d LIMIT 1",
                        intval($arr['cid']),