View Issue Details

WikiJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0006118mantisbtsqlpublic2005-08-11 05:492005-09-11 08:10
Reporterilles Assigned Tothraxisp  
PrioritynormalSeveritycrashReproducibilityalways
Status closedResolutionfixed 
Product Version1.0.0rc1 
Fixed in Version1.0.0rc2 
Summary0006118: Database query failure - click on Docs link - MySQL 3.23
Description

Database query failed. Error received from database was 0001064: You have an error in your SQL syntax near 'ON ut.id = 2
WHERE pft.project_id in (10,8,11,13,4,18,16,3,9,0) AND
( ' at line 6 for the query: SELECT pft.id, pft.project_id, pft.filename, pft.filesize, pft.title, pft.description, pft.date_added
FROM mantis_project_file_table pft
LEFT JOIN mantis_project_table pt on pft.project_id = pt.id
LEFT JOIN mantis_project_user_list_table as pult
on pft.project_id = pult.project_id and pult.user_id = 2
JOIN mantis_user_table ut ON ut.id = 2
WHERE pft.project_id in (10,8,11,13,4,18,16,3,9,0) AND
( pt.view_state = 10 OR pt.view_state is null OR
( pt.view_state = 50 and pult.user_id = 2 ) OR
( pult.user_id is null and ut.access_level >= 0 ) )
ORDER BY pt.name ASC, pft.title ASC

Additional Information

Duplicate of 0006020

Debian Woody
PHP Version 4.1.2
Apache/1.3.26
MySQL 3.23.49

TagsNo tags attached.

Relationships

has duplicate 0006119 closedryandesign Database query failure - click on Docs link - MSSQL 
child of 0005460 closedvboctor Critical Issues to Fix for Mantis 1.0.0 Release 

Activities

illes

illes

2005-08-11 05:53

reporter   ~0011163

Since I cannot edit my own post:
the 0006020 was fixed in CVS (proj_doc_page.php -> 1.48), but the problem is still exists on my server
ryandesign

ryandesign

2005-08-11 07:15

reporter   ~0011164

I'm not sure if this problem relates to 0006020... That error message was different, and that problem only occurred with Microsoft SQL server, but you say you are using MySQL server. Am I missing some information that links these two reports? I'm guessing your error occurs because Mantis is using an SQL syntax that did not exist in MySQL 3.23.49... (So until this is fixed in Mantis the workaround would be to upgrade to a current version of MySQL, which ain't a bad idea anyway.)
illes

illes

2005-08-16 06:42

reporter   ~0011221

Upgraded to MySQL 4.0.24_Debian-10 -> the problem has vanished, the bug can be closed now.

Thanks for your patience.
thraxisp

thraxisp

2005-08-16 10:38

reporter   ~0011226

JOIN ... ON ... is not valid in MySQL 3.23.

proj_doc_page.php -> 1.50