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

Bugzilla search portlet doesn't redirect to imported issue

XMLWordPrintable

      It looks like under certain circumstances, JIRA does not delete the 'Bugzilla Import Key' changeitem when deleting a project. This results in multiple changeitems not associated with an issue:

      mysql> select changeitem.*, jiraissue.pkey from changeitem, changegroup LEFT JOIN jiraissue ON changegroup.issueid=jiraissue.id WHERE jiraissue.id is null and changegroup.id=changeitem.groupid and changeitem.FIELD='Bugzilla Import Key' and oldstring=34112;
      ------------------------------------------------------------------------------------

      ID groupid FIELDTYPE FIELD OLDVALUE OLDSTRING NEWVALUE NEWSTRING pkey

      ------------------------------------------------------------------------------------

      12332002 12323896 jira Bugzilla Import Key NULL 34112 NULL 12316832 NULL
      12345158 12333841 jira Bugzilla Import Key NULL 34112 NULL 12319817 NULL
      12351213 12339486 jira Bugzilla Import Key NULL 34112 NULL 12323128 NULL
      12353432 12341632 jira Bugzilla Import Key NULL 34112 NULL 12324792 NULL

      ------------------------------------------------------------------------------------
      4 rows in set (0.22 sec)

      this confuses the Bugzilla ID search portlet, which searches then redirects to Bugzilla instead.

            [JRASERVER-8323] Bugzilla search portlet doesn't redirect to imported issue

            Jeff Turner added a comment -

            Modified the portlet to avoid the problem if it exists in the db.

            Jeff Turner added a comment - Modified the portlet to avoid the problem if it exists in the db.

              7ee5c68a815f Jeff Turner
              7ee5c68a815f Jeff Turner
              Affected customers:
              0 This affects my team
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: