• last updated 20 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
proivde upgrades script for PG 11 and bump version number to 5.9.2d2

backport from HEAD for PG 11

Backport fix to https://openacs.org/bugtracker/openacs/bug?format=table&bug_number=3331: fix original problematic update

    • -0
    • +20
    ./sql/postgresql/upgrade/upgrade-5.9.1-5.9.2d1.sql
- do not depend on beta or development versions

- make sure that released versions are not beta or development

- align version numbers (e.g. use also 5.9.1 for xotcl-core)

- bump version numbers to 5.9.1

  1. … 83 more files in changeset.
Updated spanish translation

    • -0
    • +22
    ./catalog/acs-kernel.es_ES.ISO-8859-1.xml
  1. … 13 more files in changeset.
Update italian translation

    • -1
    • +23
    ./catalog/acs-kernel.it_IT.ISO-8859-1.xml
bump version numbers to 5.9.1b9 respectively to 2.9.1b9 to prepare for release

  1. … 91 more files in changeset.
Use quotes consistently around group/community names

    • -6
    • +6
    ./catalog/acs-kernel.de_DE.ISO-8859-1.xml
    • -6
    • +6
    ./catalog/acs-kernel.en_US.ISO-8859-1.xml
  1. … 2 more files in changeset.
extend message keys

    • -75
    • +94
    ./catalog/acs-kernel.de_DE.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/acs-kernel.en_US.ISO-8859-1.xml
Support internationalization via [group::get_member_state_pretty] and

other related messages concerning state changes.

    • -78
    • +99
    ./catalog/acs-kernel.en_US.ISO-8859-1.xml
  1. … 4 more files in changeset.
Fix spelling errors

    • -2
    • +2
    ./sql/oracle/test/rel-constraints-test.sql
    • -2
    • +2
    ./sql/oracle/test/rel-segments-test.sql
    • -6
    • +6
    ./sql/oracle/upgrade/upgrade-4.5-4.5.1.sql
    • -11
    • +11
    ./sql/oracle/upgrade/upgrade-5.0d9-5.0d13.sql
  1. … 34 more files in changeset.
Fix wrong version number

Fix upgrade logics, because old instances named constraint differently. Also, skip execution when not needed, as can be demanding (acts on acs_objects).

Added missing data model upgrade from version 5.2, affecting long lived installations.

applied changes provided by Brian for oracle. For details, see issue #3302

    • -143
    • +61
    ./sql/oracle/utilities-create.sql
    • -123
    • +60
    ./sql/oracle/upgrade/upgrade-5.9.1d18-5.9.1d19.sql
    • -142
    • +59
    ./sql/oracle/upgrade/upgrade-5.9.1d19-5.9.1d20.sql
Fix issue #3300 and #3301: index name breaks Oracle name length limit of 30 chars

- bump version number of OpenACS to 5.9.1b3 and DotLRN to 2.9.1b3

  1. … 79 more files in changeset.
Updating of German translation for many packages (many thanks to Markus Moser)

    • -0
    • +21
    ./catalog/acs-kernel.de_DE.ISO-8859-1.xml
  1. … 25 more files in changeset.
Updated es_ES translation

    • -0
    • +5
    ./catalog/acs-kernel.es_ES.ISO-8859-1.xml
  1. … 20 more files in changeset.
Bump version numbers for OpenACS 5.9.1b1

  1. … 81 more files in changeset.
Italian localization of message keys for many packages

    • -6
    • +29
    ./catalog/acs-kernel.it_IT.ISO-8859-1.xml
  1. … 25 more files in changeset.
Added new database utility to retrieve primary keys of a table.

Source for the postgres version: https://wiki.postgresql.org/wiki/Retrieve_primary_key_columns

Source for the oracle version: http://stackoverflow.com/questions/4749650/function-that-would-return-the-data-retreived-from-a-select-query-oracle

    • -0
    • +245
    ./sql/oracle/upgrade/upgrade-5.9.1d19-5.9.1d20.sql
    • -1
    • +18
    ./sql/postgresql/utilities-create.sql
Added new database functions to check for various properties and constraints in database metadata:

- foreign key constraint

- unique constraint

- not null constraint

- get column default value

    • -1
    • +117
    ./sql/oracle/utilities-create.sql
    • -0
    • +225
    ./sql/oracle/upgrade/upgrade-5.9.1d18-5.9.1d19.sql
    • -9
    • +155
    ./sql/postgresql/utilities-create.sql
- add nonces to script tags

- add body handlers

  1. … 7 more files in changeset.
- Improved compatiblity with PostgreSQL before 9.2:

don't use SQL-language function names to reference parameters to

obtain compatibility for earlier PostgreSQL versions

(see https://www.postgresql.org/docs/9.2/static/release-9-2.html

item E.19.3.9.3)

- fix upgrade script for PostgreSQL before 9.2: the old version checked

already the version number, but actually the SQL compilation failed

due to the unknown "IF EXISTS" for sequences.

- Added support for W3C Content Security Policy(CSP)

* For details about CSP, see https://www.w3.org/TR/CSP/

* New calls:

security::csp::nonce:

Generate a CSP nonce token token

security::csp::require /directive/ /value/:

Add a requirements of a page to the CSP in order to generate

later a tailored policy with the minimal permissions for

this page. For example, the following requirement is

currently added per default to the oacs-master template to

permit style tags and style attribites in the markup.

security::csp::require style-src 'unsafe-inline'

security::csp::render:

Generate a policy from the requirements

* Added Kernel Parameter CSPEnabledP to activate/desctivate CSP

(default on)

- Bump version numbers

acs-tcl to 5.9.1d11

acs-bootstrap-installer to 5.9.1d4

acs-kernel to 5.9.1d17

  1. … 7 more files in changeset.
- add kernel parameter to make ad_session_id cookies secure (useful on sites, where all sessions are via https, improves security rating on e.g. mozillas observatory tool)

  1. … 1 more file in changeset.
- don't change names of arguments unless necessary, since such cases require a DROP FUNCTION