292232 - All bugs not returned upon query

Status: RESOLVED WONTFIX

(Bugzilla :: Query/Bug List, defect)

Description

[Lakshmi]

User-Agent:       Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
Build Identifier: Mozilla/4.0

Some bugs do not show up on querying. Upon investigation, these bugs have a 
blank reportee fields eventhough it is entered by an authorized user.when the 
bug is reassigned to the another user the difference , I see is in 
the "Reassign bug to ___________" the name filled in is "_UNKNOWN_". 

Reproducible: Always

Steps to Reproduce:
1.when queried for all the bugs
2.In the summary reports
3.

Actual Results:  
It does not show all the bugs

Expected Results:  
Should list all the bugs

Comment 1

[Max Kanat-Alexander]

That could probably only happen if you enabled user deletion.

Still, the bugs should show up. We probably have an INNER JOIN on the profiles
table where we should have a LEFT JOIN.

What version of Bugzilla was this in?

Comment 2

[Lakshmi]

After searching through the database files of bugzilla, I found out that the 
reporter of these bugs is deleted from database .That's why it is 
showing "unknown" when trying to reassign it . Is there a way to eliminate 
this bug?

My BugZilla version is 2.14.

Comment 3

[Max Kanat-Alexander]

Ahh. Bugzilla 2.14 is not supported any longer. It's very likely that it does
bad things when users are deleted.

If you upgrade, we could continue to investigate the situation.