302840 - [PostgreSQL] Bugzilla cannot add classification to a buglist

Status: RESOLVED INVALID

(Bugzilla :: Database, defect)

Description

[Emmanuel Seyman]

When adding classification to the columns of a buglist, clicking on "Change
Columns" gives the following error :

DBD::Pg::st execute failed: ERREUR:  erreur de syntaxe sur ou près de «desc» at
character 1324
 [for Statement "SELECT bugs.bug_id, bugs.bug_severity, bugs.priority,
bugs.bug_status, bugs.resolution, map_products.name, bugs.bug_severity,
bugs.priority, bugs.rep_platform, map_assigned_to.login_name, bugs.bug_status,
bugs.resolution, map_classifications.name, bugs.version, bugs.short_desc,
bugs.votes FROM bugs  INNER JOIN profiles AS map_assigned_to ON
(bugs.assigned_to = map_assigned_to.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) LEFT JOIN bug_status
ON (bug_status.value = bugs.bug_status) LEFT JOIN bug_group_map  ON
bug_group_map.bug_id = bugs.bug_id  AND bug_group_map.group_id NOT IN
(3,7,10,5,1,8,11,4,2,6,9)  LEFT JOIN cc ON cc.bug_id = bugs.bug_id AND cc.who =
1 WHERE 1 = 1 AND bugs.creation_ts IS NOT NULL AND ((bug_group_map.group_id IS
NULL)    OR (bugs.reporter_accessible = 1 AND bugs.reporter = 1)     OR
(bugs.cclist_accessible = 1 AND cc.who IS NOT NULL)     OR (bugs.assigned_to =
1) ) GROUP BY bugs.bug_id, bugs.bug_severity, bugs.priority, bugs.bug_status,
bugs.resolution, map_products.name, bugs.rep_platform,
map_assigned_to.login_name, map_classifications.name, bugs.version,
bugs.short_desc, bugs.votes, bugs.votes desc, bugs.short_desc , bugs.version ,
bug_status.sortkey , bug_status.value , map_assigned_to.login_name , bugs.bug_id
 ORDER BY bugs.votes desc,bugs.short_desc ,bugs.version ,bug_status.sortkey
,bug_status.value ,map_assigned_to.login_name ,bugs.version ,bugs.bug_id "] at
/var/www/html/bugzilla-2.20/buglist.cgi line 828

Comment 1

[Frédéric Buclin]

The problem is "bugs.votes desc" as reported in bug 302785. This has nothing to
do with classifications and I cannot reproduce on the tip using Pg. Maybe have
you still a cookie which mentions to order by the number of votes.