View Issue Details

IDProjectCategoryView StatusLast Update
0005434mantisbtsqlpublic2005-04-18 10:33
Reportercsaba Assigned Tovboctor  
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionfixed 
Product Version0.19.2 
Fixed in Version1.0.0a1 
Summary0005434: More SELECT DISTINCT (in filter_api.php)
Description

There is a line in filter_api.php that reads:
$query = "SELECT DISTINCT $t_bug_table.id

About 10 lines below, the results are accessed below with
$t_id_array[] = db_prepare_int ( $row['id'] );

However, some databases (e.g. SQLite), when selecting in this fashion, will include the table name as part of the key (that is, 'mantis_bug_table.id'). Therefore, I suggest, as a simple fix, to replace the $query line with:
$query = "SELECT DISTINCT $t_bug_table.id AS id

Csaba Gabor from Vienna

TagsNo tags attached.

Relationships

child of 0004937 closedvboctor Mantis 1.0.0a1 Release 

Activities

There are no notes attached to this issue.