View Issue Details

IDProjectCategoryView StatusLast Update
0006952mantisbtdb mssqlpublic2014-05-16 15:00
Reportervboctor Assigned Tovboctor  
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionfixed 
Product Version1.0.1 
Fixed in Version1.1.0a1 
Summary0006952: 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

parent of 0007029 closedvboctor Port: MS SQL Error on View Filters Page 
has duplicate 0006277 closedvboctor MSSQL on page "View Issues" error 

Activities

vboctor

vboctor

2006-04-18 19:22

manager   ~0012617

The problem is in profile_get_all_for_project().

vboctor

vboctor

2006-04-20 10:08

manager   ~0012646

--------------------

# Return an array containing all profiles used in a given project
function profile_get_all_for_project( $p_project_id ) {
    $t_project_where = helper_project_specific_where( $p_project_id );

    $t_bug_table = config_get( 'mantis_bug_table' );
    $t_user_profile_table = config_get( 'mantis_user_profile_table' );

    $query = "SELECT DISTINCT(up.id), up.user_id, up.platform, up.os, up.os_build
              FROM $t_user_profile_table up, $t_bug_table b
              WHERE $t_project_where
              AND up.id = b.profile_id";
    $result = db_query( $query );

    $t_rows = array();
    $t_row_count = db_num_rows( $result );

    for ( $i=0 ; $i < $t_row_count ; $i++ ) {
        array_push( $t_rows, db_fetch_array( $result ) );
    }

    return $t_rows;
}
grangeway

grangeway

2014-05-16 15:00

reporter   ~0040424

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