SQL errors on 5.x install

bblough - April 2, 2009 - 20:48
Project:Password policy
Version:5.x-1.x-dev
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:closed
Description

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.

AttachmentSize
password_policy_install_sql_fix.patch1.01 KB

#1

miglius - April 8, 2009 - 16:58
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.

#2

System Message - April 22, 2009 - 17:00
Status:fixed» closed

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

 
 

Drupal is a registered trademark of Dries Buytaert.