[Tickets #11886] Re: Event notifications do not work for the current day

[noreply at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/11886
------------------------------------------------------------------------------
  Ticket             | 11886
  Updated By         | Thomas Jarosch <thomas.jarosch at intra2net.com>
  Summary            | Event notifications do not work for the current day
  Queue              | Kronolith
  Version            | Git master
  Type               | Bug
-State              | Unconfirmed
+State              | Not A Bug
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             | Jan Schneider
------------------------------------------------------------------------------


Thomas Jarosch <thomas.jarosch at intra2net.com> (2012-12-17 17:04) wrote:

Bug in my sqlite 3.6.22 version.

Horde alarm issues this query:

SELECT alarm_id, alarm_uid, alarm_start, alarm_end, alarm_methods,  
alarm_params, alarm_title, alarm_text, alarm_snooze, alarm_internal  
FROM horde_alarms WHERE alarm_dismissed = 0 AND ((alarm_snooze IS NULL  
AND alarm_start <= '2012-12-17T16:26:22') OR alarm_snooze <=  
'2012-12-17T16:26:22') AND (alarm_end IS NULL OR alarm_end >=  
'2012-12-17T16:26:22') AND (alarm_uid IS NULL OR alarm_uid = '' OR  
alarm_uid = 'admin') ORDER BY alarm_start, alarm_end

-> sqlite returns nothing for this.

If I replace the "T" in the datetime in this query with a simple " ",  
sqlite returns the correct result. After returning the correct result,  
even the "T" version starts working.

-> I'll update my sqlite3 version soonish and try again.