Description of problem: See $summary and the screenshot https://bugzilla.redhat.com/bugzilla/attachment.cgi?id=148017 (I'm not going to attach the same screenshot twice). Version-Release number of selected component (if applicable): 2.18 How reproducible: always Steps to Reproduce: 1.log on as me 2. 3. Actual results: see screenshot Expected results: no bug listed more than once Additional info:
consider amending your query logic to SELECT DISTINCT FROM if you're using newer mysql or GROUP BY bugs.bug_id if you're using an older version.
Red Hat Bugzilla is now using version 3.2 of the Bugzilla codebase and therefore this bug will need to be re-verified against the new release. With the updated code this bug may no longer be relevant or may have been fixed in the new code. Updating bug version to 3.2.
The problem is still present. I can attach a new screenshot, if necessary, but the problem is the same. In the "Open Issues with FLAGS You Have Requested" list one of the bugs is listed twice.
Created attachment 325330 [details] v1 for adding code to forntpage.cgi to remove duplicate entries I have verified this problem, and found the fix by adding GROUP BY to the SQL query to group results by bug ids and that prevented duplicate bug entries. Noura
Comment on attachment 325330 [details] v1 for adding code to forntpage.cgi to remove duplicate entries Looks fine Noura.
Thanks for the review Dave, patch has been committed to cvs, should go live on Thursday. Noura