View Issue Details

IDProjectCategoryView StatusLast Update
0004027mantisbtfilterspublic2004-07-18 11:35
Reportergrangeway Assigned ToNarcissus  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
Fixed in Version0.19.0a2 
Summary0004027: Database query error in 0.19 alpha1
Description

APPLICATION ERROR 0000401
Database query failed. Error received from database was 0001064: You have an error in your SQL syntax near '(mantis_bug_table LEFT JOIN mantis_bugnote_table ON mantis_bugnote_table.bug_id ' at line 1 for the query: SELECT COUNT( DISTINCT mantis_bug_table.id ) as count FROM mantis_bug_text_table, mantis_project_table ,(mantis_bug_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 mantis_project_table.enabled = 1 AND mantis_project_table.id = mantis_bug_table.project_id AND (mantis_bug_table.project_id='1') AND ((mantis_bug_table.status='10') OR (mantis_bug_table.status='20') OR (mantis_bug_table.status='30') OR (mantis_bug_table.status='40') OR (mantis_bug_table.status='50') OR (mantis_bug_table.status='80')) AND ((summary LIKE '%paul%')
OR (mantis_bug_text_table.description LIKE '%paul%')
OR (mantis_bug_text_table.steps_to_reproduce LIKE '%paul%')
OR (mantis_bug_text_table.additional_information LIKE '%paul%')
OR (mantis_bug_table.id LIKE '%paul%')
OR (mantis_bugnote_text_table.note LIKE '%paul%')) AND (mantis_bug_text_table.id = mantis_bug_table.bug_text_id)

TagsNo tags attached.

Relationships

has duplicate 0004032 closedNarcissus Search in View_Issues 
has duplicate 0004045 closedNarcissus issue search using substring 'ldap' fails on bugs.mantisbt.org 
has duplicate 0004050 closedNarcissus View Issues - db error 
has duplicate 0004051 closedNarcissus Entering search text crashes application 

Activities

grangeway

grangeway

2004-07-08 05:16

reporter   ~0005916

(occurs when trying to search)

Narcissus

Narcissus

2004-07-08 18:05

reporter   ~0005938

The fix for this issue is in filter_api.php. The only problem at the moment is that we lose searching in bugnotes, but we will work on that later.

Related Changesets

MantisBT: master 9b9b924a

2004-07-08 19:05

narcissus


Details Diff
Fix 0004027: Database query error on text search

git-svn-id: http://mantisbt.svn.sourceforge.net/svnroot/mantisbt/trunk@2670 <a class="text" href="/?p=mantisbt.git;a=object;h=f5dc347c">f5dc347c</a>-c33d-0410-90a0-b07cc1902cb9
Affected Issues
0004027
mod - core/filter_api.php Diff File
mod - doc/ChangeLog Diff File