• last updated 16 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
add a link to the parameters page

the upgrade failed because notification_user_map constraint notif_user_map_notif_id_fk needed the pk on notifications_bak, now drops it and recreates it after the table is reloaded

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

    • -0
    • +16
    ./tcl/notification-email-procs-oracle.xql
file notification-email-procs-oracle.xql was initially added on branch oacs-5-0.

    • -0
    • +0
    ./tcl/notification-email-procs-oracle.xql
text datatype should be clob for oracle

    • -5
    • +6
    ./sql/oracle/notifications-replies-extra-create.sql
bumping up version number for the on delete cascade change to notifications.response_id column

making notifications cascade when acs objects are deleted, see bug 260

    • -2
    • +3
    ./sql/oracle/notifications-core-create.sql
file upgrade-5.0.0a5-5.0.0a6.sql was initially added on branch oacs-5-0.

    • -0
    • +0
    ./sql/oracle/upgrade/upgrade-5.0.0a5-5.0.0a6.sql
    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-5.0.0a5-5.0.0a6.sql
adding the all_intervals, and the all_delivery_methods switches to notification::type::new proc

cleaned up files: updated require sections, removed references to arsdigita and openforce, and replaced out-of-date owner info. Most of these edits were done by hand due to bug 1106; I tried to do the same things the APM would do (remove file sections, etc) and updating the release date to today

  1. … 19 more files in changeset.
updated all to 5.0.0a5, cleaned up require sections that listed multiple versions, and updated package owner info

  1. … 18 more files in changeset.
add -- to all string_truncate calls

  1. … 11 more files 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
    ./sql/oracle/notifications-replies-extra-create.sql
    • -486
    • +8
    ./sql/oracle/upgrade/upgrade-4.6.4-5.0d1.sql
    • -0
    • +8
    ./sql/postgresql/upgrade/upgrade-4.6.4-5.0d1.sql

o updated create/drop scripts

o removed debug statement

o correct param documentation of bounce_mail_message

    • -0
    • +1
    ./sql/postgresql/notifications-create.sql
    • -0
    • +1
    ./sql/postgresql/notifications-drop.sql

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
    ./sql/oracle/notifications-replies-extra-create.sql
    • -0
    • +1
    ./sql/oracle/notifications-replies-extra-drop.sql
    • -0
    • +7
    ./sql/postgresql/notifications-replies-extra-create.sql
    • -0
    • +1
    ./sql/postgresql/notifications-replies-extra-drop.sql
exporting catalog files from the translation server

    • -5
    • +5
    ./catalog/notifications.da_DK.ISO-8859-1.xml
  1. … 126 more files in changeset.
exporting catalog files from the translation server

    • -2
    • +0
    ./catalog/notifications.ms_my.utf-8.xml
    • -11
    • +11
    ./catalog/notifications.nl_NL.ISO-8859-1.xml
  1. … 135 more files in changeset.
make some Notices either warnings or debug and made them more descriptive by generally including the proc name as well bug #1032

    • -11
    • +11
    ./tcl/notification-email-procs.tcl
  1. … 72 more files in changeset.
Danish translation

    • -5
    • +5
    ./catalog/notifications.da_DK.ISO-8859-1.xml
  1. … 1 more file in changeset.
removing obsolete catalog files

    • -23
    • +0
    ./catalog/notifications.fi_FI.ISO-8859-15.xml
  1. … 23 more files in changeset.
changed more log Notices to Debugs

exporting messages from translation server

    • -2
    • +2
    ./catalog/notifications.ast_ES.ISO-8859-1.xml
    • -2
    • +2
    ./catalog/notifications.da_DK.ISO-8859-1.xml
    • -2
    • +2
    ./catalog/notifications.de_DE.ISO-8859-1.xml
    • -2
    • +2
    ./catalog/notifications.en_US.ISO-8859-1.xml
    • -2
    • +2
    ./catalog/notifications.es_ES.ISO-8859-1.xml
    • -2
    • +2
    ./catalog/notifications.fr_FR.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/notifications.gl_ES.ISO-8859-1.xml
    • -2
    • +2
    ./catalog/notifications.it_IT.ISO-8859-1.xml
    • -13
    • +13
    ./catalog/notifications.nl_NL.ISO-8859-1.xml
    • -2
    • +2
    ./catalog/notifications.no_NO.ISO-8859-1.xml
    • -2
    • +2
    ./catalog/notifications.pt_BR.ISO-8859-1.xml
    • -2
    • +2
    ./catalog/notifications.pt_PT.ISO-8859-1.xml
    • -2
    • +2
    ./catalog/notifications.sv_SE.ISO-8859-1.xml
  1. … 385 more files in changeset.
re-adding non-ISO-8859-1 catalog files with utf-8 encoding

    • -0
    • +14
    ./catalog/notifications.AR_EG.utf-8.xml
    • -0
    • +21
    ./catalog/notifications.AR_LB.utf-8.xml
    • -0
    • +21
    ./catalog/notifications.fi_FI.utf-8.xml
    • -0
    • +20
    ./catalog/notifications.hu_HU.utf-8.xml
    • -0
    • +21
    ./catalog/notifications.ko_KR.utf-8.xml
    • -0
    • +21
    ./catalog/notifications.ms_my.utf-8.xml
    • -0
    • +21
    ./catalog/notifications.pl_PL.utf-8.xml
    • -0
    • +5
    ./catalog/notifications.ru_RU.utf-8.xml
  1. … 343 more files in changeset.
