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

[Ben C. <php...@be...>]

My latest commits to the db files and query.php should remove the 'and
1' and hopefully won't break it further. :)

On Fri, Sep 06, 2002 at 07:43:42PM +0200, Florian Kolbe wrote:
> 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
> > 
> 
> 
> -------------------------------------------------------
> 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