Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-1122

Trying to add new individual (or member of a group)

    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...

        Attachments

          Activity

            People

            • Assignee:
              lobo Donald A. Lobo
              Reporter:
              modout Modise Makhetha
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 1 day
                1d
                Remaining:
                Remaining Estimate - 1 day
                1d
                Logged:
                Time Spent - Not Specified
                Not Specified