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 »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Dedupe Error - Database table not found
Pages: [1]

Author Topic: Dedupe Error - Database table not found  (Read 3649 times)

dtheweather9

  • I post occasionally
  • **
  • Posts: 57
  • Karma: 1
    • Students for the Exploration and Development of Space, USA
  • CiviCRM version: 4.4.0
  • CMS version: WordPress 3.8.1
  • MySQL version: 5.1.56
  • PHP version: 5.4.11
Dedupe Error - Database table not found
September 03, 2013, 12:06:47 pm
Good Afternoon;
I've been trying to de-duplicate about 600-5000 records using a wordpress on the newest version of wordpress and civicrm version 4.3.5

It finds the records in questions, however when i try to execute the deduplication, I get an error saying:

DB Error: no such table

I then threw it on debug/backtrace and got the following:
Backtrace:
Quote
#0 [WP-SITEROOT]/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(148): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 [WP-SITEROOT]/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 [WP-SITEROOT]/wp-content/plugins/civicrm/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: no such table", -18, 16, (Array:2), "SELECT id, school_1 AS custom_1, chapter_description_2 AS custom_2, founding_...")
#4 [WP-SITEROOT]/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-18, 16, (Array:2), "SELECT id, school_1 AS custom_1, chapter_description_2 AS custom_2, founding_...")
#5 [WP-SITEROOT]/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -18, NULL, NULL, "SELECT id, school_1 AS custom_1, chapter_description_2 AS custom_2, founding_...", "DB_Error", TRUE)
#6 [WP-SITEROOT]/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-18, NULL, NULL, NULL, "1146 ** Table '[DATABASE].civicrm_value_chapter_details_1' doesn't exist")
#7 [WP-SITEROOT]/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 [WP-SITEROOT]/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("SELECT id, school_1 AS custom_1, chapter_description_2 AS custom_2, founding_...")
#9 [WP-SITEROOT]/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(2421): DB_common->query("SELECT id, school_1 AS custom_1, chapter_description_2 AS custom_2, founding_...")
#10 [WP-SITEROOT]/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(1613): DB_DataObject->_query("SELECT id, school_1 AS custom_1, chapter_description_2 AS custom_2, founding_...")
#11 [WP-SITEROOT]/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(155): DB_DataObject->query("SELECT id, school_1 AS custom_1, chapter_description_2 AS custom_2, founding_...")
#12 [WP-SITEROOT]/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(917): CRM_Core_DAO->query("SELECT id, school_1 AS custom_1, chapter_description_2 AS custom_2, founding_...", TRUE)
#13 [WP-SITEROOT]/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/CustomValueTable.php(427): CRM_Core_DAO::executeQuery("SELECT id, school_1 AS custom_1, chapter_description_2 AS custom_2, founding_...")
#14 [WP-SITEROOT]/wp-content/plugins/civicrm/civicrm/CRM/Dedupe/Merger.php(494): CRM_Core_BAO_CustomValueTable::getEntityValues("7380")
#15 [WP-SITEROOT]/wp-content/plugins/civicrm/civicrm/CRM/Dedupe/Merger.php(811): CRM_Dedupe_Merger::findDifferences((Array:47), (Array:47))
#16 [WP-SITEROOT]/wp-content/plugins/civicrm/civicrm/CRM/Dedupe/Merger.php(593): CRM_Dedupe_Merger::getRowsElementsAndInfo("7380", "7624")
#17 [WP-SITEROOT]/wp-content/plugins/civicrm/civicrm/CRM/Dedupe/Merger.php(547): CRM_Dedupe_Merger::merge((Array:75), (Array:3), "safe", TRUE, TRUE)
#18 [WP-SITEROOT]/wp-content/plugins/civicrm/civicrm/CRM/Contact/Page/DedupeFind.php(95): CRM_Dedupe_Merger::batchMerge("10", NULL, "safe", TRUE, TRUE)
#19 [WP-SITEROOT]/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(292): CRM_Contact_Page_DedupeFind->run((Array:3), NULL)
#20 [WP-SITEROOT]/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(70): CRM_Core_Invoke::runItem((Array:13))
#21 [WP-SITEROOT]/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#22 [WP-SITEROOT]/wp-content/plugins/civicrm/civicrm.php(344): CRM_Core_Invoke::invoke((Array:3))
#23 [internal function](): civicrm_wp_invoke("")
#24 [WP-SITEROOT]/wp-includes/plugin.php(406): call_user_func_array("civicrm_wp_invoke", (Array:1))
#25 [WP-SITEROOT]/wp-admin/admin.php(149): do_action("toplevel_page_CiviCRM")
#26 {main}

and the following debug:

Code: [Select]
Database Error Code: Table '[DATABASE].civicrm_value_chapter_details_1' doesn't exist, 1146
Additional Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => SELECT id, school_1 AS custom_1, chapter_description_2 AS custom_2, founding_date_3 AS custom_3 FROM civicrm_value_chapter_details_1 WHERE entity_id = 7380 [nativecode=1146 ** Table '[DATABASE].civicrm_value_chapter_details_1' doesn't exist]
    [type] => DB_Error
    [user_info] => SELECT id, school_1 AS custom_1, chapter_description_2 AS custom_2, founding_date_3 AS custom_3 FROM civicrm_value_chapter_details_1 WHERE entity_id = 7380 [nativecode=1146 ** Table '[DATABASE].civicrm_value_chapter_details_1' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT id, school_1 AS custom_1, chapter_description_2 AS custom_2, founding_date_3 AS custom_3 FROM civicrm_value_chapter_details_1 WHERE entity_id = 7380 [nativecode=1146 ** Table '[DATABASE].civicrm_value_chapter_details_1' doesn't exist]"]
)

"chapter details" is one of my custom fields for a sub-type organization; though I'm merging things in another organization sub-type entirely. 
Any thoughts on what could be the issue?

dtheweather9

  • I post occasionally
  • **
  • Posts: 57
  • Karma: 1
    • Students for the Exploration and Development of Space, USA
  • CiviCRM version: 4.4.0
  • CMS version: WordPress 3.8.1
  • MySQL version: 5.1.56
  • PHP version: 5.4.11
Re: Dedupe Error - Database table not found
September 03, 2013, 06:10:56 pm
It appears the issue is two custom fields were interfering with the merge; disabling them (not deleting them) appears to be fixing the issue and I'm able to merge contacts again.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Dedupe Error - Database table not found

This forum was archived on 2017-11-26.