734844 - SQL error when selecting multiple modules of a product

Status: RESOLVED DUPLICATE of bug 731163

(Bugzilla :: Query/Bug List, defect)

Description

[Alexander Stohr]

User Agent: Mozilla/5.0 (Windows NT 5.1; rv:10.0.2) Gecko/20100101 Firefox/10.0.2
Build ID: 20120215223356

Steps to reproduce:

i was selecting multiple modules (holding shift key and klicking with the mouse) for a single product for a search
then i was hitting the button to send the given credientials to the server.
my default view is slightly altered (some columns added and/or removed)


Actual results:

this is the server return (including some obfuscation on members data...)

Please stand by ...
Software error:
DBD::mysql::st execute failed: Unknown column 'changeddate' in 'order clause' [for Statement "SELECT bugs.bug_id AS bug_id, bugs.bug_severity AS bug_severity, bugs.priority AS priority, bugs.bug_status AS bug_status, bugs.resolution AS resolution, map_product.name AS product, map_assigned_to.login_name AS assigned_to, map_component.name AS component, bugs.short_desc AS short_desc
  FROM bugs
LEFT JOIN bug_group_map AS security_map ON bugs.bug_id = security_map.bug_id AND NOT ( security_map.group_id IN (9,8,21,43,25,35,58,50,39,18,20,56,49,52,45,46,54,55) )
LEFT JOIN cc AS security_cc ON bugs.bug_id = security_cc.bug_id AND security_cc.who = 95
INNER JOIN products AS map_product ON bugs.product_id = map_product.id
INNER JOIN profiles AS map_assigned_to ON bugs.assigned_to = map_assigned_to.userid
INNER JOIN components AS map_component ON bugs.component_id = map_component.id
INNER JOIN bug_status AS map_bug_status ON bugs.bug_status = map_bug_status.value
INNER JOIN priority AS map_priority ON bugs.priority = map_priority.value
 WHERE bugs.creation_ts IS NOT NULL
   AND (security_map.group_id IS NULL
        OR (bugs.reporter_accessible = 1 AND bugs.reporter = 95)
        OR (bugs.cclist_accessible = 1 AND security_cc.who IS NOT NULL)
        OR bugs.assigned_to = 95
        OR bugs.qa_contact = 95)
   AND  bugs.bug_id IN (127,128,259,95,112,144,136,152,202,205,267,283,301,303,336,361,225,414,404,417,410,240,289,493,623,167,150,697,716,717,718,720,721,698,696,694,693,725,724,705,736,737,738,742,743,744,746,704,699,745,749,739,765,763,757,719,355)  AND map_product.classification_id IN (SELECT classifications.id FROM classifications WHERE  classifications.name IN ('C******N') ) AND bugs.component_id IN (SELECT components.id FROM components WHERE  components.name IN ('C*******l','P***********5') ) AND bugs.product_id IN (SELECT products.id FROM products WHERE  products.name IN ('C*********l') )
GROUP BY bugs.bug_id
ORDER BY changeddate, map_bug_status.sortkey, map_bug_status.value, map_priority.sortkey, map_priority.value, assigned_to, bug_id
LIMIT 500
"] at /var/www/bugzilla/buglist.cgi line 834


Expected results:

the query should get accepted with no error and then executed.

notes:
this sounds similar to a very old bug with number 144768 from 2002 - its assumed much has changed since then under the hood so i decided to make it a spearate issue.
anyways i was using recent fierfox and not some quite older MSIE.

Comment 1

[Frédéric Buclin]

This problem has already been fixed in Bugzilla 4.2.1 (should be released soon).