Posted by PaulchenPlump on February 6, 2009 at 11:31am
Jump to:
| Project: | SEO Checklist |
| Version: | 6.x-1.0-beta2 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
Issue Summary
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
Comments
#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