View Issue Details

IDProjectCategoryView StatusLast Update
0007198mantisbtdb oraclepublic2017-09-30 19:26
Reportermechantflou Assigned Tocproensa  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionunable to reproduce 
Summary0007198: problem in user_api to load public project with oracle database
Description

query doesn't return right result with oracle database line 676 in the file user_api.php

    $query = "SELECT p.id, p.name
    FROM    $t_project_table p,

$t_project_user_list_table u
WHERE $t_enabled_clause
p.id=u.project_id
AND u.user_id=$c_user_id
AND
( p.view_state='$t_public'
OR (p.view_state='$t_private'
AND
u.user_id='$c_user_id' )
)
ORDER BY p.name " ;

That is the solution

$query = "SELECT p.id, p.name FROM $t_project_table p,
$t_project_user_list_table u WHERE $t_enabled_clause ( p.view_state='$t_public' OR (p.view_state='$t_private'
AND u.user_id='$c_user_id' AND p.id=u.project_id)) ORDER BY p.name " ;

TagsNo tags attached.

Activities

grangeway

grangeway

2014-05-16 15:01

reporter   ~0040495

MantisBT currently supports Mysql and has support for other database engines.

The support for other databases is known to be problematic.

Having implemented the current database layer into Mantis 10 years ago, I'm currently working on replacing the current layer.

If you are interested in using Mantis with non-mysql databases - for example, Oracle, PGSQL or MSSQL, and would be willing to help out testing the new database layer, please drop me an email at paul@mantisforge.org

In the meantime, I'd advise running Mantis with Mysql Only to avoid issues.

Thanks
Paul

atrol

atrol

2014-06-16 15:33

developer   ~0040811

Reminder sent to: dregad, grangeway

Not sure, maybe this issue should be moved back to project mantis.
If so, grangeway could make a copy of it in project "Track DBAL replacement"

cproensa

cproensa

2017-09-30 19:26

developer   ~0057866

old issue, not applicable to current versions