FS#10481 - flyspray "search in comments" busted

Attached to Project: Arch Linux
Opened by Dale Blount (dale) - Friday, 23 May 2008, 23:25 GMT
Last edited by Roman Kyrylych (Romashka) - Monday, 08 June 2009, 22:39 GMT
Task Type Bug Report
Category Bugtracker
Status Closed
Assigned To Simo Leone (neotuli)
Architecture All
Severity Low
Priority Normal
Reported Version 1.0
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 3
Private No

Details

After checking the "Search in comments" box on a flyspray advanced search, it errors out with this:

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 {4,%test%,%test%,%test%} Failed! (Unknown column 'c.comment_text' in 'where clause')
Closed by  Roman Kyrylych (Romashka)
Monday, 08 June 2009, 22:39 GMT
Reason for closing:  Fixed
Comment by Dusty Phillips (Dusty) - Saturday, 21 June 2008, 23:52 GMT
Hey Simo, I'm assigning this to you since I know nothing about the flyspray install... if its not you feel free to pass it on.
Comment by Simo Leone (neotuli) - Sunday, 22 June 2008, 00:48 GMT
Yeah about this. Flyspray devs recomend running a development snapshot. Is that something we want to do? I mean, I suppose there can't really be harm in it. What do you think?
Comment by Roman Kyrylych (Romashka) - Sunday, 31 August 2008, 21:30 GMT
I see "Please update Flyspray. Your current version is 0.9.9.5 and the latest version is 0.9.9.5.1. (remind me later)" for long time already.
Please someone with superpower update it!
Comment by Glenn Matthys (RedShift) - Thursday, 11 December 2008, 07:13 GMT
Status: not implemented.

Loading...