RE: [phpBT-dev] CVS: phpbt/inc/db mysql.php,1.12,1.13 oci8.php,1. 8,1.9 pgsql.php,1.17,1.18

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

Thanks for working on this...
After fixing the comma-bug (see cvs), I get this upon submitting:
maybe it doesnt like the 'and 1' ?

DB Error: unknown error
select count(*) from phpbt_bug b, phpbt_auth_user owner, phpbt_auth_user
reporter where b.assigned_to = owner.user_id(+) and b.created_by =
reporter.user_id(+) and 1 [nativecode=ORA-00920: invalid relational operator
]

Florian

> -----Original Message-----
> From: Ben Curtis [mailto:php...@be...]
> Sent: Friday, September 06, 2002 4:55 PM
> To: php...@li...
> Subject: Re: [phpBT-dev] CVS: phpbt/inc/db mysql.php,1.12,1.13
> oci8.php,1. 8,1.9 pgsql.php,1.17,1.18
> 
> 
> Yes, I think Jirka's fix should solve the problem I introduced. :)
> Upgrade.php still needs work, but in the past I've put it off 
> until just
> before release.
> 
> On Fri, Sep 06, 2002 at 03:49:11PM +0200, Jirka Pech wrote:
> > > DB Error: invalid number
> > > SELECT sum(decode( s.status_name, 1, 1, 2, 1, 3, 1, 4, 1, 
> 0 )), sum(decode(
> > > s.status_id, 1, 0, 2, 0, 3, 0, 4, 0, 1 )) from phpbt_bug 
> b, phpbt_status s
> > > where b.status_id = s.status_id (+) and b.created_by = 1
> > > [nativecode=ORA-01722: invalid number ]
> > 
> > This comes from adding BUG_??? codes. s.status_name is not 
> a number. Try new 
> > inc/db/oci8.php from CVS and let me know.
> > 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by: OSDN - Tired of that same old
> cell phone?  Get a new here for FREE!
> https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390
> _______________________________________________
> phpbt-dev mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpbt-dev
>