CiviCRM Community Forums (archive)

I cannot upgrade past 4.2.9 without getting the following error:

[Error: Upgrade Phone Numbers]
Error Field   Error Value
Type   DB_Error
Code   -1
Message   DB Error: unknown error
Mode   16
UserInfo   DROP FUNCTION IF EXISTS civicrm_strip_non_numeric [nativecode=1548 ** Cannot load from mysql.proc. The table is probably corrupted]
DebugInfo   DROP FUNCTION IF EXISTS civicrm_strip_non_numeric [nativecode=1548 ** Cannot load from mysql.proc. The table is probably corrupted]
PEAR_Exception: DB Error: unknown error in unknown on line unknown
- DB_Error: DB Error: unknown error in unknown on line unknown
Exception trace
#   Function   Location
0   CRM_Core_Error::exceptionHandler(Object(DB_Error))   unknown:unknown
1   call_user_func(Array, Object(DB_Error))   /Applications/MAMP/htdocs/drupal7-test-site/sites/all/modules/civicrm/packages/PEAR.php:931
2   PEAR_Error->PEAR_Error('DB Error: unknow…', -1, 16, Array, 'DROP FUNCTION IF…')   /Applications/MAMP/htdocs/drupal7-test-site/sites/all/modules/civicrm/packages/DB.php:969
3   DB_Error->DB_Error(-1, 16, Array, 'DROP FUNCTION IF…')   /Applications/MAMP/htdocs/drupal7-test-site/sites/all/modules/civicrm/packages/PEAR.php:564
4   PEAR->raiseError(null, -1, null, null, 'DROP FUNCTION IF…', 'DB_Error', true)   /Applications/MAMP/htdocs/drupal7-test-site/sites/all/modules/civicrm/packages/DB/common.php:1905
5   DB_common->raiseError(-1, null, null, null, '1548 ** Cannot l…')   /Applications/MAMP/htdocs/drupal7-test-site/sites/all/modules/civicrm/packages/DB/mysql.php:898
6   DB_mysql->mysqlRaiseError()   /Applications/MAMP/htdocs/drupal7-test-site/sites/all/modules/civicrm/packages/DB/mysql.php:327
7   DB_mysql->simpleQuery('DROP FUNCTION IF…')   /Applications/MAMP/htdocs/drupal7-test-site/sites/all/modules/civicrm/packages/DB/common.php:1216
8   DB_common->query('DROP FUNCTION IF…')   /Applications/MAMP/htdocs/drupal7-test-site/sites/all/modules/civicrm/packages/DB/DataObject.php:2421
9   DB_DataObject->_query('DROP FUNCTION IF…')   /Applications/MAMP/htdocs/drupal7-test-site/sites/all/modules/civicrm/packages/DB/DataObject.php:1613
10   DB_DataObject->query('DROP FUNCTION IF…')   /Applications/MAMP/htdocs/drupal7-test-site/sites/all/modules/civicrm/CRM/Core/DAO.php:155
11   CRM_Core_DAO->query('DROP FUNCTION IF…', true)   /Applications/MAMP/htdocs/drupal7-test-site/sites/all/modules/civicrm/CRM/Core/DAO.php:917
12   CRM_Core_DAO::executeQuery('DROP FUNCTION IF…')   /Applications/MAMP/htdocs/drupal7-test-site/sites/all/modules/civicrm/CRM/Upgrade/Incremental/php/FourThree.php:934
13   CRM_Upgrade_Incremental_php_FourThree::phoneNumeric(Object(CRM_Queue_TaskContext))   unknown:unknown
14   call_user_func_array(Array, Array)   /Applications/MAMP/htdocs/drupal7-test-site/sites/all/modules/civicrm/CRM/Queue/Task.php:79
15   CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))   /Applications/MAMP/htdocs/drupal7-test-site/sites/all/modules/civicrm/CRM/Queue/Runner.php:186
16   CRM_Queue_Runner->runNext(true)   /Applications/MAMP/htdocs/drupal7-test-site/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php:44
17   CRM_Queue_Page_AJAX::{closure}()   /Applications/MAMP/htdocs/drupal7-test-site/sites/all/modules/civicrm/CRM/Queue/ErrorPolicy.php:80
18   CRM_Queue_ErrorPolicy->call(Object(Closure))   /Applications/MAMP/htdocs/drupal7-test-site/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php:47
19   CRM_Queue_Page_AJAX::runNext(Array)   unknown:unknown
20   call_user_func(Array, Array)   /Applications/MAMP/htdocs/drupal7-test-site/sites/all/modules/civicrm/CRM/Core/Invoke.php:258
21   CRM_Core_Invoke::runItem(Array)   /Applications/MAMP/htdocs/drupal7-test-site/sites/all/modules/civicrm/CRM/Core/Invoke.php:70
22   CRM_Core_Invoke::_invoke(Array)   /Applications/MAMP/htdocs/drupal7-test-site/sites/all/modules/civicrm/CRM/Core/Invoke.php:52
23   CRM_Core_Invoke::invoke(Array)   /Applications/MAMP/htdocs/drupal7-test-site/sites/all/modules/civicrm/drupal/civicrm.module:436
24   civicrm_invoke('upgrade', 'queue', 'ajax', 'runNext')   unknown:unknown
25   call_user_func_array('civicrm_invoke', Array)   /Applications/MAMP/htdocs/drupal7-test-site/includes/menu.inc:517
26   menu_execute_active_handler()   /Applications/MAMP/htdocs/drupal7-test-site/index.php:21
27   {main}   

I've tried 4.2.9 to 4.3.0, and other increments including to 4.3.4, and I always get the same error.

It seems to be related to http://forum.civicrm.org/index.php/topic,28652.15.html, but for me it is happening *during* the upgrade, so I don't know if/when the troubleshooting suggestions in that thread apply. (I'm not actually getting any errors using CiviCRM after the failed upgrade, but I do get "Database check failed - the database looks to have been partially upgraded. You may want to reload the database with the backup and try the upgrade process again." on certain screens, and it won't let me subsequently upgrade to another version, which is obviously a problem.)

I did try using this suggestion (http://forum.civicrm.org/index.php/topic,28652.msg123599.html#msg123599) to create the missing function using Drupal Devel before running the upgrade from 4.2.9, but with no luck -- same error. (Though I can't actually tell whether the code is running...I click Execute and then just get a white screen -- is there supposed to be confirmation message returned? There's still nothing in mysql.proc after I run it, so I'm guessing it's not working.)

Any advice would be appreciated!