View Issue Details

IDProjectCategoryView StatusLast Update
0005462mantisbtbugtrackerpublic2005-04-25 07:48
Reportersne Assigned Tothraxisp  
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionduplicate 
Product Version1.0.0a1 
Summary0005462: SQL error when displaying a project
Description

When I want to manage a project (click on it) I get the following error in the 'manage account' tab:

Database query failed. Error received from database was 0001064: You have an error in your SQL syntax near '( mantis_project_table p LEFT JOIN mantis_project_user_list_table l ON p.id=l.pr' at line 3 for the query: SELECT DISTINCT u.id, u.username, u.realname, u.access_level as access_level, l.access_level as override
FROM mantis_user_table u LEFT JOIN
( mantis_project_table p LEFT JOIN mantis_project_user_list_table l ON p.id=l.project_id AND p.id = 1 )
ON l.user_id=u.id
WHERE ( ( u.access_level >= 0 )
OR ( l.access_level >= 0 AND l.user_id=u.id )
OR u.access_level>=90 )
AND u.enabled = 1
AND p.id = 1

TagsNo tags attached.

Relationships

duplicate of 0005457 closedthraxisp At least MySQL 4.1.x for this version 

Activities

There are no notes attached to this issue.