0003844: missing outer joins in "print_api.php"

ID	Project	Category	View Status	Date Submitted	Last Update
0003844	mantisbt	bugtracker	public	2004-05-17 05:17	2005-07-23 02:08

Reporter	manulamb	Assigned To	thraxisp
Priority	normal	Severity	major	Reproducibility	always
Status	closed	Resolution	fixed

Summary	0003844: missing outer joins in "print_api.php"
Description	After installing Mantis, it turned out that the "assigned to", "reported by" and "category" dropdown lists where always empty in the "view bugs" screen. I had to manually add a couple of outer joins in the SQL of file ... (see attached new version). Functions in "print_api.php" : -print_reporter_option_list -print_project_user_list_option_list -print_project_user_list_option_list2 -print_project_user_list -print_assign_to_option_list (possibly not complete, to be checked by the original author of the code)
Tags	No tags attached.
Attached Files	print_api.zip (8,442 bytes)

Apel 2004-05-17 06:29 reporter ~0005515	this is similiar to 0003721

matt_doran 2004-05-26 06:20 reporter ~0005593	I've also noticed this behaviour, here are some more details. I'm using the current CVS version (0.19-DEV) but the problem also occurs in 0.18.x. (In addition to 0003721, issue 0003243 is reporting the same problem.) The "assigned to" field in the view issues filter does not contain any users when: 'All Projects' is selected in the project list No one is assigned to any projects (which will be common when relying on default access levels) As soon as a single user is assigned to a project, the drop-down is populated correcly. As shown in the above attachment, we should not rely on the fact that the project_user_list_table has rows in it.

thraxisp 2005-07-22 13:05 reporter ~0010927	These were incorporated somewhere along the way to the 1.0.0 release.