Arch Linux

Please read this before reporting a bug:
https://wiki.archlinux.org/title/Bug_reporting_guidelines

Do NOT report bugs when a package is just outdated, or it is in the AUR. Use the 'flag out of date' link on the package page, or the Mailing List.

REPEAT: Do NOT report bugs for outdated packages!
Tasklist

FS#10386 - flyspray search in comments is broken

Attached to Project: Arch Linux
Opened by Xavier (shining) - Saturday, 10 May 2008, 23:24 GMT
Last edited by Greg (dolby) - Saturday, 17 May 2008, 07:41 GMT
Task Type Bug Report
Category Bugtracker
Status Closed
Assigned To Simo Leone (neotuli)
eliott (cactus)
Architecture All
Severity Low
Priority Normal
Reported Version 2007.08-2
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 0
Private No

Details

Description:
The search in comments feature doesn't work anymore.

Additional info:
This is what appears when searching for "foo" with "search in comments" enabled:

Query { SELECT t.*, lc.category_name AS category_name, (SELECT COUNT(c.comment_id) FROM `flyspray_comments` c WHERE c.task_id = t.task_id) AS num_comments, GREATEST((SELECT max(c.date_added) FROM `flyspray_comments` c WHERE c.task_id = t.task_id), t.date_opened, t.date_closed, t.last_edited_time) AS max_date, lvc.version_name AS closedby_version, COUNT(DISTINCT att.attachment_id) AS num_attachments, p.project_title, p.project_is_active, lst.status_name AS status_name, lt.tasktype_name AS task_type, lr.resolution_name FROM `flyspray_tasks` t LEFT JOIN `flyspray_projects` p ON t.project_id = p.project_id LEFT JOIN `flyspray_list_tasktype` lt ON t.task_type = lt.tasktype_id LEFT JOIN `flyspray_list_status` lst ON t.item_status = lst.status_id LEFT JOIN `flyspray_list_resolution` lr ON t.resolution_reason = lr.resolution_id LEFT JOIN `flyspray_list_category` lc ON t.product_category = lc.category_id LEFT JOIN `flyspray_list_version` lvc ON t.closedby_version = lvc.version_id LEFT JOIN `flyspray_attachments` att ON t.task_id = att.task_id LEFT JOIN `flyspray_assigned` ass ON t.task_id = ass.task_id LEFT JOIN `flyspray_users` u ON ass.user_id = u.user_id WHERE t.project_id = ? AND ( is_closed <> '1' ) AND ((t.item_summary LIKE ? OR t.task_id LIKE ? OR c.comment_text LIKE ?)) GROUP BY t.task_id ORDER BY task_severity desc, t.task_id desc, t.task_id ASC} with params {1,%foo%,%foo%,%foo%} Failed! (Unknown column 'c.comment_text' in 'where clause')


Steps to reproduce:
* go on bugs.archlinux.org
* select advanced search
* enable "search in comments"
* search anything
This task depends upon

Closed by  Greg (dolby)
Saturday, 17 May 2008, 07:41 GMT
Reason for closing:  Upstream
Comment by Greg (dolby) - Sunday, 11 May 2008, 08:07 GMT
Relevant with  FS#9892  ?
Comment by Dan McGee (toofishes) - Wednesday, 14 May 2008, 02:04 GMT
Yeah, same thing. Any idea when upstream is planning on releasing a new version?

Loading...