Project Version from SQL Database

[Sivarama Krishna K]

Hi,

Project Versions are available in projectversion table.

But due to some reason, we need to update project version from released to not released.

Updated data base fields. But not reflecting in UI.

How can we update?

Is there any API to mark as release?

[Nic Brough -Adaptavist- · Accepted solution]

NEVER amend a Jira database, it is not intended for you to even look at, let alone change it.

Stop Jira, restore the backup you took before you ran the SQL and restart and re-index, that is the only way to undo the damage you have done.  Although you might be able to get away with creating a new project and deleting the one you've damaged.

You should indeed only use the API for updates.