View Issue Details

IDProjectCategoryView StatusLast Update
0004032mantisbtfilterspublic2004-07-18 11:35
Reporterthecrow Assigned ToNarcissus  
PrioritynormalSeveritycrashReproducibilityalways
Status closedResolutionduplicate 
Product Version0.19.0a1 
Fixed in Version0.19.0a2 
Summary0004032: Search in View_Issues
Description

I search here in this mantis i.e. gpc_api and i get the following errormessage:

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 für die Abfrage: 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.view_state='10' OR mantis_bug_table.reporter_id='4038') 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 '%gpc_api.php%')
OR (mantis_bug_text_table.description LIKE '%gpc_api.php%')
OR (mantis_bug_text_table.steps_to_reproduce LIKE '%gpc_api.php%')
OR (mantis_bug_text_table.additional_information LIKE '%gpc_api.php%')
OR (mantis_bug_table.id LIKE '%gpc_api.php%')
OR (mantis_bugnote_text_table.note LIKE '%gpc_api.php%')) AND (mantis_bug_text_table.id = mantis_bug_table.bug_text_id)

TagsNo tags attached.

Relationships

duplicate of 0004027 closedNarcissus Database query error in 0.19 alpha1 
has duplicate 0004067 closedNarcissus Adding a search to the filter causes sql-error 
has duplicate 0004069 closedvboctor view all bugs page gets APPLICATION ERROR 0000401 

Activities

thecrow

thecrow

2004-07-08 06:51

reporter   ~0005920

The link is not a link to the error 1064, it´s the errormessagecode :)