Install on PostGres throws error with fixed query
shunting - October 23, 2008 - 15:35
| Project: | Autosave |
| Version: | 6.x-1.1 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
Here is the warning:
user warning: query: CREATE TABLE autosaved_forms ( form_id varchar(64) NOT NULL, path varchar(255) NOT NULL, uid (11) NOT NULL default 0, timestamp (11) NOT NULL default 0, serialized text NOT NULL, PRIMARY KEY (form_id, path, uid) ) in /Library/WebServer/Documents/drupal/includes/database.inc on line 514.The query generated from the schema is this:
CREATE TABLE autosaved_forms (
form_id varchar(64) NOT NULL,
path varchar(255) NOT NULL,
uid int (11) NOT NULL default 0,
timestamp int (11) NOT NULL default 0,
serialized text NOT NULL,
PRIMARY KEY (form_id, path, uid)
)This query will work in PostGres however:
CREATE TABLE autosaved_forms (
form_id varchar(64) NOT NULL,
path varchar(255) NOT NULL,
uid integer NOT NULL default 0,
timestamp integer NOT NULL default 0,
serialized text NOT NULL,
PRIMARY KEY (form_id, path, uid)
)See here for interesting remarks on conversion.
#1
updated Dr5 dev version (not req in Dr6).. but i seem to have lost my CVS checkout of Dr5 by updating (it wrote over it with Dr6 version).
when i sort out how to co a branch in cvs i'll commit this.. i am not a cvs fan only use svn!!
#2
Not understanding why not in D6. The problem is in the autogenerate SQL in D6, yes? I'm running the module on a D6 site.