advimport 1.4 breaks standard contact import
While doing a standard contact import with advimport 1.4 installed, we get a "no such field" db error. Backtrace is faulting advimport. It looks like advimport_civicrm_import()
doesn't distinguish between standard and advanced contact imports.
Error and backtrace as follows:
Mar 10 13:14:56 [error] $Fatal Error Details = Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => exceptionHandler
)
[code] => -19
[message] => DB Error: no such field
[mode] => 16
[debug_info] => UPDATE civicrm_tmp_d_dflt_85fabf0284447b77757606ee78c61a8c SET entity_table = 'civicrm_contact', entity_id = '148148' WHERE _id = 4 [nativecode=1054 ** Unknown column 'entity_table' in 'field list']
[type] => DB_Error
[user_info] => UPDATE civicrm_tmp_d_dflt_85fabf0284447b77757606ee78c61a8c SET entity_table = 'civicrm_contact', entity_id = '148148' WHERE _id = 4 [nativecode=1054 ** Unknown column 'entity_table' in 'field list']
[to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="UPDATE civicrm_tmp_d_dflt_85fabf0284447b77757606ee78c61a8c SET entity_table = 'civicrm_contact', entity_id = '148148' WHERE _id = 4 [nativecode=1054 ** Unknown column 'entity_table' in 'field list']"]
)
Mar 10 13:14:56 [debug] $backTrace = #0 /var/www/example.org/vendor/civicrm/civicrm-core/CRM/Core/Error.php(942): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /var/www/example.org/vendor/pear/pear-core-minimal/src/PEAR.php(944): CRM_Core_Error::exceptionHandler(Object(DB_Error))
#2 /var/www/example.org/vendor/pear/db/DB.php(997): PEAR_Error->__construct("DB Error: no such field", -19, 16, (Array:2), "UPDATE civicrm_tmp_d_dflt_85fabf0284447b77757606ee78c61a8c SET entity_table =...")
#3 /var/www/example.org/vendor/pear/pear-core-minimal/src/PEAR.php(575): DB_Error->__construct(-19, 16, (Array:2), "UPDATE civicrm_tmp_d_dflt_85fabf0284447b77757606ee78c61a8c SET entity_table =...")
#4 /var/www/example.org/vendor/pear/pear-core-minimal/src/PEAR.php(223): PEAR::_raiseError(Object(DB_mysqli), NULL, -19, 16, (Array:2), "UPDATE civicrm_tmp_d_dflt_85fabf0284447b77757606ee78c61a8c SET entity_table =...", "DB_Error", TRUE)
#5 /var/www/example.org/vendor/pear/db/DB/common.php(1928): PEAR->__call("raiseError", (Array:7))
#6 /var/www/example.org/vendor/pear/db/DB/mysqli.php(936): DB_common->raiseError(-19, NULL, NULL, "UPDATE civicrm_tmp_d_dflt_85fabf0284447b77757606ee78c61a8c SET entity_table =...", "1054 ** Unknown column 'entity_table' in 'field list'")
#7 /var/www/example.org/vendor/pear/db/DB/mysqli.php(406): DB_mysqli->mysqliRaiseError()
#8 /var/www/example.org/vendor/pear/db/DB/common.php(1234): DB_mysqli->simpleQuery("UPDATE civicrm_tmp_d_dflt_85fabf0284447b77757606ee78c61a8c SET entity_table =...")
#9 /var/www/example.org/vendor/civicrm/civicrm-packages/DB/DataObject.php(2696): DB_common->query("UPDATE civicrm_tmp_d_dflt_85fabf0284447b77757606ee78c61a8c SET entity_table =...")
#10 /var/www/example.org/vendor/civicrm/civicrm-packages/DB/DataObject.php(1829): DB_DataObject->_query("UPDATE civicrm_tmp_d_dflt_85fabf0284447b77757606ee78c61a8c SET entity_table =...")
#11 /var/www/example.org/vendor/civicrm/civicrm-core/CRM/Core/DAO.php(468): DB_DataObject->query("UPDATE civicrm_tmp_d_dflt_85fabf0284447b77757606ee78c61a8c SET entity_table =...")
#12 /var/www/example.org/vendor/civicrm/civicrm-core/CRM/Core/DAO.php(1621): CRM_Core_DAO->query("UPDATE civicrm_tmp_d_dflt_85fabf0284447b77757606ee78c61a8c SET entity_table =...", TRUE)
#13 /var/www/example.org/web/sites/all/civicrm/extensions/advimport/CRM/Advimport/Utils.php(622): CRM_Core_DAO::executeQuery("UPDATE civicrm_tmp_d_dflt_85fabf0284447b77757606ee78c61a8c SET entity_table =...", (Array:3))
#14 /var/www/example.org/web/sites/all/civicrm/extensions/advimport/advimport.php(380): CRM_Advimport_Utils::setEntityTableAndId((Array:5), "civicrm_contact", "148148")
#15 /var/www/example.org/vendor/civicrm/civicrm-core/CRM/Utils/Hook.php(283): advimport_civicrm_import("Contact", "process", Object(CRM_Contact_Import_Parser_Contact), (Array:5))
#16 /var/www/example.org/vendor/civicrm/civicrm-core/CRM/Utils/Hook/DrupalBase.php(73): CRM_Utils_Hook->runHooks((Array:183), "civicrm_import", 4, "Contact", "process", Object(CRM_Contact_Import_Parser_Contact), (Array:5), NULL, NULL)
#17 /var/www/example.org/vendor/civicrm/civicrm-core/Civi/Core/CiviEventDispatcher.php(249): CRM_Utils_Hook_DrupalBase->invokeViaUF(4, "Contact", "process", Object(CRM_Contact_Import_Parser_Contact), (Array:5), NULL, NULL, "civicrm_import")
#18 /var/www/example.org/vendor/symfony/event-dispatcher/EventDispatcher.php(264): Civi\Core\CiviEventDispatcher::delegateToUF(Object(Civi\Core\Event\GenericHookEvent), "hook_civicrm_import", Object(Civi\Core\CiviEventDispatcher))
#19 /var/www/example.org/vendor/symfony/event-dispatcher/EventDispatcher.php(239): Symfony\Component\EventDispatcher\EventDispatcher->doDispatch((Array:1), "hook_civicrm_import", Object(Civi\Core\Event\GenericHookEvent))
#20 /var/www/example.org/vendor/symfony/event-dispatcher/EventDispatcher.php(73): Symfony\Component\EventDispatcher\EventDispatcher->callListeners((Array:1), "hook_civicrm_import", Object(Civi\Core\Event\GenericHookEvent))
#21 /var/www/example.org/vendor/civicrm/civicrm-core/Civi/Core/CiviEventDispatcher.php(198): Symfony\Component\EventDispatcher\EventDispatcher->dispatch(Object(Civi\Core\Event\GenericHookEvent), Object(Civi\Core\Event\GenericHookEvent))
#22 /var/www/example.org/vendor/civicrm/civicrm-core/CRM/Utils/Hook.php(167): Civi\Core\CiviEventDispatcher->dispatch("hook_civicrm_import", Object(Civi\Core\Event\GenericHookEvent))
#23 /var/www/example.org/vendor/civicrm/civicrm-core/CRM/Utils/Hook.php(1554): CRM_Utils_Hook->invoke((Array:4), "Contact", "process", Object(CRM_Contact_Import_Parser_Contact), (Array:5), NULL, NULL, "civicrm_import")
#24 /var/www/example.org/vendor/civicrm/civicrm-core/CRM/Contact/Import/Parser/Contact.php(695): CRM_Utils_Hook::import("Contact", "process", Object(CRM_Contact_Import_Parser_Contact), (Array:5))
#25 /var/www/example.org/vendor/civicrm/civicrm-core/CRM/Contact/Import/Parser.php(196): CRM_Contact_Import_Parser_Contact->import("1", (Array:34), NULL)
#26 /var/www/example.org/vendor/civicrm/civicrm-core/CRM/Contact/Import/ImportJob.php(233): CRM_Contact_Import_Parser->run("civicrm_tmp_d_dflt_85fabf0284447b77757606ee78c61a8c", (Array:31), 8, 1, "_id", "_status", "1", "27647ad69e52d2bdab90530f2f608c91", 219, NULL, 30, NULL, "17")
#27 /var/www/example.org/vendor/civicrm/civicrm-core/CRM/Contact/Import/Form/Preview.php(254): CRM_Contact_Import_ImportJob->runImport(Object(CRM_Contact_Import_Form_Preview))
#28 /var/www/example.org/vendor/civicrm/civicrm-core/CRM/Core/Form.php(565): CRM_Contact_Import_Form_Preview->postProcess()
#29 /var/www/example.org/vendor/civicrm/civicrm-core/CRM/Core/StateMachine.php(144): CRM_Core_Form->mainProcess()
#30 /var/www/example.org/vendor/civicrm/civicrm-core/CRM/Core/QuickForm/Action/Next.php(43): CRM_Core_StateMachine->perform(Object(CRM_Contact_Import_Form_Preview), "next", "Next")
#31 /var/www/example.org/vendor/civicrm/civicrm-packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Contact_Import_Form_Preview), "next")
#32 /var/www/example.org/vendor/civicrm/civicrm-packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contact_Import_Form_Preview), "next")
#33 /var/www/example.org/vendor/civicrm/civicrm-core/CRM/Core/Controller.php(353): HTML_QuickForm_Page->handle("next")
#34 /var/www/example.org/vendor/civicrm/civicrm-core/CRM/Core/Invoke.php(319): CRM_Core_Controller->run((Array:3), NULL)
#35 /var/www/example.org/vendor/civicrm/civicrm-core/CRM/Core/Invoke.php(69): CRM_Core_Invoke::runItem((Array:13))
#36 /var/www/example.org/vendor/civicrm/civicrm-core/CRM/Core/Invoke.php(36): CRM_Core_Invoke::_invoke((Array:3))
#37 /var/www/example.org/web/modules/contrib/civicrm/src/Civicrm.php(88): CRM_Core_Invoke::invoke((Array:3))
#38 /var/www/example.org/web/modules/contrib/civicrm/src/Controller/CivicrmController.php(80): Drupal\civicrm\Civicrm->invoke((Array:3))
#39 [internal function](): Drupal\civicrm\Controller\CivicrmController->main((Array:3), "")
#40 /var/www/example.org/web/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(123): call_user_func_array((Array:2), (Array:2))
#41 /var/www/example.org/web/core/lib/Drupal/Core/Render/Renderer.php(564): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}()
#42 /var/www/example.org/web/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(124): Drupal\Core\Render\Renderer->executeInRenderContext(Object(Drupal\Core\Render\RenderContext), Object(Closure))
#43 /var/www/example.org/web/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(97): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->wrapControllerExecutionInRenderContext((Array:2), (Array:2))
#44 /var/www/example.org/vendor/symfony/http-kernel/HttpKernel.php(158): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}()
#45 /var/www/example.org/vendor/symfony/http-kernel/HttpKernel.php(80): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1)
#46 /var/www/example.org/web/core/lib/Drupal/Core/StackMiddleware/Session.php(58): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#47 /var/www/example.org/web/core/lib/Drupal/Core/StackMiddleware/KernelPreHandle.php(48): Drupal\Core\StackMiddleware\Session->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#48 /var/www/example.org/web/core/modules/page_cache/src/StackMiddleware/PageCache.php(106): Drupal\Core\StackMiddleware\KernelPreHandle->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#49 /var/www/example.org/web/core/modules/page_cache/src/StackMiddleware/PageCache.php(85): Drupal\page_cache\StackMiddleware\PageCache->pass(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#50 /var/www/example.org/web/core/lib/Drupal/Core/StackMiddleware/ReverseProxyMiddleware.php(48): Drupal\page_cache\StackMiddleware\PageCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#51 /var/www/example.org/web/core/lib/Drupal/Core/StackMiddleware/NegotiationMiddleware.php(51): Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#52 /var/www/example.org/vendor/stack/builder/src/Stack/StackedHttpKernel.php(23): Drupal\Core\StackMiddleware\NegotiationMiddleware->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#53 /var/www/example.org/web/core/lib/Drupal/Core/DrupalKernel.php(708): Stack\StackedHttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#54 /var/www/example.org/web/index.php(19): Drupal\Core\DrupalKernel->handle(Object(Symfony\Component\HttpFoundation\Request))
#55 {main}