A BUGNOTE has been added to this bug.
=======================================================================
http://131.152.105.154/mantis/view_bug_page.php?f_id=0000072
=======================================================================
Reporter: mattzz
Handler:
=======================================================================
Project: OPIE Bug tracking
Bug ID: 0000072
Category: bugtracker
Reproducibility: always
Severity: major
Priority: normal
Status: new
=======================================================================
Date Submitted: 06-25-02 23:31 CEST
Last Modified: 06-29-02 17:36 CEST
=======================================================================
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!
Received on Sat Jun 29 15:36:55 2002
This archive was generated by hypermail 2.1.8 : Tue May 04 2004 - 09:46:21 EDT