• last updated 8 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Fixes for Oracle 19c: made set_live_revision compatible with postgres version

  1. … 1 more file in changeset.
More fixes for Oracle 19c in essential packages

in essence, this fixes

- package content_item

- package content_folder

with the following errors popping at at installation:

Errors for PACKAGE BODY CONTENT_FOLDER:

LINE/COL ERROR

-------- -----------------------------------------------------------------

76/11 PLS-00323: subprogram or cursor 'COPY' is declared in a package

specification and must be defined in the package body

Errors for PACKAGE BODY CONTENT_ITEM:

LINE/COL ERROR

-------- -----------------------------------------------------------------

22/10 PLS-00323: subprogram or cursor 'NEW' is declared in a package

specification and must be defined in the package body

40/1 PL/SQL: Item ignored

67/38 PLS-00382: expression is of wrong type

275/11 PLS-00323: subprogram or cursor 'SET_LIVE_REVISION' is declared

in a package specification and must be defined in the package

body

DRG-10595: ALTER INDEX CR_REV_ATTRIBUTE_INDEX failed

DRG-11000: invalid keyword SYNC

DRG-10595: ALTER INDEX CR_REV_CONTENT_INDEX failed

DRG-11000: invalid keyword SYNC

  1. … 2 more files in changeset.
merged changes from the oacs-5-9 branch and resolved conflicts

  1. … 7834 more files in changeset.
Content-Repository Reform: reduce dependency on cr_child_rels and make

creation of cr_child_rels entries optional. Most applications do not

need cr_child_rels, these take substantial space and slow down

operations. The change is fully backward compatible, since per

default cr_child_rels are still created. First tests show an

improvement for the creation of cr_items by 17% and for deletion by

28% (when parent item is a plain cr_item, as it is e.g. the case in

xwowiki). Same change made as well for Oracle.

- affected functions (here with pg-names)

* procedure content_item__new/21 (version for text or file entries) has new optional boolean parameter: with_child_rels

* procedure content_item__new/17 (version for blob entries) has new optional boolean parameter: with_child_rels

- remove/reduce dependency on cr_child_rels (if no rel-tag is used, the chile-information is obtained from cr_items)

* content_item__is_publishable/1

* content_item__is_valid_child/3

* content_item__is_valid_child/2

- reduce number of functions by using defaults

* content_item__copy/5

* content_item__get_title/2

* content_item__move/3

  1. … 4 more files in changeset.
- Add argument to content_item__set_live_revision (and oracle's counterpart)

to honor optionally provided "publish_date". The old behavior used hard-coded

the current time. The function is fully backward compatible, when no

publish_date is provided, the current time is used for the publish_date.

- changes for PostgreSQL and Oracle.

  1. … 4 more files in changeset.
Got rid of stupid logging of delete operations, just as I did on PG.

Merged acs-core oacs-5-2 (currently 5.2.3) -> HEAD.

TODO:

1. Bump acs-core package version numbers to 5.3.0d1

2. Would be nice to do a test install, wouldn't it?

  1. … 721 more files in changeset.
Remove code that guesses package_id based on parent_id

  1. … 2 more files in changeset.
Changes to make the root of parentless items = -4 (security context root) instead of 0 (unregistered visitor)

Sites upgradeed from 4.6-4.6.1 have been operating with -4 as the parent_id for years (for example openacs.org) while new installs had

parent_id = 0. This caused problems with the new package_id code that calls content_item__get_root_folder which was assuming the root =

0. It looks like the new install code did not accomodate parent_id=-4 and that is now fixed.

Needs testing on Oracle.

  1. … 7 more files in changeset.
Bugfix

  1. … 1 more file in changeset.
commit to HEAD of merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20050111 and jcd-merge-5-1-20050224

  1. … 321 more files in changeset.
fixed some upgrade scripts for oracle

  1. … 7 more files in changeset.
merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040712 and jcd-merge-5-1-20040724 to HEAD

  1. … 138 more files in changeset.
add view content_item_globals, which already exists for PG but was missing for Oracle

  1. … 2 more files in changeset.
merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040517 and jcd-merge-5-1-20040628 to HEAD

  1. … 687 more files in changeset.
Changed CR "rename" procs to "edit_name" to avoid issues with Oracle 9.2 (and

changed PG for consistency)

  1. … 25 more files in changeset.
Further fixing of bug #1858

  1. … 3 more files in changeset.
merge changes on oacs-5-1 branch to head, changes between jcd-merge-20040420 and jcd-merge-5-1-20040517 were merged, head pre changes is jcd-merge-pre-20040517 and post is jcd-merge-post-20040517

  1. … 834 more files in changeset.
Fix content_item.rename to actually have an effect.

merge all the changes on the oacs-5-1 and dotlrn-2-0 branches up to tag jcd-merge-20040420

  1. … 647 more files in changeset.
various bug fixes for package_id, title addition to acs_objects

  1. … 4 more files in changeset.
fixing bug 1598

  1. … 1 more file in changeset.
Remerge Timo's changes for tip 42,43, cf tip 53

  1. … 97 more files in changeset.
rollback of Timo's name, package_id commit; see TIP 53

  1. … 96 more files in changeset.
TIP#42,43: adding package_id and title to acs_objects table

  1. … 96 more files in changeset.
modified content_item.get_title to return a useful label for extlinks (postgres and oracle)

  1. … 1 more file in changeset.
Fix content_item.move and content_folder.move

  1. … 2 more files in changeset.
Fix missing commas in function definitions

Added optional name parameter to content_item.copy and content_item.move.

merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

  1. … 598 more files in changeset.