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

[Jan Schneider]

Zitat von Andreas Haumer <andreas at xss.co.at>:

> -----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?

http://cvs.horde.org/diff.php/horde/scripts/sql/create.xml?r1=1.23&r2=1.24
Note the commit message.

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/