[Mantis Bugs 0000072]: search in bug reports does not work

The following issue has been RESOLVED.
======================================================================
http://opie-bugs.oszine.de/view.php?id=72
======================================================================
Reported By: mattzz
Assigned To: tille_admin
======================================================================
Project: Mantis Bugs
Issue ID: 72
Category: bugtracker
Reproducibility: always
Severity: major
Priority: normal
Status: resolved
Resolution: fixed
Fixed in Version:
======================================================================
Date Submitted: 06-25-2002 23:31 CEST
Last Modified: 07-29-2007 07:54 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
----------------------------------------------------------------------
still a problem?

----------------------------------------------------------------------
 mattzz - 06-29-02 17:36
----------------------------------------------------------------------
yup!

----------------------------------------------------------------------
 docwhat - 10-28-02 17:37
----------------------------------------------------------------------
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).

----------------------------------------------------------------------
 mattzz - 11-03-02 16:52
----------------------------------------------------------------------
<flame war mode>
Why don't you get back to bugzilla, anyway? :-/
</flame>

Mantis looks nice, but as docwhat said - if you can't search....

Anyway, I don't have the feeling, that somebody really cares about this
bug. I mean, come on, this bug was entered in 06-2002.

edited on: 2002-11-03 16:52

----------------------------------------------------------------------
 BlueLightning - 12-28-06 01:03
----------------------------------------------------------------------
This seems to work just fine now. I'll wait for responses and close if
nobody objects.

----------------------------------------------------------------------
 BlueLightning - 07-29-07 07:54
----------------------------------------------------------------------
No responses in some time, resolving.

Issue History
Date Modified Username Field Change
======================================================================
12-28-06 01:03 BlueLightning Note Added: 0004417
07-29-07 07:54 BlueLightning Status assigned => resolved
07-29-07 07:54 BlueLightning Resolution open => fixed
07-29-07 07:54 BlueLightning Note Added: 0004685
======================================================================
Received on Sun Jul 29 2007 - 01:54:33 EDT