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) »
  • upgrading 4.4 to 4.5 fails after database upgrade is done
Pages: [1]

Author Topic: upgrading 4.4 to 4.5 fails after database upgrade is done  (Read 944 times)

helenbn

  • I post occasionally
  • **
  • Posts: 87
  • Karma: 2
    • Pretty Good Designs
  • CiviCRM version: 4.5.x
  • CMS version: Joomla 2.5.x, 3.x
  • MySQL version: 5.x.x
  • PHP version: 5.x.x
upgrading 4.4 to 4.5 fails after database upgrade is done
November 06, 2014, 01:54:59 pm
Hi,

Upgrading CiviCRM 4.4 to 4.5 seems to do fine all the way through the database upgrade process is "Done!" but I do not get the "Success" page. Instead I get :
Quote
Sorry but we are not able to provide this at the moment.
DB Error: unknown error
Return to home page.
It all seems ok but I am not sure. Anything I can check?

Using Joomla 2.5.x

Thanks,
Helen
Pretty Good Designs | http://prettygooddesigns.com | Hey, that's pretty good!

helenbn

  • I post occasionally
  • **
  • Posts: 87
  • Karma: 2
    • Pretty Good Designs
  • CiviCRM version: 4.5.x
  • CMS version: Joomla 2.5.x, 3.x
  • MySQL version: 5.x.x
  • PHP version: 5.x.x
Re: upgrading 4.4 to 4.5 fails after database upgrade is done
November 06, 2014, 02:06:13 pm
Just tested and I get the same error when going form the Confirmation to the Payment Gateway.

Checked the Logs and I have this error:
Quote
Nov 06 16:00:50  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
           
  • => CRM_Core_Error
    • [1] => handle
            )

       
Code: [Select]
=> -1
    [message] => DB Error: unknown error
    [mode] => 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]
    [type] => DB_Error
    [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]"]
)


