DB Error: no such field when attempting to install Automatic Soft Credits extension
This is on CiviCRM 5.47.4 on Drupal 9. We have not previously been using soft credits.
[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] => SELECT a.id as `id`, a.name_a_b as `name_a_b`, a.label_a_b as `label_a_b`, a.name_b_a as `name_b_a`, a.label_b_a as `label_b_a`, a.description as `description`, a.contact_type_a as `contact_type_a`, a.contact_type_b as `contact_type_b`, a.contact_sub_type_a as `contact_sub_type_a`, a.contact_sub_type_b as `contact_sub_type_b`, a.is_reserved as `is_reserved`, a.is_active as `is_active`, a_to_civicrm_value_automatic_sof_8.soft_credit_type as `custom_42`, a_to_civicrm_value_relationship__1.display_block_on_contact_summary_1 as `custom_1`, a_to_civicrm_value_relationship__1.exclude_expired_relationships_2 as `custom_2`, a_to_civicrm_value_relationship__1.exclude_pending_relationships_3 as `custom_3`
FROM civicrm_relationship_type a
LEFT JOIN `civicrm_value_automatic_sof_8` `a_to_civicrm_value_automatic_sof_8` ON `a_to_civicrm_value_automatic_sof_8`.entity_id = `a`.id
LEFT JOIN `civicrm_value_relationship__1` `a_to_civicrm_value_relationship__1` ON `a_to_civicrm_value_relationship__1`.entity_id = `a`.id
WHERE (a.is_active = "1")
[nativecode=1054 ** Unknown column 'a_to_civicrm_value_automatic_sof_8.soft_credit_type' in 'field list']
[type] => DB_Error
[user_info] => SELECT a.id as `id`, a.name_a_b as `name_a_b`, a.label_a_b as `label_a_b`, a.name_b_a as `name_b_a`, a.label_b_a as `label_b_a`, a.description as `description`, a.contact_type_a as `contact_type_a`, a.contact_type_b as `contact_type_b`, a.contact_sub_type_a as `contact_sub_type_a`, a.contact_sub_type_b as `contact_sub_type_b`, a.is_reserved as `is_reserved`, a.is_active as `is_active`, a_to_civicrm_value_automatic_sof_8.soft_credit_type as `custom_42`, a_to_civicrm_value_relationship__1.display_block_on_contact_summary_1 as `custom_1`, a_to_civicrm_value_relationship__1.exclude_expired_relationships_2 as `custom_2`, a_to_civicrm_value_relationship__1.exclude_pending_relationships_3 as `custom_3`
FROM civicrm_relationship_type a
LEFT JOIN `civicrm_value_automatic_sof_8` `a_to_civicrm_value_automatic_sof_8` ON `a_to_civicrm_value_automatic_sof_8`.entity_id = `a`.id
LEFT JOIN `civicrm_value_relationship__1` `a_to_civicrm_value_relationship__1` ON `a_to_civicrm_value_relationship__1`.entity_id = `a`.id
WHERE (a.is_active = "1")
[nativecode=1054 ** Unknown column 'a_to_civicrm_value_automatic_sof_8.soft_credit_type' in 'field list']
[to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="SELECT a.id as `id`, a.name_a_b as `name_a_b`, a.label_a_b as `label_a_b`, a.name_b_a as `name_b_a`, a.label_b_a as `label_b_a`, a.description as `description`, a.contact_type_a as `contact_type_a`, a.contact_type_b as `contact_type_b`, a.contact_sub_type_a as `contact_sub_type_a`, a.contact_sub_type_b as `contact_sub_type_b`, a.is_reserved as `is_reserved`, a.is_active as `is_active`, a_to_civicrm_value_automatic_sof_8.soft_credit_type as `custom_42`, a_to_civicrm_value_relationship__1.display_block_on_contact_summary_1 as `custom_1`, a_to_civicrm_value_relationship__1.exclude_expired_relationships_2 as `custom_2`, a_to_civicrm_value_relationship__1.exclude_pending_relationships_3 as `custom_3`
FROM civicrm_relationship_type a
LEFT JOIN `civicrm_value_automatic_sof_8` `a_to_civicrm_value_automatic_sof_8` ON `a_to_civicrm_value_automatic_sof_8`.entity_id = `a`.id
LEFT JOIN `civicrm_value_relationship__1` `a_to_civicrm_value_relationship__1` ON `a_to_civicrm_value_relationship__1`.entity_id = `a`.id
WHERE (a.is_active = "1")
[nativecode=1054 ** Unknown column 'a_to_civicrm_value_automatic_sof_8.soft_credit_type' in 'field list']"]
)
Drupal Log:
Fatal Error Details = array:3 [ "message" => "DB Error: no such field" "code" => null "exception" => CiviCRM_API3_Exception {#6209 -extraParams: array:3 [ "is_error" => 1 "error_message" => "DB Error: no such field" "error_code" => "undefined" ] #message: "DB Error: no such field" #code: 0 #file: ".../civicrm/civicrm-core/api/api.php" #line: 135 trace: { .../civicrm/civicrm-core/api/api.php:135 { …} .../civicrm/civicrm-core/CRM/Admin/Form/Extensions.php:184 { …} .../civicrm/civicrm-core/CRM/Core/Form.php:573 { …} .../civicrm/civicrm-core/CRM/Core/StateMachine.php:144 { …} .../civicrm/civicrm-core/CRM/Core/QuickForm/Action/Next.php:43 { …} .../civicrm/civicrm-packages/HTML/QuickForm/Controller.php:203 { …} .../civicrm/civicrm-packages/HTML/QuickForm/Page.php:103 { …} .../civicrm/civicrm-core/CRM/Core/Controller.php:355 { …} .../civicrm/civicrm-core/CRM/Core/Page/Basic.php:336 { …} .../civicrm/civicrm-core/CRM/Core/Page/Basic.php:140 { …} .../civicrm/civicrm-core/CRM/Admin/Page/Extensions.php:105 { …} .../civicrm/civicrm-core/CRM/Core/Invoke.php:319 { …} .../civicrm/civicrm-core/CRM/Core/Invoke.php:69 { …} .../civicrm/civicrm-core/CRM/Core/Invoke.php:36 { …} .../modules/contrib/civicrm/src/Civicrm.php:88 { Drupal\civicrm\Civicrm->invoke($args) › ob_start(); › $content = \CRM_Core_Invoke::invoke($args); › $output = ob_get_clean(); } .../modules/contrib/civicrm/src/Controller/CivicrmController.php:80 { …} Drupal\civicrm\Controller\CivicrmController->main() {} .../core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php:123 { …} .../core/lib/Drupal/Core/Render/Renderer.php:564 { …} .../core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php:124 { …} .../core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php:97 { …} .../symfony/http-kernel/HttpKernel.php:158 { …} .../symfony/http-kernel/HttpKernel.php:80 { …} .../core/lib/Drupal/Core/StackMiddleware/Session.php:58 { …} .../core/lib/Drupal/Core/StackMiddleware/KernelPreHandle.php:48 { …} .../core/modules/page_cache/src/StackMiddleware/PageCache.php:106 { …} .../core/modules/page_cache/src/StackMiddleware/PageCache.php:85 { …} .../core/modules/ban/src/BanMiddleware.php:50 { …} .../core/lib/Drupal/Core/StackMiddleware/ReverseProxyMiddleware.php:48 { …} .../core/lib/Drupal/Core/StackMiddleware/NegotiationMiddleware.php:51 { …} .../stack/builder/src/Stack/StackedHttpKernel.php:23 { …} .../core/lib/Drupal/Core/DrupalKernel.php:708 { …} .../index.php:19 { …} } } ]