Installing the 5.x alpha version of the module produces the following SQL errors -

* user warning: Key column 'id' doesn't exist in table query: CREATE TABLE password_policy_users ( uid int(10) unsigned NOT NULL default '0', pass varchar(32) NOT NULL default '', created int(11) NOT NULL default '0', KEY (id) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in /var/www/drupal-5.14/includes/database.mysql.inc on line 174.
* user warning: Key column 'id' doesn't exist in table query: CREATE TABLE password_policy_expiration ( uid int(10) unsigned NOT NULL, warning int(11) default NULL, blocked int(11) default NULL, unblocked int(11) default NULL, KEY (id) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in /var/www/drupal-5.14/includes/database.mysql.inc on line 174.

It appears that the install script is trying to set the KEY on `id` which doesn't exist, instead of `uid`.

Patch attached.

CommentFileSizeAuthor
password_policy_install_sql_fix.patch1.01 KBAnonymous (not verified)

Comments

miglius’s picture

Version: 5.x-1.0-alpha1 » 5.x-1.x-dev
Status: Needs review » Fixed

This is already addressed in the 5.x dev version.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.