Nov 06 16:00:50  [info] $backTrace = #0 /home/thecrook/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php(239): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /home/thecrook/public_html/administrator/components/com_civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /home/thecrook/public_html/administrator/components/com_civicrm/civicrm/packages/DB.php(975): PEAR_Error->PEAR_Error("DB Error: unknown error", -1, 16, (Array:2), "SHOW function status WHERE db = database() AND name = 'civicrm_strip_non_nume...")
#4 /home/thecrook/public_html/administrator/components/com_civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-1, 16, (Array:2), "SHOW function status WHERE db = database() AND name = 'civicrm_strip_non_nume...")
#5 /home/thecrook/public_html/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -1, NULL, NULL, "SHOW function status WHERE db = database() AND name = 'civicrm_strip_non_nume...", "DB_Error", TRUE)
#6 /home/thecrook/public_html/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(899): DB_common->raiseError(-1, NULL, NULL, NULL, "1548 ** Cannot load from mysql.proc. The table is probably corrupted")
#7 /home/thecrook/public_html/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(328): DB_mysql->mysqlRaiseError()
#8 /home/thecrook/public_html/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("SHOW function status WHERE db = database() AND name = 'civicrm_strip_non_nume...")
#9 /home/thecrook/public_html/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(2442): DB_common->query("SHOW function status WHERE db = database() AND name = 'civicrm_strip_non_nume...")
#10 /home/thecrook/public_html/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(1634): DB_DataObject->_query("SHOW function status WHERE db = database() AND name = 'civicrm_strip_non_nume...")
#11 /home/thecrook/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(325): DB_DataObject->query("SHOW function status WHERE db = database() AND name = 'civicrm_strip_non_nume...")
#12 /home/thecrook/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(1116): CRM_Core_DAO->query("SHOW function status WHERE db = database() AND name = 'civicrm_strip_non_nume...", TRUE)
#13 /home/thecrook/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(1737): CRM_Core_DAO::executeQuery("SHOW function status WHERE db = database() AND name = 'civicrm_strip_non_nume...")
#14 /home/thecrook/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/Phone.php(79): CRM_Core_DAO::checkSqlFunctionsExist()
#15 /home/thecrook/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/Block.php(379): CRM_Core_BAO_Phone::add((Array:7))
#16 /home/thecrook/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/Location.php(68): CRM_Core_BAO_Block::create("phone", (Array:28), NULL)
#17 /home/thecrook/public_html/administrator/components/com_civicrm/civicrm/CRM/Contact/BAO/Contact.php(358): CRM_Core_BAO_Location::create((Array:28), TRUE)
#18 /home/thecrook/public_html/administrator/components/com_civicrm/civicrm/CRM/Contact/BAO/Contact.php(1849): CRM_Contact_BAO_Contact::create((Array:28))
#19 /home/thecrook/public_html/administrator/components/com_civicrm/civicrm/CRM/Contribute/Form/Contribution/Confirm.php(835): CRM_Contact_BAO_Contact::createProfileContact((Array:29), (Array:11), "1", (Array:0), NULL, NULL, TRUE)
#20 /home/thecrook/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Form.php(328): CRM_Contribute_Form_Contribution_Confirm->postProcess()
#21 /home/thecrook/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/StateMachine.php(162): CRM_Core_Form->mainProcess()
#22 /home/thecrook/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/QuickForm/Action/Next.php(60): CRM_Core_StateMachine->perform(Object(CRM_Contribute_Form_Contribution_Confirm), "next", "Next")
#23 /home/thecrook/public_html/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Contribute_Form_Contribution_Confirm), "next")
#24 /home/thecrook/public_html/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contribute_Form_Contribution_Confirm), "next")
#25 /home/thecrook/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Controller.php(356): HTML_QuickForm_Page->handle("next")
#26 /home/thecrook/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(331): CRM_Core_Controller->run((Array:3), NULL)
#27 /home/thecrook/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(75): CRM_Core_Invoke::runItem((Array:15))
#28 /home/thecrook/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#29 /home/thecrook/public_html/components/com_civicrm/civicrm.php(86): CRM_Core_Invoke::invoke((Array:3))
#30 /home/thecrook/public_html/components/com_civicrm/civicrm.php(11): civicrm_invoke()
#31 /home/thecrook/public_html/libraries/joomla/application/component/helper.php(380): require_once("/home/thecrook/public_html/components/com_civicrm/civicrm.php")
#32 /home/thecrook/public_html/libraries/joomla/application/component/helper.php(348): JComponentHelper::executeComponent("/home/thecrook/public_html/components/com_civicrm/civicrm.php")
#33 /home/thecrook/public_html/includes/application.php(194): JComponentHelper::renderComponent("com_civicrm")
#34 /home/thecrook/public_html/index.php(42): JSite->dispatch()
#35 {main}[/quote]

I have this set up in a local environment without the error. Can I just repair the database table from the one I have? If so, can you tell which table is in need of repair?

Thanks,
Helen
Pretty Good Designs | http://prettygooddesigns.com | Hey, that's pretty good!

helenbn

  • I post occasionally
  • **
  • Posts: 87
  • Karma: 2
    • Pretty Good Designs
  • CiviCRM version: 4.5.x
  • CMS version: Joomla 2.5.x, 3.x
  • MySQL version: 5.x.x
  • PHP version: 5.x.x
