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


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

Reply via email to