As reported by nortont, User restrictions causes the following error:

PDOException: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens: SELECT ur.urid AS urid FROM {user_restrictions} ur WHERE (type = :type AND LOWER(:mask) = LOWER(mask)) ; Array ( [status] => 0 [type] => [mask] => %@lawnlesson.com [submit] => Save rule [form_build_id] => form-80LQ3u9f-f6oGiyQdRmyldBjkeS4dHzy4ZehYmRg3M8 [form_token] => EgNLqBx_fB0kPIawJAUvQC84Go4_F7yb8YzupcnDAos [form_id] => user_restrictions_ui_edit_rule_form [op] => Save rule ) in UserRestrictions::exists() (line 114 of /home/nortroni/public_html/drupal/sites/all/modules/user_restrictions/user_restrictions.classes.inc)

I have changed the code to avoid the error. I am just returned from my trip on USA, and I will commit the code as soon as I can.

Comments

BenK’s picture

BenK commented

Subscribing

nortont’s picture

nortont commented

Any Fix?

kemalo’s picture

kemalo commented

Any Fix? Got the same problems.

justkristin’s picture

justkristin commented

Same here.

mikejonesok’s picture

mikejonesok commented

Same issue. Is this project still alive? I cannot get the module to work without the fix. Thanks!

vatavale’s picture

vatavale commented

same issue

barrett’s picture

barrett commented

The patch attached to comment 7 in #1037428: Form elements missing (http://drupal.org/comment/edit/4286166#comment-4286166) attempts to address this.

zolo’s picture

zolo commented

http://drupal.org/files/issues/user_restrictions_0.patch :)

fizk’s picture

fizk commented
Status: Active » Closed (duplicate)

Marking duplicate of #1214080: Patch to make the module usable