CiviCRM Community Forums (archive)

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
        )

   

=> -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.

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!