[Tickets #7409] error creating tables with setup.php

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/7409
------------------------------------------------------------------------------
  Ticket             | 7409
  Created By         | greg at proxyconcept.net
  Summary            | error creating tables with setup.php
  Queue              | Horde Groupware Webmail Edition
  Version            | 1.2
  Type               | Bug
  State              | Unconfirmed
  Priority           | 1. Low
  Milestone          |
  Patch              | 1
  Owners             |
------------------------------------------------------------------------------


greg at proxyconcept.net (2008-09-29 14:02) wrote:

When I launch ./scripts/setup.php and try to create database tables, I  
have this error :

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: ERREUR:  Valeur du champ date/time en dehors des  
limites : «0000-00-00 00:00:00»
HINT:  Peut-être avez-vous besoin d'un paramètrage «datestyle» différent.]

The timestamps default values are bad : maybe '0000-00-00 00:00:00'  
have a correct syntax but it's not a valid date. I replace this  
default date with '0001-01-01 00:00:00' and the script runs fine.

So quick correction :
perl -i.orig -pe "s/0000\-00\-00/0001-01-01/g" ./scripts/sql/create.xml