View Issue Details

IDProjectCategoryView StatusLast Update
0006020mantisbtsqlpublic2005-09-11 08:12
Reporteraviru Assigned Tograngeway  
PrioritynormalSeveritycrashReproducibilityalways
Status closedResolutionfixed 
Product Version1.0.0rc1 
Fixed in Version1.0.0rc2 
Summary0006020: Database query failure - click on Docs link - MSSQL
Description

Database: MSSQL Server
Click on Docs menu-link throws the following error.

APPLICATION ERROR 0000401
Database query failed. Error received from database was 0000107: The column prefix 'pft' does not match with a table name or alias name used in the query. for the query: SELECT pft.id, pft.project_id, pft.filename, pft.filesize, pft.title, pft.description, pft.date_added
FROM mantis_project_file_table pft, mantis_user_table ut
LEFT JOIN mantis_project_table pt on pft.project_id = pt.id
LEFT JOIN mantis_project_user_list_table as pult
on pft.project_id = pult.project_id and pult.user_id = 1
WHERE ut.id = 1 AND pft.project_id in (0) AND
( pt.view_state = 10 OR pt.view_state is null OR
( pt.view_state = 50 and pult.user_id = 1 ) OR
( pult.user_id is null and ut.access_level >= 0 ) )
ORDER BY pt.name ASC, pft.title ASC

I copy pasted this sql in SQL Server's query analyzer window and it shows the same error. Tried it with MySQL and it seems to be fine.
So looks like its SQL Server specific.

TagsNo tags attached.

Relationships

has duplicate 0006129 closedthraxisp Accessing Project Documentation 
has duplicate 0006143 closedthraxisp PostgreSQL: relation "pft" does not exist 

Activities

grangeway

grangeway

2005-07-29 14:21

reporter   ~0011018

This is probably going to be an 'order of joins' type issue.

thraxisp

thraxisp

2005-07-30 15:32

reporter   ~0011030

Fixed in CVS.

proj_doc_page.php -> 1.48