Sql-Error after installing module
PaulchenPlump - February 6, 2009 - 11:31
| Project: | SEO Checklist |
| Version: | 6.x-1.0-beta2 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
Hi,
I received this error after installing modules:
warning: pg_query() [function.pg-query]: Query failed: ERROR: date/time field value out of range: "0000-00-00 00:00:00" HINT: Perhaps you need a different "datestyle" setting. in /var/www/drupal/includes/database.pgsql.inc on line 138.
user warning: query: CREATE TABLE seo_checklist ( id serial, group_id smallint NOT NULL default 0, subgroup_id smallint NOT NULL default 0, name varchar(255) NOT NULL default '', module varchar(255) NOT NULL default '', option_checked smallint NOT NULL default 0, date_changed timestamp NOT NULL default '0000-00-00 00:00:00', linked_seo smallint NOT NULL default 0, checked_module smallint NOT NULL default 0, extra2 smallint NOT NULL default 0, extra3 smallint NOT NULL default 0, download varchar(255) NOT NULL default '', enable varchar(255) NOT NULL default '', configure varchar(255) NOT NULL default '', order_id smallint NOT NULL default 0, PRIMARY KEY (id) ) in /var/www/drupal/includes/database.inc on line 514.
warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "`" LINE 1: INSERT INTO seo_checklist (`id`, `group_id`, `subgroup_id`, ... ^ in /var/www/drupal/includes/database.pgsql.inc on line 138.
...Postgresql does not like '0000-00-00 00:00:00' as the default for TIMESTAMP columns, will only accept a valid date and time.
IMHO it must not changed in SEOChecklist.install, but in database.pgsql.inc
#1
I don't know how to fix this problem. Does anyone want to offer a patch or point me in the right direction?
#2
Try 2.0. Download it here: Drupal SEO Checklist