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.