<turbo-stream action="replace" target="forum-thread-gap-12691-12698"><template>
<div id="messages-post-component-12693">
  <div data-view-component="true" class="op-forum-post-stem border-left"></div>
  <div id="message-12693" tabindex="-1" autofocus="autofocus" data-test-selector="forum-post-12693" data-view-component="true" class="Box op-forum-post position-relative">
  <div id="header-bfbdfa95-0859-45c5-9f09-ad098c38f276" data-view-component="true" class="Box-header py-2 tmp-py-2">
  
  
  <div data-view-component="true" class="flex-items-center flex-justify-between d-flex flex-row">
      
  <div data-view-component="true" class="flex-wrap flex-items-center d-flex flex-row">
      <div data-view-component="true" class="mr-2 tmp-mr-2"><opce-principal class="" data-principal="{&quot;href&quot;:&quot;/api/v3/users/87&quot;,&quot;name&quot;:&quot;Jens Ulferts&quot;,&quot;id&quot;:87}" data-link="true" data-size="&quot;mini&quot;" data-hide-name="true" data-name-classes="&quot;&quot;" data-title="null" data-hover-card="true" data-hover-card-url="&quot;/users/87/hover_card&quot;"></opce-principal></div>
      <div data-view-component="true" class="mr-2 tmp-mr-2"><a target="_blank" data-hover-card-url="/users/87/hover_card" data-hover-card-trigger-target="trigger" href="/users/87" data-view-component="true" class="Link--primary Link text-bold">Jens Ulferts</a></div>
      <div data-view-component="true"><a data-turbo="false" href="/projects/OP/forums/9/topics/12691?r=12693#message-12693" data-view-component="true" class="Link--secondary Link text-small">10/15/2020 09:23 AM</a></div>
</div>

      
  <div data-view-component="true" class="ml-1 tmp-ml-1 flex-items-center d-flex flex-row">
      <div data-view-component="true"><action-menu data-select-variant="none" data-view-component="true">
  <button id="primary-menu-8793868a-aceb-44b4-b2a3-ba11a4cf9ba3-button" popovertarget="primary-menu-8793868a-aceb-44b4-b2a3-ba11a4cf9ba3-overlay" aria-controls="primary-menu-8793868a-aceb-44b4-b2a3-ba11a4cf9ba3-list" aria-haspopup="true" aria-labelledby="tooltip-b0e49cfe-a3ff-4ff1-9d9f-db67f9057bca" type="button" data-view-component="true" class="Button Button--iconOnly Button--invisible Button--medium">  <svg aria-hidden="true" data-component="Octicon" height="16" viewBox="0 0 16 16" version="1.1" width="16" data-view-component="true" class="octicon octicon-kebab-horizontal Button-visual">
    <path d="M8 9a1.5 1.5 0 1 0 0-3 1.5 1.5 0 0 0 0 3M1.5 9a1.5 1.5 0 1 0 0-3 1.5 1.5 0 0 0 0 3m13 0a1.5 1.5 0 1 0 0-3 1.5 1.5 0 0 0 0 3"></path>
</svg>
</button><tool-tip id="tooltip-b0e49cfe-a3ff-4ff1-9d9f-db67f9057bca" for="primary-menu-8793868a-aceb-44b4-b2a3-ba11a4cf9ba3-button" popover="manual" data-direction="s" data-type="label" data-view-component="true" class="sr-only position-absolute">Message actions</tool-tip>


<anchored-position data-target="action-menu.overlay" id="primary-menu-8793868a-aceb-44b4-b2a3-ba11a4cf9ba3-overlay" anchor="primary-menu-8793868a-aceb-44b4-b2a3-ba11a4cf9ba3-button" align="start" side="outside-bottom" anchor-offset="normal" popover="auto" data-view-component="true">
  <div data-view-component="true" class="Overlay Overlay--size-auto">
    
      <div data-view-component="true" class="Overlay-body Overlay-body--paddingNone">      <action-list>
  <div data-view-component="true">
    <ul data-target="action-menu.list" aria-labelledby="primary-menu-8793868a-aceb-44b4-b2a3-ba11a4cf9ba3-button" id="primary-menu-8793868a-aceb-44b4-b2a3-ba11a4cf9ba3-list" role="menu" data-view-component="true" class="ActionListWrap--inset ActionListWrap">
        <li data-targets="action-list.items" role="none" data-view-component="true" class="ActionListItem">
    
    
    <clipboard-copy value="https://community.openproject.org/projects/OP/forums/9/topics/12691?r=12693#message-12693" tabindex="-1" id="item-2cc8c481-3179-47c9-876f-b056f36f4d7d" role="menuitem" data-view-component="true" class="ActionListContent ActionListContent--visual16">
        <span class="ActionListItem-visual ActionListItem-visual--leading">
          <svg aria-hidden="true" data-component="Octicon" height="16" viewBox="0 0 16 16" version="1.1" width="16" data-view-component="true" class="octicon octicon-copy">
    <path d="M0 6.75C0 5.784.784 5 1.75 5h1.5a.75.75 0 0 1 0 1.5h-1.5a.25.25 0 0 0-.25.25v7.5c0 .138.112.25.25.25h7.5a.25.25 0 0 0 .25-.25v-1.5a.75.75 0 0 1 1.5 0v1.5A1.75 1.75 0 0 1 9.25 16h-7.5A1.75 1.75 0 0 1 0 14.25Z"></path><path d="M5 1.75C5 .784 5.784 0 6.75 0h7.5C15.216 0 16 .784 16 1.75v7.5A1.75 1.75 0 0 1 14.25 11h-7.5A1.75 1.75 0 0 1 5 9.25Zm1.75-.25a.25.25 0 0 0-.25.25v7.5c0 .138.112.25.25.25h7.5a.25.25 0 0 0 .25-.25v-7.5a.25.25 0 0 0-.25-.25Z"></path>
</svg>
        </span>
      
        <span data-view-component="true" class="ActionListItem-label">
          Copy link to clipboard
</span>      
</clipboard-copy>
  
</li>
</ul>    
</div></action-list>


</div>
      
</div></anchored-position>
</action-menu></div>
</div>

</div>

</div>
  <div data-view-component="true" class="Box-body"><div class="op-uc-container"><p class="op-uc-p">This is probably because of a transition from MySQL to PostgreSQL. The automated migration script seems to sometimes mess up the primary key sequences.</p>
<p class="op-uc-p">To answer your question, I'd first need more information.</p>
<p class="op-uc-p">Get the database string to connect to the database in the next step (also described here: <a href="https://docs.openproject.org/installation-and-operations/operation/restoring/#restoring-the-database" rel="noopener noreferrer nofollow" target="_top" class="op-uc-link"><strong>https://docs.openproject.org/installation-and-operations/operation/restoring/#restoring-the-database</strong></a>):</p>
<p class="op-uc-p"><code class="op-uc-code">openproject config:get DATABASE_URL</code></p>
<p class="op-uc-p">With the output of that command, connect to the database:</p>
<p class="op-uc-p"><code class="op-uc-code">psql [output of the previous command]</code></p>
<p class="op-uc-p">Then within the postgresql shell, type:</p>
<p class="op-uc-p"><code class="op-uc-code">\d+ cost_objects</code></p>
<p class="op-uc-p">Please post the output of that last command back here, so I can take a look at the current naming. <strong>Please do not post the value of the DATABASE_URL, though</strong>.</p></div></div>
  
</div>
</div></template></turbo-stream>