View Issue Details

IDProjectCategoryView StatusLast Update
0005780mantisbtadministrationpublic2005-07-23 02:25
Reporterericmichael Assigned Tothraxisp  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionduplicate 
Product Version1.0.0a3 
Summary0005780: Update failure. 0.19.2 -> 1.0.0a3
Description

After update and running the update from <root>/admin/update.php I still get the following:

APPLICATION ERROR 0000401

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

Additional Information

I have read some where that this was fixed. My mysql server is version 3.23.52.

TagsNo tags attached.

Relationships

duplicate of 0005689 closedthraxisp After upgrading to 1.0.0a3 Mantis not working correct 

Activities

There are no notes attached to this issue.