RogerSelwyn wrote Feb 13 at 12:01 PM

OK, I'll close anyway.

bitboxx wrote Feb 12 at 3:08 PM

Sorry Roger I don't know because the customer installed it and I was called to fix the issue ;-)

RogerSelwyn wrote Feb 10 at 12:50 PM

Did you install a beta of 5.2.2, because that script should have been applied as part of the 5.2.2 update?

bitboxx wrote Feb 10 at 12:11 PM

Bingo ! You made my day! Thanx Roger !

RogerSelwyn wrote Feb 10 at 8:27 AM

This should do the job, if not let me know.

IF EXISTS (SELECT * FROM dbo.sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}EventsMasterAvailableModules]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE {databaseOwner}[{objectQualifier}EventsMasterAvailableModules]
GO

/*** EventsMasterAvailableModules ***/

CREATE PROCEDURE {databaseOwner}{objectQualifier}EventsMasterAvailableModules
(
@PortalID int,
@ModuleID int
)
AS
SELECT @ModuleID as ModuleID, c.PortalID, 0 as MasterID, a.ModuleID as SubEventID
FROM {databaseOwner}{objectQualifier}Modules a
LEFT JOIN {databaseOwner}{objectQualifier}ModuleDefinitions b on a.ModuleDefID = b.ModuleDefID
LEFT JOIN {databaseOwner}{objectQualifier}DesktopModules d on b.DesktopModuleID = d.DesktopModuleID
LEFT JOIN {databaseOwner}{objectQualifier}TabModules t on a.ModuleID = t.ModuleID
LEFT JOIN {databaseOwner}{objectQualifier}Tabs c on t.TabID = c.TabID
WHERE
d.ModuleName = 'DNN_Events' AND
c.PortalID = @PortalID and
a.ModuleID Not In (SELECT SubEventID FROM {databaseOwner}{objectQualifier}EventsMaster where ModuleID = @ModuleID) AND
a.ModuleID Not In (SELECT ModuleID FROM {databaseOwner}{objectQualifier}EventsMaster where SubEventID = @ModuleID) AND
a.ModuleID != @ModuleID AND
t.IsDeleted = 0
GROUP BY c.PortalID, a.ModuleID
ORDER BY c.PortalID, a.ModuleID

GO

bitboxx wrote Feb 10 at 7:29 AM

Hi Roger, yes I tested it locally - first with a 5.2.1 version (same issue) then I updated to 5.2.2 - now its working. But live side is still on 5.2.2 ,no chance to update ... Perhaps an sql statement would be fine!

RogerSelwyn wrote Feb 9 at 4:13 PM

Aha, that is a bug that is fixed in 5.2.2. Not sure what version you are using, but either upgrade to 5.2.2 or I can provide the SQL to fix.

bitboxx wrote Feb 9 at 2:08 PM

I can do what I want - I can't get the subcalendar function running. I added an events module on one page and another one on another page. I added events to the first module. On the second module I set "Include Other Site Event Modules" - but the listbox is ALWAYS empty. No idea what is wrong...

RogerSelwyn wrote Feb 8 at 11:13 AM

You can achieve this by using the sub-calendar capability of the module. Either use the master calendar to roll-up events from the sub-calendars. Or use the filter to select from the master calendar. This is the relevant section of the documentation - http://dnnevents.codeplex.com/wikipage?title=Descripition%20of%20the%20Events%20Module%20Settings&referringTitle=Documentation#SubCalendars Settings

Please let me know if this meets your need.