• last updated 21 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Temporary mod to cleanup_notifications.select_notification_ids. Old notifications were hanging around, and as they piled up where bogging down sweep_notifications.select_notifications, which computes a product of notifications and notification_requests that can become quite large. Something's going wrong with the outer join, because querying notification_user_map shows that sent_date is not null for all rows. So we're getting non-matching rows for some reason. Have to figure out why. For now we've simply added a clause that permits deletion of any notification with notif_date greater than 30 days old.

Committing an uncommitted change, so that we can have a clean record of the next change, which I'm about to make.

Applied Robert Locke's fix for the cleanup proc

Added Envelope and Mail-Followup-To headers

commit changes from Dons fixes for sweeper and Bart for From as sender and reply-to as notifications-blah

    • -3
    • +5
    ./sql/oracle/notifications-core-create.sql
    • -4
    • +23
    ./tcl/notification-display-procs.tcl
    • -1
    • +10
    ./tcl/notification-request-procs.tcl
    • -28
    • +22
    ./tcl/sweep-procs-postgresql.xql
*** empty log message ***

*** empty log message ***

Send notifications in the name of the owner with a reply-to of the mailer

    • -0
    • +20
    ./tcl/notification-email-procs.xql

- Send notifications in the name of the owner with a reply address of the mailer.

Clean up comments

Remove old query

Add type_id to object-goto URL, we can't get the notification type from

the object_id alone.

Modified to query the notification_types table for the service

contract implementation to grab the url when redirecting to the object page.

remove forums specific sql

adds comment from dave

run notifications cleanup every 2 days, not every 60 secs

redirect for registration on manage, add redirect to manage as index.tcl

cleanups on the manage link

    • -27
    • +33
    ./tcl/notification-email-procs.tcl
Initial revision

    • -0
    • +1
    ./sql/oracle/upgrade/upgrade-0.1d-0.2d.sql
    • -0
    • +13
    ./sql/postgresql/upgrade/upgrade-0.1d-0.2d.sql
    • -0
    • +14
    ./tcl/notifications-security-procs.xql
    • -0
    • +39
    ./www/manage-oracle.xql
    • -0
    • +44
    ./www/manage-postgresql.xql
    • -0
    • +23
    ./www/object-goto.tcl
  1. … 398 more files in changeset.
*** empty log message ***

added extra notification intervals for openacs.org

    • -0
    • +32
    ./sql/postgresql/extra-intervals.sql
Initial revision

    • -0
    • +82
    ./notifications.info
    • -0
    • +68
    ./sql/oracle/delivery-method-sc-create.sql
    • -0
    • +61
    ./sql/oracle/email-sc-impl-create.sql
    • -0
    • +68
    ./sql/oracle/notification-type-sc-create.sql
    • -0
    • +223
    ./sql/oracle/notifications-core-create.sql
    • -0
    • +49
    ./sql/oracle/notifications-core-drop.sql
    • -0
    • +26
    ./sql/oracle/notifications-create.sql
    • -0
    • +49
    ./sql/oracle/notifications-init.sql
    • -0
    • +389
    ./sql/oracle/notifications-package-create.sql
    • -0
    • +22
    ./sql/oracle/notifications-package-drop.sql
    • -0
    • +44
    ./sql/oracle/notifications-replies-create.sql
    • -0
    • +83
    ./sql/oracle/notifications-replies-package-create.sql
    • -0
    • +72
    ./sql/postgresql/delivery-method-sc-create.sql
    • -0
    • +67
    ./sql/postgresql/email-sc-impl-create.sql
    • -0
    • +73
    ./sql/postgresql/notification-type-sc-create.sql
  1. … 7569 more files in changeset.