CiviCRM Community Forums (archive)

I have a strange issue with CiviEvent. Basically it seems as though the creation of a contact is not happening properly, and so when it tries to create the contribution with the contact ID, it gives a foreign key error as the contact id does not exist in civicrm_contact.

I'm using a custom profile to get the contact information, and that profile operates perfectly normally on its own, correctly creating a new contact.

I put some code in a post hook to have a look at what was happening post contact creation. The hook runs, so civi is creating a contact and all of the correct contact info is in the $objectRef (name, etc). However, when I look in the database seconds after, the contact does not actually exist.

Below is the code in my post hook.
if ( ($op == 'create') && ($objectName == 'Individual') ){
              print_r($objectId);
              print_r($objectRef);
              CRM_Core_Error::backtrace( );
              CRM_Core_Error::debug( 'T', $type );
              exit( );
}
And below is the output of the two print_r statements:
945938CRM_Contact_DAO_Contact Object ( [id] => 945938 [contact_type] => Individual [contact_sub_type] => null [do_not_email] => [do_not_phone] => [do_not_mail] => [do_not_sms] => [do_not_trade] => [is_opt_out] => [legal_identifier] => [external_identifier] => [sort_name] => Tester, Testing [display_name] => Testing Tester [nick_name] => [legal_name] => [image_URL] => [preferred_communication_method] => [preferred_language] => en_CA [preferred_mail_format] => [hash] => 0a66ed4078fd314ffdbc80a5dc1dd11b [api_key] => [source] => [first_name] => Testing [middle_name] => null [last_name] => Tester [prefix_id] => null [suffix_id] => [email_greeting_id] => 1 [email_greeting_custom] => [email_greeting_display] => [postal_greeting_id] => 1 [postal_greeting_custom] => [postal_greeting_display] => [addressee_id] => 1 [addressee_custom] => [addressee_display] => [job_title] => [gender_id] => null [birth_date] => null [is_deceased] => [deceased_date] => [household_name] => [primary_contact_id] => [organization_name] => [sic_code] => [user_unique_id] => [employer_id] => [is_deleted] => [created_date] => [modified_date] => [_DB_DataObject_version] => 1.8.12 [__table] => civicrm_contact [N] => 0 [_database_dsn] => [_database_dsn_md5] => 32ae8a3ab826a9a3886c1e1183f3b6e2 [_database] => civinbla [_query] => Array ( [condition] => [group_by] => [order_by] => [having] => [limit_start] => [limit_count] => [data_select] => * ) [_DB_resultid] => [_resultFields] => [_link_loaded] => [_join] => [_lastError] => [phone] => Array ( [0] => CRM_Core_DAO_Phone Object ( [id] => 47058 [contact_id] => 945938 [location_type_id] => 1 [is_primary] => 1 [is_billing] => 0 [mobile_provider_id] => [phone] => 5069991940 [phone_ext] => [phone_numeric] => [phone_type_id] => 1 [_DB_DataObject_version] => 1.8.12 [__table] => civicrm_phone [N] => 0 [_database_dsn] => [_database_dsn_md5] => 32ae8a3ab826a9a3886c1e1183f3b6e2 [_database] => civinbla [_query] => Array ( [condition] => [group_by] => [order_by] => [having] => [limit_start] => [limit_count] => [data_select] => * ) [_DB_resultid] => [_resultFields] => [_link_loaded] => [_join] => [_lastError] => ) ) [email] => Array ( ) [im] => [openid] => [address] => Array ( [0] => CRM_Core_DAO_Address Object ( [id] => 945133 [contact_id] => 945938 [location_type_id] => 5 [is_primary] => 1 [is_billing] => 1 [street_address] => 21872 laskjhdka [street_number] => [street_number_suffix] => [street_number_predirectional] => [street_name] => [street_type] => [street_number_postdirectional] => [street_unit] => [supplemental_address_1] => [supplemental_address_2] => [supplemental_address_3] => [city] => Fredericton [county_id] => [state_province_id] => 1103 [postal_code_suffix] => [postal_code] => E3B 2M4 [usps_adc] => [country_id] => 1039 [geo_code_1] => 45.9601958 [geo_code_2] => -66.6615021 [manual_geo_code] => 0 [timezone] => [name] => Testing Tester [master_id] => [_DB_DataObject_version] => 1.8.12 [__table] => civicrm_address [N] => 0 [_database_dsn] => [_database_dsn_md5] => 32ae8a3ab826a9a3886c1e1183f3b6e2 [_database] => civinbla [_query] => Array ( [condition] => [group_by] => [order_by] => [having] => [limit_start] => [limit_count] => [data_select] => * ) [_DB_resultid] => [_resultFields] => [_link_loaded] => [_join] => [_lastError] => ) [1] => CRM_Core_DAO_Address Object ( [id] => 945134 [contact_id] => 945938 [location_type_id] => 1 [is_primary] => 1 [is_billing] => 0 [street_address] => 21872 laskjhdka [street_number] => [street_number_suffix] => [street_number_predirectional] => [street_name] => [street_type] => [street_number_postdirectional] => [street_unit] => [supplemental_address_1] => null [supplemental_address_2] => [supplemental_address_3] => [city] => Fredericton [county_id] => [state_province_id] => 1103 [postal_code_suffix] => [postal_code] => E3B 2M4 [usps_adc] => [country_id] => 1039 [geo_code_1] => 45.9601958 [geo_code_2] => -66.6615021 [manual_geo_code] => 0 [timezone] => [name] => [master_id] => [_DB_DataObject_version] => 1.8.12 [__table] => civicrm_address [N] => 0 [_database_dsn] => [_database_dsn_md5] => 32ae8a3ab826a9a3886c1e1183f3b6e2 [_database] => civinbla [_query] => Array ( [condition] => [group_by] => [order_by] => [having] => [limit_start] => [limit_count] => [data_select] => * ) [_DB_resultid] => [_resultFields] => [_link_loaded] => [_join] => [_lastError] => ) ) [contact_type_display] => Individual )
So as you can see, it appears the contact did exist, and then somehow disappeared, which leads to an error on the Contribution insert, as the contact_id field is set to 945938 which doesn't exist - and so giving me the foreign key constraint

When we have lost information due to transaction rollbacks it has often turned out to be the cmsuser create function that failed. I think in 4.4 I have patched the contribution form such that the CMS User fn cannot trigger a rollback.

i would enable mysql query logging and see the queries it logs (and where it fails). alternatively u can ask civi to dump all queries (check civicrm.settings.php)

lobo

Have had similar issue. Participant tries to register for an event and saves but participant/contact does not appear to be written away - unless he is hiding in Bermuda Triangle.
The cms company looking after the website did a Joomla upgrade earlier and all phone entries in civi bomb out. here is part of backtrace
Error("DB Error: unknown error", -1, 16, (Array:2), "INSERT INTO civicrm_phone (contact_id , location_type_id , is_primary , is_bi...")
Any ideas??