Forum OpenACS Q&A: Re: upgrade (was: having problems. Refrain from using it until Sept 25th)

<blockquote> I suspect the problem is the notifications table has just
grown too big since it's not being purged and I vaguely
remember Don maybe having cleaned it out before. Is that
right, Don?

There's a scheduled cleanup proc that does this butI think there's something wrong with the query that returns the list of ids to delete: notification::sweep::cleanup_notifications.select_notification_ids

Currently there are 2507 rows in the notifications table, almost all of which have notif_date older than yesterday.  But the select_notification_ids returns no rows.