View Issue Details

IDProjectCategoryView StatusLast Update
0017189mantisbtapi soappublic2014-12-08 02:08
Reportervboctor Assigned Tograngeway  
PrioritynormalSeverityblockReproducibilityhave not tried
Status closedResolutionfixed 
Product Version1.3.0dev 
Target Version1.3.0-beta.1 
Summary0017189: mc_projects_get_user_accessible() produces a mysql error
Description

Here is the exception:

Error Type: APPLICATION ERROR 0000401,
Error Description: Database query failed. Error received from database was 0001064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 12 for the query: SELECT DISTINCT p.id, p.name, ph.parent_id
FROM mantis_project_table p
LEFT JOIN mantis_project_user_list_table u
ON p.id = u.project_id AND u.user_id=?
LEFT JOIN mantis_project_hierarchy_table ph
ON ph.child_id = p.id
WHERE p.enabled = ? AND
ph.parent_id IS NOT NULL AND
( p.view_state=?
OR (p.view_state=?
AND
u.user_id=? )
)
ORDER BY p.name.

TagsNo tags attached.

Activities

grangeway

grangeway

2014-04-12 18:53

reporter   ~0039921

Victor,

Is that against the dbapi patchset ?

As I've got all the SOAP unit tests passing - is there a soap unit test covering mc_projects_get_user_accessible ?

Paul

grangeway

grangeway

2014-04-12 19:06

reporter   ~0039922

Victor,

In fact, just had a look - this issue is fixed in the dbapi branch that's up for review at the moment.

Paul

grangeway

grangeway

2014-04-12 19:14

reporter   ~0039923

Pull request has been refreshed to state it includes the fix for this issue https://github.com/mantisbt/mantisbt/pull/162

rombert

rombert

2014-04-17 09:20

reporter   ~0040115

This particular method is called several times during the SOAP Unit tests. Victor, how did you manage to produce the error?

grangeway

grangeway

2014-06-01 17:30

reporter   ~0040707

This was fixed by https://github.com/mantisbt/mantisbt/commit/2926132bf36d8811720118a66d5763dc8ce1c075