Mantis 1.1.8 & Oracle : problem with filter
Posted: 17 Sep 2009, 09:47
Hello,
I'm trying of use Mantis (v 1.1.
with Oracle 10g.
I've followed what is written here http://www.mantisbt.org/bugs/view.php?id=6895 but I'm still having problems.
I've also had to change some queries because table aliases are not correct: in Oracle the word "AS" is not used for tables.
For example:
function summary_print_by_activity() in summary_api.php
FROM $t_mantis_bug_table AS b, $t_mantis_history_table AS h --> FROM $t_mantis_bug_table b, $t_mantis_history_table h in
Anyway, I've noticed that I cannot filter bugs.
Even if I choose some options, the bug summary always shows all bugs. Ignoring filter.
I've also have problems when saving filters: I've not messages of failure but Mantis doesn't save the filter.
Can anyone help me?
PS: sorry for my Englis
I'm trying of use Mantis (v 1.1.

I've followed what is written here http://www.mantisbt.org/bugs/view.php?id=6895 but I'm still having problems.
I've also had to change some queries because table aliases are not correct: in Oracle the word "AS" is not used for tables.
For example:
function summary_print_by_activity() in summary_api.php
FROM $t_mantis_bug_table AS b, $t_mantis_history_table AS h --> FROM $t_mantis_bug_table b, $t_mantis_history_table h in
Anyway, I've noticed that I cannot filter bugs.
Even if I choose some options, the bug summary always shows all bugs. Ignoring filter.
I've also have problems when saving filters: I've not messages of failure but Mantis doesn't save the filter.
Can anyone help me?
PS: sorry for my Englis
