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.

Comments

liquidcms’s picture

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!!

shunting’s picture

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.

liquidcms’s picture

Status: Active » Closed (won't fix)

closing all 6.x-1.x issues as no longer supported - if this is not working on latest 6.x-2-dev please reopen