This question is in reference to Atlassian Documentation: Workflow transition button disappeared from the issue view page
Ask your question here...
You'll need to go into a bit more detail for your exact case.
@Nic Brough [Adaptavist], the case is as described in article.
Diagnosis query select * from os_wfentry where id = (select workflow_id from jiraissue where issuenum = 4 and project = (select id from project where pkey = 'TTWO')); has shown that state is 0.
But even after update os_wfentry set state = 1 where id = (select workflow_id from jiraissue where issuenum = 4 and project = (select id from project where pkey = 'TTWO')); and having state equal to 1, buttons in issue are still absent.
Did you try the integrity checker? Was JIRA shutdown when you ran the SQL?
@Nic Brough [Adaptavist], Yes, I did, but the page didn 't show the results as it should (We have large enough enstance). No, JIRA wasn't shutdown.
When you run almost any SQL on JIRA, you must have it shut down when you do it. If it's SQL affecting issues like this, then it's a definite. (The "almost" is because there are filter stuff you can change). Stop JIRA, check that the data you've changed is still changed in the database, and then restart it.
It looks like you're new here. Sign in or register to get started.