Answers.Body: <p>Welcome to SE!  The missing column is <code>workflow_name</code>.  That should have been added by the upgrade to 5.26.  Check the table definition for <code>civicrm_msg_template</code> - does it have a <code>workflow_name</code> column?  If not, go back and look at your logs for the upgrade to 5.26 and see if there are any errors there.</p>
  <p>Also, do you have logging enabled?  If so disable and re-enable that at <code>Administer &gt; System Settings &gt; Misc &gt; Logging</code> to make sure the logging table schema is correct.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-12-02T11:08:07.347Z
Answers.LastActivityDate: 2020-12-02T11:08:07.347Z
Answers.UserDisplayName: Aidan
Body: <p>We're using CiviCRM 5.31.0 on Joomla 3.9.23.</p>
  <p>Even with all CiviCRM extensions disabled, we get similar errors like this when doing a DB Upgrade, installing, enabling, and disabling extensions.</p>
  <p>How do we resolve this?</p>
  <pre><code>#0 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php(148): CRM_Core_Error::backtrace()
  #1 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/packages/PEAR.php(921): CRM_Core_Error::handle(Object(DB_Error))
  #2 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/packages/DB.php(997): PEAR_Error-&gt;__construct(&quot;DB Error: no such field&quot;, -19, 16, (Array:2), &quot;\n            UPDATE civicrm_msg_template SET msg_html = '&lt;!DOCTYPE html PUBL...&quot;)
  #3 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/packages/PEAR.php(575): DB_Error-&gt;__construct(-19, 16, (Array:2), &quot;\n            UPDATE civicrm_msg_template SET msg_html = '&lt;!DOCTYPE html PUBL...&quot;)
  #4 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/packages/PEAR.php(223): PEAR::_raiseError(Object(DB_mysqli), NULL, -19, 16, (Array:2), &quot;\n            UPDATE civicrm_msg_template SET msg_html = '&lt;!DOCTYPE html PUBL...&quot;, &quot;DB_Error&quot;, TRUE)
  #5 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1925): PEAR-&gt;__call(&quot;raiseError&quot;, (Array:7))
  #6 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/packages/DB/mysqli.php(936): DB_common-&gt;raiseError(-19, NULL, NULL, &quot;\n            UPDATE civicrm_msg_template SET msg_html = '&lt;!DOCTYPE html PUBL...&quot;, &quot;1054 ** Unknown column 'workflow_name' in 'field list'&quot;)
  #7 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/packages/DB/mysqli.php(406): DB_mysqli-&gt;mysqliRaiseError()
  #8 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1231): DB_mysqli-&gt;simpleQuery(&quot;\n            UPDATE civicrm_msg_template SET msg_html = '&lt;!DOCTYPE html PUBL...&quot;)
  #9 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(2696): DB_common-&gt;query(&quot;\n            UPDATE civicrm_msg_template SET msg_html = '&lt;!DOCTYPE html PUBL...&quot;)
  #10 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(1829): DB_DataObject-&gt;_query(&quot;\n            UPDATE civicrm_msg_template SET msg_html = '&lt;!DOCTYPE html PUBL...&quot;)
  #11 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(457): DB_DataObject-&gt;query(&quot;\n            UPDATE civicrm_msg_template SET msg_html = '&lt;!DOCTYPE html PUBL...&quot;)
  #12 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(1563): CRM_Core_DAO-&gt;query(&quot;\n            UPDATE civicrm_msg_template SET msg_html = '&lt;!DOCTYPE html PUBL...&quot;, TRUE)
  #13 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Incremental/MessageTemplates.php(314): CRM_Core_DAO::executeQuery(&quot;\n            UPDATE civicrm_msg_template SET msg_html = %1 WHERE id IN (38,37)&quot;, (Array:1))
  #14 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Incremental/General.php(157): CRM_Upgrade_Incremental_MessageTemplates-&gt;updateTemplates()
  #15 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Form.php(808): CRM_Upgrade_Incremental_General::updateMessageTemplate(&quot;&lt;p&gt;This system uses MySQL/MariaDB v5.6.41-84.1-log. You may proceed with the ...&quot;, &quot;5.30.alpha1&quot;)
  #16 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Page/Upgrade.php(108): CRM_Upgrade_Form-&gt;setPreUpgradeMessage(&quot;&lt;p&gt;This system uses MySQL/MariaDB v5.6.41-84.1-log. You may proceed with the ...&quot;, &quot;5.29.1&quot;, &quot;5.31.0&quot;)
  #17 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Page/Upgrade.php(57): CRM_Upgrade_Page_Upgrade-&gt;runIntro()
  #18 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(312): CRM_Upgrade_Page_Upgrade-&gt;run((Array:2), NULL)
  #19 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(68): CRM_Core_Invoke::runItem((Array:13))
  #20 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(36): CRM_Core_Invoke::_invoke((Array:2))
  #21 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm.php(121): CRM_Core_Invoke::invoke((Array:2))
  #22 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm.php(40): civicrm_invoke()
  #23 /home/fxx/public_html/fxx/libraries/src/Component/ComponentHelper.php(402): require_once(&quot;/home/fxx/public_html/fxx/administrator/components/com_c...&quot;)
  #24 /home/fxx/public_html/fxx/libraries/src/Component/ComponentHelper.php(377): Joomla\CMS\Component\ComponentHelper::executeComponent(&quot;/home/fxx/public_html/fxx/administrator/components/com_c...&quot;)
  #25 /home/fxx/public_html/fxx/libraries/src/Application/AdministratorApplication.php(101): Joomla\CMS\Component\ComponentHelper::renderComponent(&quot;com_civicrm&quot;)
  #26 /home/fxx/public_html/fxx/libraries/src/Application/AdministratorApplication.php(159): Joomla\CMS\Application\AdministratorApplication-&gt;dispatch()
  #27 /home/fxx/public_html/fxx/libraries/src/Application/CMSApplication.php(196): Joomla\CMS\Application\AdministratorApplication-&gt;doExecute()
  #28 /home/fxx/public_html/fxx/administrator/index.php(51): Joomla\CMS\Application\CMSApplication-&gt;execute()
  #29 {main}
  </code></pre>
  
