View Issue Details

IDProjectCategoryView StatusLast Update
0004050mantisbtbugtrackerpublic2004-07-18 11:35
Reportered Assigned ToNarcissus  
PrioritynormalSeverityblockReproducibilityalways
Status closedResolutionduplicate 
Product Version0.19.0a1 
Fixed in Version0.19.0a2 
Summary0004050: View Issues - db error
Description

Go to "View Issues". Type "switch button" in the search box. A DB error is resulted.

Additional Information

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.view_state='10' OR mantis_bug_table.reporter_id='3591') 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 '%switch button%')
OR (mantis_bug_text_table.description LIKE '%switch button%')
OR (mantis_bug_text_table.steps_to_reproduce LIKE '%switch button%')
OR (mantis_bug_text_table.additional_information LIKE '%switch button%')
OR (mantis_bug_table.id LIKE '%switch button%')
OR (mantis_bugnote_text_table.note LIKE '%switch button%')) AND (mantis_bug_text_table.id = mantis_bug_table.bug_text_id)

Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.

TagsNo tags attached.

Relationships

duplicate of 0004027 closedNarcissus Database query error in 0.19 alpha1 

Activities

There are no notes attached to this issue.