CiviCRM Community Forums (archive)

Help,

I suddenly cannot log into my site with my admin username and password through the log-in menu.  (i did just recently install smfforum and am now using that login menu - however i have had no problem logging in through it in the last few days).

I receive the following error:

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

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_contact (domain_id , contact_type , sort_name , display_name , preferred_communication_method , hash ) VALUES ( 0 , 'Individual' , 'gracearoha@auroville.org.in' , 'gracearoha@auroville.org.in' , '' , '75522cb070f76bfd31a708891fffd13e' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`25_civicrm-new/civicrm_contact`, CONSTRAINT `civicrm_contact_ibfk_1` FOREIGN KEY (`domain_id`) REFERENCES `civicrm_domain` (`id`))]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_contact (domain_id , contact_type , sort_name , display_name , preferred_communication_method , hash ) VALUES ( 0 , 'Individual' , 'gracearoha@auroville.org.in' , 'gracearoha@auroville.org.in' , '' , '75522cb070f76bfd31a708891fffd13e' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`25_civicrm-new/civicrm_contact`, CONSTRAINT `civicrm_contact_ibfk_1` FOREIGN KEY (`domain_id`) REFERENCES `civicrm_domain` (`id`))]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_contact (domain_id , contact_type , sort_name , display_name , preferred_communication_method , hash ) VALUES ( 0 , 'Individual' , 'gracearoha@auroville.org.in' , 'gracearoha@auroville.org.in' , '' , '75522cb070f76bfd31a708891fffd13e' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`25_civicrm-new/civicrm_contact`, CONSTRAINT `civicrm_contact_ibfk_1` FOREIGN KEY (`domain_id`) REFERENCES `civicrm_domain` (`id`))]"]
)
I can log in through the browser by going to site.com/user.

I noticed that the contact that is referred to in the above error shares the same e-mail address as the admin, but does not show up as a user in Drupal.  So i tried to delete this record from the database, but i receive the following error:

#1451 - Cannot delete or update a parent row: a foreign key constraint fails (`25_civicrm-new/civicrm_subscription_history`, CONSTRAINT `civicrm_subscription_history_ibfk_1` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`))

Then when i try to go into the civicrm admin menu, i receive the following error:

Sorry. A non-recoverable error has occurred.
Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`25_civicrm-new/civicrm_contact`, CONSTRAINT `civicrm_contact_ibfk_1` FOREIGN KEY (`domain_id`) REFERENCES `civicrm_domain` (`id`)), 1452
(with the same details as the above error)

i am running civicrm 1.6 and Drupal 1.5 and have been running both for several months without this error.

Any ideas? [/code]

Ah,
That did the trick.

Thank you!