[kronolith] kronolith.sql and postgres

Jan Schneider jan@horde.org
Mon, 3 Dec 2001 14:55:18 +0100


Zitat von Paul Cooper <pgc@ucecom.com>:

> When I try to setup kronolith using postgresql with
> 
> psql horde < kronolith.sql
> 
> I get the following error message(s)
> 
> ERROR:  Bad timestamp external representation '0000-00-00 00:00:00'
> 
> It appears that postgres does not like 0000-00-00 00:00:00. I can't
> seem
> to find anything about this is the postgres docs but I think the reason
> is that it is an invalid date. The most minimal change I can make that
> postgres accepts is 0000-01-01 00:00:00. I've done a quick grep on
> kronolith code and can't seem to find the default anywhere so I'm
> guessing the code doesn't (yet) rely on the default value?

Correct. It's only there to make sure be have any timestamps at all in the 
table.
 
> Also I'd like to work on implementing shared calendars in kronolith -
> I've had a look around and found horde/lib/Category and
> horde/lib/Group.php which look like they might be about sharing horde
> data (calendar, tasks, addresses, etc). Any other docs or stuff I
> should
> be aware of before I start hacking.

The group/category stuff is work in progress. So the code will probably 
change and break things and documentation is only in the sources.

Jan.

::::::::::::::::::::::::::::::::::::::::
AMMMa AG - discover your knowledge
:::::::::::::::::::::::::::
Detmolder Str. 25-33 :: D-33604 Bielefeld
fon +49.521.96878-0 :: fax  +49.521.96878-20
http://www.ammma.de
::::::::::::::::::::::::::::::::::::::::::::::