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