CiviCRM Community Forums (archive)

Hello All,

I have been trying to auto approve registration from Drupal 7 using the Rules module. The registration process requires approval from admin by default. I have added a rule to the new user create 1. unblock the account 2. add roles to the account for certain domains (example.org).

When I try to register using the domain, I get the error below.

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '152-5' for key 'PRIMARY': INSERT INTO {users_roles} (uid, rid) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1); Array ( [:db_insert_placeholder_0] => 152 [:db_insert_placeholder_1] => 5 ) in user_save() (line 579 of /var/www/mcua/htdocs/modules/user/user.module).