I have tried everything. When a user subscribes to a folder, or if I add the user using subscription manager to a folder - it lasts for only a few minutes. You can refresh subscription manager a few times and actually watch it disappear. Or if you are the user you can view the folders under 'my subscriptions' and they also eventually disappear. Usually in a matter of minutes. Could one of these scheduled jobs be clearing the setting? I see consistent notifications to the superuser from another site where I must have subscribed to test this functionality as host. I am getting no errors. The eMail functionality is very important. PLEASE HELP
THANKS

I think that this running periodically and because of the new site groups it somehow thinks these users are invalid and deletes them. ONLY SuperUser records remain in the dbo.DMX_Subscriptions

USE [USSInteract]
GO
/****** Object: StoredProcedure [dbo].[DMX_RemoveOldUserSubscriptions] Script Date: 05/09/2013 14:27:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[DMX_RemoveOldUserSubscriptions]
AS
-- DNN 5+
BEGIN TRY
EXEC('DELETE FROM dbo.DMX_Subscriptions
FROM dbo.DMX_Subscriptions s
INNER JOIN dbo.DMX_Entries e ON s.EntryId=e.EntryId
WHERE
NOT EXISTS (SELECT up.UserId FROM dbo.UserPortals up WHERE up.PortalId=e.PortalId AND up.UserId=s.UserId AND up.Authorised=1 AND up.IsDeleted=0)
OR NOT EXISTS (SELECT u.UserId FROM dbo.Users u WHERE u.UserId=s.UserId)');
END TRY
BEGIN CATCH
END CATCH;

IT has to do with sitegroups, where the portal ID in entries table does not directly exist in the userportal table. I am trying to figure out how to change this to work with Site Groups. BUG.

This will need to be examined more closely by us. For now sitegroups are not supported in DMX. As I wrote to Jim earlier: DMX was created in an era when data leakage between portals was a cardinal sin. A module was expected to protect against that. With site groups this has changed somewhat. But any change to data binding to the portal goes to the heart of DMX and it is not yet clear if this is even doable.

Peter