449693 - If a custom multi-select field is active, displaying all columns in buglists throws a SQL error

Status: RESOLVED FIXED

(Bugzilla :: Query/Bug List, defect)

Description

[Frédéric Buclin]

Try displaying all open bugs assigned to me, and display all columns in the buglist using &columnlist=all:

https://landfill.bugzilla.org/bugzilla-tip/buglist.cgi?quicksearch=%40lpsolit&columnlist=all

A SQL error is thrown:

DBD::mysql::st execute failed: Unknown column 'bugs.cf_mulitple_select' in 'field list' [for Statement "SELECT bugs.bug_id, bugs.bug_severity, bugs.priority, bugs.bug_status, bugs.resolution, map_products.name, bugs.remaining_time, (SUM(ldtime.work_time)*COUNT(DISTINCT ldtime.bug_when)/COUNT(bugs.bug_id)) AS actual_time, bugs.priority, bugs.delta_ts, bugs.cf_mulitple_select, bugs.keywords, bugs.cf_drop_down, map_assigned_to.login_name, map_qa_contact.login_name, bugs.bug_severity, bugs.estimated_time, bugs.remaining_time, bugs.cf_large_text, bugs.creation_ts, bugs.cf_free_text, bugs.resolution, map_classifications.name, CASE WHEN map_qa_contact.realname  = '' THEN map_qa_contact.login_name  ELSE map_qa_contact.realname  END AS qa_contact_realname, bugs.alias, bugs.op_sys, (CASE WHEN (SUM(ldtime.work_time)*COUNT(DISTINCT ldtime.bug_when)/COUNT(bugs.bug_id))             + bugs.remaining_time = 0.0 THEN 0.0 ELSE 100*((SUM(ldtime.work_time)*COUNT(DISTINCT ldtime.bug_when)/COUNT(bugs.bug_id))      /((SUM(ldtime.work_time)*COUNT(DISTINCT ldtime.bug_when)/COUNT(bugs.bug_id)) + bugs.remaining_time)) END) AS percentage_complete, CASE WHEN map_assigned_to.realname = '' THEN map_assigned_to.login_name ELSE map_assigned_to.realname END AS assigned_to_realname, map_reporter.login_name, bugs.rep_platform, bugs.short_desc, bugs.status_whiteboard, bugs.votes, bugs.bug_status, bugs.cf_date, bugs.version, DATE_FORMAT(bugs.deadline, '%Y-%m-%d') AS deadline, map_components.name, (SUM(ldtime.work_time)*COUNT(DISTINCT ldtime.bug_when)/COUNT(bugs.bug_id)) AS actual_time, CASE WHEN map_reporter.realname    = '' THEN map_reporter.login_name    ELSE map_reporter.realname    END AS reporter_realname, map_products.name, bugs.target_milestone FROM bugs  INNER JOIN profiles AS map_assigned_to ON (bugs.assigned_to = map_assigned_to.userid) INNER JOIN profiles AS map_reporter ON (bugs.reporter = map_reporter.userid) LEFT JOIN profiles AS map_qa_contact ON (bugs.qa_contact = map_qa_contact.userid) INNER JOIN products AS map_products ON (bugs.product_id = map_products.id) AND (bugs.product_id = map_products.id) INNER JOIN classifications AS map_classifications ON (map_products.classification_id = map_classifications.id) INNER JOIN components AS map_components ON (bugs.component_id = map_components.id) LEFT JOIN longdescs AS ldtime ON (ldtime.bug_id = bugs.bug_id) LEFT JOIN bug_status ON (bug_status.value = bugs.bug_status) LEFT JOIN priority ON (priority.value = bugs.priority) LEFT JOIN bug_group_map  ON bug_group_map.bug_id = bugs.bug_id  AND bug_group_map.group_id NOT IN (8,16,4,9,14,2,17,12,3,10,18,11,13,1,6,15,20,5,19,7)  LEFT JOIN cc ON cc.bug_id = bugs.bug_id AND cc.who = 10195 WHERE (( bugs.bug_status IN ('REOPENED','NEW','ASSIGNED','UNCONFIRMED') )) AND ((bugs.assigned_to IN (SELECT userid FROM profiles WHERE INSTR(profiles.login_name, 'lpsolit') > 0))) AND bugs.creation_ts IS NOT NULL AND ((bug_group_map.group_id IS NULL)    OR (bugs.reporter_accessible = 1 AND bugs.reporter = 10195)     OR (bugs.cclist_accessible = 1 AND cc.who IS NOT NULL)     OR (bugs.assigned_to = 10195) OR (bugs.qa_contact = 10195) ) GROUP BY bugs.bug_id ORDER BY bug_status.sortkey,bug_status.value,priority.sortkey,priority.value,map_assigned_to.login_name,bugs.bug_id"] at /var/www/html/bugzilla-tip/buglist.cgi line 1040

That's because multi-select fields are included in the query, which of course do not exist in the bugs table. Those must be excluded from the list (at least till we are able to display multi-select fields).

This crash also affects 3.2 RC1, but not 3.0.5 which doesn't support multi-select fields yet.

Comment 1

[Frédéric Buclin]

Attachment: patch, v1

Exclude multi-select fields from the list of available columns. We don't support them yet.

Comment 2

[Frédéric Buclin]

tip:

Checking in buglist.cgi;
/cvsroot/mozilla/webtools/bugzilla/buglist.cgi,v  <--  buglist.cgi
new revision: 1.381; previous revision: 1.380
done

3.1.4:

Checking in buglist.cgi;
/cvsroot/mozilla/webtools/bugzilla/buglist.cgi,v  <--  buglist.cgi
new revision: 1.374.2.3; previous revision: 1.374.2.2
done