[OPIE Bug tracking 0000186]: search in Opie Mantis fails

Der folgende Fehler wurde zugewiesen.
=======================================================================
http://131.152.105.154/mantis/view_bug_page.php?f_id=0000186
=======================================================================
Reporter: commandln
Bearbeiter: tille_admin
=======================================================================
Projekt: OPIE Bug tracking
Fehler ID: 0000186
Kategorie: bugtracker
Reproduzierbarkeit: immer
Auswirkung: schwerer Fehler
Priorität: normal
Status: zugewiesen
=======================================================================
erstellt am: 09-05-02 16:06 CEST
letzte Aktualisierung: 10-17-02 12:55 CEST
=======================================================================
Zusammenfassung: search in Opie Mantis fails
Beschreibung:
Type in a search term, hit apply filter, get an error.
=======================================================================

-----------------------------------------------------------------------
 sandman - 09-05-02 18:44 CEST
-----------------------------------------------------------------------
Works here (logged in as developer on WinNT using IE 6)

-----------------------------------------------------------------------
 commandln - 09-05-02 18:47 CEST
-----------------------------------------------------------------------
Using Linux, Mozilla 1.0--but error message would seem to indicate this is
not a browser issue but a server side issue, specifically an SQL or DB
issue. The column view_state needs a table prefix in the where clause,
specifically. The browser or OS has nothing to do with this.

-----------------------------------------------------------------------
 commandln - 09-05-02 18:49 CEST
-----------------------------------------------------------------------
Also, the error *ONLY* occurs when you put something in the *SEARCH* field.
 If I just use the drop downs (which aren't quite as useful), then the
error does not occur. I believe I stated in my original report "Type in a
search term".

-----------------------------------------------------------------------
 sandman - 09-05-02 22:55 CEST
-----------------------------------------------------------------------
Exactly what I did .. typed in "suspend", hit "ApplyFilter" and it works

-----------------------------------------------------------------------
 ccady - 09-20-02 19:23 CEST
-----------------------------------------------------------------------
I, too, get this error. Perhaps it has to do with being a "reporter"
only?

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='0000191')) AND
status<>'90' AND ((summary LIKE '%VNC%') OR (description LIKE '%VNC%') OR
(steps_to_reproduce LIKE '%VNC%') OR (additional_information LIKE '%VNC%')
OR (mantis_bug_table.id LIKE '%VNC%') OR (mantis_bugnote_text_table.note
LIKE '%VNC%')) AND mantis_bug_text_table.id = mantis_bug_table.bug_text_id
:

1052: Column: 'view_state' in where clause is ambiguous

-----------------------------------------------------------------------
 nchip - 10-08-02 15:22 CEST
-----------------------------------------------------------------------
according to:

http://mantisbt.sourceforge.net/

This has been fixed 0.17.4a, with .17.5 beeing the
latest (including security fixes)
Received on Thu Oct 17 11:47:36 2002