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; } } }

Updating vname in projectversion table not updating the version names

Varnika Bisht

Hi Team,

We have many projects in the system and one version is named differently in every project. To standardize we want to keep same nomenclature of one version in all projects. since updating at project level was tough, we thought to update from backend using query

update projectversion

set vname = <new value>

where vname = <older value>

The update is successful. However the tickets are reflecting older values as well as the version available at project also has older name. Does anyone know how can we achieve this?

Accepted answers

All comments

Walter Buggenhout

Hi @Varnika Bisht,

Have you tried to reindex Jira?

Varnika Bisht

Yes Walter, still doesn't reflect back.

Walter Buggenhout

That was my best guess on this. Sorry it didn't fix the issue. Maybe someone else may have additional ideas about this then.

Just as a recommendation for the future: do avoid direct database updates, even (and especially) if they seem like a quick fix. There's layers between your database and the application and missing a piece may put you in serious trouble.

Varnika Bisht

Would you know an alternate way to efficiently do this update if not via database update?

Nic Brough -Adaptavist-

You should never write to a Jira database.

You've run into one of the reasons whay - you don't really understand the data structure in there and you've neglected some of the changes you needed to do to make this work.

There's a good chance that you have corrupted your database, so you really should roll it back to the backup you took before you did this. (Shut it down, restore the database dump, restart and re-index in full)

Then look at making your changes via the API - for the internal one, using a plugin you write, or a scripting or automation app, or look at the REST API admin functions or CLI

Varnika Bisht

It works after system is restarted. We are just changing version names and don't see any efficient way to do this.

Nic Brough -Adaptavist-

Mmm, that's because of caching.

You almost certainly have corrupted your database now, you really should go back to a backup.

Using SQL to do this is absolutely not an "efficient" way to do this - I don't think it can be efficient to run the SQL and then spend weeks trying to fix the data you've damaged.

Welcome!

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

Quick Links

Find more posts tagged with

server

jira-software

jira-software-server