• last updated 9 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
delete--> del upgrade

    • -0
    • +404
    ./upgrade/upgrade-4.6.4-5.0d1.sql
merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

    • -5
    • +6
    ./notifications-replies-extra-create.sql
  1. … 595 more files in changeset.
fix inconsistency between notifications-replies-extra-create and upgrade scripts, hopefully this finally fixed 1231

    • -1
    • +1
    ./notifications-replies-extra-create.sql
  1. … 1 more file in changeset.
no need to drop table if you are just changing a constraint.

  1. … 1 more file in changeset.
use clobs for to_addr, headers, body; fix load_qmail_mail_queue.holdinsert query, fix upgrade script, make constriant names conform to standards. Fixes bug 1231

  1. … 3 more files in changeset.
text datatype should be clob for oracle

    • -5
    • +6
    ./notifications-replies-extra-create.sql
making notifications cascade when acs objects are deleted, see bug 260

  1. … 2 more files in changeset.
file upgrade-5.0.0a5-5.0.0a6.sql was initially added on branch oacs-5-0.

    • -0
    • +0
    ./upgrade/upgrade-5.0.0a5-5.0.0a6.sql
  1. … 1 more file in changeset.

o notifications fixes have been completed.

o needed fixes in lt_format_time and html-email-procs.

o Oracle bits /should/ work but are untested at this time.

    • -0
    • +1
    ./notifications-replies-extra-create.sql
    • -486
    • +8
    ./upgrade/upgrade-4.6.4-5.0d1.sql
  1. … 4 more files in changeset.

o updated create/drop scripts

o removed debug statement

o correct param documentation of bounce_mail_message

  1. … 3 more files in changeset.

Added bounce messages for improperly addressed emails and for emails

from unauthorized senders.

Messages follow the qmail-send Bounce Messages Format (QDBMF)

http://cr.yp.to/proto/qsbmf.txt

Added a notification_email_hold table to hold possible bounce messages

until they are accepted by the system.

    • -0
    • +7
    ./notifications-replies-extra-create.sql
    • -0
    • +1
    ./notifications-replies-extra-drop.sql
  1. … 6 more files in changeset.
Added upgrade to upgrade to changes made for Oracle 9i support

    • -0
    • +486
    ./upgrade/upgrade-4.6.4-5.0d1.sql
  1. … 23 more files in changeset.
Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

    • -23
    • +23
    ./notifications-package-create.sql
    • -4
    • +4
    ./notifications-replies-package-create.sql
  1. … 273 more files in changeset.
Applied patch #123: Added dropping of these objects and permissions removal. This should be rolled into acs_object.delete, but if this makes dropping work, that's better than nothing

Merged 4.6.4d1 (unreleased) to HEAD. This marks the end of the life of the oacs-4-6 branch.

  1. … 809 more files in changeset.
Forgot to remove the call to notification-type-sc-create.sql. Can't believe I didn't catch this in my fresh-install test

  1. … 1 more file in changeset.
Added support for notifications going out as the user who sent the notification. This required changing the delivery method service contract, so I moved all service contracts into tcl

  1. … 20 more files in changeset.
file upgrade-4.6.2-4.6.4.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./upgrade/upgrade-4.6.2-4.6.4.sql
  1. … 1 more file in changeset.
merge of 4.6.3b1 to HEAD

    • -0
    • +156
    ./upgrade/upgrade-4.6.1-4.6.2.sql
  1. … 36 more files in changeset.
file upgrade-4.6.1-4.6.2.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./upgrade/upgrade-4.6.1-4.6.2.sql
  1. … 1 more file in changeset.
Upgrade to 4.6.2: Notifications extensions - dynamic notifications recipients.

    • -0
    • +156
    ./upgrade/upgrade-4.6.1-4.6.2.sql
  1. … 18 more files in changeset.
file upgrade-0.4d-4.6.1.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./upgrade/upgrade-0.4d-4.6.1.sql
  1. … 1 more file in changeset.
A bunch of things

1. AOLserver 4.0's nsxml appears to expose a gcc bug which causes the

backwards-compatible "getattr" command to fail. I dug around nsxml

and it does appear to be a gcc bug. I changed to the proper nsxml v2

syntax.

2. In the course of exploring #1 above, I realized that the calls to

dom:: Tcl XML package commands were still being executed despite

being commented out. Typical Tcl misunderstanding on someone's part.

Net effect: we were parsing all APM .info files twice, once in Tcl

and once in ns_xml! Yuk!

3. Fixed a minor notifications bug - you couldn't delete a notification

request if any unsent notifications were pending, causing the homework

package to bomb if you deleted an uploaded homework file and the prof

hadn't yet received their notification.

4. Fixed an obscure corner case in my permissions denormalization code.

  1. … 14 more files in changeset.
Make Oracle version cascade in all the places that the PG version does

    • -0
    • +43
    ./upgrade/upgrade-0.4d-0.5d.sql
  1. … 1 more file in changeset.
Added support for dynamic notifications

  1. … 30 more files in changeset.
file upgrade-0.2d-0.3d.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./upgrade/upgrade-0.2d-0.3d.sql
  1. … 1 more file in changeset.
file upgrade-0.3d-0.4d.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./upgrade/upgrade-0.3d-0.4d.sql
  1. … 1 more file in changeset.
adds indexes for foreign keys, bumps to version 0.4d, upgrade scripts added

  1. … 5 more files in changeset.
Merge of all changes from oacs-4-6 to HEAD. All changes up to tag jcd-merge-2

on oacs-4-6 are included.

  1. … 56 more files in changeset.
1. Changed cleanup sweep interval to 15 minutes

2. Fixed broken PostgreSQL and Oracle queries that were supposed to select

notifications for deletion but rather returned all notifications if any

were ripe for deletion, causing seemingly random failure to deliver

notifications. Sloan had hacked this with a kludge to only delete

notifications older than two days but this didn't work on openacs.org,

which supports weekly summaries of notifications.

3. Changed notification::new to not insert notifications that have no

pending requests. This avoids having to waste time deleting them

afterwards.

4. Added notification_request::request_exists which returns true if

there's at least one notification request for a given object and

notification type.

5. Added a couple of indexes to speed queries that ran slow on openacs.org.

  1. … 9 more files in changeset.