Author Topic: Contribution Payment Error (Please Help) (Read 358 times)

jaylenbledsoe · August 05, 2014, 09:00:48 am

Using the Stripe Payment Integration, after selecting "Make Contribution", visitors are given an error.

Debug shows this:

Sorry but we are not able to provide this at the moment.
DB Error: constraint violation
Error Details

Code: [Select]

Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`indepe42_members`.`civicrm_address`, CONSTRAINT `FK_civicrm_address_state_province_id` FOREIGN KEY (`state_province_id`) REFERENCES `civicrm_state_province` (`id`) ON DELETE SET NULL), 1452
Additional Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_address (contact_id , location_type_id , is_primary , is_billing , street_address , city , state_province_id , postal_code , country_id , geo_code_1 , geo_code_2 , manual_geo_code ) VALUES ( 2 ,  5 ,  1 ,  1 , '2457 Periwinkle Court' , 'Florissant' ,  1024 , '63031' ,  1228 ,  38.830298 ,  -90.348888 ,  0 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`indepe42_members`.`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] => INSERT INTO civicrm_address (contact_id , location_type_id , is_primary , is_billing , street_address , city , state_province_id , postal_code , country_id , geo_code_1 , geo_code_2 , manual_geo_code ) VALUES ( 2 ,  5 ,  1 ,  1 , '**Address Removed**,  0 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`indepe42_members`.`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: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_address (contact_id , location_type_id , is_primary , is_billing , street_address , city , state_province_id , postal_code , country_id , geo_code_1 , geo_code_2 , manual_geo_code ) VALUES ( 2 ,  5 ,  1 ,  1 , '**Address Removed**)  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`indepe42_members`.`civicrm_address`, CONSTRAINT `FK_civicrm_address_state_province_id` FOREIGN KEY (`state_province_id`) REFERENCES `civicrm_state_province` (`id`) ON DELETE SET NULL)]"]
)

What can i do to fix this??

CiviCRM Community Forums (archive)

News:

Author Topic: Contribution Payment Error (Please Help) (Read 358 times)

jaylenbledsoe

Contribution Payment Error (Please Help)