Index: openacs-4/packages/static-pages/sql/oracle/upgrade/upgrade-4.2a-4.3.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/static-pages/sql/oracle/upgrade/upgrade-4.2a-4.3.sql,v
diff -u -r1.1.2.2 -r1.1.2.3
--- openacs-4/packages/static-pages/sql/oracle/upgrade/upgrade-4.2a-4.3.sql	12 Dec 2002 22:01:41 -0000	1.1.2.2
+++ openacs-4/packages/static-pages/sql/oracle/upgrade/upgrade-4.2a-4.3.sql	15 Dec 2002 23:25:55 -0000	1.1.2.3
@@ -18,7 +18,9 @@
 where package_key = 'static-pages' ;
 commit;
 
--- TODO: Must convert any old static_pages.filename values in the db
--- to be relative to the server rather than page root.  See also
--- comment in tcl/static-pages-init.tcl re. CR_LOCATIONS STATIC_PAGES.
+-- This converts any old static_pages.filename values in the db to be
+-- relative to the server rather than page root.  See also comment in
+-- tcl/static-pages-init.tcl re. CR_LOCATIONS STATIC_PAGES:
 -- --atp@piskorski.com, 2002/12/12 16:17 EST
+
+update static_pages  set filename = '/www' || filename;
Index: openacs-4/packages/static-pages/sql/postgresql/upgrade/upgrade-4.2a-4.3.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/static-pages/sql/postgresql/upgrade/upgrade-4.2a-4.3.sql,v
diff -u -r1.1.2.2 -r1.1.2.3
--- openacs-4/packages/static-pages/sql/postgresql/upgrade/upgrade-4.2a-4.3.sql	12 Dec 2002 22:01:51 -0000	1.1.2.2
+++ openacs-4/packages/static-pages/sql/postgresql/upgrade/upgrade-4.2a-4.3.sql	15 Dec 2002 23:26:07 -0000	1.1.2.3
@@ -17,3 +17,10 @@
 update apm_package_types  set singleton_p = ''f''
 where package_key = ''static-pages'' ;
 commit;
+
+-- This converts any old static_pages.filename values in the db to be
+-- relative to the server rather than page root.  See also comment in
+-- tcl/static-pages-init.tcl re. CR_LOCATIONS STATIC_PAGES:
+-- --atp@piskorski.com, 2002/12/12 16:17 EST
+
+update static_pages  set filename = ''/www'' || filename;