View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006952 | mantisbt | db mssql | public | 2006-04-18 19:13 | 2014-05-16 15:00 |
| Reporter | vboctor | Assigned To | vboctor | ||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | 1.0.1 | ||||
| Fixed in Version | 1.1.0a1 | ||||
| Summary | 0006952: MS SQL Error on View Filters Page | ||||
| Description | http://www.example.com/mantis/view_filters_page.php?for_screen=1&target_field=handler_id[] Database query failed. Error received from database was 0008163: The text, ntext, or image data type cannot be selected as DISTINCT. for the query: SELECT DISTINCT(up.id), up.* | ||||
| Tags | No tags attached. | ||||
|
The problem is in profile_get_all_for_project(). |
|
-------------------- |
|
|
MantisBT currently supports Mysql and has support for other database engines. The support for other databases is known to be problematic. Having implemented the current database layer into Mantis 10 years ago, I'm currently working on replacing the current layer. If you are interested in using Mantis with non-mysql databases - for example, Oracle, PGSQL or MSSQL, and would be willing to help out testing the new database layer, please drop me an email at paul@mantisforge.org In the meantime, I'd advise running Mantis with Mysql Only to avoid issues. Thanks |
|