• last updated 4 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates

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.
Fixed typo in PG upgrade script ("can''t" vs. "can't") and added symlinks

as registered content types to folders in order to ease further extension

of the semantics of file-storage.

    • -3
    • +10
    ./sql/oracle/file-storage-package-create.sql
1. One fix to track APM changes made by Peter, in acs-subsite

2. changed attachments to use cr_extlinks

3. Fixed a couple of problems with my prior commit to file-storage that

removed fs_urls.

    • -2
    • +13
    ./sql/oracle/file-storage-package-create.sql
    • -4
    • +720
    ./sql/oracle/upgrade/upgrade-4.6.1-4.6.2.sql
    • -4
    • +85
    ./sql/postgresql/upgrade/upgrade-4.6.1-4.6.2.sql
file upgrade-4.6.1-4.6.2.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./sql/oracle/upgrade/upgrade-4.6.1-4.6.2.sql
    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-4.6.1-4.6.2.sql
Removed the vile fs_simple_objects added by OF to store URLs in file

storage despite the existence of a non-versioned URL type in the content

repository. Upgrade scripts provided. I added Tcl API to the content

repository to honor our desire to export the SQL API to Tcl client code.

1. folder contents are now counted correctly (bug fix)

2. The fs_objects view is now usable in PG (it was a UNION view before and

therefore didn't scale)

3. Code in file storage is considerably simpler now and all file storage

objects are now stored in the content repository, as they should

be.

The Oracle version may need some work I'll finish testing this afternoon.

    • -220
    • +0
    ./sql/oracle/file-storage-simple-package-create.sql
    • -56
    • +45
    ./sql/oracle/file-storage-views-create.sql
    • -183
    • +0
    ./sql/postgresql/file-storage-simple-package-create.sql
    • -0
    • +104
    ./sql/postgresql/upgrade/upgrade-4.6.1-4.6.2.sql
    • -17
    • +0
    ./tcl/fs-simple-procs-postgresql.xql
  1. … 32 more files in changeset.
Bump the max upload default to 5,000,000. This is currently used as the default for all classes/communities in dotLRN and it is hard to get to the file-storage instance for each one to change it, so making the default a bit higher means fewer folks will have to deal with that hassle

Changed this file to make sure that a user can delete and admin perms on

files they upload via the file-storage UI. Previously if you only had

write privs on a folder, you couldn't delete or admin privs on your own

files uploaded to the folder.

Typo in query caused URLs to be listed many, many times

committing the latest translations from the dotLRN translation server

    • -1
    • +1
    ./catalog/file-storage.TH_TH.TIS-620.xml
    • -1
    • +1
    ./catalog/file-storage.da_DK.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/file-storage.de_DE.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/file-storage.en_US.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/file-storage.es_ES.ISO-8859-1.xml
    • -1
    • +42
    ./catalog/file-storage.fi_FI.ISO-8859-15.xml
    • -1
    • +1
    ./catalog/file-storage.it_IT.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/file-storage.nl_NL.ISO-8859-1.xml
    • -3
    • +67
    ./catalog/file-storage.no_NO.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/file-storage.pl_PL.ISO-8859-2.xml
    • -1
    • +1
    ./catalog/file-storage.pt_BR.ISO-8859-1.xml
    • -0
    • +6
    ./catalog/file-storage.ru_RU.windows-1251.xml
    • -1
    • +1
    ./catalog/file-storage.sh_HR.ISO-8859-5.xml
  1. … 422 more files in changeset.
Fixed download archives for PostgreSQL

    • -0
    • +8
    ./tcl/file-storage-procs-postgresql.xql
Fixed Bug #302: Don't display download archive link when the folder's empty

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. … 39 more files in changeset.
Moved over my new permissions stuff plus improved file storage stuff (mostly

speed improvements in PG-land)

    • -14
    • +75
    ./www/folder-chunk-postgresql.xql
  1. … 12 more files in changeset.
Inserted modified views from 4.6.1 ...

Added back oracle and specific folder-chunk queries for fame, speed, and

fortune.

Removed garbage I'd commented out earlier

1. Got rid of the "create or replace function" decls used for triggers, due

to the brand-new PG 7.3 "opaque" vs. "trigger" issue.

2. Added a new "fs::get_folder_object_ids" for use when you just need the

object ids rather than a bunch of (slow) permissions information,

(slow) counts of items in folders and subfolders, last modified info,

etc. dotLRN was calling "fs::get_folder_contents" when cloning folders

despite making use of only the object_id and that proc used to be unimaginably

slow. It's faster now due to the new permissions code but it's still slow

enough to warrant avoiding it when possible.

3. Fixed typo in my last commit.

  1. … 2 more files in changeset.
file upgrade-4.6-4.6.1.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-4.6-4.6.1.sql
First whack at speeding up (though not rationalizing, unfortunately) file

storage for PostgreSQL. Also fixes the fs_files view.

    • -1
    • +6
    ./sql/oracle/file-storage-views-create.sql
    • -20
    • +22
    ./tcl/file-storage-procs-oracle.xql
Committing the latest translation work from the dotlrn translation server. Many thanks to all the volunteer translators.

    • -0
    • +6
    ./catalog/file-storage.TH_TH.TIS-620.xml
    • -1
    • +1
    ./catalog/file-storage.da_DK.ISO-8859-1.xml
    • -3
    • +26
    ./catalog/file-storage.de_DE.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/file-storage.en_US.ISO-8859-1.xml
    • -9
    • +65
    ./catalog/file-storage.es_ES.ISO-8859-1.xml
    • -3
    • +35
    ./catalog/file-storage.fi_FI.ISO-8859-15.xml
    • -1
    • +1
    ./catalog/file-storage.it_IT.ISO-8859-1.xml
    • -1
    • +2
    ./catalog/file-storage.nl_NL.ISO-8859-1.xml
    • -0
    • +45
    ./catalog/file-storage.no_NO.ISO-8859-1.xml
    • -1
    • +2
    ./catalog/file-storage.pl_PL.ISO-8859-2.xml
    • -0
    • +6
    ./catalog/file-storage.pt_BR.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/file-storage.sh_HR.ISO-8859-5.xml
  1. … 125 more files in changeset.
1. Fixed a couple of typos in file storage

2. New fast permissions stuff (PG only thus far)

2. While poking around CMS code looking for things that needed recreating

due to the permissions upgrade, changed over to "create or replace function"

    • -24
    • +22
    ./tcl/file-storage-procs-postgresql.xql
  1. … 22 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. … 15 more files in changeset.
new_p listed twice, mistake merging the 7.3 patches, fixes bug 209

adds fs_url to graphics/ link since folder-chunk used to display outside the file-storage package

Switched to "file copy" ...

  1. … 7 more files in changeset.
I18N: committing all the message catalog files from the dotLRN translation server. Kudos to all our translators for this contribution.

    • -72
    • +91
    ./catalog/file-storage.da_DK.ISO-8859-1.xml
    • -0
    • +89
    ./catalog/file-storage.de_DE.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/file-storage.en_US.ISO-8859-1.xml
    • -0
    • +53
    ./catalog/file-storage.es_ES.ISO-8859-1.xml
    • -0
    • +37
    ./catalog/file-storage.fi_FI.ISO-8859-15.xml
    • -0
    • +26
    ./catalog/file-storage.it_IT.ISO-8859-1.xml
    • -0
    • +109
    ./catalog/file-storage.nl_NL.ISO-8859-1.xml
    • -0
    • +108
    ./catalog/file-storage.pl_PL.ISO-8859-2.xml
    • -0
    • +54
    ./catalog/file-storage.sh_HR.ISO-8859-5.xml
  1. … 326 more files in changeset.
merge bartt PG 7.3 fixes from HEAD

    • -3
    • +5
    ./tcl/file-storage-procs-postgresql.xql
  1. … 52 more files in changeset.
last_modified should be last_modified_ansi

    • -1
    • +1
    ./tcl/file-storage-procs-postgresql.xql
Merge of all changes from oacs-4-6 to HEAD. All changes up to tag jcd-merge-2

on oacs-4-6 are included.

  1. … 75 more files in changeset.
Patches to make OpenACS PG 7.3 compatible.

    • -4
    • +4
    ./tcl/file-storage-procs-postgresql.xql
  1. … 52 more files in changeset.