• last updated 13 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Migrated the 4.6.1 permissions stuff to HEAD

    • -318
    • +391
    ./sql/oracle/acs-permissions-create.sql
    • -458
    • +603
    ./sql/oracle/groups-body-create.sql
    • -97
    • +119
    ./sql/oracle/rel-segments-body-create.sql
    • -301
    • +223
    ./sql/oracle/rel-segments-create.sql
    • -2
    • +5
    ./sql/postgresql/groups-body-create.sql

Migrated over changes to move some GIF resources into a common subdirectory

in the subsite package, so anyone who can read the main site can read

the images (previously you had to grant read privs to "/doc" explicitly

to get the graphics stored by acs-datetime to show up.

    • -18
    • +20
    ./sql/oracle/rel-segments-create.sql
    • -5
    • +8
    ./sql/postgresql/groups-body-create.sql
    • -19
    • +25
    ./sql/postgresql/rel-segments-create.sql
  1. … 36 more files in changeset.
bumping up allowed length of group_type column in group_types table from 100 to 400. Adding a subject in dotlrn with a 100 length subject pretty_name would break otherwise (the group_type becomes department key + subject pretty_name)

making upgrade script use timestamptz like the create script

I accidently dropped a trigger create when I switched back to dropping and

creating them instead of using "create or replace function" (which doesn't

quite work in PG 7.3 unfortunately when the function's attached to a trigger)

    • -2
    • +5
    ./sql/postgresql/groups-body-create.sql
committing the latest translations from the dotLRN translation server

    • -0
    • +7
    ./catalog/acs-kernel.ast_ES.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/acs-kernel.de_DE.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/acs-kernel.en_US.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/acs-kernel.es_ES.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/acs-kernel.fi_FI.ISO-8859-15.xml
    • -0
    • +7
    ./catalog/acs-kernel.fr_FR.ISO-8859-1.xml
    • -0
    • +7
    ./catalog/acs-kernel.gl_ES.ISO-8859-1.xml
    • -0
    • +7
    ./catalog/acs-kernel.ja_JP.Shift_JIS.xml
    • -1
    • +1
    ./catalog/acs-kernel.nl_NL.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/acs-kernel.no_NO.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/acs-kernel.pl_PL.ISO-8859-2.xml
    • -0
    • +7
    ./catalog/acs-kernel.pt_BR.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/acs-kernel.ru_RU.windows-1251.xml
    • -0
    • +7
    ./catalog/acs-kernel.sv_SE.ISO-8859-1.xml
  1. … 421 more files in changeset.
Sped up the view used to build the denormalized acs_privilege_descendant_map

table.

    • -0
    • +87
    ./sql/postgresql/upgrade/upgrade-4.6.1-4.6.2.sql
Removed Your Workspace from the context bar and put it in the default-master template instead.

  1. … 5 more files in changeset.
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
Upgrade to 4.6.2: APM changes and change in installation procedure

    • -0
    • +676
    ./sql/oracle/upgrade/upgrade-4.6.1-4.6.2.sql
    • -142
    • +0
    ./sql/postgresql/acs-install.sql
    • -0
    • +208
    ./sql/postgresql/upgrade/upgrade-4.6.1-4.6.2.sql
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 ...

    • -8
    • +8
    ./sql/postgresql/acs-objects-create.sql
    • -6
    • +6
    ./sql/postgresql/community-core-create.sql
  1. … 45 more files in changeset.
Made changes so we can install under PG 7.3.

    • -5
    • +8
    ./sql/postgresql/groups-body-create.sql
add email and url as acs_datatypes

    • -1
    • +11
    ./sql/oracle/acs-metadata-create.sql
    • -0
    • +13
    ./sql/oracle/upgrade/upgrade-4.6-4.6.1.sql
    • -0
    • +10
    ./sql/postgresql/acs-metadata-create.sql
Fixed a couple of minor upgrade problems.

    • -20
    • +15
    ./sql/postgresql/upgrade/upgrade-4.6-4.6.1.sql
A bunch of things

1. AOLserver 4.0's nsxml appears to expose a gcc bug which causes the

backwards-compatible "getattr" command to fail. I dug around nsxml

and it does appear to be a gcc bug. I changed to the proper nsxml v2

syntax.

2. In the course of exploring #1 above, I realized that the calls to

dom:: Tcl XML package commands were still being executed despite

being commented out. Typical Tcl misunderstanding on someone's part.

Net effect: we were parsing all APM .info files twice, once in Tcl

and once in ns_xml! Yuk!

3. Fixed a minor notifications bug - you couldn't delete a notification

request if any unsent notifications were pending, causing the homework

package to bomb if you deleted an uploaded homework file and the prof

hadn't yet received their notification.

4. Fixed an obscure corner case in my permissions denormalization code.

    • -19
    • +21
    ./sql/oracle/rel-segments-create.sql
    • -18
    • +24
    ./sql/oracle/upgrade/upgrade-4.6-4.6.1.sql
    • -19
    • +25
    ./sql/postgresql/rel-segments-create.sql
    • -21
    • +29
    ./sql/postgresql/upgrade/upgrade-4.6-4.6.1.sql
  1. … 12 more files in changeset.
forgot about all of the trigger work-arounds for data-change violation problem that no longer exists. Fixed now.

  1. … 3 more files in changeset.
Eliminated acs_privilege_hierarchy_index in favor of using acs_privilege_descendant_map. In addition, rewrote trigger for creating acs_privilege_descendant_map as permissions creation was getting too slow on .LRN. .LRN has somewhere in the neighborhood of 90 entries in the privilege hierarchy, which is much higher than anticipated.

My upgrade invalidated the acs_group package.

    • -0
    • +182
    ./sql/oracle/upgrade/upgrade-4.6-4.6.1.sql
merge bug 180 fix to 4.6 branch

    • -1
    • +1
    ./sql/oracle/upgrade/upgrade-4.2-4.2.1.sql
Moved over my new permissions stuff plus improved file storage stuff (mostly

speed improvements in PG-land)

    • -18
    • +37
    ./sql/oracle/acs-objects-create.sql
    • -19
    • +60
    ./sql/oracle/groups-body-create.sql
    • -37
    • +208
    ./sql/oracle/rel-segments-create.sql
    • -24
    • +26
    ./sql/postgresql/acs-objects-create.sql
    • -64
    • +111
    ./sql/postgresql/groups-body-create.sql
    • -161
    • +201
    ./sql/postgresql/rel-segments-create.sql
  1. … 8 more files in changeset.
the upgrade scripts for message_catalog file type must check if the file type is already there since the upgrade script came so late

    • -1
    • +18
    ./sql/postgresql/upgrade/upgrade-4.7d-4.7.2d.sql
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.

    • -2
    • +18
    ./sql/postgresql/groups-body-create.sql
  1. … 4 more files in changeset.
trying to fix issue with APM upgrade UI breaking on new APM filetype message_catalog described here: http://openacs.org/forums/message-view?message_id=80178 Issuing warning in log file instead of erroring out on un-recognized filetypes. Adding upgrade script to acs-kernel that adds the message_catalog filetype

    • -0
    • +1
    ./sql/oracle/upgrade/upgrade-4.7d-4.7.2d.sql
    • -0
    • +1
    ./sql/postgresql/upgrade/upgrade-4.7d-4.7.2d.sql
  1. … 1 more file in changeset.
rollback Dons commit which should have gone in on 4.6 rather than HEAD

    • -24
    • +16
    ./sql/postgresql/acs-objects-create.sql
    • -206
    • +46
    ./sql/postgresql/groups-body-create.sql
    • -93
    • +160
    ./sql/postgresql/rel-segments-create.sql
    • -1
    • +2
    ./sql/postgresql/rel-segments-drop.sql
Minor bug fix tweaks to the Oracle version, and some rewriting on the

PostgreSQL side to better match the structure of the Oracle side.

    • -1
    • +1
    ./sql/oracle/upgrade/upgrade-4.6-4.6.1.sql
    • -37
    • +19
    ./sql/postgresql/groups-body-create.sql
    • -18
    • +35
    ./sql/postgresql/rel-segments-create.sql
    • -90
    • +162
    ./sql/postgresql/upgrade/upgrade-4.6-4.6.1.sql
Adding parameter PermissionCacheTimeout that determines the lifetime of the permissions cache. Adding comment to PermissionCacheP parameter saying server must be restarted after change. Removing instantiation of acs-kernel in acs-install.sql (not needed as its done in apm_install_package).

change the delete from acs_permissions to be a dynamic sql delete since the table is not defined at the time the package body is created. Its a hack but further cleanup will have to wait for 4.7

    • -1
    • +8
    ./sql/oracle/upgrade/upgrade-4.6-4.6.1.sql
Fixed various problems with the new permissions and minor main site changes

    • -49
    • +35
    ./sql/oracle/groups-body-create.sql
    • -31
    • +79
    ./sql/oracle/upgrade/upgrade-4.6-4.6.1.sql
remove conflict markers from Dons commit. fixes bug 243

finish my sentence about why the pkg body being replaced. Thanks Don.

    • -1
    • +2
    ./sql/oracle/upgrade/upgrade-4.6-4.6.1.sql