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 |
Reporter | mchendl | Assigned To | cproensa | ||
Priority | normal | Severity | major | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Product Version | 2.1.0 | ||||
Target Version | 2.7.0 | Fixed in Version | 2.7.0 | ||
Summary | 0023241: Error when changing sort order in filters, due date field only | ||||
Description | 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 | ||||
Additional Information | 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. [1] https://github.com/mantisbt/mantisbt |
|
See: |
|
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) |
|
@atrol 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 2017-08-23 16:22 Committer: dregad Details Diff |
Fix sorting of due date for undefined values Previously fixed in 0016259, the order clause still has error with some databases. Rewrite the sort expression in a protable syntax. Fixes: 0023241 |
Affected Issues 0023241 |
|
mod - core/filter_api.php | Diff File |