I have the same problem. Just installed Mantis on a Debian/PHP5.05DEV/MySQL 3.23.58 system.
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 ...