View Issue Details

IDProjectCategoryView StatusLast Update
0002018mantisbtbugtrackerpublic2003-12-13 05:03
ReporterreporterAssigned Toaarjona  
PrioritynormalSeveritycrashReproducibilityalways
Status closedResolutionduplicate 
Platformx86OSWindowsOS Version98
Product Version0.17.3 
Summary0002018: ERROR Screen when filtering 'Reporter' and 'Search'.
Description

When filtering the database by choosing a reporter (in the first pull down menu) AND having something in the "search" field (anything will do), the following error pops up:

"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 reporter_id='0000032' AND status<>'90' AND ((summary LIKE '%testsearch%') OR (description LIKE '%testsearch%') OR (steps_to_reproduce LIKE '%testsearch%') OR (additional_information LIKE '%testsearch%') OR (mantis_bug_table.id LIKE '%testsearch%') OR (mantis_bugnote_text_table.note LIKE '%testsearch%')) AND mantis_bug_text_table.id = mantis_bug_table.bug_text_id :
1052: Column: 'reporter_id' in where clause is ambiguousERROR: 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 reporter_id='0000032' AND status<>'90' AND ((summary LIKE '%testsearch%') OR (description LIKE '%testsearch%') OR (steps_to_reproduce LIKE '%testsearch%') OR (additional_information LIKE '%testsearch%') OR (mantis_bug_table.id LIKE '%testsearch%') OR (mantis_bugnote_text_table.note LIKE '%testsearch%')) AND mantis_bug_text_table.id = mantis_bug_table.bug_text_id :
1052: Column: 'reporter_id' in where clause is ambiguous"

Steps To Reproduce
  1. Go to "view_all_bug_page.php"
  2. Select a reporter from the filter options.
  3. Type anything into the search box.
  4. Click on "Apply Filter"
  5. You should now see the error message.
Additional Information

This can be duplicated on the mantisbt bugtracker here as well as my system.

TagsNo tags attached.

Relationships

duplicate of 0002006 closedaarjona when searching and you type in a username you get a sql query error 

Activities

aarjona

aarjona

2002-05-22 11:18

reporter   ~0002641

This bug is a duplicate of bug 0002006