nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Change auto increment ID number

Mario Donaire

The data has been moved from one table to another. In this table the field ID is auto incremental, so the problem comes because the start number of this field ID is different from the previous table. When the new table does an insert, this table is trying to create a new row with an existing ID. Is there any way to change this auto incremental field ID without directly changing this table in our database?

Accepted answers

Fabio Racobaldo _Catworkx_

Hi @Mario Donaire ,

welcome to the Atlassian community!

That table field can be updated in order to track the last project key number based on the project key. Unfortunately that behaviour is based on the field on DB and you have no chance to manage it in other way.

Hope this helps,

Fabio

All comments

Fabio Racobaldo _Catworkx_

Hi @Mario Donaire ,

welcome to the Atlassian community!

Hope this helps,

Fabio

Mario Donaire

Hi @Fabio Racobaldo _Catworkx_

I am sorry but when you talk about the project key number I do not know what you mean or what I should do.

Fabio Racobaldo _Catworkx_

Hi @Mario Donaire ,

there is a table "project" containing a field "pcounter" with the last number of the issue created for that project.

You should update that field, per project basis, with the last key number created.

Here an how to guide for reset https://confluence.atlassian.com/jirakb/how-to-reset-the-project-counter-after-moving-issues-776643590.html but in your case you should update that field with the correct value.

Hope this helps,

Fabio

Mario Donaire

Hi @Fabio Racobaldo _Catworkx_

This table is not related to the "project" table. This table is from a plugin we are developing. I have also looked in the schemas of the tables but there is no information related to the ID field. Is there any way to modify this table? I

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server