Mantis Bug Tracker - Forums

Posted: **22 Apr 2005, 12:50**

I am running the newest Mantis version on a Win 2000 Box with Apache/1.3.33 (Win32) PHP/4.3.10 . MySQL Server is an 3.23.x .
I had to run the SQL Script on my local MySQL 4.x and made a dump with compatibility to 3.23. This Script could be processed on the 3.23 MySQL Server w/out any Errors.
The following Error occurs at least on
view_filters_page.php?for_screen=1&target_field=handler_id[]
and on
manage_proj_edit_page.php?project_id=1
Everything is well though on MySQL 4

This message appears somewhere in the respectively listed page:

Code: Select all

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 = 1 )
ON l.user_id=u.id
WHERE ( ( u.access_level >= 25 )
OR ( l.access_level >= 25 AND l.user_id=u.id )
OR u.access_level>=90 )
AND u.enabled = 1
AND p.id = 1

edit: was a fresh installation

Posted: **22 Apr 2005, 13:01**

Look at the following post could be the same problem:

http://forums.mantisbt.org/viewtopic.php?t=256

-Hinke

Posted: **22 Apr 2005, 14:44**

This is fixed in CVS, and tracked under #5457.

Posted: **26 Apr 2005, 12:37**

Thank you very much,
Mantis is running fine now, but I will have to do some Modifications as we have several hundreds of Projects, just too much for your little Dropdown-Menu :)
Then I need something to group the Projects to make it some more easy to navigate, because some guys here don't like scrolling that much :)

David