CiviCRM Community Forums (archive)

Hello when a user tries to fill out an online contribution page and confirm. They receive a DB Error: unknown error. Upon examination with debugging enabled, civicrm seems to be having trouble with the following function:

"civicrm_strip_non_numeric"

Here is the backtrace:

Array
(
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_phone (contact_id , location_type_id , is_primary , is_billing , phone , phone_type_id ) VALUES ( 1774 ,  1 ,  1 ,  0 , '2122536182' ,  1 )  [nativecode=1305 ** FUNCTION tovporg_civicrm.civicrm_strip_non_numeric does not exist]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_phone (contact_id , location_type_id , is_primary , is_billing , phone , phone_type_id ) VALUES ( 1774 ,  1 ,  1 ,  0 , '2122536182' ,  1 )  [nativecode=1305 ** FUNCTION tovporg_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="INSERT INTO civicrm_phone (contact_id , location_type_id , is_primary , is_billing , phone , phone_type_id ) VALUES ( 1774 ,  1 ,  1 ,  0 , '2122536182' ,  1 )  [nativecode=1305 ** FUNCTION tovporg_civicrm.civicrm_strip_non_numeric does not exist]"]


If anyone could please help as I am stumped, I think it would be nice to update the database troubleshooting tools to work with the current version.

Thanks in advance!

mpdas108 :

Can you confirm if you still this on latest CiviCRM (4.3.2)

-Yashodha

Cool!

peter

might want to ping colemanw on irc and get this sorted out. seems like the phone stored procedure is not getting into the mysql db for some reason

lobo

Thanks Coleman, that resolved the issue!

I tried rebuilding the trigger and it didn't work.

What exactly did you try, like what query? And what was the result precisely? An error message?

I suppose you could try to run this in MySQL:

  CREATE FUNCTION civicrm_strip_non_numeric(input VARCHAR(255) CHARACTER SET utf8)
      RETURNS VARCHAR(255) CHARACTER SET utf8
      DETERMINISTIC
      NO SQL
    BEGIN
      DECLARE output   VARCHAR(255) CHARACTER SET utf8 DEFAULT '';
      DECLARE iterator INT          DEFAULT 1;
      WHILE iterator < (LENGTH(input) + 1) DO
        IF SUBSTRING(input, iterator, 1) IN ('0', '1', '2', '3', '4', '5', '6', '7', '8', '9') THEN
          SET output = CONCAT(output, SUBSTRING(input, iterator, 1));
        END IF;
        SET iterator = iterator + 1;
      END WHILE;
      RETURN output;
    END
and see what happens.

That code is copied and pasted from the CiviCRM source code.

Someone else will respond now I think. I'm not sure what the issue is.