View Issue Details

IDProjectCategoryView StatusLast Update
0005929mantisbtinstallationpublic2005-07-23 02:16
Reporternuttzy Assigned Tothraxisp  
PrioritynormalSeveritycrashReproducibilityalways
Status closedResolutionduplicate 
Product Version1.0.0a3 
Summary0005929: SQL error prevents login
Description

Just downloaded and installed 1.0.0a3 (fresh DB). Trying to login for the first time. I get the following MySQL error:

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 = 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

Additional Information

PHP 4.3.0
MySQL 3.23.55

Replacing all the plain JOIN's to INNER JOIN eliminates the problem but I'm not sure if that's the desired SQL.

TagsNo tags attached.

Relationships

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

Activities

nuttzy

nuttzy

2005-07-12 22:22

reporter   ~0010745

Actual page is my_view_page.php