View Issue Details

WikiJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0007029mantisbtdb mssqlpublic2006-05-05 11:552014-05-16 15:00
Reportervboctor Assigned Tovboctor  
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionfixed 
Product Version1.0.1 
Fixed in Version1.0.3 
Summary0007029: Port: 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.*
FROM mantis_user_profile_table up, mantis_bug_table b
WHERE project_id=1
AND up.id = b.profile_id

TagsNo tags attached.

Relationships

Relationship GraphDependency Graph
child of 0006952 closedvboctor MS SQL Error on View Filters Page 
child of 0006971 closedvboctor Mantis 1.0.3 Release 

Activities

grangeway

grangeway

2014-05-16 15:00

reporter   ~0040421

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
Paul