Duplication error when accessing CiviCRM prevents me from using CiviCRM

[posco]

I get this error every time I try to access any CiviCRM profile or page when I log in as the Drupal superuser:

Code: [Select]

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 , contact_id , domain_id , email ) VALUES ( 1 ,  396 ,  1 , 'ngoodman1@stu.matcmadison.edu' )  [nativecode=1062 ** Duplicate entry '396' for key 3]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_uf_match (uf_id , contact_id , domain_id , email ) VALUES ( 1 ,  396 ,  1 , 'ngoodman1@stu.matcmadison.edu' )  [nativecode=1062 ** Duplicate entry '396' 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 , contact_id , domain_id , email ) VALUES ( 1 ,  396 ,  1 , 'ngoodman1@stu.matcmadison.edu' )  [nativecode=1062 ** Duplicate entry '396' for key 3]"]
)

CiviCRM refuses to load anything after I encounter this error so I can't access CiviCRM at all.

The duplication problem is probably correct; I have used that e-mail on different contacts and have had duplication problems in the past. I was always able to resolve those by editing the contacts or merging the duplicates. What I don't understand is why CiviCRM is trying to insert a record for the Drupal superuser account every time I try to access to go into CiviCRM. There should already be a contact for the superuser.

What would I have to do to resolve this problem? I'm assuming I'm going to have to make edits to the database directly as I have no access to the CiviCRM pages.

I'm using CiviCRM 1.9 and Drupal 5.x.[/code]

[posco]

I figured this out. Apparently somebody deleted the Drupal superuser's contact. The Drupal superuser and another contact in the system both had the same e-mail. When CiviCRM tried to recreate the superuser contact, it ran into a collision with the user that already had the e-mail. I logged in as that other user and changed their e-mail.

After that CiviCRM was able to make the new contact for the superuser.