Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
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
Comment #1
liquidcms CreditAttribution: liquidcms commentedupdated 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!!
Comment #2
shunting CreditAttribution: shunting commentedNot understanding why not in D6. The problem is in the autogenerate SQL in D6, yes? I'm running the module on a D6 site.
Comment #3
liquidcms CreditAttribution: liquidcms commentedclosing all 6.x-1.x issues as no longer supported - if this is not working on latest 6.x-2-dev please reopen