View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0023241||mantisbt||filters||public||2017-08-18 07:25||2017-10-08 23:52|
|Target Version||2.7.0||Fixed in Version||2.7.0|
|Summary||0023241: Error when changing sort order in filters, due date field only|
application error 0000401 when changing sort_order for due date in "view issues" table header or filter settings
|Steps To Reproduce|
1) enable "due date" field
special Situation: Windows Server with IIS and MSSQL (ODBC Driver 13).
|Tags||No tags attached.|
Seems to be a IIS and/or MSSQL issue.
@atrol: any idea to improve the mssql support? It's not my first issue (e.g. no attachment upload into database). As I understand (I'm not a coder) the mssql support is generally weak. It's a technical requirement to use mssql in my current company. The tool is great and fits our requirements perfectly, but no chance for mysql. We are ready to pay for it.
Might be fixed in latest version, see 0022208
As a first step I recommend to upgrade to latest stable version (2.5.1. at the moment), as there are some bug fixes in it, some of them also related to MSSQL, e.g. 0022904.
I did not have a deeper look at your current issue, maybe it's also fixed after the upgrade.
I myself do you not use MSSQL for MantisBT and will not be able to invest any time in MSSQL support.
You could search for a developer at one of the freelancer developer portals.
All contributions are welcome and greatly appreciated.
Introduced when fixing 0016259
Make a copy of file core/filter_api.php and try if removing the following lines (should start in line 1090 if you are using version 2.1.0) from the file fixes your issue.
OK, i wasn't thinking enough.
maybe this is safer, and portable:
to replace the "1" with a suitable integer (reasonable max or min)
Please, review especially the part about what is the expected result, to work on a fix.
This is the change i made:
It's on a branch i'm working with more changes to filter_api. If you consider the fix is urgent it can be submitted as separate PR. Otherwise it will be bundled with other future filter changes
Thanks for the quick bugfix. I used the code snippet from @cproensa in my 2.1.0 release code. A separate release would be fine for our upcoming release update, but our IT ops team hasn't named a specific date for that.
note that the final fix has been implemented slightly different. What you used works ok, but the original approach (with corrected syntax) has been finally used.
MantisBT: master da11963b
Committer: dregad Details Diff
|Fix sorting of due date for undefined values
Previously fixed in 0016259, the order clause still has error with some
Rewrite the sort expression in a protable syntax.
|mod - core/filter_api.php||Diff File|
|2017-08-18 07:25||mchendl||New Issue|
|2017-08-18 07:52||atrol||Note Added: 0057498|
|2017-08-23 11:38||mchendl||Note Added: 0057537|
|2017-08-23 12:09||atrol||Note Added: 0057538|
|2017-08-23 12:09||atrol||Note Edited: 0057538||View Revisions|
|2017-08-23 16:27||cproensa||Note Added: 0057539|
|2017-08-23 16:28||cproensa||Note Edited: 0057539||View Revisions|
|2017-08-23 16:54||atrol||Relationship added||related to 0016259|
|2017-08-23 16:58||atrol||Note Added: 0057540|
|2017-08-23 17:02||atrol||Note Added: 0057541|
|2017-08-23 17:50||cproensa||Note Added: 0057542|
|2017-08-23 18:20||cproensa||Note Added: 0057543|
|2017-08-24 03:34||dregad||Relationship added||related to 0023260|
|2017-08-24 20:36||cproensa||Note Added: 0057547|
|2017-08-25 03:07||mchendl||Note Added: 0057548|
|2017-08-26 13:13||cproensa||Status||new => assigned|
|2017-08-26 13:13||cproensa||Assigned To||=> cproensa|
|2017-10-07 12:45||dregad||Changeset attached||=> MantisBT master da11963b|
|2017-10-07 12:45||cproensa||Status||assigned => resolved|
|2017-10-07 12:45||cproensa||Resolution||open => fixed|
|2017-10-07 12:45||cproensa||Fixed in Version||=> 2.7.0|
|2017-10-07 13:32||atrol||Target Version||=> 2.7.0|
|2017-10-08 11:29||cproensa||Summary||error when changing sort order in filters, due date field only => Error when changing sort order in filters, due date field only|
|2017-10-08 11:31||cproensa||Note Added: 0057909|
|2017-10-08 23:52||vboctor||Status||resolved => closed|