View Issue Details

IDProjectCategoryView StatusLast Update
0021592mantisbtfilterspublic2017-01-31 04:02
Reportervboctor Assigned Tocproensa  
PrioritynormalSeverityminorReproducibilitysometimes
Status closedResolutionfixed 
Product Version1.3.0 
Target Version2.1.0Fixed in Version2.1.0 
Summary0021592: Unknown column 'mantis_bug_table.tags'
Description

A couple of users reported this issue

Message : "APPLICATION ERROR 0000401
Database query failed. Error received from database was #1054: Unknown column 'mantis_bug_table.tags' in 'order clause' for the query: SELECT DISTINCT mantis_bug_table.* FROM mantis_bug_table JOIN mantis_project_table ON mantis_project_table.id = mantis_bug_table.project_id WHERE mantis_project_table.enabled = ? AND ( mantis_bug_table.project_id = 2 ) AND ( ( mantis_bug_table.handler_id=2 ) AND ( mantis_bug_table.status in (?, ?, ?, ?, ?, ?) ) ) ORDER BY mantis_bug_table.sticky DESC, mantis_bug_table.tags DESC, mantis_bug_table.priority DESC, mantis_bug_table.last_updated DESC, mantis_bug_table.date_submitted DESC.
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."

Steps To Reproduce
  • In My Account / Manage Columns, add 'tags' to View Issues Columns
  • Open View Issues page
  • Click on 'Sort by', Select 'tags', apply filter
Tagsmantishub

Relationships

related to 0021595 new When a filter generates a bad query, reset the filter 
child of 0021935 closedcproensa Filter api refactoring, manage stored filters 

Activities

dregad

dregad

2016-08-09 04:25

developer   ~0053763

Looks like a query generated by filter api

dregad

dregad

2016-08-09 04:31

developer   ~0053764

Added repro steps. Also changed the product and target version, as this bug also exists in 1.3.

Since it's not possible to sort by tags by clicking on the column header. I don't think the field should be available in the selection list either.

cproensa

cproensa

2016-08-09 06:57

developer   ~0053765

i have a lot of clean up for filter api, which includes many bug fixes in PR https://github.com/mantisbt/mantisbt/pull/783

this could be included, but need to refresh again that branch and agree on what to implement

dregad

dregad

2016-08-09 09:25

developer   ~0053771

I'll have a look at your PR.

cproensa

cproensa

2016-10-17 07:20

developer   ~0054246

This also happens for other columns:
example: notes, overdue

plugin columns, which are not sortable, are selectable, however it doesn't fail.
(sortable plugin columns work ok)

cproensa

cproensa

2016-10-17 16:49

developer   ~0054253

I've included the fix in PR https://github.com/mantisbt/mantisbt/pull/862