CiviCRM Community Forums (archive)

Hi

I am still working on my single civi multi-site setup and thought I had cracked it until I discovered an issue with a user (member) attempting to register for more than one Drupal site.

I have 5 sites I want members to join whichever site they wish creating a civi record. I also need the funtionality for the user to be able to also register a Drupal account on site 2, site 3 etc so they can enable their profile, blog etc

Problem is when trying to register a Drupal account on site 2 the user gets the following error...email changed

Database Error Code: Duplicate entry 'xxx@xxx.com-1' for key 'UI_uf_name_domain_id', 1062
Additional Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -5
    [message] => DB Error: already exists
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_uf_match (domain_id , uf_id , uf_name , contact_id ) VALUES ( 1 ,  159 , 'xxx@xxx.com' ,  135 )  [nativecode=1062 ** Duplicate entry 'xxx@xxx.com-1' for key 'UI_uf_name_domain_id']
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_uf_match (domain_id , uf_id , uf_name , contact_id ) VALUES ( 1 ,  159 , 'xxx@xxx.com' ,  135 )  [nativecode=1062 ** Duplicate entry 'xxx@xxx.com-1' for key 'UI_uf_name_domain_id']
    [to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_uf_match (domain_id , uf_id , uf_name , contact_id ) VALUES ( 1 ,  159 , 'xxx@xxx.com' ,  135 )  [nativecode=1062 ** Duplicate entry 'xxx@xxx.com-1' for key 'UI_uf_name_domain_id']"]
)[/i]

Is this something to do with UF_match...?

Is there any setting, or code, I can change to enable an email to be able to point to multiple Drupal accounts...?

Cheers
Robbie