mysql syntax error

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
akucharski
Posts: 2
Joined: Aug 15, 2005 1:04 pm
Contact:

mysql syntax error

Post by akucharski »

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?

akucharski
Posts: 2
Joined: Aug 15, 2005 1:04 pm
Contact:

Post by akucharski »

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?

thraxisp
Developer
Posts: 509
Joined: Feb 13, 2005 10:38 pm
Location: Ottawa, Canada
Contact:

Post by thraxisp »

This was fixed in 1.0.0rc1 (see #5977).
--
Glenn Henshaw Logical Outcome Ltd.
Mantis developer and user w: http://www.logicaloutcome.ca

Post Reply