CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • WordPress Installations (Moderators: Kurund Jalmi, Coleman Watts) »
  • Error creating new WP user tracked to CiviCRM
Pages: [1]

Author Topic: Error creating new WP user tracked to CiviCRM  (Read 1448 times)

CityBloc

  • I post occasionally
  • **
  • Posts: 38
  • Karma: 0
  • CiviCRM version: 4.4.6
  • CMS version: WordPress 3.9.2
  • MySQL version: 5.5.37
  • PHP version: 5.3.10
Error creating new WP user tracked to CiviCRM
September 15, 2012, 05:33:12 pm
Hi -

Does anybody know why Civi kicks out a new WP user registration that happens to use the email addr or name of a deleted WP user?  When users do this now, they get a page "Sorry but we are not able to provide this at the moment" from Civi (referenced in the HTML of the error page).

Oddly, the user record is successfully written to WP's database.  And the behavior goes away when Civi is shut off.

Anybody know what's up?

CityBloc

  • I post occasionally
  • **
  • Posts: 38
  • Karma: 0
  • CiviCRM version: 4.4.6
  • CMS version: WordPress 3.9.2
  • MySQL version: 5.5.37
  • PHP version: 5.3.10
Re: Error creating new WP user tracked to CiviCRM
September 17, 2012, 12:35:48 pm
Bumping with a paste of the error page HTML:

http://pastebin.com/xtUXRW0q

-r

CityBloc

  • I post occasionally
  • **
  • Posts: 38
  • Karma: 0
  • CiviCRM version: 4.4.6
  • CMS version: WordPress 3.9.2
  • MySQL version: 5.5.37
  • PHP version: 5.3.10
Re: Error creating new WP user tracked to CiviCRM
September 17, 2012, 09:11:21 pm
Turned on debugging, found this.  Can anybody suggest why a deleted WP user constitutes a duplicate entry here?


Additional Details:
Array
(
    [callback] => Array
        (
           
  • => CRM_Core_Error
  • [1] => handle
            )

       
Code: [Select]
=> -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 ,  27 , 'test@cityblocchicago.com' ,  302 )  [nativecode=1062 ** Duplicate entry 'test@cityblocchicago.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 ,  27 , 'test@cityblocchicago.com' ,  302 )  [nativecode=1062 ** Duplicate entry 'test@cityblocchicago.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 ,  27 , 'test@cityblocchicago.com' ,  302 )  [nativecode=1062 ** Duplicate entry 'test@cityblocchicago.com-1' for key 'UI_uf_name_domain_id']"]
)

CityBloc

  • I post occasionally
  • **
  • Posts: 38
  • Karma: 0
  • CiviCRM version: 4.4.6
  • CMS version: WordPress 3.9.2
  • MySQL version: 5.5.37
  • PHP version: 5.3.10
Re: Error creating new WP user tracked to CiviCRM
September 17, 2012, 09:47:29 pm
Dug around and found that civicrm_uf_match getting in the way of re-registration is a known issue under Drupal; I guess this means its' also an issue under Wordpress. 

From:

http://wiki.civicrm.org/confluence/display/CRMDOC42/Notes+for+New+Developers+and+Webmasters

>> When I delete a drupal user and the corresponding contact and then re-register a user with the same email address it seems to create a few problems?

Yes, you will have to manually edit the civicrm_uf_match table and remove the old entry that matches the old Drupal user id with the old CiviCRM contact id.

NB: an issue has been logged against 1.7 for this.


So there it is.   

-r
« Last Edit: September 17, 2012, 09:49:09 pm by CityBloc »

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Error creating new WP user tracked to CiviCRM
September 18, 2012, 03:59:14 am

hey rob:

any chance u can take a look and submit a patch for the below

thanx

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

CityBloc

  • I post occasionally
  • **
  • Posts: 38
  • Karma: 0
  • CiviCRM version: 4.4.6
  • CMS version: WordPress 3.9.2
  • MySQL version: 5.5.37
  • PHP version: 5.3.10
Re: Error creating new WP user tracked to CiviCRM
September 18, 2012, 11:19:18 am
Quote from: Donald Lobo on September 18, 2012, 03:59:14 am

hey rob:

any chance u can take a look and submit a patch for the below

thanx

lobo


Hi Don,

I would love to, but I'm not a software developer.  Please let me know how best can I help and I will.

-r




Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • WordPress Installations (Moderators: Kurund Jalmi, Coleman Watts) »
  • Error creating new WP user tracked to CiviCRM

This forum was archived on 2017-11-26.