Answers.Body: <p>This can happen if you try to re-run through the 5.48 part of the import and didn't do a <strong>complete drop</strong> of the database before restoring from backup.</p>
  <p>This might be the same as <a href="https://civicrm.stackexchange.com/questions/42130/error-updating-to-civicrm-5-50-3-drupal-7-9">Error updating to civicrm 5.50.3 / Drupal 7.9</a></p>
  <p>See also <a href="https://lab.civicrm.org/dev/core/-/issues/3504" rel="nofollow noreferrer">https://lab.civicrm.org/dev/core/-/issues/3504</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-08-03T17:44:48.943Z
Answers.Text: I think this is dues to a failed update. I will try stepping back.
Answers.UserDisplayName: Alan Fuller
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-08-04T08:52:00.453Z
Answers.Text: OK so the update breaks because of this Extended Reports.  https://civicrm.stackexchange.com/questions/41445/upgrade-to-5-47-x-fails-with-error-exception-api-error-db-error-constraint
  
  Now past that - but upgrade to 5.51.2  runs but then looses all my custom reports from templates, and the custom reports dont work either.
  
  CiviCRM is really hard to upgrade and keep up to date, to the point where it is getting silly.  This is my second day on just trying to get updated and the old version isn't that old.  The LTS version tells you to apply patches that simply are not available - dooh
Answers.UserDisplayName: Alan Fuller
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-08-03T13:13:26.443Z
Answers.LastActivityDate: 2022-08-03T13:13:26.443Z
Answers.UserDisplayName: Demerit
Body: <p>I have been trying to update versions, and have been hitting errors</p>
  <p>I have stepped back and step through versions and the issue appears at 5.48.x  update</p>
  <p>UPDATE civicrm_queue SET runner = &quot;task&quot; WHERE is_autorun = 1 [nativecode=1054 ** Unknown column 'is_autorun' in 'where clause']</p>
  <p>I have searched but not found a similar issue.  How can I get past this?</p>
  <pre><code>Error: Convert &quot;is_autorun&quot; to &quot;runner&quot;]
  </code></pre>
  <p>Error Field Error Value
  Type    DB_Error
  Code    -19
  Message DB Error: no such field
  Mode    16
  UserInfo    UPDATE civicrm_queue SET runner = &quot;task&quot; WHERE is_autorun = 1 [nativecode=1054 ** Unknown column 'is_autorun' in 'where clause']
  DebugInfo   UPDATE civicrm_queue SET runner = &quot;task&quot; WHERE is_autorun = 1 [nativecode=1054 ** Unknown column 'is_autorun' in 'where clause']
  PEAR_Exception: DB Error: no such field in /var/www/html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php on line 922</p>
  <ul>
  <li>DB_Error: DB Error: no such field in unknown on line unknown
  Exception trace</li>
  </ul>
  <h1>Function    Location</h1>
  <p>0   CRM_Core_Error::exceptionHandler(Object(DB_Error))  /var/www/html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php:922
  1   PEAR_Error-&gt;__construct('DB Error: no suc…', -19, 16, Array, 'UPDATE civicrm_q…')   /var/www/html/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB.php:997
  2   DB_Error-&gt;__construct(-19, 16, Array, 'UPDATE civicrm_q…')  /var/www/html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php:575
  3   PEAR::_raiseError(Object(DB_mysqli), null, -19, 16, Array, 'UPDATE civicrm_q…', 'DB_Error', true)   /var/www/html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php:223
  4   PEAR-&gt;__call('raiseError', Array)   /var/www/html/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB/common.php:1928
  5   DB_common-&gt;raiseError(-19, null, null, 'UPDATE civicrm_q…', '1054 ** Unknown …')    /var/www/html/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB/mysqli.php:936
  6   DB_mysqli-&gt;mysqliRaiseError()   /var/www/html/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB/mysqli.php:406
  7   DB_mysqli-&gt;simpleQuery('UPDATE civicrm_q…') /var/www/html/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB/common.php:1234
  8   DB_common-&gt;query('UPDATE civicrm_q…')   /var/www/html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php:2696
  9   DB_DataObject-&gt;_query('UPDATE civicrm_q…')  /var/www/html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php:1829
  10  DB_DataObject-&gt;query('UPDATE civicrm_q…')   /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php:468
  11  CRM_Core_DAO-&gt;query('UPDATE civicrm_q…', true)  /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php:1633
  12  CRM_Core_DAO::executeQuery('UPDATE civicrm_q…') /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Upgrade/Incremental/php/FiveFortyEight.php:107
  13  CRM_Upgrade_Incremental_php_FiveFortyEight::convertAutorun(Object(CRM_Queue_TaskContext))   /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Queue/Task.php:73
  14  CRM_Queue_Task-&gt;run(Object(CRM_Queue_TaskContext))  /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Queue/Runner.php:215
  15  CRM_Queue_Runner-&gt;runNext(true) /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Queue/Page/AJAX.php:36
  16  CRM_Queue_Page_AJAX::{closure}()    /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Queue/ErrorPolicy.php:89
  17  CRM_Queue_ErrorPolicy-&gt;call(Object(Closure))    /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Queue/Page/AJAX.php:38
  18  CRM_Queue_Page_AJAX::runNext()  /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:285
  19  CRM_Core_Invoke::runItem(Array) /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:69
  20  CRM_Core_Invoke::_invoke(Array) /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:36
  21  CRM_Core_Invoke::invoke(Array)  /var/www/html/wp-content/plugins/civicrm/civicrm.php:1199
  22  CiviCRM_For_WordPress-&gt;invoke('')   /var/www/html/wp-includes/class-wp-hook.php:307
  23  WP_Hook-&gt;apply_filters('', Array)   /var/www/html/wp-includes/class-wp-hook.php:331
  24  WP_Hook-&gt;do_action(Array)   /var/www/html/wp-includes/plugin.php:476
  25  do_action('toplevel_page_Ci…')  /var/www/html/wp-admin/admin.php:259</p>
  
