[phpBT-dev] Could someone help fix the Oracle-SQL stuff?

[Florian K. <Flo...@in...>]

Hi, I'm trying to fix the Oracle-SQL-Statements in
inc/db/oci8.php
I guess, the opposing statements are 'include-template-owner'
and 'include-template-reporter' (I can't even log on).

First of all, I think there is a comma too much after the second 'sum'.
If I fix that, it gives me the following:

DB Error: no such field
SELECT sum(decode( s.status_id, BUG_UNCONFIRMED, 1, BUG_PROMOTED, 1,
BUG_ASSIGNED, 1, BUG_REOPENED, 1, 0 )), sum(decode( s.status_id,
BUG_UNCONFIRMED, 0, BUG_PROMOTED, 0, BUG_ASSIGNED, 0, BUG_REOPENED, 0, =
1 ))
from phpbt_bug b, phpbt_status s where b.status_id =3D s.status_id (+) =
and
b.assigned_to =3D 1 [nativecode=3DORA-00904: invalid column name ]

If I pretty print that in SQL*Plus Worksheet, I get:
SELECT
sum(decode(s.status_id,
  BUG_UNCONFIRMED, 1,
  BUG_PROMOTED,    1,
  BUG_ASSIGNED,    1,
  BUG_REOPENED,    1,
  0 )),
sum(decode(s.status_id,
  BUG_UNCONFIRMED, 0,
  BUG_PROMOTED,    0,
  BUG_ASSIGNED,    0,
  BUG_REOPENED,    0,
  1 ))
from phpbt_bug b, phpbt_status s where b.status_id =3D s.status_id (+) =
and
b.assigned_to =3D 1;

Where the error is:
  BUG_REOPENED,    0,
  *
FEHLER in Zeile 12:
ORA-00904: Ung=FCltiger Spaltenname (invalid column name)

Any hints on how to fix it?

Thanks,
  Florian