Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-5714

Duplicate entry in userbase table breaks User browser, Forgot Password

XMLWordPrintable

      It is evidently possible for there to be duplicate user entries in the userbase table:

      jira-xdoclet=# select username from userbase group by username having count > 1;
      username
      ------------
      millettjon
      (1 row)

      jira-xdoclet=# select * from userbase where username ='millettjon';
      id | username | password_hash
      ---------------------------------------------------------------------------------------------------------
      12364 | millettjon |
      12363 | millettjon | 9Ik/GVcirBUsMRbbMlDXfiVpeCtJL88sJThLI+Z01kGIZWlA61BuPgZv0MQ3pWRaHIHsnnwd23cCROFYAIrDhg==

      This causes the User browser to show:

      Displaying users 0 to of .

      and not display any users.

            Unassigned Unassigned
            7ee5c68a815f Jeff Turner
            Votes:
            5 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: