I downloaded and installed Mantis 1.00a3. Copied my config_inc.php file to the new directory, and hit the /admin page in my browser. I executed "Check your installation" and all was fine. I was upgrading from 1.00a2.

Next I clicked "Upgrade your installation" and had it execute all. Then I clicked "System Utilities" (I don't know what's there), and got:

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

The main page displays a similar error. I can't tell if there's a simple syntax error, or a problem with the database upgrade. I've done the upgrade twice, both with the same results. It seems to be related to a custom field definition.

You can see it at http://bugs.dadaimc.org/ after clicking "View Issues"

PS: (I'm a bit curious about how "g_port" is obsolete, and we're to use "ghostname" instead...one contains the hostname, the other a port number. I'm using localhost and the standard port 3306, but are we expected to use localhost:3306 or something? That isn't clear.