View Issue Details

IDProjectCategoryView StatusLast Update
0004156mantisbtfilterspublic2004-08-29 01:47
Reportergrangeway Assigned Tograngeway  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
Product Version0.19.0a2 
Fixed in Version0.19.0rc1 
Summary0004156: Sql error
Description

Since adding the 'monitored by' stuff to my view, mssql driver generates a query error on :

SELECT COUNT( DISTINCT mantis_bug_table.id ) as count FROM mantis_bug_table, mantis_project_table LEFT JOIN mantis_bug_monitor_table as user_monitor ON user_monitor.bug_id = mantis_bug_table.id WHERE mantis_project_table.enabled = 1 AND mantis_project_table.id = mantis_bug_table.project_id AND (mantis_bug_table.project_id='1') AND (mantis_bug_table.handler_id=0) AND ((mantis_bug_table.status='10') OR (mantis_bug_table.status='20') OR (mantis_bug_table.status='30') OR (mantis_bug_table.status='40') OR (mantis_bug_table.status='50') OR (mantis_bug_table.status='80')) AND ((user_monitor.user_id='3'))

of:
Server: Msg 107, Level 16, State 3, Line 1
The column prefix 'mantis_bug_table' does not match with a table name or alias name used in the query.

Can we/ don't we need to be doing:

FROM mantis_project_table, mantis_bug_table LEFT JOIN mantis_bug_monitor_table

instead ?

TagsNo tags attached.

Relationships

child of 0003987 closedvboctor Mantis 0.19.0 Release 

Activities

grangeway

grangeway

2004-08-01 18:44

reporter   ~0006543

Victor, although i need this fixing (it breaks mssql), we don't need to fix this before rc1

jlatour

jlatour

2004-08-06 11:23

reporter   ~0006712

Is there any reason we shouldn't change this?