Re: upgrading 4.4 to 4.5 fails after database upgrade is done
November 07, 2014, 01:29:07 pm
Rebuilt the site locally by using backups that included last successful contribution. Upgraded locally and got no errors. Moved site back to live and looks great. Tried to make a contribution and got the same error in the logs. :(

Civi 4.5.3

Looking for answers.

Pretty Good Designs | http://prettygooddesigns.com | Hey, that's pretty good!

helenbn

  • I post occasionally
  • **
  • Posts: 87
  • Karma: 2
    • Pretty Good Designs
  • CiviCRM version: 4.5.x
  • CMS version: Joomla 2.5.x, 3.x
  • MySQL version: 5.x.x
  • PHP version: 5.x.x
Re: upgrading 4.4 to 4.5 fails after database upgrade is done
November 08, 2014, 12:10:12 pm
Found where this is involves ~administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php

Code: [Select]
/**
   * Because sql functions are sometimes lost, esp during db migration, we check here to avoid numerous support requests
   * @see http://issues.civicrm.org/jira/browse/CRM-13822
   * TODO: Alternative solutions might be
   *  * Stop using functions and find another way to strip numeric characters from phones
   *  * Give better error messages (currently a missing fn fatals with "unknown error")
   */
  static function checkSqlFunctionsExist() {
    if (!self::$_checkedSqlFunctionsExist) {
      self::$_checkedSqlFunctionsExist = TRUE;
      $dao = CRM_Core_DAO::executeQuery("SHOW function status WHERE db = database() AND name = 'civicrm_strip_non_numeric'");
      if (!$dao->fetch()) {
        self::triggerRebuild();
      }
    }
  }
Pretty Good Designs | http://prettygooddesigns.com | Hey, that's pretty good!

helenbn

  • I post occasionally
  • **
  • Posts: 87
  • Karma: 2
    • Pretty Good Designs
  • CiviCRM version: 4.5.x
  • CMS version: Joomla 2.5.x, 3.x
  • MySQL version: 5.x.x
  • PHP version: 5.x.x
Re: upgrading 4.4 to 4.5 fails after database upgrade is done
November 10, 2014, 05:58:54 am
My host ran a command that forced update of cPanel and particularly MySQL and that fixed everything.

Hope that will help someone else.
Pretty Good Designs | http://prettygooddesigns.com | Hey, that's pretty good!

Dan C

  • I post frequently
  • ***
  • Posts: 179
  • Karma: 17
  • CiviCRM version: All
  • CMS version: Joomla 2.5 and 3.X, Drupal 7, Wordpress 3.7 and up
  • MySQL version: 5.1.7 and up
  • PHP version: 5.3.5 and up
Re: upgrading 4.4 to 4.5 fails after database upgrade is done
November 10, 2014, 12:50:56 pm
Do you know what version of MySQL you were on and went to?  It would be good to know if it is a problem with a specific version of MySQL.
CrusonWeb - Web Development, Implementation, and Support.  Specializing in CiviCRM and Joomla (although also knowledgable in Wordpress and Drupal as well).

helenbn

  • I post occasionally
  • **
  • Posts: 87
  • Karma: 2
    • Pretty Good Designs
  • CiviCRM version: 4.5.x
  • CMS version: Joomla 2.5.x, 3.x
  • MySQL version: 5.x.x
  • PHP version: 5.x.x
Re: upgrading 4.4 to 4.5 fails after database upgrade is done
November 10, 2014, 12:58:02 pm
Went to 5.5.37 from something lower... can't remember.  :-\  But even though it did not affect another site with Civi on it, it did this one. Thinking that the upgrade originally went through overlapped with a cron I may have had running, either within Civi or a database backup or something. Hard to tell. Anyway, that was a month ago and there wasn't a Civi payment/donation made until later - then the error was discovered. So too I discovered the error upon updating Civi on the live version
Pretty Good Designs | http://prettygooddesigns.com | Hey, that's pretty good!

helenbn

  • I post occasionally
  • **
  • Posts: 87
  • Karma: 2
    • Pretty Good Designs
  • CiviCRM version: 4.5.x
  • CMS version: Joomla 2.5.x, 3.x
  • MySQL version: 5.x.x
  • PHP version: 5.x.x
Re: upgrading 4.4 to 4.5 fails after database upgrade is done
November 26, 2014, 12:22:52 pm
Correction: Went from 5.1.73 to 5.5.37 then to 5.5.40. The first upgrade is when it initially broke.
Pretty Good Designs | http://prettygooddesigns.com | Hey, that's pretty good!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • upgrading 4.4 to 4.5 fails after database upgrade is done

This forum was archived on 2017-11-26.