CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • DB Upgrade from 4.2.8 to 4.3.3 fails
Pages: [1]

Author Topic: DB Upgrade from 4.2.8 to 4.3.3 fails  (Read 2298 times)

kecker

  • I’m new here
  • *
  • Posts: 28
  • Karma: 1
DB Upgrade from 4.2.8 to 4.3.3 fails
June 06, 2013, 12:04:23 am
Upgrade seemed to go fine, but when I tried to run the database update script I got about 20% into it and then got this:

[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=1370 ** alter routine command denied to user 'bpoubuil_sd57'@'localhost' for routine 'bpoubuil_sd57.civicrm_strip_non_numeric']
DebugInfo   DROP FUNCTION IF EXISTS civicrm_strip_non_numeric [nativecode=1370 ** alter routine command denied to user 'bpoubuil_sd57'@'localhost' for routine 'bpoubuil_sd57.civicrm_strip_non_numeric']
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))   /home/bpoubuil/public_html/sd57/administrator/components/com_civicrm/civicrm/packages/PEAR.php:931
2   PEAR_Error->PEAR_Error('DB Error: unknow…', -1, 16, Array, 'DROP FUNCTION IF…')   /home/bpoubuil/public_html/sd57/administrator/components/com_civicrm/civicrm/packages/DB.php:969
3   DB_Error->DB_Error(-1, 16, Array, 'DROP FUNCTION IF…')   /home/bpoubuil/public_html/sd57/administrator/components/com_civicrm/civicrm/packages/PEAR.php:564
4   PEAR->raiseError(null, -1, null, null, 'DROP FUNCTION IF…', 'DB_Error', true)   /home/bpoubuil/public_html/sd57/administrator/components/com_civicrm/civicrm/packages/DB/common.php:1905
5   DB_common->raiseError(-1, null, null, null, '1370 ** alter ro…')   /home/bpoubuil/public_html/sd57/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php:898
6   DB_mysql->mysqlRaiseError()   /home/bpoubuil/public_html/sd57/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php:327
7   DB_mysql->simpleQuery('DROP FUNCTION IF…')   /home/bpoubuil/public_html/sd57/administrator/components/com_civicrm/civicrm/packages/DB/common.php:1216
8   DB_common->query('DROP FUNCTION IF…')   /home/bpoubuil/public_html/sd57/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php:2421
9   DB_DataObject->_query('DROP FUNCTION IF…')   /home/bpoubuil/public_html/sd57/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php:1613
10   DB_DataObject->query('DROP FUNCTION IF…')   /home/bpoubuil/public_html/sd57/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php:155
11   CRM_Core_DAO->query('DROP FUNCTION IF…', true)   /home/bpoubuil/public_html/sd57/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php:917
12   CRM_Core_DAO::executeQuery('DROP FUNCTION IF…')   /home/bpoubuil/public_html/sd57/administrator/components/com_civicrm/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)   /home/bpoubuil/public_html/sd57/administrator/components/com_civicrm/civicrm/CRM/Queue/Task.php:79
15   CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))   /home/bpoubuil/public_html/sd57/administrator/components/com_civicrm/civicrm/CRM/Queue/Runner.php:186
16   CRM_Queue_Runner->runNext(true)   /home/bpoubuil/public_html/sd57/administrator/components/com_civicrm/civicrm/CRM/Queue/Page/AJAX.php:44
17   {closure}()   /home/bpoubuil/public_html/sd57/administrator/components/com_civicrm/civicrm/CRM/Queue/ErrorPolicy.php:80
18   CRM_Queue_ErrorPolicy->call(Object(Closure))   /home/bpoubuil/public_html/sd57/administrator/components/com_civicrm/civicrm/CRM/Queue/Page/AJAX.php:47
19   CRM_Queue_Page_AJAX::runNext(Array)   unknown:unknown
20   call_user_func(Array, Array)   /home/bpoubuil/public_html/sd57/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php:258
21   CRM_Core_Invoke::runItem(Array)   /home/bpoubuil/public_html/sd57/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php:70
22   CRM_Core_Invoke::_invoke(Array)   /home/bpoubuil/public_html/sd57/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php:52
23   CRM_Core_Invoke::invoke(Array)   /home/bpoubuil/public_html/sd57/administrator/components/com_civicrm/admin.civicrm.php:116
24   civicrm_invoke()   /home/bpoubuil/public_html/sd57/administrator/components/com_civicrm/admin.civicrm.php:40
25   require_once('/home/bpoubuil/p…')   /home/bpoubuil/public_html/sd57/libraries/joomla/application/component/helper.php:383
26   JComponentHelper::executeComponent('/home/bpoubuil/p…')   /home/bpoubuil/public_html/sd57/libraries/joomla/application/component/helper.php:351
27   JComponentHelper::renderComponent('com_civicrm')   /home/bpoubuil/public_html/sd57/administrator/includes/application.php:153
28   JAdministrator->dispatch()   /home/bpoubuil/public_html/sd57/administrator/index.php:46
29   {main}   

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: DB Upgrade from 4.2.8 to 4.3.3 fails
June 09, 2013, 08:33:24 am
Appears that this SQL

Code: [Select]
DROP FUNCTION IF EXISTS civicrm_strip_non_numeric
which is perfectly valid, has generated an error. Even if your site lacked the civicrm_strip_non_numeric function, this SQL should work. Can you try to run that SQL on a COPY of your database and see if it works or not?
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Upperholme

  • Administrator
  • Ask me questions
  • *****
  • Posts: 568
  • Karma: 8
    • MC3
  • CiviCRM version: 4.x
  • CMS version: Drupal 6.x/7.x, Wordpress, Joomla
Re: DB Upgrade from 4.2.8 to 4.3.3 fails
June 10, 2013, 08:38:57 am
To me it looks like the db user does not have sufficient privileges to run this SQL command, and that's why it's failing. Is it possible to give the db user the required privileges?
Graham Mitchell
http://mc3.coop
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • DB Upgrade from 4.2.8 to 4.3.3 fails

This forum was archived on 2017-11-26.