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 »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Error when creating an account: PEAR_Exception: DB Error: already exists in CRM_
Pages: [1]

Author Topic: Error when creating an account: PEAR_Exception: DB Error: already exists in CRM_  (Read 1494 times)

jmickela

  • I post occasionally
  • **
  • Posts: 33
  • Karma: 0
  • CiviCRM version: 4.1.1
  • CMS version: Drupal 7
  • MySQL version: 5
  • PHP version: 5
Error when creating an account: PEAR_Exception: DB Error: already exists in CRM_
May 10, 2012, 12:26:49 pm
I'm getting the following error when I create an account:

Code: [Select]
PEAR_Exception: DB Error: already exists in CRM_Core_Error::exceptionHandler()
Did some searching and found nothing at all with this error. Anyone know what I can do about this?

jmickela

  • I post occasionally
  • **
  • Posts: 33
  • Karma: 0
  • CiviCRM version: 4.1.1
  • CMS version: Drupal 7
  • MySQL version: 5
  • PHP version: 5
Re: Error when creating an account: PEAR_Exception: DB Error: already exists in CRM_
May 31, 2012, 05:36:34 pm
Bump.

Changed payment processor from paypal standard to pro, still getting this error. Happens right after I click "Confirm Contribution".

The account still gets created, but I get left at an error page.

jmickela

  • I post occasionally
  • **
  • Posts: 33
  • Karma: 0
  • CiviCRM version: 4.1.1
  • CMS version: Drupal 7
  • MySQL version: 5
  • PHP version: 5
Re: Error when creating an account: PEAR_Exception: DB Error: already exists in CRM_
June 01, 2012, 06:33:39 pm
For some reason I started getting some debug info with this error...here is what I'm getting:

Code: [Select]


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

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [c0de] => -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 ,  104471 , 'jason1@drawbridgehouse.com' ,  19729 )  [nativecode=1062 ** Duplicate entry 'jason1@drawbridgehouse.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 ,  104471 , 'jason1@drawbridgehouse.com' ,  19729 )  [nativecode=1062 ** Duplicate entry 'jason1@drawbridgehouse.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 ,  104471 , 'jason1@drawbridgehouse.com' ,  19729 )  [nativecode=1062 ** Duplicate entry 'jason1@drawbridgehouse.com-1' for key 'UI_uf_name_domain_id']"]
)


I get this output no matter what address I use, this is not an address used by any contacts. The account is created, the user is logged in.
« Last Edit: June 01, 2012, 06:35:20 pm by jmickela »

jmickela

  • I post occasionally
  • **
  • Posts: 33
  • Karma: 0
  • CiviCRM version: 4.1.1
  • CMS version: Drupal 7
  • MySQL version: 5
  • PHP version: 5
Re: Error when creating an account: PEAR_Exception: DB Error: already exists in CRM_
June 04, 2012, 03:04:18 pm
For any Googlers who land here looking for answers:

Turns out there is some bug that causes Civi to try to insert into the civicrm_uf_match table twice when using CiviContribute and allowing users to set their password while registering (not requiring email confirmation to log in). I don't know how to fix if, but setting the option to require email confirmation in Drupal will fix the issue.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Error when creating an account: PEAR_Exception: DB Error: already exists in CRM_
June 05, 2012, 07:37:11 am
I do believe this is the same bug that was reported here:

http://issues.civicrm.org/jira/browse/CRM-9091?focusedCommentId=41171&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-41171
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

jmickela

  • I post occasionally
  • **
  • Posts: 33
  • Karma: 0
  • CiviCRM version: 4.1.1
  • CMS version: Drupal 7
  • MySQL version: 5
  • PHP version: 5
Re: Error when creating an account: PEAR_Exception: DB Error: already exists in CRM_
June 05, 2012, 12:30:51 pm
Not the same bug.

In that case the bug involves other existing users already using the same email address that the new user is signing up with.

In this case no user is already using the email address being used to sign up. This bug doesn't involve a user conflicting with another use, this bug somehow involves a user account conflicting with itself.

ouyang1512

  • I post occasionally
  • **
  • Posts: 59
  • Karma: 0
  • CiviCRM version: 4.1.1
  • CMS version: Drupal 7.12
  • MySQL version: MySQL 5.1.52
  • PHP version: 5.3.6
Re: Error when creating an account: PEAR_Exception: DB Error: already exists in CRM_
July 10, 2012, 11:14:56 am
I had the same issue with same error messages when I tried to create a drupal account with the civievent registration. And the suggestion above (require email verfication) made this issue go away.

Barnacle

  • I post occasionally
  • **
  • Posts: 62
  • Karma: 2
    • White Fuse Media
  • CiviCRM version: 4.4
  • CMS version: Drupal 7
  • MySQL version: 5.x
  • PHP version: 5.3
Re: Error when creating an account: PEAR_Exception: DB Error: already exists in CRM_
July 11, 2012, 05:25:59 am
I have a related problem. Requiring drupal account creation with event registration is looping back when I press 'continue' (i.e. not continuing). I tried requiring email verification and this did not fix the issue.
--
http://whitefusemedia.com/
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Error when creating an account: PEAR_Exception: DB Error: already exists in CRM_

This forum was archived on 2017-11-26.