| Summary | postgresql 8.4.1 error "date/time field value out of range" using iCal/WebDAV |
| Queue | Kronolith |
| Queue Version | 2.3.2 |
| Type | Bug |
| State | Resolved |
| Priority | 2. Medium |
| Owners | jan (at) horde (dot) org |
| Requester | tx4587 (at) crawford (dot) homeunix (dot) mnet |
| Created | 09/21/2009 (5755 days ago) |
| Due | |
| Updated | 01/13/2010 (5641 days ago) |
| Assigned | |
| Resolved | 09/25/2009 (5751 days ago) |
| Github Issue Link | |
| Github Pull Request | |
| Milestone | 2.3.3 |
| Patch | Yes |
Don't make up fake dates for searching events without start or end
limits (
Bug #8590).http://git.horde.org/diff.php/kronolith/lib/Driver/Sql.php?rt=horde-git&r1=95d623ef3b92818099d9621d625546aa47257530&r2=faf3dd69fb00ec2f73046aa5f29968af9648d734
Assigned to Jan Schneider
State ⇒ Resolved
Milestone ⇒ 2.3.3
MFH: Don't make up fake dates for searching events without start or
end limits (
Bug #8590).http://cvs.horde.org/diff.php/kronolith/lib/Driver/sql.php?rt=horde&r1=1.136.2.44&r2=1.136.2.45&ty=u
Don't make up fake dates for searching events without start or end
limits (
Bug #8590).http://git.horde.org/diff.php/kronolith/lib/Driver/Sql.php?rt=horde-hatchery&r1=95d623ef3b92818099d9621d625546aa47257530&r2=faf3dd69fb00ec2f73046aa5f29968af9648d734
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ postgresql 8.4.1 error "date/time field value out of range" using iCal/WebDAV
Queue ⇒ Kronolith
Milestone ⇒
Patch ⇒ Yes
New Attachment: kronolith_sql.patch
State ⇒ Unconfirmed
out of range error during the query to the postgresql 8.4.1 server.
The query that causes the error follows:
Sep 21 11:23:57 HORDE [error] [kronolith] DB Error: unknown error:
SELECT event_id, event_uid, event_description, event_location,
event_private, event_status, event_at
tendees, event_keywords, event_title, event_category,
event_recurcount, event_recurtype, event_recurenddate,
event_recurinterval, event_recurdays, event_start, event_e
nd, event_alarm, event_modified, event_exceptions, event_creator_id
FROM kronolith_events WHERE calendar_id = 'username' AND ((event_end >
'0000-01-01 00:00:00' AND event_start < '9999-12-31 00:00:00') OR
(event_recurenddate >= '0000-01-01 00:00:00' AND event_start <=
'9999-12-31 00:00:00' AND event_recurtype <> 0)) [nativecode=ERROR:
date/time field value out of range: "0000-01-01 00:00:00" at character
406] [pid 13841 on line 331 of
"/var/www/html/horde-webmail-1.2.4/kronolith/lib/Driver/sql.php"]
Postgresql doesn't like the timestamp "0000-01-01 00:00:00". Modifying
the file "kronolith/lib/Driver/sql.php" to what is in the patch fixes
the problem.