• last updated 20 hours ago
Constraints: committers
Constraints: files
Constraints: dates
Converge downstream reading_info feature with upstream

Port downstream only idiom to update reading_info table

Make more use of api when retrieving forum and message information

Optimize message existance query

Fix sql update to populate new forum_id column in existing data

Maintenance of forum reading count feature

- removal of forums_reading_info_user (1Mio rows on Learn@WU).

This materialized view had to be constantly synced with

forums_reading_info table. Reimplemented as view.

- simplify logics in stored procedure due to new datamodel

- fix inconsistencies between oracle and postgres function definition

- re-enabled parameter to decide whether use these stats or not in


TODO: consider further reform of this feature as stats grow very

large on busy sites for probably little value added

    • -2
    • +2
    • -5
    • +2
Remove deprecated idioms and unneded queries

Persist sanitized timestamp into data object before saving (Many thanks to Markus Moser)

Implement post anonymously through explicit forum attribute in table

Now moderators can explicitly decide whether a forum will enable posting anonymously or not.

Forum must be in a policy different from closed and the anonymous flag must be set accordingly for this to happen.


- normalize api in a way it can accomodate all current attributes. In particular,

now edit api will now leave every unspecified attribute unchanged, instead of

setting it to some default.

- fix some usability issues when managing forum parameters (e.g. values not

retrieved in form when editing existing forum)

- introduce missing Oracle upgrade script for the whole forum reform

- fix oracle creation script

    • -2
    • +2
    • -18
    • +18
    • -7
    • +27
    • -8
    • +12
Update docs: remove broken links and remove/update obsolete section

  1. … 285 more files in changeset.
further cleanup for XOTcl2

    • -99
    • +101
    • -24
    • +0
Simplify idiom

Since PostgreSQL 10 does not support the tsearch2 backword compatibility package anymore, make sure that OpenACS does not use the old names requiring this package.

Revert db_exec_plsql or Oracle will break, remove leftover xql files

restrict detail statistics to swa

Optimize query by using multi-object permission checking and trying to filter the most tuples before joining cr_items with cr_revisions

Reduce divergence between oracle and postgres

Fix oracle systax to call function via select

Uniform API when deleting folder, drill through some calling levels in stored procedure, use a simpler db_string instead of db_exec_plsql

Fix broken links

Remove broken links

make sure to create in initialize WorkflowContext new and remove duplicated instproc

    • -10
    • +6
Bring legacy versions of image__new() in sync with the actual definitions

fix variable reference

check stripped_name before trying to import the prototype page

    • -3
    • +5
Fixes for previous commit

Bump version number

    • -2
    • +2
Prefer XOTcl2 idioms

    • -114
    • +108
    • -486
    • +481
    • -187
    • +187
Prefer XOTcl2 idioms

    • -154
    • +134
    • -55
    • +52
    • -225
    • +225
Prefer XOTcl2 idioms

    • -110
    • +100
    • -46
    • +45
Prefer XOTcl2 idioms

    • -119
    • +111
Prefer XOTcl2 idioms

    • -56
    • +54
    • -24
    • +24
    • -31
    • +31
prefer XOTcl2 idioms

    • -115
    • +92