A BUGNOTE has been added to this bug.
=======================================================================
http://131.152.105.154/mantis/view_bug_page.php?f_id=0000072
=======================================================================
Reporter: mattzz
Handler: tille_admin
=======================================================================
Project: OPIE Bug tracking
Bug ID: 0000072
Category: bugtracker
Reproducibility: always
Severity: major
Priority: normal
Status: assigned
=======================================================================
Date Submitted: 06-25-02 23:31 CEST
Last Modified: 10-28-02 17:37 CET
=======================================================================
Summary: search in bug reports does not work
Description:
ERROR: FAILED QUERY: SELECT COUNT( DISTINCT ( mantis_bug_table.id ) ) as
count FROM mantis_bug_table, mantis_bug_text_table LEFT JOIN
mantis_bugnote_table ON mantis_bugnote_table.bug_id = mantis_bug_table.id
LEFT JOIN mantis_bugnote_text_table ON mantis_bugnote_text_table.id =
mantis_bugnote_table.bugnote_text_id WHERE project_id='0000002' AND
(view_state='10' OR (view_state='50' AND reporter_id='0000061')) AND
status<>'90' AND category='Taskbar/Launcher/Plugins' AND ((summary LIKE
'%security%') OR (description LIKE '%security%') OR (steps_to_reproduce
LIKE '%security%') OR (additional_information LIKE '%security%') OR
(mantis_bug_table.id LIKE '%security%') OR (mantis_bugnote_text_table.note
LIKE '%security%')) AND mantis_bug_text_table.id =
mantis_bug_table.bug_text_id :
1052: Column: 'view_state' in where clause is ambiguous
=======================================================================
-----------------------------------------------------------------------
tille_admin - 06-29-02 17:32 CEST
-----------------------------------------------------------------------
still a problem?
-----------------------------------------------------------------------
mattzz - 06-29-02 17:36 CEST
-----------------------------------------------------------------------
yup!
-----------------------------------------------------------------------
docwhat - 10-28-02 17:37 CET
-----------------------------------------------------------------------
This is still a problem. Can someone please fix this? Without searching,
the bug database is pretty much useless.
Example: Try looking up addressbook bugs by clicking "ViewBugs" then type
in "addressbook" into the search field and press "Filter".
This is rather a big deal. I can help with the SQL if no-one else knows
how to resolve the SQL problem from above. (It needs a table name for the
view_state column, because it apparently is in multiple tables. The join
should probably be checked, too).
Received on Mon Oct 28 17:16:03 2002
This archive was generated by hypermail 2.1.8 : Tue May 04 2004 - 09:46:26 EDT