Mantis Bug Tracker - Forums

Posted: **02 Jul 2005, 13:42**

What to do?

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 = 1
JOIN mantis_user_table as ut on ut.id = 1
WHERE pt.view_state = 10 OR 
( pt.view_state = 50 and pult.user_id = 1 ) OR 
( pult.user_id is null and ut.access_level >= 90 )
ORDER BY name ASC

Posted: **02 Jul 2005, 21:15**

I just installed Mantis1.0.0a3, and I have this same problem. Whenever I visit the manage_proj_edit_page.php, I get it. I tried it at work on a Fedora Core 3 machine, and I tried it at home on a RedHat 8.0 machine. Same thing. Oh the RH8 machine, here are the versions of the usual suspects:

$ php
X-Powered-By: PHP/4.2.2
Content-type: text/html
$ mysql --version
mysql Ver 11.18 Distrib 3.23.52, for pc-linux-gnu (i686)
$ httpd -version
Server version: Apache/2.0.40
Server built: Sep 4 2002 17:20:34

This seems to be an out-of-the-box error. Perhaps those JOINs require a more recent version of mysql? But the Mantis "requirements" page says version 3.23 is sufficient.

I'd be grateful for any help. Thanks,

Paul Jungwirth

Posted: **02 Jul 2005, 21:25**

Ah, we should join the conversation here:

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