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.
| Comment | File | Size | Author |
|---|---|---|---|
| password_policy_install_sql_fix.patch | 1.01 KB | Anonymous (not verified) |
Comments
Comment #1
miglius commentedThis is already addressed in the 5.x dev version.