CiviCRM Community Forums (archive)

We get contributions from many countries, but for some reason, this donor and Thailand is unable to donate despite our many attempts to help him do it.  We have Thailand enabled in the country and state tables.... ?

Test Test-User
111 South Island
Bangkok, 18 10110
TH



    Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`fpwr_civicrm20/civicrm_address`, CONSTRAINT `FK_civicrm_address_state_province_id` FOREIGN KEY (`state_province_id`) REFERENCES `civicrm_state_province` (`id`) ON DELETE SET NULL), 1452

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => UPDATE  civicrm_address  SET contact_id = 259 , location_type_id = 5 , is_primary = 0 , is_billing = 0 , street_address = '111 South Island' , city = 'Bangkok' , state_province_id = 18 , postal_code = '10110' , country_id = 1211 , geo_code_1 = 13.670304 , geo_code_2 = 100.637435   WHERE (  civicrm_address.id = 1743 )   [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`fpwr_civicrm20/civicrm_address`, CONSTRAINT `FK_civicrm_address_state_province_id` FOREIGN KEY (`state_province_id`) REFERENCES `civicrm_state_province` (`id`) ON DELETE SET NULL)]
    [type] => DB_Error
    [user_info] => UPDATE  civicrm_address  SET contact_id = 259 , location_type_id = 5 , is_primary = 0 , is_billing = 0 , street_address = '111 South Island' , city = 'Bangkok' , state_province_id = 18 , postal_code = '10110' , country_id = 1211 , geo_code_1 = 13.670304 , geo_code_2 = 100.637435   WHERE (  civicrm_address.id = 1743 )   [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`fpwr_civicrm20/civicrm_address`, CONSTRAINT `FK_civicrm_address_state_province_id` FOREIGN KEY (`state_province_id`) REFERENCES `civicrm_state_province` (`id`) ON DELETE SET NULL)]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="UPDATE  civicrm_address  SET contact_id = 259 , location_type_id = 5 , is_primary = 0 , is_billing = 0 , street_address = '111 South Island' , city = 'Bangkok' , state_province_id = 18 , postal_code = '10110' , country_id = 1211 , geo_code_1 = 13.670304 , geo_code_2 = 100.637435   WHERE (  civicrm_address.id = 1743 )   [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`fpwr_civicrm20/civicrm_address`, CONSTRAINT `FK_civicrm_address_state_province_id` FOREIGN KEY (`state_province_id`) REFERENCES `civicrm_state_province` (`id`) ON DELETE SET NULL)]"]
)


So how do we fix?  Reload all of those reference tables?

Its coming from the "abbreviation" field in the state_province table. 

More on this - by changing the "abbreviation" for the "Chai-Nat" province of Thailand from "18" to its state_province_id of 4635, we got past this error.  However, we get a "10536:Invalid Data" error from PayPal because I am sure that PP doesn't recognize 4635 as an accurate province?

Anyways, if you can point us to the code where id and abbreviation are being switched, we can attempt to fix it.

Jeff

I am not that worried about the PP error. 

I am wondering more so why the system appears to be using the "abbreviation" as the state_province_id - which for Thailand is causing us not to be able to accept donations.

jeff:

Can you reproduce this issue either on sandbox or on demo? You can probably use pay later to bypass the payment processor

I cant seem to reproduce this on my local install

lobo

you rock - we will try it - thanks

We will expose the state-country widget to front end pages in a future 2.x release.

lobo