Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Critical
-
Resolution: Won't Fix
-
Affects Version/s: 1.4
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
Description
I am new at using the CiviCRM on Drupal 4.7, MySQL 5.0... I tried resolving the problem by tracing the errors in the database but still could not overcome... Please help me resolve the following;
I started with the registration of Groups, then tried to add members but the following was displayed;
Sorry. A non-recoverable error has occurred.
Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`civicrm/civicrm_address`, CONSTRAINT `civicrm_address_ibfk_5` FOREIGN KEY (`geo_coord_id`) REFERENCES `civicrm_geo_coord` (`id`)), 1452
Return to CiviCRM menu.
error
Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -1
[message] => DB Error: unknown error
[mode] => 16
[debug_info] => INSERT INTO civicrm_address (location_id , street_address , supplemental_address_1 , supplemental_address_2 , city , county_id , state_province_id , postal_code , postal_code_suffix , country_id , geo_coord_id , geo_code_1 , geo_code_2 ) VALUES ( 1 , '619 Khwezi Str' , 'Naledi Ext 2' , 'Soweto' , 'Johannesburg' , 1 , NULL , '1868' , NULL , 1196 , 1 , NULL , NULL ) [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm/civicrm_address`, CONSTRAINT `civicrm_address_ibfk_5` FOREIGN KEY (`geo_coord_id`) REFERENCES `civicrm_geo_coord` (`id`))]
[type] => db_error
[user_info] => INSERT INTO civicrm_address (location_id , street_address , supplemental_address_1 , supplemental_address_2 , city , county_id , state_province_id , postal_code , postal_code_suffix , country_id , geo_coord_id , geo_code_1 , geo_code_2 ) VALUES ( 1 , '619 Khwezi Str' , 'Naledi Ext 2' , 'Soweto' , 'Johannesburg' , 1 , NULL , '1868' , NULL , 1196 , 1 , NULL , NULL ) [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm/civicrm_address`, CONSTRAINT `civicrm_address_ibfk_5` FOREIGN KEY (`geo_coord_id`) REFERENCES `civicrm_geo_coord` (`id`))]
[to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_address (location_id , street_address , supplemental_address_1 , supplemental_address_2 , city , county_id , state_province_id , postal_code , postal_code_suffix , country_id , geo_coord_id , geo_code_1 , geo_code_2 ) VALUES ( 1 , '619 Khwezi Str' , 'Naledi Ext 2' , 'Soweto' , 'Johannesburg' , 1 , NULL , '1868' , NULL , 1196 , 1 , NULL , NULL ) [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm/civicrm_address`, CONSTRAINT `civicrm_address_ibfk_5` FOREIGN KEY (`geo_coord_id`) REFERENCES `civicrm_geo_coord` (`id`))]"]
)
I will appreciate any help in guiding me to tracking or resolving the problem...