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-28T02:13:40.673Z
Answers.Text: We do actually have a version of that installed but it is not used for anything. Perhaps uninstalling it and repeating the 5.34 to 5.55 update to see what happens.
Answers.UserDisplayName: P a u l
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-11-28T15:19:01.667Z
Answers.Text: Yes, That might also work
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-11-28T01:32:55.643Z
Answers.LastActivityDate: 2022-11-28T01:32:55.643Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>The Wordpress database update process from 5.34.0 to 5.55.2 fails right near the end with this error:</p>
  <p>Exception: &quot;API error: DB Error: constraint violation on ReportTemplate.create&quot;</p>
  <p>Perhaps you know of a quick fix before I have to roll everything back.</p>
  <p>Note: civicrm seems to be up and running however -- I haven't seen a bug yet. Perhaps I can ignore this update error?</p>
  <p>Edit: Here is the tail end of the log I found hope it's enough:</p>
  <pre><code>    #message: &quot;DB Error: constraint violation&quot;
  #code: 0
  #file: &quot;/home/noyb/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php&quot;
  #line: 955
  trace: {
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php:955 {
      ›   CRM_Core_Error::backtrace('backTrace', TRUE);
      ›   throw new PEAR_Exception($pearError-&gt;getMessage(), $pearError);
      › }
    }
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php:944 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB.php:997 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php:575 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php:223 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB/common.php:1928 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB/mysqli.php:943 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB/mysqli.php:413 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB/common.php:1234 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php:2696 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php:1650 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php:730 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/CRM/Price/BAO/PriceSet.php:225 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/CRM/Price/Form/DeleteSet.php:76 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php:573 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/StateMachine.php:144 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Next.php:43 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php:203 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php:103 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php:355 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/CRM/Price/Page/Set.php:145 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:319 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:69 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:36 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm.php:1199 { …}
    /home/noyb/public_html/wp-includes/class-wp-hook.php:303 { …}
    /home/noyb/public_html/wp-includes/class-wp-hook.php:327 { …}
    /home/noyb/public_html/wp-includes/plugin.php:470 { …}
    /home/noyb/public_html/wp-admin/admin.php:259 { …}
  }
  </code></pre>
  <p>}
  ]</p>
  <blockquote>
  <p>Nov 27 13:04:43  [debug] $backTrace = #0 /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(441): CRM_Core_Error::backtrace(&quot;backTrace&quot;, TRUE)
  #1 /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(39): CRM_Core_Error::handleUnhandledException(Object(PEAR_Exception))
  #2 /home/noyb/public_html/wp-content/plugins/civicrm/civicrm.php(1199): CRM_Core_Invoke::invoke((Array:3))
  #3 /home/noyb/public_html/wp-includes/class-wp-hook.php(303): CiviCRM_For_WordPress-&gt;invoke(&quot;&quot;)
  #4 /home/noyb/public_html/wp-includes/class-wp-hook.php(327): WP_Hook-&gt;apply_filters(&quot;&quot;, (Array:1))
  #5 /home/noyb/public_html/wp-includes/plugin.php(470): WP_Hook-&gt;do_action((Array:1))
  #6 /home/noyb/public_html/wp-admin/admin.php(259): do_action(&quot;toplevel_page_CiviCRM&quot;)
  #7 {main}</p>
  </blockquote>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-11-27T20:10:09.593Z
Comments.Text: Please check your [CiviCRM logs](https://civicrm.stackexchange.com/q/15931/12) for the backtrace and edit your question to include it?  Otherwise folks will be unable to help you.
Comments.UserDisplayName: Jon G - Megaphone Tech
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-11-28T00:51:23.743Z
Comments.Text: I added some log info.
Comments.UserDisplayName: P a u l
Tags: <upgrade><error>
Title: Database update error with 5.55.2
ThreadText: # Database update error with 5.55.2
  
  (Asked by: username_0 on 2022-11-27)
  
  The Wordpress database update process from 5.34.0 to 5.55.2 fails right near the end with this error:
  Exception: "API error: DB Error: constraint violation on ReportTemplate.create"
  Perhaps you know of a quick fix before I have to roll everything back.
  Note: civicrm seems to be up and running however -- I haven't seen a bug yet. Perhaps I can ignore this update error?
  Edit: Here is the tail end of the log I found hope it's enough:
      #message: "DB Error: constraint violation"
  #code: 0
  #file: "/home/noyb/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php"
  #line: 955
  trace: {
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php:955 {
      ›   CRM_Core_Error::backtrace('backTrace', TRUE);
      ›   throw new PEAR_Exception($pearError->getMessage(), $pearError);
      › }
    }
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php:944 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB.php:997 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php:575 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php:223 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB/common.php:1928 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB/mysqli.php:943 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB/mysqli.php:413 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB/common.php:1234 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php:2696 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php:1650 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php:730 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/CRM/Price/BAO/PriceSet.php:225 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/CRM/Price/Form/DeleteSet.php:76 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php:573 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/StateMachine.php:144 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Next.php:43 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php:203 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php:103 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php:355 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/CRM/Price/Page/Set.php:145 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:319 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:69 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:36 { …}
    /home/noyb/public_html/wp-content/plugins/civicrm/civicrm.php:1199 { …}
    /home/noyb/public_html/wp-includes/class-wp-hook.php:303 { …}
    /home/noyb/public_html/wp-includes/class-wp-hook.php:327 { …}
    /home/noyb/public_html/wp-includes/plugin.php:470 { …}
    /home/noyb/public_html/wp-admin/admin.php:259 { …}
  }
  
  }
  ]
  
  Nov 27 13:04:43  [debug] $backTrace = #0 /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(441): CRM_Core_Error::backtrace("backTrace", TRUE)
  #1 /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(39): CRM_Core_Error::handleUnhandledException(Object(PEAR_Exception))
  #2 /home/noyb/public_html/wp-content/plugins/civicrm/civicrm.php(1199): CRM_Core_Invoke::invoke((Array:3))
  #3 /home/noyb/public_html/wp-includes/class-wp-hook.php(303): CiviCRM_For_WordPress->invoke("")
  #4 /home/noyb/public_html/wp-includes/class-wp-hook.php(327): WP_Hook->apply_filters("", (Array:1))
  #5 /home/noyb/public_html/wp-includes/plugin.php(470): WP_Hook->do_action((Array:1))
  #6 /home/noyb/public_html/wp-admin/admin.php(259): do_action("toplevel_page_CiviCRM")
  #7 {main}
  
  **Tags:** upgrade, error
  
  > **Comments:**
  > **username_1**: Please check your [CiviCRM logs](https://civicrm.stackexchange.com/q/15931/12) for the backtrace and edit your question to include it?  Otherwise folks will be unable to help you.  
  > **username_0**: I added some log info.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2022-11-28. Score: 0
  
  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**: We do actually have a version of that installed but it is not used for anything. Perhaps uninstalling it and repeating the 5.34 to 5.55 update to see what happens.  
  > **username_2**: Yes, That might also work  
  
  ---
  
  