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

* Your Email Address
* Spam protection	Enter the letters below: __. __.. ..__..__ (__ (__ \|_/ [__][ __ .__).__)\| \\| \|[_./
Comment	> 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 > >
Attachment
Watch this ticket

Saved Queries