Database Error Since VPS Server Migration

[luchtcm]

Hi all,

Our CiviCRM forms that rely on profiles are no longer working. There may be other stuff that's not working, but we haven't run into it yet.

Our VPS provider migrated our site from one server to another (for performance reasons). Below what I sent to the hosting provider. Unfortunately, they don't have any database backups to fix the issue. Any thoughts? Would an upgrade fix the corruption? Any ideas? Thanks!

Thanks in advance,

Craig

Here is the error:

Database Error Code: Cannot load from mysql.proc. The table is probably corrupted, 1548
Additional Details:
Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

Code: [Select]

=> -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => UPDATE  civicrm_phone  SET is_primary = 0   WHERE (  civicrm_phone.id = 239 )   [nativecode=1548 ** Cannot load from mysql.proc. The table is probably corrupted]
    [type] => DB_Error
    [user_info] => UPDATE  civicrm_phone  SET is_primary = 0   WHERE (  civicrm_phone.id = 239 )   [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="UPDATE  civicrm_phone  SET is_primary = 0   WHERE (  civicrm_phone.id = 239 )   [nativecode=1548 ** Cannot load from mysql.proc. The table is probably corrupted]"]
)

backTrace

#0 /home/autismmc/public_html/sites/all/modules/civicrm/CRM/Core/Error.php(149): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /home/autismmc/public_html/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /home/autismmc/public_html/sites/all/modules/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: unknown error", -1, 16, (Array:2), "UPDATE  civicrm_phone  SET is_primary = 0   WHERE (  civicrm_phone.id = 239 )...")
#4 /home/autismmc/public_html/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-1, 16, (Array:2), "UPDATE  civicrm_phone  SET is_primary = 0   WHERE (  civicrm_phone.id = 239 )...")
#5 /home/autismmc/public_html/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -1, NULL, NULL, "UPDATE  civicrm_phone  SET is_primary = 0   WHERE (  civicrm_phone.id = 239 )...", "DB_Error", TRUE)
#6 /home/autismmc/public_html/sites/all/modules/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-1, NULL, NULL, NULL, "1548 ** Cannot load from mysql.proc. The table is probably corrupted")
#7 /home/autismmc/public_html/sites/all/modules/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /home/autismmc/public_html/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("UPDATE  civicrm_phone  SET is_primary = 0   WHERE (  civicrm_phone.id = 239 )  ")
#9 /home/autismmc/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php(2421): DB_common->query("UPDATE  civicrm_phone  SET is_primary = 0   WHERE (  civicrm_phone.id = 239 )  ")
#10 /home/autismmc/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php(1324): DB_DataObject->_query("UPDATE  civicrm_phone  SET is_primary = 0   WHERE (  civicrm_phone.id = 239 )  ")
#11 /home/autismmc/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php(274): DB_DataObject->update()
#12 /home/autismmc/public_html/sites/all/modules/civicrm/CRM/Core/BAO/Block.php(279): CRM_Core_DAO->save()
#13 /home/autismmc/public_html/sites/all/modules/civicrm/CRM/Core/BAO/Location.php(66): CRM_Core_BAO_Block::create("phone", (Array:31), NULL)
#14 /home/autismmc/public_html/sites/all/modules/civicrm/CRM/Contact/BAO/Contact.php(352): CRM_Core_BAO_Location::create((Array:31), TRUE)
#15 /home/autismmc/public_html/sites/all/modules/civicrm/CRM/Contact/BAO/Contact.php(1775): CRM_Contact_BAO_Contact::create((Array:31))
#16 /home/autismmc/public_html/sites/all/modules/civicrm/CRM/Event/Form/Registration/Confirm.php(1112): CRM_Contact_BAO_Contact::createProfileContact((Array:44), (Array:25), "2", (Array:0), NULL, "Individual", TRUE)
#17 /home/autismmc/public_html/sites/all/modules/civicrm/CRM/Event/Form/Registration/Confirm.php(556): CRM_Event_Form_Registration_Confirm->updateContactFields("2", (Array:44), (Array:25))
#18 /home/autismmc/public_html/sites/all/modules/civicrm/CRM/Core/Form.php(261): CRM_Event_Form_Registration_Confirm->postProcess()
#19 /home/autismmc/public_html/sites/all/modules/civicrm/CRM/Core/StateMachine.php(160): CRM_Core_Form->mainProcess()
#20 /home/autismmc/public_html/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php(60): CRM_Core_StateMachine->perform(Object(CRM_Event_Form_Registration_Confirm), "next", "Next")
#21 /home/autismmc/public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Event_Form_Registration_Confirm), "next")
#22 /home/autismmc/public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Event_Form_Registration_Confirm), "next")
#23 /home/autismmc/public_html/sites/all/modules/civicrm/CRM/Core/Controller.php(345): HTML_QuickForm_Page->handle("next")
#24 /home/autismmc/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(323): CRM_Core_Controller->run((Array:3), NULL)
#25 /home/autismmc/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(72): CRM_Core_Invoke::runItem((Array:15))
#26 /home/autismmc/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#27 /home/autismmc/public_html/sites/all/modules/civicrm/drupal/civicrm.module(456): CRM_Core_Invoke::invoke((Array:3))
#28 [internal function](): civicrm_invoke("event", "register")
#29 /home/autismmc/public_html/includes/menu.inc(517): call_user_func_array("civicrm_invoke", (Array:2))
#30 /home/autismmc/public_html/index.php(21): menu_execute_active_handler()
#31 {main}

I found a similar error on a CiviCRM forum: http://forum.civicrm.org/index.php?topic=28748.5;wap2. The host in question stated the following: For future reference problem was the innodb_file_per_table restriction in root mysql configuration of VPS which was preventing clean import.

[Hershel]

This is actually a server admin problem, not related to CiviCRM. Your only real error is:

Cannot load from mysql.proc. The table is probably corrupted, 1548

and one fix is to ask the host to execute this:

Code: [Select]

mysql_upgrade -uroot -p
This an upgrade to MySQL, not to CiviCRM. Upgrading CiviCRM should not be expected to fix this, as it's a MySQL problem.

PS: Running CiviCRM without regular backups is extremely discouraged.

[luchtcm]

Thanks much. I'll send that along to the hosting provider to see what they say.

Unfortunately, I had thought that we were getting regular backups, but, of course, a situation like this comes up only to find out that we're not taking regular backups.

I'll let you know what happens next.

Thanks!

[luchtcm]

This is now working. After the hosting provider ran the command, I reset the triggers for the site and everything is now good.

Thanks much!