View Issue Details

IDProjectCategoryView StatusLast Update
0005689mantisbtupgradepublic2005-07-23 02:32
ReporterTomR Assigned Tothraxisp  
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionfixed 
Product Version1.0.0a3 
Fixed in Version1.0.0rc1 
Summary0005689: After upgrading to 1.0.0a3 Mantis not working correct
Description

I suspect problems with custom field becuase everywhere ( view issues, maint projec, maint custom fields ) I get a 401 Database query failed error.

TagsNo tags attached.

Relationships

has duplicate 0005691 closedthraxisp Failed to login after installation 
has duplicate 0005717 closedthraxisp First Login after installation fails. 
has duplicate 0005739 closedthraxisp SQL error on <my view> and <view issues> 
has duplicate 0005738 closedthraxisp SQL error on <my view> and <view issues> 
has duplicate 0005747 closedthraxisp Upgrade leaves site unusable 
has duplicate 0005757 closedthraxisp Installed & upgraded, getting error 401, database error 1064! 
has duplicate 0005780 closedthraxisp Update failure. 0.19.2 -> 1.0.0a3 
has duplicate 0005908 closedthraxisp After Install 
has duplicate 0005929 closedthraxisp SQL error prevents login 
has duplicate 0005876 closedthraxisp After succesful installation -> login_page is blank 
has duplicate 0005983 closedthraxisp Error in de system_utils option 
child of 0005460 closedvboctor Critical Issues to Fix for Mantis 1.0.0 Release 

Activities

TomR

TomR

2005-05-31 17:12

reporter   ~0010299

Same problem with CVS-HEAD

thraxisp

thraxisp

2005-05-31 19:13

reporter   ~0010300

Can you provide more information?

1) Did you run the database update (http://yoursite/mantisbt/admin )?

2) can you turn "$g_show_detailed_errors = ON;" and provide the traceback information?

ssschneider

ssschneider

2005-06-01 04:42

reporter   ~0010311

I got the same problem after upgrading to the current CVS-Version:

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 o' 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

I did all updates in the Database with the Admin-Feature.
Any Ideas?
Thx

TomR

TomR

2005-06-01 06:30

reporter   ~0010314

Last edited: 2005-06-01 06:30

I got the same output as ssschneider.

Updated database through mantis/admin pages.

thraxisp

thraxisp

2005-06-01 07:39

reporter   ~0010315

Last edited: 2005-06-01 07:40

MySQL 3.23 doesn't support "t1 JOIN t2 ON condition" syntax.

A fix should be in CVS later today.

thraxisp

thraxisp

2005-06-01 09:29

reporter   ~0010316

Fixed in CVS.

core/custom_field_api.php -> 1.53