Answers.Body: <p>Please have a look at the solution in this question: <a href="https://civicrm.stackexchange.com/questions/44802/db-update-failure-after-update-5-60/44810#comment52821_44810">DB update failure after update 5.60</a></p>
  <p><strong>SOLUTION:</strong></p>
  <p>After restoring the CiviCRM database from the backup, do the following:</p>
  <p>Remove all records from civicrm_job_log table by command:</p>
  <pre><code>DELETE FROM civicrm_job_log;
  </code></pre>
  <p>Re-run the update process from the CiviCRM main window, and it will finish successfully.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-05-26T18:51:20.530Z
Answers.Text: That works but removes all your scheduled job logs.  If you want to keep them, see other solutions here: https://civicrm.stackexchange.com/q/44762/225
Answers.UserDisplayName: Aidan
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-05-24T04:56:24.673Z
Answers.LastActivityDate: 2023-05-24T04:56:24.673Z
Answers.UserDisplayName: Guitarman
Body: <p>I have a Joomla 3.11 environment running PHP 7.3 and CIVICRM 5.57.  We have followed the steps to upgrade CIVICRM to 5.60/5.61 in Joomla.  The CRM updates fine but it abends when trying to update the database.  I have posted a screenshot of the results below.  Any help would be greatly appreciated.
  <a href="https://i.sstatic.net/hrn5Z.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/hrn5Z.png" alt="enter image description here" /></a></p>
  
Tags: <upgrade><joomla><database>
Title: CIVICRM Upgrade in Joomla Environment - CRM updates but database aborts
ThreadText: # CIVICRM Upgrade in Joomla Environment - CRM updates but database aborts
  
  (Asked by: username_0 on 2023-05-23)
  
  I have a Joomla 3.11 environment running PHP 7.3 and CIVICRM 5.57. We have followed the steps to upgrade CIVICRM to 5.60/5.61 in Joomla. The CRM updates fine but it abends when trying to update the database. I have posted a screenshot of the results below. Any help would be greatly appreciated.
  [![enter image description here](https://i.sstatic.net/hrn5Z.png)](https://i.sstatic.net/hrn5Z.png)
  
  **Tags:** upgrade, joomla, database
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2023-05-24. Score: 0
  
  Please have a look at the solution in this question: DB update failure after update 5.60
  SOLUTION:
  After restoring the CiviCRM database from the backup, do the following:
  Remove all records from civicrm_job_log table by command:
  DELETE FROM civicrm_job_log;
  
  Re-run the update process from the CiviCRM main window, and it will finish successfully.
  
  > **Comments:**
  > **username_2**: That works but removes all your scheduled job logs.  If you want to keep them, see other solutions here: https://civicrm.stackexchange.com/q/44762/225  
  
  ---
  
  