Bugzilla and sorting doesn't work...
Hi.
I have a debian system (woody/stable with security.debian.org updates)
in use for bug tracking. I've setup bugzilla with mysql and it has been
working great for quite some time (started it back when woody was not
yet stable, but I did a complete reinstall after woody became stable).
Now something has happened (actually last summer, but I haven't had time
to resolve this before)... The sort in buglist.cgi doesn't work anymore.
It only counts the last criteria on the url. Anyone have any idea on
what could wrong? The system itself (apache, bugzilla, and mysql) is
default install.
Here's an example url that doesn't sort by version at all, only by
target milestone:
url:
...&order=bugs.version%2C%20bugs.target_milestone
apache log entry:
192.168.1.113 - - [03/Oct/2002:13:33:17 +0300] "GET
/cgi-bin/bugzilla/buglist.cgi?bug_status=NEW&bug_status=ASSIGNED&bug_status=REOPENED&email1=&emailtype1=exact&emailassigned_to1=1&emailreporter1=1&email2=&emailtype2=substring&emailreporter2=1&bugidtype=include&bug_id=&changedin=&votes=&chfieldfrom=&chfieldto=Now&chfieldvalue=&product=Auric&short_desc=&short_desc_type=allwordssubstr&long_desc=&long_desc_type=allwordssubstr&bug_file_loc=&bug_file_loc_type=allwordssubstr&status_whiteboard=&status_whiteboard_type=allwordssubstr&field0-0-0=noop&type0-0-0=noop&value0-0-0=&namedcmd=My+open+bugs&newqueryname=All+open+bugs&tofooter=1&order=bugs.version%2C%20bugs.target_milestone
HTTP/1.1" 200 50666 "-" "Mozilla/5.0 Galeon/1.2.5 (X11; Linux i586; U;)
Gecko/20020623 Debian/1.2.5-0.woody.1"
mysql log entry:
351 Query SELECT bugs.bug_id, bugs.groupset,
substring(bugs.bug_severity, 1, 3), substring(bugs.priority, 1, 3),
map_assigned_to.login_name, map_reporter.login_name,
substring(bugs.bug_status,1,4), substring(bugs.resolution,1,4),
substring(bugs.product, 1, 8), substring(bugs.version, 1, 5),
bugs.target_milestone, substring(bugs.short_desc, 1, 60) FROM bugs,
profiles map_assigned_to, profiles map_reporter LEFT JOIN profiles
map_qa_contact ON bugs.qa_contact = map_qa_contact.userid LEFT JOIN
milestones ms_order ON ms_order.value = bugs.target_milestone AND
ms_order.product = bugs.product WHERE bugs.assigned_to =
map_assigned_to.userid AND bugs.reporter = map_reporter.userid AND
bugs.groupset & 127 = bugs.groupset AND (bugs.product = 'Auric') AND
(bugs.bug_status = 'NEW' OR bugs.bug_status = 'ASSIGNED' OR
bugs.bug_status = 'REOPENED') GROUP BY bugs.bug_id ORDER BY
ms_order.sortkey,ms_order.value
It would seem that version doesn't appear in mysql log entry at all...
But why? Is this a bug in bugzilla? Do I need some apache module or
something? It worked ok Q1 and Q2, but not after I came back from summer
vacation...
p.s. please cc me (or mail directly), i'm not subscribed
Any help will be greatly appreciated.
Thanks in advance,
--
Mikko Kilpikoski
Reply to: