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

Jira insert line in table cwd_membership

Marine Tm

Hello I'am trying to insert user into jira group i tried this query but it fails...

i don't know what is the ID should i insert in the the column 'ID' the same thing for the column parent_id and child_id.

is there someone who know what shoould insert in IDs columns plz ?

The second picture (SELECT query) shows what contain the table membership.

Accepted answers

All comments

Nic Brough -Adaptavist-

Please, stop trying to do this. You do not understand what you are doing, you are going to break your system, you render yourself unsupported, and you can't do it with an active system.

Have you shut down your system, taken a full backup, and proved that can be restored before trying to run your SQL?

Heather Ronnebeck

Is there a reason you can't do this from the administration panel in the GUI? Adding users to the administrators' group is quite simple from the front end.

Marine Tm

Hello @Nic Brough -Adaptavist- ,

i'am executing this in a test environement i just forget to use

Begin transaction

.....SQL query

Rollback transaction

to not commit the changes.

if i understand what you saying i should stop my jira test before executing the query ?

Marine Tm

yes, but i'm searching for a sql query ....

Nic Brough -Adaptavist-

Ok, so backup less important in test (assuming you're prepared to rebuild it all from scratch if you break the data)

So, yes, as we've said repeatedly, you can not run database updates/inserts/deletes on an active Jira system. It must be offline.

If you've run an update against the data while the Jira is active, and then done a rollback, there's a very good chance you've made even more of a mess of the database than just running it without rollback.

Seriously, please, please, stop trying to do this the wrong way. Use the UI, use REST, use an App built for it. Anything but SQL.

Marine Tm

@Nic Brough -Adaptavist- i have already tried to do it with REST API but it did not work

i'm on windows, and the Test environement where jira is located is not the same where i'm writing you actually, there is nothing in no internet ...

and the curl command work only in linux

or maybe i don't have the rights to execute the command with my account

but it did not work when i try with api rest :'(

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

atl-gruland