[phpBT-dev] CVS: phpbt/inc/db pgsql.php,1.12,1.13

[Jirka P. <fi...@us...>]

Update of /cvsroot/phpbt/phpbt/inc/db
In directory usw-pr-cvs1:/tmp/cvs-serv10850/phpbt/inc/db

Modified Files:
	pgsql.php 
Log Message:
Database independency nightmare bugfix. Not tested.


Index: pgsql.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/pgsql.php,v
retrieving revision 1.12
retrieving revision 1.13
diff -u -r1.12 -r1.13
--- pgsql.php	26 Jun 2002 12:30:43 -0000	1.12
+++ pgsql.php	26 Jun 2002 13:49:34 -0000	1.13
@@ -135,8 +135,8 @@
 		'left join '.TBL_AUTH_USER.' lastmodifier on b.last_modified_by = lastmodifier.user_id '.
 		'left join '.TBL_RESOLUTION.' resolution on b.resolution_id = resolution.resolution_id '.
 		'left join '.TBL_DATABASE.' on b.database_id = '.TBL_DATABASE.'.database_id '.
-		'left join '.TBL_VERSION.' on version2 b.to_be_closed_in_version_id = version2.version_id '.
-		'left join '.TBL_VERSION.' on version3 b.closed_id_version_id = version3.version_id, '.
+		'left join '.TBL_VERSION.' version2 on b.to_be_closed_in_version_id = version2.version_id '.
+		'left join '.TBL_VERSION.' version3 on b.closed_id_version_id = version3.version_id, '.
 		TBL_SEVERITY.' severity, '.TBL_STATUS.' status, '.TBL_OS.' os, '.
 		TBL_VERSION.' version, '.TBL_COMPONENT.' component, '.TBL_PROJECT.' project '.
 		'where b.severity_id = severity.severity_id '.