Answers.Body: <p>Do you have an Extended report extension installed? If yes, then probably you would need to</p>
  <ol>
  <li>Upgrade CiviCRM to 5.46.3</li>
  <li>Upgrade the Extended report extension to the latest version.</li>
  <li>Upgrade CiviCRM to 5.55.2</li>
  <li>Run the extension update db if there are any.</li>
  </ol>
  <p>or</p>
  <ol>
  <li>Replace the extended report extension folder to latest.</li>
  <li>Upgrade CiviCRM to 5.55.2</li>
  <li>Run the extension update db if there are any.</li>
  </ol>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-11-30T04:25:01.123Z
Answers.Text: Oooh, indeed there's a ton of stuff in Extensions that says it needs updating.  I'll post a screen shot of that as an addendum to my question, looks like this might be a multi-step process.  I'm super glad I'm practicing on an AMI on AWS so I can keep scrubbing it and start over.
Answers.UserDisplayName: Ken Williams
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-11-30T12:24:51.130Z
Answers.Text: First, sort the missing extension and later update the extension.
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-11-29T11:06:07.747Z
Answers.LastActivityDate: 2022-11-29T11:06:07.747Z
Answers.UserDisplayName: Pradeep Nayak
Answers.Body: <p>Thanks to @pradeep-nayak for setting me on the right path.  For posterity, here are the steps that ended up working.</p>
  <pre><code># DO: visit /civicrm/admin/extensions?reset=1 and do updates
  
  
  # Upgrade drupal
  DRUP=~/stack/drupal
  TB=drupal-7.92.tar.gz
  OTHER=/bitnami/drupal
  
  sudo mv $DRUP $DRUP-old
  
  cd &quot;$(dirname $DRUP)&quot;
  curl https://ftp.drupal.org/files/projects/$TB | sudo tar -zxvf -
  sudo mv &quot;${TB//\.tar\.gz/}&quot; drupal
  
  cd $DRUP
  sudo rm -rf sites
  sudo ln -s $OTHER/sites .
  sudo ln -s $OTHER/modules/contrib $DRUP/modules/
  
  
  
  # Upgrade civicrm to intermediate version
  V1=5.46.3
  cd $OTHER/modules/contrib
  rm -rf civicrm
  curl -L https://download.civicrm.org/civicrm-${V1}-drupal.tar.gz | tar -zxf -
  # DO: visit /civicrm/upgrade?reset=1
  # DO: visit /civicrm/admin/extensions?reset=1 and do updates
  
  
  # Upgrade civicrm to final version
  V2=5.55.2
  cd $OTHER/modules/contrib
  rm -rf civicrm
  curl -L https://download.civicrm.org/civicrm-${V2}-drupal.tar.gz | tar -zxf -
  # DO: visit /civicrm/upgrade?reset=1
  # DO: visit /civicrm/admin/extensions?reset=1 and do updates
  </code></pre>
  <p>When I did this &quot;for real&quot; the final time, I did get some errors in the website after the CiviCRM steps about various PHP errors that prevented the site from loading.  I'm not sure what that was about, but just waiting a while longer between steps seemed to cure it.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-12-06T03:07:00.553Z
Answers.LastActivityDate: 2022-12-06T03:07:00.553Z
Answers.UserDisplayName: Ken Williams
Body: <p>On a (copy of a) Drupal 7.92 site, I'm attempting to upgrade CiviCRM from version 5.42.1 to 5.55.2.  I did this by executing the following steps:</p>
  <pre><code>cd /bitnami/drupal/modules/contrib
  rm -rf civicrm
  curl -L https://download.civicrm.org/civicrm-5.55.2-drupal.tar.gz | tar -zxf -
  </code></pre>
  <p>and then (since I don't have <code>drush</code> installed) I visited <code>/civicrm/upgrade?reset=1</code> on my site to execute the database updates.  Everything seemed to go well (there were a lot of updates!) until just before the end of the progress bar, when I got this error message:</p>
  <img src="https://i.sstatic.net/Xgkwg.png" width="800" />
  <p>It doesn't give any more specifics than this, e.g. what constraint is being violated.</p>
  <p>If I visit the <code>/civicrm/upgrade?reset=1</code> upgrade page again, it says &quot;Your database has already been upgraded to CiviCRM 5.55.2&quot;.</p>
  <p>Can I assume that this is not going to cause any snags?  Any way to figure out more specifically what went wrong, before I try this on my live site?</p>
  <p><strong>UPDATE</strong></p>
  <p>@pradeep-nayak correctly suggested that there were likely CiviCRM Extensions that needed to be updated.  Here's a screenshot of my extensions page after attempting the upgrade:</p>
  <p><a href="https://i.sstatic.net/rr9yY.jpg" rel="nofollow noreferrer"><img src="https://i.sstatic.net/rr9yY.jpg" alt="extensions page" /></a></p>
  <p>I'll try doing the upgrade in steps as suggested and update if anything <em>interesting</em> happens.</p>
  
Tags: <upgrade><database>
Title: Upgrading, received database error
ThreadText: # Upgrading, received database error
  
  (Asked by: username_0 on 2022-11-29)
  
  On a (copy of a) Drupal 7.92 site, I'm attempting to upgrade CiviCRM from version 5.42.1 to 5.55.2. I did this by executing the following steps:
  
  ```
  cd /bitnami/drupal/modules/contrib
  rm -rf civicrm
  curl -L https://download.civicrm.org/civicrm-5.55.2-drupal.tar.gz | tar -zxf -
  
  ```
  
  and then (since I don't have `drush` installed) I visited `/civicrm/upgrade?reset=1` on my site to execute the database updates. Everything seemed to go well (there were a lot of updates!) until just before the end of the progress bar, when I got this error message:
  
  ![](https://i.sstatic.net/Xgkwg.png)
  
  It doesn't give any more specifics than this, e.g. what constraint is being violated.
  
  If I visit the `/civicrm/upgrade?reset=1` upgrade page again, it says "Your database has already been upgraded to CiviCRM 5.55.2".
  
  Can I assume that this is not going to cause any snags? Any way to figure out more specifically what went wrong, before I try this on my live site?
  
  **UPDATE**
  
  @username_1 correctly suggested that there were likely CiviCRM Extensions that needed to be updated. Here's a screenshot of my extensions page after attempting the upgrade:
  
  [![extensions page](https://i.sstatic.net/rr9yY.jpg)](https://i.sstatic.net/rr9yY.jpg)
  
  I'll try doing the upgrade in steps as suggested and update if anything *interesting* happens.
  
  **Tags:** upgrade, database
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2022-11-29. Score: 1 | Accepted answer
  
  Do you have an Extended report extension installed? If yes, then probably you would need to
  
  1. Upgrade CiviCRM to 5.46.3
  2. Upgrade the Extended report extension to the latest version.
  3. Upgrade CiviCRM to 5.55.2
  4. Run the extension update db if there are any.
  
  or
  
  1. Replace the extended report extension folder to latest.
  2. Upgrade CiviCRM to 5.55.2
  3. Run the extension update db if there are any.
  
  > **Comments:**
  > **username_0**: Oooh, indeed there's a ton of stuff in Extensions that says it needs updating.  I'll post a screen shot of that as an addendum to my question, looks like this might be a multi-step process.  I'm super glad I'm practicing on an AMI on AWS so I can keep scrubbing it and start over.  
  > **username_1**: First, sort the missing extension and later update the extension.  
  
  ---
  
  ### Answer by username_0 on 2022-12-06. Score: 0
  
  Thanks to @username_1 for setting me on the right path. For posterity, here are the steps that ended up working.
  
  ```
  # DO: visit /civicrm/admin/extensions?reset=1 and do updates
  
  # Upgrade drupal
  DRUP=~/stack/drupal
  TB=drupal-7.92.tar.gz
  OTHER=/bitnami/drupal
  
  sudo mv $DRUP $DRUP-old
  
  cd "$(dirname $DRUP)"
  curl https://ftp.drupal.org/files/projects/$TB | sudo tar -zxvf -
  sudo mv "${TB//\.tar\.gz/}" drupal
  
  cd $DRUP
  sudo rm -rf sites
  sudo ln -s $OTHER/sites .
  sudo ln -s $OTHER/modules/contrib $DRUP/modules/
  
  # Upgrade civicrm to intermediate version
  V1=5.46.3
  cd $OTHER/modules/contrib
  rm -rf civicrm
  curl -L https://download.civicrm.org/civicrm-${V1}-drupal.tar.gz | tar -zxf -
  # DO: visit /civicrm/upgrade?reset=1
  # DO: visit /civicrm/admin/extensions?reset=1 and do updates
  
  # Upgrade civicrm to final version
  V2=5.55.2
  cd $OTHER/modules/contrib
  rm -rf civicrm
  curl -L https://download.civicrm.org/civicrm-${V2}-drupal.tar.gz | tar -zxf -
  # DO: visit /civicrm/upgrade?reset=1
  # DO: visit /civicrm/admin/extensions?reset=1 and do updates
  
  ```
  
  When I did this "for real" the final time, I did get some errors in the website after the CiviCRM steps about various PHP errors that prevented the site from loading. I'm not sure what that was about, but just waiting a while longer between steps seemed to cure it.
  
  
  ---
  
  