SQL errors on 5.x install
| Project: | Password policy |
| Version: | 5.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
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.
| Attachment | Size |
|---|---|
| password_policy_install_sql_fix.patch | 1.01 KB |

#1
This is already addressed in the 5.x dev version.
#2
Automatically closed -- issue fixed for 2 weeks with no activity.