CiviCRM Community Forums (archive)

Im trying to add phone numbers to contacts and am just getting this error

===================
Error Details
Database Error Code: Cannot load from mysql.proc. The table is probably corrupted, 1548
Additional Details:
Array
(
     => Array
        (
            [list]
[li] => CRM_Core_Error[/li]
[li][1] => handle
        )

     => -1
     => DB Error: unknown error
     => 16
    [debug_info] => SHOW function status WHERE db = database() AND name = 'civicrm_strip_non_numeric' [nativecode=1548 ** Cannot load from mysql.proc. The table is probably corrupted]
     => DB_Error
    [/li]
[/list][user_info] => SHOW function status WHERE db = database() AND name = 'civicrm_strip_non_numeric' [nativecode=1548 ** Cannot load from mysql.proc. The table is probably corrupted]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="SHOW function status WHERE db = database() AND name = 'civicrm_strip_non_numeric' [nativecode=1548 ** Cannot load from mysql.proc. The table is probably corrupted]"]
)
Return to home page.
===========================


There seems to be a lot of forum discussion around problems with civicrm_strip_non_numeric and Ive tried a few solutions like rebuilding the triggers. But to no avail. The triggers have been rebuilt but the problem remains.

Any help much appreciated.