306348 - Crash in Search - DB = PostgreSQL

Status: VERIFIED DUPLICATE of bug 298400

(Bugzilla :: User Interface, defect)

Description

[Sidnei Mistura]

User-Agent:       Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; FDM)
Build Identifier: Bugzilla

Software error:
DBD::Pg::st execute failed: ERROR:  syntax error at or near "desc" at character 
1146
 [for Statement "SELECT bugs.bug_id, bugs.bug_severity, bugs.priority, 
bugs.bug_status, bugs.resolution, bugs.bug_severity, bugs.priority, 
bugs.rep_platform, map_assigned_to.login_name, bugs.bug_status, 
bugs.resolution, bugs.short_desc, (SUM(CASE WHEN (LOWER(longdescs_0.thetext) 
LIKE '%loca%') THEN 1 ELSE 0 END)/COUNT(CASE WHEN (LOWER(longdescs_0.thetext) 
LIKE '%loca%') THEN 1 ELSE 0 END) + CASE WHEN (LOWER(bugs.short_desc) LIKE '%
loca%') THEN 1 ELSE 0 END) AS relevance FROM bugs  INNER JOIN profiles AS 
map_assigned_to ON (bugs.assigned_to = map_assigned_to.userid) INNER JOIN 
longdescs AS longdescs_0 ON (bugs.bug_id = longdescs_0.bug_id ) LEFT JOIN 
bug_group_map  ON bug_group_map.bug_id = bugs.bug_id  WHERE ((bugs.bug_status 
IN ('UNCONFIRMED','NEW','ASSIGNED','REOPENED'))) AND (((CASE WHEN (LOWER
(longdescs_0.thetext) LIKE '%loca%') THEN 1 ELSE 0 END > 0) OR (bugs.short_desc 
~* '(^|[^a-z0-9])loca($|[^a-z0-9])'))) AND bugs.creation_ts IS NOT NULL AND 
((bug_group_map.group_id IS NULL)) GROUP BY bugs.bug_id, bugs.short_desc, 
bugs.bug_severity, bugs.priority, bugs.bug_status, bugs.resolution, 
bugs.rep_platform, map_assigned_to.login_name, relevance desc ORDER BY 
relevance desc LIMIT 200"] at G:/Bugzilla/buglist.cgi line 828

For help, please send mail to the webmaster ([e-mail]), giving this 
error message and the time and date of the error. 


Reproducible: Always

Comment 1

[Frédéric Buclin]

*** This bug has been marked as a duplicate of 298400 ***