View Issue Details

WikiJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0005738mantisbtsqlpublic2005-06-08 09:422005-07-23 02:28
Reporternlaine Assigned Tothraxisp  
PrioritynormalSeverityblockReproducibilityalways
Status closedResolutionduplicate 
Product Version1.0.0a3 
Summary0005738: SQL error on <my view> and <view issues>
Description

I proceeded an update from 1.0.0a2 to 1.0.0a3 and got stuck with this error, impossible to go anyfurther. The problem lays within the SQL syntax, some INNER are missing. Below the exact error message, and attached the file in error with the fix. Now it all works fine.

Additional Information

APPLICATION ERROR 0000401

Database query failed. Error received from database was 0001064: You have an error in your SQL syntax near 'on cft.id = cfpt.field_id
JOIN mantis_project_table as pt on' at line 3 for the query: SELECT distinct cft.id as id, cft.name as name
FROM mantis_custom_field_table as cft
JOIN mantis_custom_field_project_table as cfpt on cft.id = cfpt.field_id
JOIN mantis_project_table as pt on cfpt.project_id = pt.id
LEFT JOIN mantis_project_user_list_table as pult
on cfpt.project_id = pult.project_id and pult.user_id = 2
JOIN mantis_user_table as ut on ut.id = 2
WHERE pt.view_state = 10 OR
( pt.view_state = 50 and pult.user_id = 2 ) OR
( pult.user_id is null and ut.access_level >= 90 )
ORDER BY name ASC

TagsNo tags attached.

Relationships

Relationship GraphDependency Graph
duplicate of 0005689 closedthraxisp After upgrading to 1.0.0a3 Mantis not working correct 

Activities

nlaine

nlaine

2005-06-08 09:45

reporter   ~0010412

sorry for this duplicate, first submission refused the attachment. This entry can be deleted