| Summary | error creating tables with setup.php |
| Queue | Horde Groupware Webmail Edition |
| Queue Version | 1.2 |
| Type | Bug |
| State | Resolved |
| Priority | 1. Low |
| Owners | jan (at) horde (dot) org |
| Requester | greg (at) proxyconcept (dot) net |
| Created | 09/29/2008 (6113 days ago) |
| Due | |
| Updated | 10/24/2008 (6088 days ago) |
| Assigned | 10/07/2008 (6105 days ago) |
| Resolved | 10/24/2008 (6088 days ago) |
| Github Issue Link | |
| Github Pull Request | |
| Milestone | |
| Patch | No |
State ⇒ Resolved
http://cvs.horde.org/co.php/groupware/patches/pear-MDB2-Schema-Validate.php.patch?r=1.1
Assigned to Jan Schneider
Patch ⇒ No
State ⇒ Assigned
Priority ⇒ 1. Low
Type ⇒ Bug
Summary ⇒ error creating tables with setup.php
Queue ⇒ Horde Groupware Webmail Edition
Milestone ⇒
Patch ⇒ Yes
State ⇒ Unconfirmed
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