antoniop in OpenACS

Fix typo

*** empty log message ***

Fix typo

Upgrade fix

Execute cleanup only if explicitly uncommented, as might have performance implications.

Also, correct unaligned constraint names in old instances upgraded incrementally over the years.

Add missing change in the data model from previous commit

Portrait management reform and correction

Moved logics to create a portrait in a proc in order to reuse it in other places

such as picture retrieval services (e.g. Bach picture retrieval at WU). Turns out

we were not doing our homeworks here: when the portrait is created into CR, a

cr_child_rel is created. When the portrait was erased though, this was not cleaned

up propely, leaving dangling acs_objects with no reference in cr_child_rels table.

On busy sites, this can grow in the ten thousands order of magnitude. Changes include

also fix for this behavior and tuples cleanup.

Bump version number on HEAD in agreement with version on 5-9 branch

Backport fix for https://openacs.org/forums/message-view?message_id=5386710 on the oacs-5-9 branch (requires bumping the version number)

Make so that these clauses are really clauses and not time intervals, as downstream code will be hacky otherwise

Improve previous fix: don't specify root folder at all and let file-storage deal with this

Bugfix: make sure root_folder_id exists or dotlrn won't display community folder correctly

Fix missing default value

Fix extra parenthesys

Bugfix: content variable was not define before access (thanks to Giulia Nencini)

I am also not reading file content anymore, as this is potentially unsafe when file is very big and also could need special encoding translation etc.

Better retrieve the path and let the user decide what to do afterwards.

Bugfix, get also id_column from acs_object_type retrieval

Revert changes not meant to be committed

Fix typo

Reduce divergencies between oracle and postgres codebase, replace queries with proper api, exploit on delete cascade

Specify default for max sort order (fixes but-tracker installation)

Reduce divergencies between oracle and postgres codebase

Reduce divergencies between oracle and postgres codebase

Correct non-portable usage of limit idiom

Reduce divergencies between oracle and postgres codebase

Reduce divergencies between oracle and postgres codebase

Insert missing from dual idiom

Reduce divergencies between oracle and postgres codebase, remove obsolete query as one that is supposed to be executed is directly in tcl

Reduce divergencies between oracle and postgres codebase

    • -0
    • +15
    /openacs-4/packages/forums/lib/forums/forums-chunk.xql
Fix typo

Reduce divergencies between oracle and postgres codebase by using api when available and avoiding unnecessary xql queries

Reduce divergencies between oracle and postgres codebase

    • -0
    • +55
    /openacs-4/packages/dotlrn/www/admin/user.xql