• last updated 22 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Bump 'acs-kernel' version number

Modernize logic for protecting against cached passwords from forms,

when users log out and other users use the back button (for Nora).

- switch to more modern caching prevention

- add CSRF protection to login form against forgery requests

- none of the cache-preventing mechanisms helps when the user

stores the password in the browser (no change to the past).

- For admins of existing sites: alter kernel parameter

"LoginPageExpirationTime" to 0 make use of this feature

  1. … 2 more files in changeset.
implementing feature request #3408: support for passing in null values to acs_object__set_attribute

  1. … 2 more files in changeset.
Use a german gender-neutral wording for "members"

  1. … 1 more file in changeset.
Move away portraits created as children of the -100 object that might be still around after acs-kernel/sql/postgresql/upgrade/upgrade-5.10.0d13-5.10.0d14.sql

  1. … 2 more files in changeset.
Fix typo

Data model upgrade for those instances that might have missed the renaming of the person object type

  1. … 1 more file in changeset.
Modernize SQL existence test: make it more readable and faster

  1. … 2 more files in changeset.
Modernize SQL existence test: make these more readable and faster

  1. … 2 more files in changeset.
Reparent portraits coming from the old good days, which were saved with -100 as parent_id (since at least 6 years portraits are saved as children of the user object)

  1. … 2 more files in changeset.
site nodes reform part 2: change from tree_sortkeys to recursive queries

-- This upgrade script completes the commits "change queries on

-- site-node tree from tree_sortkey to recursive queries" from Oct 21,

-- 2018, 4 months ago. This upgrade has the purpose to drop the now

-- obsolete triggers and indices.

--

-- Delaying the 2nd part had the purpose to make upgrades more smooth,

-- at least for upgrades via .apm files. Without site nodes working,

-- users cannot navigate on their server unless it is restarted.

--

-- http://fisheye.openacs.org/changelog/OpenACS?cs=MAIN%3Agustafn%3A20181021173623

-- http://fisheye.openacs.org/changelog/OpenACS?cs=MAIN%3Agustafn%3A20181021175135

-- http://fisheye.openacs.org/changelog/OpenACS?cs=MAIN%3Agustafn%3A20181022074137

-- http://fisheye.openacs.org/changelog/OpenACS?cs=MAIN%3Agustafn%3A20181022085126

-- http://fisheye.openacs.org/changelog/OpenACS?cs=MAIN%3Agustafn%3A20181022081230

--

  1. … 2 more files in changeset.
revert premature commit affecting all sites

  1. … 6 more files in changeset.
Add new column 'public_avatar_p' to the 'user_preferences' table, in order to allow the user to decide wheter to make the avatar (profile picture) public to other users or not, with a conservative default, false. Add also a simple API to get/set that value and bump acs-kernel version number.

  1. … 6 more files in changeset.
Rollback of 'boolean' parameter datatype, as oracle does not see necessary to have 'boolean' datatypes, and they do not even provide with a proper alternative on what to use instead. Great. See: https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:6263249199595#876972400346931526

  1. … 4 more files in changeset.
Add 'boolean' parameter datatype and increase version number

  1. … 4 more files in changeset.
Fix typo

Bring files on oacs-5-10 in sync with HEAD

  1. … 15 more files in changeset.
Reinstate reworked versions of some oracle database utilities left behind during solution of bug #3302

Rework is based on coding style observed in code provided by Brian Fenton, but could still not be tested. See https://openacs.org/bugtracker/openacs/bug?bug_number=3302

  1. … 2 more files in changeset.
schema queries: allow mixed case for column and table names (similar to function_args

bump versiom number to 5.10.0d11

  1. … 2 more files in changeset.
proivde upgrades script for PG 11 and bump version number to 5.9.2d2

  1. … 1 more file in changeset.
document parameter consitently concerning required server restarts

Add @see in deprecated proc, declare acs-kernel.AdminOwner parameter deprecated (superseded by acs-kernel.HostAdministrator)

  1. … 1 more file in changeset.
Change database type for boolean from "bool" to "boolean" in acs_datatypes

  1. … 2 more files in changeset.
Remove obsolete table apm_package_db_types: this was superseded by threaded cache ::acs::known_database_types

  1. … 5 more files in changeset.
imporve spelling

  1. … 6 more files in changeset.
Replace obsolete function bitfromint4() by cast

  1. … 2 more files in changeset.
Replace obsolete funktion bittoint4() by cast

  1. … 2 more files in changeset.
Fix typos

  1. … 52 more files in changeset.
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.

  1. … 16 more files in changeset.
  1. … 2 more files in changeset.