removing non-ISO-8859-1 catalog files. They will be re-added in utf-8 in a moment

    • -14
    • +0
    ./catalog/notifications.AR_EG.ISO-8859-6.xml
    • -21
    • +0
    ./catalog/notifications.AR_LB.ISO-8859-6.xml
    • -21
    • +0
    ./catalog/notifications.fi_FI.utf-8.xml
    • -21
    • +0
    ./catalog/notifications.ko_KR.EUC-KR.xml
    • -19
    • +0
    ./catalog/notifications.ms_my.US-ASCII.xml
    • -21
    • +0
    ./catalog/notifications.pl_PL.ISO-8859-2.xml
  1. … 303 more files in changeset.
taking action on lost gl_ES messages (http://openacs.org/forums/message-view?message_id=133859). The messages had ended up in message files with locale utf-8 (don't know why yet). Moving the messages back to ISO-8859-1 files and removing the utf-8 files

    • -22
    • +0
    ./catalog/notifications.gl_ES.utf-8.xml
  1. … 29 more files in changeset.
taking action on lost gl_ES messages (http://openacs.org/forums/message-view?message_id=133859). The messages had ended up in message files with locale utf-8 (don't know why yet). Moving the messages back to ISO-8859-1 files and removing the utf-8 files

    • -1
    • +1
    ./catalog/notifications.gl_ES.ISO-8859-1.xml
  1. … 14 more files in changeset.
removing I18N messages no longer used (almost 200). Collapsing certain keys to make translation easier. Our message key structure is still too fragmented in many places (we have too many keys)

    • -1
    • +0
    ./catalog/notifications.AR_LB.ISO-8859-6.xml
    • -1
    • +0
    ./catalog/notifications.ast_ES.ISO-8859-1.xml
    • -1
    • +0
    ./catalog/notifications.da_DK.ISO-8859-1.xml
    • -1
    • +0
    ./catalog/notifications.de_DE.ISO-8859-1.xml
    • -1
    • +0
    ./catalog/notifications.en_US.ISO-8859-1.xml
    • -1
    • +0
    ./catalog/notifications.es_ES.ISO-8859-1.xml
    • -1
    • +0
    ./catalog/notifications.fi_FI.utf-8.xml
    • -3
    • +1
    ./catalog/notifications.gl_ES.ISO-8859-1.xml
    • -1
    • +0
    ./catalog/notifications.it_IT.ISO-8859-1.xml
    • -1
    • +0
    ./catalog/notifications.ko_KR.EUC-KR.xml
    • -1
    • +0
    ./catalog/notifications.ms_my.US-ASCII.xml
    • -1
    • +0
    ./catalog/notifications.nl_NL.ISO-8859-1.xml
    • -1
    • +0
    ./catalog/notifications.no_NO.ISO-8859-1.xml
    • -1
    • +0
    ./catalog/notifications.pl_PL.ISO-8859-2.xml
    • -1
    • +0
    ./catalog/notifications.pt_BR.ISO-8859-1.xml
  1. … 281 more files in changeset.
Added upgrade to upgrade to changes made for Oracle 9i support

    • -0
    • +486
    ./sql/oracle/upgrade/upgrade-4.6.4-5.0d1.sql
  1. … 23 more files in changeset.
Updated version numbers to upgrade to changes made for Oracle 9i support

  1. … 37 more files in changeset.
adding latest translations from the translation server. Will tidy up the files next using the check-catalog.sh script.

    • -0
    • +22
    ./catalog/notifications.ast_ES.ISO-8859-1.xml
    • -2
    • +2
    ./catalog/notifications.da_DK.ISO-8859-1.xml
    • -2
    • +1
    ./catalog/notifications.de_DE.ISO-8859-1.xml
    • -2
    • +1
    ./catalog/notifications.en_US.ISO-8859-1.xml
    • -2
    • +1
    ./catalog/notifications.es_ES.ISO-8859-1.xml
    • -0
    • +22
    ./catalog/notifications.fi_FI.utf-8.xml
    • -0
    • +10
    ./catalog/notifications.fr_FR.ISO-8859-1.xml
    • -0
    • +22
    ./catalog/notifications.gl_ES.utf-8.xml
    • -2
    • +1
    ./catalog/notifications.it_IT.ISO-8859-1.xml
    • -2
    • +1
    ./catalog/notifications.ko_KR.EUC-KR.xml
    • -2
    • +1
    ./catalog/notifications.ms_my.US-ASCII.xml
    • -2
    • +1
    ./catalog/notifications.nl_NL.ISO-8859-1.xml
    • -2
    • +1
    ./catalog/notifications.no_NO.ISO-8859-1.xml
    • -2
    • +1
    ./catalog/notifications.pl_PL.ISO-8859-2.xml
    • -2
    • +1
    ./catalog/notifications.pt_BR.ISO-8859-1.xml
  1. … 630 more files in changeset.