Answers.Body: <p>Note the column was added on June 9 to 5.51 (<a href="https://github.com/civicrm/civicrm-core/pull/23679" rel="nofollow noreferrer">https://github.com/civicrm/civicrm-core/pull/23679</a>), and then 5.51 became the RC on June 10, so depending on how your test site evolved it's very likely you would have missed that upgrade step since it was added in so late. You probably also want to check civicrm_queue.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-10-10T16:25:08.870Z
Answers.Text: Thanks, I was getting release candidates because of Search Kit so that was probably the cause.  Glad it was just that.
Answers.UserDisplayName: Andy Clark
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-10-10T12:10:24.190Z
Answers.LastActivityDate: 2022-10-10T12:10:24.190Z
Answers.UserDisplayName: Demerit
Body: <p>Grouping by month in 5.54's Search Kit is something I noticed &amp; would like, so I launched the upgrade on my test system to 5.54. However the upgrade from 5.53.0 to 5.54 failed as follows:</p>
  <p>&quot;SELECT <code>a</code>.<code>id</code> AS <code>id</code> FROM civicrm_user_job a WHERE (<code>a</code>.<code>expires_date</code> &lt; &quot;20221010092632&quot;) AND (<code>a</code>.<code>is_template</code> = &quot;0&quot;) [nativecode=1054 ** Unknown column 'a.is_template' in 'where clause']&quot;</p>
  <p>PEAR_Exception: DB Error: no such field in /home/acivior1/public_html/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php on line 944</p>
  <ul>
  <li>DB_Error: DB Error: no such field in unknown on line unknown</li>
  </ul>
  <p>Sure enough, table civicrm_user_job doesn't have column is_template. This is a Drupal 7 system. Looking at another 5.53 system - it does have this column.  After restoring back to 5.53 table civicrm_user_job does <strong>not</strong> have this column.  The test system was only create many a year back whereas the system with the column was created 9 years ago...</p>
  
Tags: <drupal><upgrade>
Title: Upgrade to 5.54 failed
ThreadText: # Upgrade to 5.54 failed
  
  (Asked by: username_0 on 2022-10-10)
  
  Grouping by month in 5.54's Search Kit is something I noticed & would like, so I launched the upgrade on my test system to 5.54. However the upgrade from 5.53.0 to 5.54 failed as follows:
  
  "SELECT `a`.`id` AS `id` FROM civicrm\_user\_job a WHERE (`a`.`expires_date` < "20221010092632") AND (`a`.`is_template` = "0") [nativecode=1054 \*\* Unknown column 'a.is\_template' in 'where clause']"
  
  PEAR\_Exception: DB Error: no such field in /home/acivior1/public\_html/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php on line 944
  
  * DB\_Error: DB Error: no such field in unknown on line unknown
  
  Sure enough, table civicrm\_user\_job doesn't have column is\_template. This is a Drupal 7 system. Looking at another 5.53 system - it does have this column. After restoring back to 5.53 table civicrm\_user\_job does **not** have this column. The test system was only create many a year back whereas the system with the column was created 9 years ago...
  
  **Tags:** drupal, upgrade
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2022-10-10. Score: 2 | Accepted answer
  
  Note the column was added on June 9 to 5.51 (<https://github.com/civicrm/civicrm-core/pull/23679>), and then 5.51 became the RC on June 10, so depending on how your test site evolved it's very likely you would have missed that upgrade step since it was added in so late. You probably also want to check civicrm\_queue.
  
  > **Comments:**
  > **username_0**: Thanks, I was getting release candidates because of Search Kit so that was probably the cause.  Glad it was just that.  
  
  ---
  
  