• last updated 9 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Fixed relative path, removed extra single quotes not needed outside plpgsql

function.

Added upgrade to upgrade to changes made for Oracle 9i support

    • -0
    • +605
    ./sql/oracle/upgrade/upgrade-4.3-5.0d1.sql
  1. … 23 more files in changeset.
Updated version numbers to upgrade to changes made for Oracle 9i support

  1. … 37 more files in changeset.
Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

  1. … 273 more files in changeset.
noquote changes (Dirk Gomez)

  1. … 119 more files in changeset.
merge of 4.6.3b1 to HEAD

    • -2
    • +3
    ./tcl/static-pages-procs-postgresql.xql
  1. … 16 more files in changeset.
merge of 4.6.3b1 to HEAD

  1. … 5 more files in changeset.
1. Fixed a type mismatch problem in acs-messaging for PostgreSQL that was

ignored by versions before 7.3 and therefore had been missed.

2. Fixed a problem in static pages regarding misunderstanding of how

nsv_array set works by someone who worked on it at some point.

3. Fixed a typo in static pages for PostgreSQL (misspelled function

name)

4. Fixed a typo in a query in survey.

    • -2
    • +3
    ./tcl/static-pages-procs-postgresql.xql
  1. … 3 more files in changeset.

1. Made it possible to upgrade from acs-kernel 4.6.1 to acs-kernel 4.6.2

by using the APM rather than running the upgrade script by hand from

PSQL or SQL*Plus.

2. Changed a bunch of package .info files to depend on acs-kernel 4.6.2

to force the APM to upgrade acs-kernel (and therefore the APM datamodel)

before anything else. No guarantee on this though since not all

packages properly define their dependence on the kernel, it appears.

3. Whacked the release notes to suggest people use the APM to upgrade

acs-kernel first, other package later, just for safety's sake.

4. Fixed goof-up in acs-subsite I accidently introduced.

  1. … 34 more files in changeset.
I've changed "timestamp" to "timestamptz" and have begun fixing some

code that used to be legal but as of PG 7.3 is not. You can no longer

subtract an integer from a timestamp but must cast to date, "timestamp"

disappeared (must use "interval" now), "datetime" disappeared ("timestamptz"),

and suchwhat.

Not done but closer than it was before ...

  1. … 14 more files in changeset.
- Adds table cr_extension_mime_type_map,

- Adds function cr_filename_to_mime_type [-create] filename

- Adds function cr_create_mime_type -extension -mime_type -description

- Removes *_maybe_create_new_mime_type

- Updates acs-content-repository to 4.6.3. Ugrade scripts provided.

- Updates dependency information for several packages.

- Adds most mime types plus comprehensive list of extension to mime-typemappings.

- Maps .c .h .c++ .pl etc to text/plain

  1. … 9 more files in changeset.
In some cases when file not in DB yet, static_page_id was referenced

but not yet set at all, fixed.

- Overhauled sp_maybe_create_new_mime_type to no longer have ANY side

effects (fixes bug 145).

- sp_sync_cr_with_filesystem_internal is now robust to errors caught

in do_sp_new (calling static_page.new), it continues on with other

files.

- Removed a few unnecessary ns_logs.

Fixed bad typo bug in sp_maybe_create_new_mime_type - if file-storage

package was installed, proc would fail due to left missing 'eval'.

Merge of all changes from oacs-4-6 to HEAD. All changes up to tag jcd-merge-2

on oacs-4-6 are included.

    • -589
    • +21
    ./sql/oracle/static-pages-create.sql
    • -0
    • +45
    ./sql/oracle/upgrade/upgrade-4.2a-4.3.sql
    • -0
    • +602
    ./sql/postgresql/static-page-pb.sql
    • -585
    • +2
    ./sql/postgresql/static-pages-create.sql
    • -19
    • +47
    ./tcl/static-pages-procs-oracle.xql
    • -20
    • +46
    ./tcl/static-pages-procs-postgresql.xql
    • -14
    • +22
    ./www/admin/fs-scan-progress.tcl
  1. … 20 more files in changeset.
Replaced ns_schedule_daily with ad_schedule_proc.

Replaced ns_share with nsv, and related improvements to mutex locking.

www/page-visit.tcl now works properly with files under package

directories and under the global www/ page root.

    • -0
    • +9
    ./tcl/static-pages-procs-postgresql.xql
Failure to check for empty_string in sp_serve_html_page was breaking

/doc/static-pages/.

Now correctly sets mime type using sp_maybe_create_new_mime_type,

rather than always using text/html.

    • -1
    • +20
    ./sql/oracle/upgrade/upgrade-4.2a-4.3.sql
    • -11
    • +8
    ./tcl/static-pages-procs-oracle.xql
    • -12
    • +8
    ./tcl/static-pages-procs-postgresql.xql
Added proc sp_sync_cr_with_filesystem_scheduled, so can optionally

schedule to run every night at e.g. 4 am.

Upgrade script now properly converts existing filenames from page to

server root relative, for both Oracle and Postgres.

    • -4
    • +6
    ./sql/oracle/upgrade/upgrade-4.2a-4.3.sql
- Now supports multiple static-pages package instances, each with its

own fs_root parameter.

- static_pages.filename column is now relative to server root, not

page root. May still need an upgrade sript to convert old values in

db, see TODO comment in oracle upgrade-4.2a-4.3.sql.

- Added update to singleton_p = 'f' to upgrade scripts, which I left

out before.

- (Did NOT yet change www/page-visit.tcl to support files beneath the

packages/*/www/ directories.)

- Added other misc. comments.

- Now supports multiple static-pages package instances, each with its

own fs_root parameter.

- static_pages.filename column is now relative to server root, not

page root. May still need an upgrade sript to convert old values in

db, see TODO comment in oracle upgrade-4.2a-4.3.sql.

- Added update to singleton_p = 'f' to upgrade scripts, which I left

out before.

- (Did NOT yet change www/page-visit.tcl to support files beneath the

packages/*/www/ directories.)

- Added other misc. comments.

    • -1
    • +10
    ./sql/oracle/upgrade/upgrade-4.2a-4.3.sql
    • -0
    • +23
    ./tcl/static-pages-procs-oracle.xql
    • -0
    • +21
    ./tcl/static-pages-procs-postgresql.xql
file upgrade-4.2a-4.3.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./sql/oracle/upgrade/upgrade-4.2a-4.3.sql
    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-4.2a-4.3.sql
- Name of root folder is now unique in the CR even if have multiple

package instances, for both Oracle and Postgres.

- All Postgres functions now defined with "create or replace".

    • -0
    • +15
    ./sql/oracle/upgrade/upgrade-4.2a-4.3.sql
    • -15
    • +24
    ./sql/postgresql/static-page-pb.sql
Moved Postgres functions and bodies out of static-pages-create.sql

into separate files (just like for Oracle) - necessary to more cleanly

support upgrade files. No other changes.

    • -0
    • +589
    ./sql/postgresql/static-page-pb.sql
    • -585
    • +2
    ./sql/postgresql/static-pages-create.sql
file static-page-pb.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./sql/postgresql/static-page-pb.sql
Moved Oracle package headers and bodies out of static-pages-create.sql

into separate files - necessary to more cleanly support upgrade files.

Also added a few comments. No other changes.

    • -589
    • +19
    ./sql/oracle/static-pages-create.sql
file static-page-ph.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./sql/oracle/static-page-ph.sql