Mantis Bug Tracker - Forums

Posted: **15 Aug 2005, 18:08**

I completed the install of Mantis 1.0.0a3 step by step according to the directions. I ran the check.php script and all was fine.

I am getting what I think is a bizare mysql syntax error on user login:

APPLICATION ERROR #401

Database query failed. Error received from database was #1064: 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

I am running PHP 4.x and Mysql 3.28.58. Has anyone else run across this?

Posted: **15 Aug 2005, 22:15**

I just performed an install on an older machine and the problem is gone. I would like to get the original to work. I wonder where the problem is. Has anyone run into this?

Posted: **16 Aug 2005, 14:12**

This was fixed in 1.0.0rc1 (see #5977).