[horde] Setup error with Horde Webmail 1.2-rc1 and PostgreSQL-8.2.9

[Andreas Haumer]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi!

In order to check if the problem with horde-webmail-1.1.3 and
PostgreSQL-8.2.9 (see my other mail to this list a few minutes ago)
also exists with the current release candidate, I tried to install
horde-webmail-1.2-rc1, again with PostgreSQL-8.2.9 as database backend.

This time, I can't even configure the horde application using
the scripts/setup.php script... :-(

In step 2, "Create database or tables", I get the following error:

[...]
Loading database module...
Creating database...
[ ERROR! ] Creating the tables failed. Please see the manual at docs/INSTALL
~           for how to setup the database manually. Error messages:
MDB2 Error: unknown error
_doquery: [Error message: Could not execute statement]
[Last executed query: CREATE  TABLE horde_alarms (alarm_id VARCHAR(255) DEFAULT ' ' NOT NULL, alarm_uid VARCHAR(255) DEFAULT NULL, alarm_start TIMESTAMP without time zone DEFAULT '0000-00-00 00:00:00' NOT NULL, alarm_end TIMESTAMP without time zone DEFAULT '0000-00-00 00:00:00', alarm_methods VARCHAR(255) DEFAULT NULL, alarm_params TEXT, alarm_title VARCHAR(255) DEFAULT ' ' NOT NULL, alarm_text TEXT, alarm_snooze TIMESTAMP without time zone DEFAULT '0000-00-00 00:00:00', alarm_dismissed SMALLINT
DEFAULT 0 NOT NULL, alarm_internal TEXT)]
[Native message: ERROR:  date/time field value out of range: "0000-00-00 00:00:00"
HINT:  Perhaps you need a different "datestyle" setting.]
[...]

Any idea?

Seems to me, PostgreSQL is not the database of choice for
horde, is it?

- - andreas

- --
Andreas Haumer                     | mailto:andreas at xss.co.at
*x Software + Systeme              | http://www.xss.co.at/
Karmarschgasse 51/2/20             | Tel: +43-1-6060114-0
A-1100 Vienna, Austria             | Fax: +43-1-6060114-71
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFIznlcxJmyeGcXPhERAi3eAJ99iJRnvII/p31V/Tm9V7o3DEiAaQCePH6m
NGLJi+iJeNqA8KBqDheo1UM=
=jbRI
-----END PGP SIGNATURE-----