Tags: <upgrade><error>
Title: DB Upgrade/Update Error - no such field, unknown column
ThreadText: # DB Upgrade/Update Error - no such field, unknown column
  
  (Asked by: username_0 on 2020-12-02)
  
  We're using CiviCRM 5.31.0 on Joomla 3.9.23.
  
  Even with all CiviCRM extensions disabled, we get similar errors like this when doing a DB Upgrade, installing, enabling, and disabling extensions.
  
  How do we resolve this?
  
  ```
  #0 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php(148): CRM_Core_Error::backtrace()
  #1 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/packages/PEAR.php(921): CRM_Core_Error::handle(Object(DB_Error))
  #2 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/packages/DB.php(997): PEAR_Error->__construct("DB Error: no such field", -19, 16, (Array:2), "\n            UPDATE civicrm_msg_template SET msg_html = '<!DOCTYPE html PUBL...")
  #3 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/packages/PEAR.php(575): DB_Error->__construct(-19, 16, (Array:2), "\n            UPDATE civicrm_msg_template SET msg_html = '<!DOCTYPE html PUBL...")
  #4 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/packages/PEAR.php(223): PEAR::_raiseError(Object(DB_mysqli), NULL, -19, 16, (Array:2), "\n            UPDATE civicrm_msg_template SET msg_html = '<!DOCTYPE html PUBL...", "DB_Error", TRUE)
  #5 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1925): PEAR->__call("raiseError", (Array:7))
  #6 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/packages/DB/mysqli.php(936): DB_common->raiseError(-19, NULL, NULL, "\n            UPDATE civicrm_msg_template SET msg_html = '<!DOCTYPE html PUBL...", "1054 ** Unknown column 'workflow_name' in 'field list'")
  #7 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/packages/DB/mysqli.php(406): DB_mysqli->mysqliRaiseError()
  #8 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1231): DB_mysqli->simpleQuery("\n            UPDATE civicrm_msg_template SET msg_html = '<!DOCTYPE html PUBL...")
  #9 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(2696): DB_common->query("\n            UPDATE civicrm_msg_template SET msg_html = '<!DOCTYPE html PUBL...")
  #10 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(1829): DB_DataObject->_query("\n            UPDATE civicrm_msg_template SET msg_html = '<!DOCTYPE html PUBL...")
  #11 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(457): DB_DataObject->query("\n            UPDATE civicrm_msg_template SET msg_html = '<!DOCTYPE html PUBL...")
  #12 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(1563): CRM_Core_DAO->query("\n            UPDATE civicrm_msg_template SET msg_html = '<!DOCTYPE html PUBL...", TRUE)
  #13 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Incremental/MessageTemplates.php(314): CRM_Core_DAO::executeQuery("\n            UPDATE civicrm_msg_template SET msg_html = %1 WHERE id IN (38,37)", (Array:1))
  #14 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Incremental/General.php(157): CRM_Upgrade_Incremental_MessageTemplates->updateTemplates()
  #15 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Form.php(808): CRM_Upgrade_Incremental_General::updateMessageTemplate("<p>This system uses MySQL/MariaDB v5.6.41-84.1-log. You may proceed with the ...", "5.30.alpha1")
  #16 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Page/Upgrade.php(108): CRM_Upgrade_Form->setPreUpgradeMessage("<p>This system uses MySQL/MariaDB v5.6.41-84.1-log. You may proceed with the ...", "5.29.1", "5.31.0")
  #17 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Page/Upgrade.php(57): CRM_Upgrade_Page_Upgrade->runIntro()
  #18 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(312): CRM_Upgrade_Page_Upgrade->run((Array:2), NULL)
  #19 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(68): CRM_Core_Invoke::runItem((Array:13))
  #20 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(36): CRM_Core_Invoke::_invoke((Array:2))
  #21 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm.php(121): CRM_Core_Invoke::invoke((Array:2))
  #22 /home/fxx/public_html/fxx/administrator/components/com_civicrm/civicrm.php(40): civicrm_invoke()
  #23 /home/fxx/public_html/fxx/libraries/src/Component/ComponentHelper.php(402): require_once("/home/fxx/public_html/fxx/administrator/components/com_c...")
  #24 /home/fxx/public_html/fxx/libraries/src/Component/ComponentHelper.php(377): Joomla\CMS\Component\ComponentHelper::executeComponent("/home/fxx/public_html/fxx/administrator/components/com_c...")
  #25 /home/fxx/public_html/fxx/libraries/src/Application/AdministratorApplication.php(101): Joomla\CMS\Component\ComponentHelper::renderComponent("com_civicrm")
  #26 /home/fxx/public_html/fxx/libraries/src/Application/AdministratorApplication.php(159): Joomla\CMS\Application\AdministratorApplication->dispatch()
  #27 /home/fxx/public_html/fxx/libraries/src/Application/CMSApplication.php(196): Joomla\CMS\Application\AdministratorApplication->doExecute()
  #28 /home/fxx/public_html/fxx/administrator/index.php(51): Joomla\CMS\Application\CMSApplication->execute()
  #29 {main}
  
  ```
  
  **Tags:** upgrade, error
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2020-12-02. Score: 1
  
  Welcome to SE! The missing column is `workflow_name`. That should have been added by the upgrade to 5.26. Check the table definition for `civicrm_msg_template` - does it have a `workflow_name` column? If not, go back and look at your logs for the upgrade to 5.26 and see if there are any errors there.
  
  Also, do you have logging enabled? If so disable and re-enable that at `Administer > System Settings > Misc > Logging` to make sure the logging table schema is correct.
  
  
  ---
  
  