[phpBT-dev] CVS: phpbt/inc/db oci8.php,1.15,1.15.2.1

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt/inc/db
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10411/inc/db

Modified Files:
      Tag: phpbt-1_0
	oci8.php 
Log Message:
Fixed a query

Index: oci8.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/oci8.php,v
retrieving revision 1.15
retrieving revision 1.15.2.1
diff -u -r1.15 -r1.15.2.1
--- oci8.php	21 Jun 2003 13:36:30 -0000	1.15
+++ oci8.php	25 Feb 2004 12:42:30 -0000	1.15.2.1
@@ -39,7 +39,7 @@
 		'group by d.database_id, database_name, sort_order '.
 		'order by %s %s',
 	'admin-list-sites' => 'select s.site_id, site_name, sort_order, '.
-		'count(bug_id) as bug_count from '.TBL_SITE. ' s, '.TBL_BUG.
+		'count(bug_id) as bug_count from '.TBL_SITE. ' s, '.TBL_BUG.' b '.
 		'where s.site_id = b.site_id(+) group by s.site_id, site_name, '.
 		'sort_order order by %s %s',
 	'admin-list-statuses' => 'select s.status_id, status_name, status_desc, '.