CiviCRM Community Forums (archive)

I had a join contribution page which has a profile with 2 phone fields, one for home and one for mobile.  The site got upgraded to 4.3 and now when anyone submits the form they get an unknown DB error and cannot contribute.

When I remove the phone fields from the profile, it all works smoothly. Bug in new version to do with the phone fields??

I've heard about a 4.3.2 installer bug and something about a missing db trigger? Started a thread in the profiles form here:
http://forum.civicrm.org/index.php/topic,28748.new.html#new
but felt now that this forum is more appropriate

In the drupal log i see this:
<code>
$Fatal Error Details = Array ( [callback] => Array (
    => CRM_Core_Error [1] => handle )  => -1 [message] => DB Error: unknown error [mode] => 16 [debug_info] => UPDATE civicrm_phone SET contact_id = 2272 , location_type_id = 2 , is_primary = 0 , is_billing = 0 , phone = '555-555-5555' , phone_type_id = 1 WHERE ( civicrm_phone.id = 3813 ) [nativecode=1305 ** FUNCTION skvare_awc_civicrm.civicrm_strip_non_numeric does not exist] [type] => DB_Error [user_info] => UPDATE civicrm_phone SET contact_id = 2272 , location_type_id = 2 , is_primary = 0 , is_billing = 0 , phone = '555-555-5555' , phone_type_id = 1 WHERE ( civicrm_phone.id = 3813 ) [nativecode=1305 ** FUNCTION skvare_awc_civicrm.civicrm_strip_non_numeric does not exist] [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="UPDATE civicrm_phone SET contact_id = 2272 , location_type_id = 2 , is_primary = 0 , is_billing = 0 , phone = '555-555-5555' , phone_type_id = 1 WHERE ( civicrm_phone.id = 3813 ) [nativecode=1305 ** FUNCTION skvare_awc_civicrm.civicrm_strip_non_numeric does not exist]"] )
</code>

Seems related to http://forum.civicrm.org/index.php/topic,28652.msg122768.html

This problem keeps cropping up.....I can run the db trigger rebuild like you recommend and it will work for a few days....then all of a sudden....BOOM....my customer is calling me and reporting errors....I look and the log and its the phone problem again...Run the db triggers and it fixes it...but it has become obvious to me that this is a symptom of some deeper underlying issue...

Why should I have to rebuild the triggers every few days or week?