SQL error in 1.0.0a1 report bug

General discussion of Mantis.

Moderators: Developer, Contributor

Post Reply
npitman
Posts: 1
Joined: 21 Apr 2005, 12:11

SQL error in 1.0.0a1 report bug

Post by npitman »

I have installed Version Mantis 1.0.0a1. I can create users and create projects. Any ideas why I get the following when I try to report a bug?

APPLICATION ERROR #401
Database query failed. Error received from database was #1064: 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 = 2 )
ON l.user_id=u.id
WHERE ( ( u.access_level >= 55 )
OR ( l.access_level >= 55 AND l.user_id=u.id )
OR u.access_level>=90 )
AND u.enabled = 1
AND p.id = 2
thraxisp
Developer
Posts: 509
Joined: 14 Feb 2005, 03:38
Location: Ottawa, Canada
Contact:

Post by thraxisp »

This has been reported and fixed in CVS (#5457). Thanks.
Post Reply