FS#11844 - Can't search for text in comments -> Unknown column 'c.comment_text' in 'where clause'
Attached to Project:
Arch Linux
Opened by Michael Schmarck (mschmarck) - Wednesday, 22 October 2008, 13:01 GMT
Last edited by Jan de Groot (JGC) - Wednesday, 22 October 2008, 13:44 GMT
Opened by Michael Schmarck (mschmarck) - Wednesday, 22 October 2008, 13:01 GMT
Last edited by Jan de Groot (JGC) - Wednesday, 22 October 2008, 13:44 GMT
|
Details
I tried to search for "libespeak.so.1:" and also wanted to
search in "Comments". So I clicked on the "Advanced" button
to the right of the text field "Search this project for".
Under miscellaneous, I enabled the checkbox in front of
"Search in comments". I then hit "return" when the cursor
was in the text box. This brought me to this URL:
http://bugs.archlinux.org/index.php?string=libespeak.so.1%3A&project=1&search_name=&search_in_comments=1&type[]=&sev[]=&pri[]=&due[]=&reported[]=&cat[]=&status[]=open&percent[]=&opened=&dev=&closed=&duedatefrom=&duedateto=&changedfrom=&changedto=&openedfrom=&openedto=&closedfrom=&closedto=&do=index But instead of a result, an error message was shown: 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,%libespeak.so.1:%,%libespeak.so.1:%,%libespeak.so.1:%} Failed! (Unknown column 'c.comment_text' in 'where clause') |
This task depends upon
Closed by Jan de Groot (JGC)
Wednesday, 22 October 2008, 13:44 GMT
Reason for closing: Duplicate
Additional comments about closing: bug 9892 .
Wednesday, 22 October 2008, 13:44 GMT
Reason for closing: Duplicate
Additional comments about closing: