Index: openacs-4/packages/new-portal/new-portal.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/new-portal/new-portal.info,v
diff -u -r1.29.2.9 -r1.29.2.10
--- openacs-4/packages/new-portal/new-portal.info	22 Apr 2007 18:49:18 -0000	1.29.2.9
+++ openacs-4/packages/new-portal/new-portal.info	5 Jul 2007 22:02:31 -0000	1.29.2.10
@@ -8,14 +8,14 @@
     <singleton-p>t</singleton-p>
     <auto-mount>portal</auto-mount>
 
-    <version name="2.3.0" url="http://openacs.org/repository/download/apm/new-portal-2.3.0.apm">
+    <version name="2.3.1d2" url="http://openacs.org/repository/download/apm/new-portal-2.3.d2.apm">
         <owner url="http://openacs.org">OpenACS</owner>
         <summary>Portals.</summary>
         <release-date>2007-04-22</release-date>
         <vendor url="http://openacs.org">OpenACS</vendor>
         <description format="text/plain">New Portal Package aka NPP. Portals are used to aggregate content from different sources within a single page.  Props to Ian Baker for &quot;Portal&quot;.</description>
 
-        <provides url="new-portal" version="2.3.0"/>
+        <provides url="new-portal" version="2.3.d21"/>
         <requires url="acs-kernel" version="5.3.1a1"/>
 
         <callbacks>
Index: openacs-4/packages/new-portal/sql/oracle/api-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/new-portal/sql/oracle/api-create.sql,v
diff -u -r1.42.2.3 -r1.42.2.4
--- openacs-4/packages/new-portal/sql/oracle/api-create.sql	29 Mar 2007 19:20:57 -0000	1.42.2.3
+++ openacs-4/packages/new-portal/sql/oracle/api-create.sql	5 Jul 2007 22:02:32 -0000	1.42.2.4
@@ -267,7 +267,8 @@
             -- now insert the pages from the portal template
             for page in (select *
                          from portal_pages
-                         where portal_id = portal.new.template_id)
+                         where portal_id = portal.new.template_id
+                         order by sort_key)
             loop
 
                 v_page_id := portal_page.new(
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/new-portal/sql/oracle/upgrade/upgrade-2.3.1d1-2.3.1d2.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: openacs-4/packages/new-portal/sql/postgresql/api-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/new-portal/sql/postgresql/api-create.sql,v
diff -u -r1.14.2.5 -r1.14.2.6
--- openacs-4/packages/new-portal/sql/postgresql/api-create.sql	29 Mar 2007 19:20:58 -0000	1.14.2.5
+++ openacs-4/packages/new-portal/sql/postgresql/api-create.sql	5 Jul 2007 22:02:32 -0000	1.14.2.6
@@ -132,7 +132,7 @@
 
 select define_function_args('portal__new','portal_id,name,theme_id,layout_id,template_id,default_page_name,default_accesskey,object_type;portal,creation_date,creation_user,creation_ip,context_id');
 
-create function portal__new (integer,varchar,integer,integer,integer,varchar,varchar,varchar,timestamptz,integer,varchar,integer)
+create or replace function portal__new (integer,varchar,integer,integer,integer,varchar,varchar,varchar,timestamptz,integer,varchar,integer)
 returns integer as '
 declare
     p_portal_id                     alias for $1;
@@ -226,6 +226,7 @@
         for v_page in select *
                       from portal_pages
                       where portal_id = p_template_id
+		      order by sort_key
         loop
 
             v_page_id := portal_page__new(
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/new-portal/sql/postgresql/upgrade/upgrade-2.3.1d1-2.3.1d2.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/new-portal/tcl/test/new-portal-test-procs.tcl'.
Fisheye: No comparison available.  Pass `N' to diff?