• last updated 6 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

  1. … 3 more files in changeset.
*** empty log message ***

*** empty log message ***

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

    • -0
    • +20
    ./notification-email-procs.xql
adds comment from dave

run notifications cleanup every 2 days, not every 60 secs

cleanups on the manage link

OpenACS update 2002-10-08

  1. … 2803 more files in changeset.
Initial revision

    • -0
    • +14
    ./notifications-security-procs.xql
  1. … 405 more files in changeset.
*** empty log message ***

OpenACS update 2002-08-05

    • -0
    • +10
    ./notification-procs-postgresql.xql
  1. … 54 more files in changeset.
OpenACS update 2002-07-25

    • -0
    • +6
    ./notification-request-procs-postgresql.xql
  1. … 119 more files in changeset.
Importing OpenACS 4.5devel 2002-06-09

    • -0
    • +0
    ./notification-reply-procs-postgresql.xql
    • -0
    • +0
    ./notification-request-procs-oracle.xql
    • -0
    • +0
    ./notification-request-procs-postgresql.xql
  1. … 7569 more files in changeset.
Initial revision

    • -0
    • +56
    ./delivery-method-procs.tcl
    • -0
    • +13
    ./delivery-method-procs.xql
    • -0
    • +26
    ./interval-procs.tcl
    • -0
    • +66
    ./notification-display-procs.tcl
    • -0
    • +224
    ./notification-email-procs.tcl
    • -0
    • +14
    ./notification-procs-oracle.xql
    • -0
    • +12
    ./notification-procs-postgresql.xql
    • -0
    • +89
    ./notification-procs.tcl
    • -0
    • +73
    ./notification-procs.xql
    • -0
    • +14
    ./notification-reply-procs-oracle.xql
    • -0
    • +12
    ./notification-reply-procs-postgresql.xql
    • -0
    • +51
    ./notification-reply-procs.tcl
    • -0
    • +13
    ./notification-reply-procs.xql
    • -0
    • +22
    ./notification-request-procs-oracle.xql
    • -0
    • +12
    ./notification-request-procs-postgresql.xql
  1. … 7569 more files in changeset.