Author Topic: Missing Table: xxxxxxx.civicrm_value_bank_details_9 (Read 1029 times)

Interpolat · December 16, 2013, 01:57:21 pm

Please help me resolve this. I must have deleted this table at some point, and now get this error with almost every Civi execution. How can I re-install table:

Database Error Code: Table 'xxxxxxx.civicrm_value_bank_details_9' doesn't exist, 1146
Additional Details:
Array
(
[callback] => Array
(

=> CRM_Core_Error

Code: [Select]

 => -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => CREATE TRIGGER civicrm_value_bank_details_9_after_insert after insert ON civicrm_value_bank_details_9 FOR EACH ROW BEGIN  
UPDATE civicrm_contact SET modified_date = CURRENT_TIMESTAMP WHERE id = NEW.entity_id;
 END [nativecode=1146 ** Table 'xxxxxxx.civicrm_value_bank_details_9' doesn't exist]
    [type] => DB_Error
    [user_info] => CREATE TRIGGER civicrm_value_bank_details_9_after_insert after insert ON civicrm_value_bank_details_9 FOR EACH ROW BEGIN  
UPDATE civicrm_contact SET modified_date = CURRENT_TIMESTAMP WHERE id = NEW.entity_id;
 END [nativecode=1146 ** Table 'xxxxxxx.civicrm_value_bank_details_9' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="CREATE TRIGGER civicrm_value_bank_details_9_after_insert after insert ON civicrm_value_bank_details_9 FOR EACH ROW BEGIN  
UPDATE civicrm_contact SET modified_date = CURRENT_TIMESTAMP WHERE id = NEW.entity_id;
 END [nativecode=1146 ** Table 'xxxxxxx.civicrm_value_bank_details_9' doesn't exist]"]
)

totten · December 16, 2013, 02:41:21 pm

Could there be a stale record in "civicrm_custom_group" -- e.g. somehow the table was deleted, but the reference to it in "civicrm_custom_group"" was left behind? If that's the case, you could try deleting the stale record.

Sometimes people have problems with custom-data tables following a backup/restore -- e.g. one should generally neesd to drop the DB (or drop all the civicrm_* tables) before restoring from a backup. If one restores a backup with dropping all the tables, there can be issues with re-creating the tables.

To get more directly to your question about creating the table... it's ordinarily created by installing org.civicrm.hrbank ( https://github.com/civicrm/civihr/tree/master/hrbank ). There's a file which defines the table and fields:

https://github.com/civicrm/civihr/blob/master/hrbank/xml/auto_install.xml

Things you could try:
* Reinstall the extension
* Import the XML manually by putting this snippet in a script ("/tmp/import-hrbank.php") and running it through drush ("drush scr /tmp/import-hrbank.php"):

Code: [Select]

    civicrm_initialize();
    require_once 'CRM/Utils/Migrate/Import.php';
    $import = new CRM_Utils_Migrate_Import();
    $import->run($xml_file);

Interpolat · December 16, 2013, 04:53:11 pm

@Totten

Thank you very much. Your first point re the civicrm_custom_group was spot on. I deleted the references in there, and all is well again. Greatly appreciated.

CiviCRM Community Forums (archive)

News:

Author Topic: Missing Table: xxxxxxx.civicrm_value_bank_details_9 (Read 1029 times)

Interpolat

Missing Table: xxxxxxx.civicrm_value_bank_details_9

totten

Re: Missing Table: xxxxxxx.civicrm_value_bank_details_9

Interpolat

Re: Missing Table: xxxxxxx.civicrm_value_bank_details_9