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) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 2.2 Release Testing »
  • Synchronize Users to Contacts: non-recoverable error has occurred
Pages: [1]

Author Topic: Synchronize Users to Contacts: non-recoverable error has occurred  (Read 2798 times)

businessbroker

  • Guest
Synchronize Users to Contacts: non-recoverable error has occurred
January 19, 2009, 06:04:59 pm
I pressed button to sync users and contacts and I get this list of error lines:

Code: [Select]
/home1/fornitur/public_html/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 138
, handle,
/home1/fornitur/public_html/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 912
/home1/fornitur/public_html/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 966
/home1/fornitur/public_html/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 574
/home1/fornitur/public_html/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1903
/home1/fornitur/public_html/sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 898
/home1/fornitur/public_html/sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/home1/fornitur/public_html/sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1216
/home1/fornitur/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php, query, 2394
/home1/fornitur/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php, _query, 1039
/home1/fornitur/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php, insert, 279
/home1/fornitur/public_html/sites/all/modules/civicrm/CRM/Core/BAO/UFMatch.php, save, 242
/home1/fornitur/public_html/sites/all/modules/civicrm/CRM/Core/BAO/CMSUser.php, synchronizeUFMatch, 89
/home1/fornitur/public_html/sites/all/modules/civicrm/CRM/Admin/Form/CMSUser.php, synchronize, 74
/home1/fornitur/public_html/sites/all/modules/civicrm/CRM/Core/Form.php, postProcess, 247
/home1/fornitur/public_html/sites/all/modules/civicrm/CRM/Core/StateMachine.php, mainProcess, 166
/home1/fornitur/public_html/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php, perform, 63
/home1/fornitur/public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/home1/fornitur/public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/home1/fornitur/public_html/sites/all/modules/civicrm/CRM/Core/Controller.php, handle, 232
/home1/fornitur/public_html/sites/all/modules/civicrm/CRM/Admin/Page/CMSUser.php, run, 71
/home1/fornitur/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 197
/home1/fornitur/public_html/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 318
, civicrm_invoke,
/home1/fornitur/public_html/includes/menu.inc, call_user_func_array, 348
/home1/fornitur/public_html/index.php, menu_execute_active_handler, 18


The content access permissions need to be rebuilt. Please visit this page.

unrecoverable error
    Sorry. A non-recoverable error has occurred.

    DB Error: already exists

    Return to home page.

Error Details:

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

     => -5
    [message] => DB Error: already exists
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_uf_match (uf_id , uf_name , contact_id ) VALUES ( 6 , 'rabith@atlantum.net' ,  3 )  [nativecode=1062 ** Duplicate entry '3' for key 3]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_uf_match (uf_id , uf_name , contact_id ) VALUES ( 6 , 'rabith@atlantum.net' ,  3 )  [nativecode=1062 ** Duplicate entry '3' for key 3]
    [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 (uf_id , uf_name , contact_id ) VALUES ( 6 , 'rabith@atlantum.net' ,  3 )  [nativecode=1062 ** Duplicate entry '3' for key 3]"]
)


for ation f some drupal module, now i have double users: half with username as email and half with norma username, problem could come from this situation?
« Last Edit: January 19, 2009, 06:07:56 pm by businessbroker »

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Synchronize Users to Contacts: non-recoverable error has occurred
January 19, 2009, 10:07:34 pm
CiviCRM - Drupal mapping is based on mail address in drupal. So it looks like you have multiple CiviCRM contacts with same email address corresponding to one drupal user's mail address.  Can you empty your "civicrm_uf_match"  table and again Synchronize.

HTh

Kurund
Found this reply helpful? Support CiviCRM

businessbroker

  • Guest
Re: Synchronize Users to Contacts: non-recoverable error has occurred
January 20, 2009, 02:41:25 pm
done, but now i get a very similar error:

Code: [Select]
/home1/fornitur/public_html/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 138
, handle,
/home1/fornitur/public_html/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 912
/home1/fornitur/public_html/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 966
/home1/fornitur/public_html/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 574
/home1/fornitur/public_html/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1903
/home1/fornitur/public_html/sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 898
/home1/fornitur/public_html/sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/home1/fornitur/public_html/sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1216
/home1/fornitur/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php, query, 2394
/home1/fornitur/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php, _query, 1039
/home1/fornitur/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php, insert, 279
/home1/fornitur/public_html/sites/all/modules/civicrm/CRM/Core/BAO/UFMatch.php, save, 242
/home1/fornitur/public_html/sites/all/modules/civicrm/CRM/Core/BAO/CMSUser.php, synchronizeUFMatch, 89
/home1/fornitur/public_html/sites/all/modules/civicrm/CRM/Admin/Form/CMSUser.php, synchronize, 74
/home1/fornitur/public_html/sites/all/modules/civicrm/CRM/Core/Form.php, postProcess, 247
/home1/fornitur/public_html/sites/all/modules/civicrm/CRM/Core/StateMachine.php, mainProcess, 166
/home1/fornitur/public_html/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php, perform, 63
/home1/fornitur/public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/home1/fornitur/public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/home1/fornitur/public_html/sites/all/modules/civicrm/CRM/Core/Controller.php, handle, 232
/home1/fornitur/public_html/sites/all/modules/civicrm/CRM/Admin/Page/CMSUser.php, run, 71
/home1/fornitur/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 197
/home1/fornitur/public_html/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 318
, civicrm_invoke,
/home1/fornitur/public_html/includes/menu.inc, call_user_func_array, 348
/home1/fornitur/public_html/index.php, menu_execute_active_handler, 18


Sorry. A non-recoverable error has occurred.

DB Error: already exists

Return to home page.

Error Details:

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

    [code] => -5
    [message] => DB Error: already exists
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_uf_match (uf_id , uf_name , contact_id ) VALUES ( 6 , 'rabith@atlantum.net' ,  3 )  [nativecode=1062 ** Duplicate entry 'rabith@atlantum.net' for key 2]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_uf_match (uf_id , uf_name , contact_id ) VALUES ( 6 , 'rabith@atlantum.net' ,  3 )  [nativecode=1062 ** Duplicate entry 'rabith@atlantum.net' for key 2]
    [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 (uf_id , uf_name , contact_id ) VALUES ( 6 , 'rabith@atlantum.net' ,  3 )  [nativecode=1062 ** Duplicate entry 'rabith@atlantum.net' for key 2]"]
)

[/code]

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Synchronize Users to Contacts: non-recoverable error has occurred
January 20, 2009, 07:39:04 pm
I guess than you will have to fix duplicate email issue as mentioned earlier in this thread.

Kurund
Found this reply helpful? Support CiviCRM
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 2.2 Release Testing »
  • Synchronize Users to Contacts: non-recoverable error has occurred

This forum was archived on 2017-11-26.