First, this procedure is quite specific to the mix of code running on openacs.org. It might give some hints into what might need to be done on a site running custom code.
Log onto current openacs server. psql -f openacs.org-2003-08-30-fixed-2.dump openacs.org psql -f /web/openacs.org/packages/acs-kernel/sql/postgresql/postgresql.sql openacs.org psql -f upgrade-4.2-4.5.sql openacs.org log on to temp openacs server. start aolserver visit temp-server/acs-admin/apm/ install packages Upgrade acs-kernel - no sql scripts restart aolserver visit APM Install Packages acs-tcl acs-admin acs-bootstrap-installer acs-templating acs-service-contract apply upgrade-4.5.1-4.6.sql upgrade script acs-subsite -don't run upgrade script acs-utilities -restart visit apm upgrade acs-content-repository apply upgrade-4.5-4.6.sql openacs.org upgrade-4.6.2-4.6.3.sql openacs.org upgrade-4.6.3-4.6.4.sql openacs.org upgrade-4.6.4-4.6.5.sql opeancs.org upgrade search -don't run sql scripts upgrade notifications apply upgrade-0.2d-0.3d.sql openacs.org SKIP! psql -f upgrade-0.3d-0.4d.sql openacs.org creates indexes that already exist upgrade-0.4d-4.6.1.sql openacs.org upgrade-4.6.1-4.6.2.sql openacs.org -restart aolserver Install packages Upgrade acs-api-browser acs-content acs-core-docs acs-datetime acs-events upgrade-0.1d-0.2d.sql acs-mail apply upgrade-4.5-4.6.sql openacs.org upgrade-4.6-4.6.1.sql openacs.org upgrade-4.6.1-4.6.2.sql openacs.org acs-messaging apply upgrade-4.6.2-4.6.3.sql openacs.org acs-workflow apply upgrade-4.6-4.6.1.sql openacs.org bookmarks apply upgrade-4.1.1b-4.6.sql openacs.org faq apply upgrade-4.0-4.6.sql openacs.org file-storage apply upgrade-4.6.1-4.6.2.sql openacs.org --go get irc-logger!! news apply upgrade-4.1.0b-4.6.sql openacs.org modified to fix timestamp issue page rss-support skin static-pages apply upgrade-4.2a-4.3.sql wp -restart aolserver install workflow package -restart aolserver (make sure workflow is enabled before trying to upgrade bugtracker!!! upgrade bugtracker apply upgrade-0.9d1-1.2d2.sql upgrade-1.2d5-1.2d6.sql upgrade-1.2d6-1.2d7.sql upgrade-1.2d8-1.2d9.sql upgrade-1.2d9-1.2d10.sql ETP apply upgrade-1.2-1.3.sql Don't forget to vacuum
Further work
Now that the site is working on 4.6.3 we can upgrade to openacs 5.0. In a checkout of openacs-org branch do cvs update -rand resovle any conflicts. Follow the 4.6.3 to 5.0 upgrade procedure: http://openacs.org/projects/openacs/5.0/upgrade-463-50. After this the only trick will be compiling OpenFTS 0.3.2 and fixing the search system. Vaugue guide to this: visit openfts-driver/ and try to remove the openfts tables from there. Then remove the openfts-driver package from the apm. After that go into psql and make sure there aren't any index* tables. If there are, drop them. Make sure txt table is also dropped. Compile tsearch and Openfts 0.3.2 and install them into the database. reinstall openfts driver package. Initialize it by browsing to openfts-driver. If it worked you will need to reindex all the content which includes forums_messages and etp_page_revisions. Only index the parent of a thread, the service contract will index all the children for you. Only index live revisions of content repository items.