View Issue Details

IDProjectCategoryView StatusLast Update
0006119mantisbtsqlpublic2005-09-11 08:12
Reporterilles Assigned Toryandesign  
PrioritynormalSeveritycrashReproducibilityalways
Status closedResolutionduplicate 
Product Version1.0.0rc1 
Summary0006119: Database query failure - click on Docs link - MSSQL
Description

Database query failed. Error received from database was 0001064: You have an error in your SQL syntax near 'ON ut.id = 2
WHERE pft.project_id in (10,8,11,13,4,18,16,3,9,0) AND
( ' at line 6 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
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 = 2
JOIN mantis_user_table ut ON ut.id = 2
WHERE pft.project_id in (10,8,11,13,4,18,16,3,9,0) AND
( pt.view_state = 10 OR pt.view_state is null OR
( pt.view_state = 50 and pult.user_id = 2 ) OR
( pult.user_id is null and ut.access_level >= 0 ) )
ORDER BY pt.name ASC, pft.title ASC

Additional Information

Duplicate of 0006020

Debian Woody
PHP Version 4.1.2
Apache/1.3.26
MySQL 3.23.49

TagsNo tags attached.

Relationships

duplicate of 0006118 closedthraxisp Database query failure - click on Docs link - MySQL 3.23 

Activities

illes

illes

2005-08-11 05:51

reporter   ~0011162

Sorry, DELETE this issue