CiviCRM Community Forums (archive)

Hello,

Did an import (that was successful, btw) but instead of giving a success message, it gave me a "DB Error: no such table" error. Not a clue where to start with the error log, but this is what is say:

Nov 09 15:20:56  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

Code: [Select]

=> -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => UPDATE civicrm_import_job_5f005519defb49b56b7b22bdd7d19a88
                      SET    _status      = 'IMPORTED',
                             _statusMsg = NULL
                      WHERE  _id       = '200' [nativecode=1146 ** Table 'aceadvoc.civicrm_import_job_5f005519defb49b56b7b22bdd7d19a88' doesn't exist]
    [type] => DB_Error
    [user_info] => UPDATE civicrm_import_job_5f005519defb49b56b7b22bdd7d19a88
                      SET    _status      = 'IMPORTED',
                             _statusMsg = NULL
                      WHERE  _id       = '200' [nativecode=1146 ** Table 'aceadvoc.civicrm_import_job_5f005519defb49b56b7b22bdd7d19a88' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="UPDATE civicrm_import_job_5f005519defb49b56b7b22bdd7d19a88
                      SET    _status      = 'IMPORTED',
                             _statusMsg = NULL
                      WHERE  _id       = '200' [nativecode=1146 ** Table 'aceadvoc.civicrm_import_job_5f005519defb49b56b7b22bdd7d19a88' doesn't exist]"]
)


Nov 09 15:20:56  [info] $backTrace = #0 /mnt/data/vhosts/casite-232297.cloudaccess.net/httpdocs/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php(196): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /mnt/data/vhosts/casite-232297.cloudaccess.net/httpdocs/administrator/components/com_civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /mnt/data/vhosts/casite-232297.cloudaccess.net/httpdocs/administrator/components/com_civicrm/civicrm/packages/DB.php(968): PEAR_Error->PEAR_Error("DB Error: no such table", -18, 16, (Array:2), "UPDATE civicrm_import_job_5f005519defb49b56b7b22bdd7d19a88\n                 ...")
#4 /mnt/data/vhosts/casite-232297.cloudaccess.net/httpdocs/administrator/components/com_civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-18, 16, (Array:2), "UPDATE civicrm_import_job_5f005519defb49b56b7b22bdd7d19a88\n                 ...")
#5 /mnt/data/vhosts/casite-232297.cloudaccess.net/httpdocs/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1903): PEAR->raiseError(NULL, -18, NULL, NULL, "UPDATE civicrm_import_job_5f005519defb49b56b7b22bdd7d19a88\n                 ...", "DB_Error", TRUE)
#6 /mnt/data/vhosts/casite-232297.cloudaccess.net/httpdocs/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-18, NULL, NULL, NULL, "1146 ** Table 'aceadvoc.civicrm_import_job_5f005519defb49b56b7b22bdd7d19a88' ...")
#7 /mnt/data/vhosts/casite-232297.cloudaccess.net/httpdocs/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /mnt/data/vhosts/casite-232297.cloudaccess.net/httpdocs/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1012): DB_mysql->simpleQuery("UPDATE civicrm_import_job_5f005519defb49b56b7b22bdd7d19a88\n                 ...")
#9 /mnt/data/vhosts/casite-232297.cloudaccess.net/httpdocs/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1211): DB_common->execute(399, (Array:3))
#10 /mnt/data/vhosts/casite-232297.cloudaccess.net/httpdocs/administrator/components/com_civicrm/civicrm/CRM/Import/Parser.php(963): DB_common->query("UPDATE civicrm_import_job_5f005519defb49b56b7b22bdd7d19a88\n                 ...", (Array:3))
#11 /mnt/data/vhosts/casite-232297.cloudaccess.net/httpdocs/administrator/components/com_civicrm/civicrm/CRM/Import/Parser/Contact.php(2039): CRM_Import_Parser->updateImportRecord("200", (Array:1))
#12 /mnt/data/vhosts/casite-232297.cloudaccess.net/httpdocs/administrator/components/com_civicrm/civicrm/CRM/Import/Parser/Contact.php(980): CRM_Import_Parser_Contact->processMessage((Array:12), "_status", 1)
#13 /mnt/data/vhosts/casite-232297.cloudaccess.net/httpdocs/administrator/components/com_civicrm/civicrm/CRM/Import/Parser.php(358): CRM_Import_Parser_Contact->import("8", (Array:12), NULL)
#14 /mnt/data/vhosts/casite-232297.cloudaccess.net/httpdocs/administrator/components/com_civicrm/civicrm/CRM/Import/ImportJob.php(275): CRM_Import_Parser->run("civicrm_import_job_5f005519defb49b56b7b22bdd7d19a88", (Array:9), 8, 1, "_id", "_status", "8", "4cb7b734ce66e8295f6dc425a93700f5", 1122, NULL, 30, NULL, "19")
#15 /mnt/data/vhosts/casite-232297.cloudaccess.net/httpdocs/administrator/components/com_civicrm/civicrm/CRM/Import/Form/Preview.php(289): CRM_Import_ImportJob->runImport(Object(CRM_Import_Form_Preview))
#16 /mnt/data/vhosts/casite-232297.cloudaccess.net/httpdocs/administrator/components/com_civicrm/civicrm/CRM/Core/Form.php(246): CRM_Import_Form_Preview->postProcess()
#17 /mnt/data/vhosts/casite-232297.cloudaccess.net/httpdocs/administrator/components/com_civicrm/civicrm/CRM/Core/StateMachine.php(159): CRM_Core_Form->mainProcess()
#18 /mnt/data/vhosts/casite-232297.cloudaccess.net/httpdocs/administrator/components/com_civicrm/civicrm/CRM/Core/QuickForm/Action/Next.php(60): CRM_Core_StateMachine->perform(Object(CRM_Import_Form_Preview), "next", "Next")
#19 /mnt/data/vhosts/casite-232297.cloudaccess.net/httpdocs/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Import_Form_Preview), "next")
#20 /mnt/data/vhosts/casite-232297.cloudaccess.net/httpdocs/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Import_Form_Preview), "next")
#21 /mnt/data/vhosts/casite-232297.cloudaccess.net/httpdocs/administrator/components/com_civicrm/civicrm/CRM/Core/Controller.php(289): HTML_QuickForm_Page->handle("next")
#22 /mnt/data/vhosts/casite-232297.cloudaccess.net/httpdocs/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(227): CRM_Core_Controller->run((Array:3), NULL)
#23 /mnt/data/vhosts/casite-232297.cloudaccess.net/httpdocs/administrator/components/com_civicrm/admin.civicrm.php(87): CRM_Core_Invoke::invoke((Array:3))
#24 /mnt/data/vhosts/casite-232297.cloudaccess.net/httpdocs/administrator/components/com_civicrm/admin.civicrm.php(40): civicrm_invoke()
#25 /mnt/data/vhosts/casite-232297.cloudaccess.net/httpdocs/libraries/joomla/application/component/helper.php(383): require_once("/mnt/data/vhosts/casite-232297.cloudaccess.net/httpdocs/administrator/compone...")
#26 /mnt/data/vhosts/casite-232297.cloudaccess.net/httpdocs/libraries/joomla/application/component/helper.php(351): JComponentHelper::executeComponent("/mnt/data/vhosts/casite-232297.cloudaccess.net/httpdocs/administrator/compone...")
#27 /mnt/data/vhosts/casite-232297.cloudaccess.net/httpdocs/administrator/includes/application.php(153): JComponentHelper::renderComponent("com_civicrm")
#28 /mnt/data/vhosts/casite-232297.cloudaccess.net/httpdocs/administrator/index.php(46): JAdministrator->dispatch()
#29 {main}


Thanks for your thoughts