CiviCRM Community Forums (archive)

When I created a user from the "Create New Account", this error was produced.

Steps before I made this post:
1) Made sure that:
define('CIVICRM_DOMAIN_ID' , 1 );

2) I did load:
civicrm_41.mysql
civicrm_generated.mysql

3) Searched for other solutions in the forums related to this error.

Server Stats: MySql 5.1 / PHP 5 / Drupal 5.1

(hehehe.. all version 5's!)

I am new to Drupal and Civcrm on my 3rd cup of coffee, day 2.

Sorry. A non-recoverable error has occurred.

Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`db207833555/civicrm_location`, CONSTRAINT `FK_civicrm_location_location_type_id` FOREIGN KEY (`location_type_id`) REFERENCES `civicrm_location_type` (`id`)), 1452

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

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_location (entity_table , entity_id , is_primary ) VALUES ('civicrm_contact' ,  106 ,  1 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`db207833555/civicrm_location`, CONSTRAINT `FK_civicrm_location_location_type_id` FOREIGN KEY (`location_type_id`) REFERENCES `civicrm_location_type` (`id`))]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_location (entity_table , entity_id , is_primary ) VALUES ('civicrm_contact' ,  106 ,  1 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`db207833555/civicrm_location`, CONSTRAINT `FK_civicrm_location_location_type_id` FOREIGN KEY (`location_type_id`) REFERENCES `civicrm_location_type` (`id`))]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_location (entity_table , entity_id , is_primary ) VALUES ('civicrm_contact' ,  106 ,  1 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`db207833555/civicrm_location`, CONSTRAINT `FK_civicrm_location_location_type_id` FOREIGN KEY (`location_type_id`) REFERENCES `civicrm_location_type` (`id`))]"]
)[/code]





tags: error message non-recoverable error newbie foreign key child row