View Issue Details

IDProjectCategoryView StatusLast Update
0006766mantisbtbugtrackerpublic2006-02-28 09:36
Reportercoreyo Assigned To 
PrioritynormalSeverityminorReproducibilityalways
Status newResolutionopen 
Product Version1.0.1 
Target VersionFixed in Version 
Summary0006766: print_reporter_option_list() Bug in "core/print_api.php"
Description

when the project filter is set to "all projects" (i.e. 0), an implicit MySQL query is called in the "print_reporter_option_list()" function.

This query begins with a regular join that creates all possible combinations of the "mantis_user_table", the "mantis_project_table", and the "mantis_project_user_list_table" tables. Though the "mantis_user_table" and "mantis_project_table" will necessarily have at least 1 entry, the "mantis_project_user_list_table" contains no entries unless someone has been given special permissions to a specific project. If this table is empty, the "print_reporter_option_list()" function will necessarily always return 0 results.

On another note, there is probably some optimization that could be done here as this query grows exponentially in resources and times as these 3 tables acquire entries.

I recognized this bug in a modified 0.8.x version of mantis, but noticed that it was still present in the latest 1.0.1 code.

Steps To Reproduce
  • clear the "mantis_project_user_list_table" so that it has no rows
  • select "all projects" from the filter

At this point, anything that calls the "print_reporter_option_list()" function will necessarily return 0 results.

Additional Information

this bug is likely also present in the other functions such as
print_assign_to_option_list()
etc...

TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2006-02-28 09:36 coreyo New Issue