no pgsql support
spydmobile - February 11, 2009 - 00:19
| Project: | SimpleFeed |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
hi, installed in d6.9 on pgsql8.3.x and got:
* warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "(" LINE 9: error int(1) NOT NULL default 0, ^ in /var/www/sparcs/includes/database.pgsql.inc on line 139.
* user warning: query: CREATE TABLE simplefeed_feed ( vid int_unsigned NOT NULL, nid int_unsigned NOT NULL, url text, expires int NOT NULL default 0, refresh int NOT NULL default 0, checked int NOT NULL default 0, hash varchar(32), error int(1) NOT NULL default 0, PRIMARY KEY (vid) ) in /var/www/sparcs/includes/database.inc on line 515.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "simplefeed_feed" does not exist in /var/www/sparcs/includes/database.pgsql.inc on line 139.
* user warning: query: CREATE INDEX simplefeed_feed_nid_idx ON simplefeed_feed (nid) in /var/www/sparcs/includes/database.inc on line 515.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "simplefeed_feed" does not exist in /var/www/sparcs/includes/database.pgsql.inc on line 139.
* user warning: query: CREATE INDEX simplefeed_feed_error_idx ON simplefeed_feed (error) in /var/www/sparcs/includes/database.inc on line 515.This appears to be a database abstraction or postgres syntax issue. regardless its a show stopper for me :-(
#1
i dont know if this is the only problem, but there is something wrong in the simplefeed.install file:
'error' => array('type' => 'int',
'not null' => TRUE,
'default' => 0,
'length' => 1,
'description' => t("Whether the feed is throwing errors or not."),
Length is used for a type 'varchar' or 'text', its ignored for other field types. So that part should be something like this:
'error' => array('type' => 'int',
'not null' => TRUE,
'default' => 0,
'size' => 'tiny',
'description' => t("Whether the feed is throwing errors or not."),