Index: openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/tcl/Attic/sweep-procs-oracle.xql,v
diff -u -r1.18 -r1.19
--- openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql	7 Jun 2008 20:29:01 -0000	1.18
+++ openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql	2 Sep 2008 22:32:00 -0000	1.19
@@ -45,7 +45,7 @@
             where nnr.notification_id = notification_user_map.notification_id(+)
               and nnr.user_id = notification_user_map.user_id(+)
               and notification_user_map.sent_date is null
-              and nnr.notif_date < sysdate
+              and (nnr.notif_date is null or nnr.notif_date < sysdate)
               and acs_objects.object_id = nnr.request_id
               and acs_objects.creation_date <= nnr.notif_date
             order by nnr.user_id, nnr.type_id, nnr.notif_date
Index: openacs-4/packages/notifications/tcl/sweep-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/tcl/Attic/sweep-procs-postgresql.xql,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/notifications/tcl/sweep-procs-postgresql.xql	27 Jun 2007 18:54:48 -0000	1.9
+++ openacs-4/packages/notifications/tcl/sweep-procs-postgresql.xql	2 Sep 2008 22:32:00 -0000	1.10
@@ -34,7 +34,7 @@
               left outer join notification_user_map using (notification_id, user_id)
             where sent_date is null
               and creation_date <= notif_date
-              and notif_date < current_timestamp
+              and (notif_date is null or notif_date < current_timestamp)
               and interval_id = :interval_id
           order by user_id, type_id, notif_date
         </querytext>