Excerpt | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
JIRA 7 bug
Broken portlets can be fixed individually by editing them and setting However only the dashboard owner can do this, and it's not exactly intuitive. This page describes a SQL fix to migrate all Created vs Resolved portlets to the new preference format. |
Table of Contents
Table of Contents |
---|
I haven't yet upgraded. Will I be affected?
...
Code Block |
---|
UPDATE sequence_value_item SET seq_id = (SELECT ceil(max(id)/100)*100 FROM gadgetuserpreference) WHERE seq_name='GadgetUserPreference' RETURNING seq_id; ┌────────┐ │ seq_id │ ├────────┤ │ 12800 │ └────────┘ (1 row) |
Shameless Plug
My business, Red Radish Consulting, offers a quarterly JIRA/Confluence upgrade service, and the fix described here was derived on-the-fly for a client. Save yourself the hassle of dealing with exciting bugs like this, and contact us for a quote!