Tags: <upgrade>
Title: Trying to update versions - DB Upgrade error at 5.48.x
ThreadText: # Trying to update versions - DB Upgrade error at 5.48.x
  
  (Asked by: username_0 on 2022-08-03)
  
  I have been trying to update versions, and have been hitting errors
  I have stepped back and step through versions and the issue appears at 5.48.x  update
  UPDATE civicrm_queue SET runner = "task" WHERE is_autorun = 1 [nativecode=1054 ** Unknown column 'is_autorun' in 'where clause']
  I have searched but not found a similar issue.  How can I get past this?
  Error: Convert "is_autorun" to "runner"]
  
  Error Field Error Value
  Type    DB_Error
  Code    -19
  Message DB Error: no such field
  Mode    16
  UserInfo    UPDATE civicrm_queue SET runner = "task" WHERE is_autorun = 1 [nativecode=1054 ** Unknown column 'is_autorun' in 'where clause']
  DebugInfo   UPDATE civicrm_queue SET runner = "task" WHERE is_autorun = 1 [nativecode=1054 ** Unknown column 'is_autorun' in 'where clause']
  PEAR_Exception: DB Error: no such field in /var/www/html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php on line 922
  
  DB_Error: DB Error: no such field in unknown on line unknown
  Exception trace
  
  Function    Location
  0   CRM_Core_Error::exceptionHandler(Object(DB_Error))  /var/www/html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php:922
  1   PEAR_Error->__construct('DB Error: no suc…', -19, 16, Array, 'UPDATE civicrm_q…')   /var/www/html/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB.php:997
  2   DB_Error->__construct(-19, 16, Array, 'UPDATE civicrm_q…')  /var/www/html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php:575
  3   PEAR::_raiseError(Object(DB_mysqli), null, -19, 16, Array, 'UPDATE civicrm_q…', 'DB_Error', true)   /var/www/html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php:223
  4   PEAR->__call('raiseError', Array)   /var/www/html/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB/common.php:1928
  5   DB_common->raiseError(-19, null, null, 'UPDATE civicrm_q…', '1054 ** Unknown …')    /var/www/html/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB/mysqli.php:936
  6   DB_mysqli->mysqliRaiseError()   /var/www/html/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB/mysqli.php:406
  7   DB_mysqli->simpleQuery('UPDATE civicrm_q…') /var/www/html/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB/common.php:1234
  8   DB_common->query('UPDATE civicrm_q…')   /var/www/html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php:2696
  9   DB_DataObject->_query('UPDATE civicrm_q…')  /var/www/html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php:1829
  10  DB_DataObject->query('UPDATE civicrm_q…')   /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php:468
  11  CRM_Core_DAO->query('UPDATE civicrm_q…', true)  /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php:1633
  12  CRM_Core_DAO::executeQuery('UPDATE civicrm_q…') /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Upgrade/Incremental/php/FiveFortyEight.php:107
  13  CRM_Upgrade_Incremental_php_FiveFortyEight::convertAutorun(Object(CRM_Queue_TaskContext))   /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Queue/Task.php:73
  14  CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))  /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Queue/Runner.php:215
  15  CRM_Queue_Runner->runNext(true) /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Queue/Page/AJAX.php:36
  16  CRM_Queue_Page_AJAX::{closure}()    /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Queue/ErrorPolicy.php:89
  17  CRM_Queue_ErrorPolicy->call(Object(Closure))    /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Queue/Page/AJAX.php:38
  18  CRM_Queue_Page_AJAX::runNext()  /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:285
  19  CRM_Core_Invoke::runItem(Array) /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:69
  20  CRM_Core_Invoke::_invoke(Array) /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:36
  21  CRM_Core_Invoke::invoke(Array)  /var/www/html/wp-content/plugins/civicrm/civicrm.php:1199
  22  CiviCRM_For_WordPress->invoke('')   /var/www/html/wp-includes/class-wp-hook.php:307
  23  WP_Hook->apply_filters('', Array)   /var/www/html/wp-includes/class-wp-hook.php:331
  24  WP_Hook->do_action(Array)   /var/www/html/wp-includes/plugin.php:476
  25  do_action('toplevel_page_Ci…')  /var/www/html/wp-admin/admin.php:259
  
  **Tags:** upgrade
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2022-08-03. Score: 0
  
  This can happen if you try to re-run through the 5.48 part of the import and didn't do a **complete drop** of the database before restoring from backup.
  
  This might be the same as [Error updating to civicrm 5.50.3 / Drupal 7.9](https://civicrm.stackexchange.com/questions/42130/error-updating-to-civicrm-5-50-3-drupal-7-9)
  
  See also <https://lab.civicrm.org/dev/core/-/issues/3504>
  
  > **Comments:**
  > **username_0**: I think this is dues to a failed update. I will try stepping back.  
  > **username_0**: OK so the update breaks because of this Extended Reports.  https://civicrm.stackexchange.com/questions/41445/upgrade-to-5-47-x-fails-with-error-exception-api-error-db-error-constraint  Now past that - but upgrade to 5.51.2  runs but then looses all my custom reports from templates, and the custom reports dont work either.  CiviCRM is really hard to upgrade and keep up to date, to the point where it is getting silly.  This is my second day on just trying to get updated and the old version isn't that old.  The LTS version tells you to apply patches that simply are not available - dooh  
  
  ---
  
  