Uploaded image for project: 'Jira Server and Data Center'
  1. Jira Server and Data Center
  2. JRASERVER-30873

JQL auto complete disabled on a user basis after upgrading to 5.2.x

    XMLWordPrintable

    Details

      Description

      Steps to reproduce

      1. Install JIRA 5.1.7
      2. Create two users
      3. Disable JQL Auto Complete in the Issue Navigators advanced search section for one of the users
      4. Upgrade JIRA to version 5.2.1

      Expected results

      • The ability to enable JQL auto complete for the user that had it disabled is no longer there
      • Presumed that JQL auto complete would be enabled/disabled for all users since it seems like it is no longer possible to control this on a per user basis

      Actual results

      • JQL auto complete is disabled for the user(s) that had it disabled before upgrading
      • The user(s) are unable to enable JQL auto complete

      Notes:

      There are still some entries in the database keeping the JQL auto complete disabled for users that had it disabled prior to upgrading:

      select propertyvalue from propertynumber where id in(select id from propertyentry where property_key='user.jql.autocomplete.disabled')
      

      Workaround/Resolution

      1. Run this query against JIRA's database to identify if any users have JQL auto complete disabled:

      select propertyvalue from propertynumber where id in(select id from propertyentry where property_key='user.jql.autocomplete.disabled')
      

      2. If any rows return a value of '1' then JQL auto complete is disabled for certain users
      3. Run this query to enable JQL auto complete for all users that have it disabled:

      update propertynumber set propertyvalue='0' where id in(select id from propertyentry where property_key='user.jql.autocomplete.disabled');
      

      Please make sure to take a backup of your data prior to making any changes on the database level.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              edalgliesh Eric Dalgliesh
              Reporter:
              pkirkeby Pelle Kirkeby (Inactive)
              Votes:
              5 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: