Index: openacs-4/packages/acs-api-browser/www/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-api-browser/www/index-oracle.xql,v
diff -u -N
--- openacs-4/packages/acs-api-browser/www/index-oracle.xql	20 Jul 2006 10:10:31 -0000	1.1
+++ /dev/null	1 Jan 1970 00:00:00 -0000
@@ -1,20 +0,0 @@
-<?xml version="1.0"?>
-
-<queryset>
-   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
-
-<fullquery name="get_local_package_version_id">      
-      <querytext>
-        select * from (
-            select version_id
-              from apm_package_version_info
-            where installed_p = 't'
-              and enabled_p = 't'
-              and package_key = :about_package_key
-	) 
-        where rownum = 1
-      </querytext>
-</fullquery>
-
- 
-</queryset>
Index: openacs-4/packages/acs-api-browser/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-api-browser/www/index-postgresql.xql,v
diff -u -N
--- openacs-4/packages/acs-api-browser/www/index-postgresql.xql	20 Jul 2006 10:10:31 -0000	1.1
+++ /dev/null	1 Jan 1970 00:00:00 -0000
@@ -1,20 +0,0 @@
-<?xml version="1.0"?>
-
-<queryset>
-   <rdbms><type>postgresql</type><version>7.1</version></rdbms>
-
-<fullquery name="get_local_package_version_id">
-      <querytext>
-
-        select version_id
-          from apm_package_version_info
-        where installed_p = 't'
-          and enabled_p = 't'
-          and package_key = :about_package_key
-	limit 1 
-    
-      </querytext>
-</fullquery>
-
- 
-</queryset>
Index: openacs-4/packages/acs-api-browser/www/index.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-api-browser/www/index.tcl,v
diff -u -N -r1.11.2.1 -r1.11.2.2
--- openacs-4/packages/acs-api-browser/www/index.tcl	30 Apr 2019 18:50:10 -0000	1.11.2.1
+++ openacs-4/packages/acs-api-browser/www/index.tcl	1 Sep 2020 14:13:51 -0000	1.11.2.2
@@ -29,7 +29,13 @@
     multirow create disabled_packages
     multirow create uninstalled_packages
 
-    if { [db_0or1row get_local_package_version_id {} ] } {
+    if { [db_0or1row get_local_package_version_id {
+        select min(version_id)
+          from apm_package_version_info
+        where installed_p = 't'
+          and enabled_p = 't'
+          and package_key = :about_package_key
+    }] } {
         rp_form_update version_id $version_id
         rp_internal_redirect package-view
         ad_script_abort