I logged this issue: https://dnnevents.codeplex.com/workitem/25807

---------------------------------

On a clients site with 1 general agenda (events module) and 5 location pages with a sub agenda, we tried to include the general agenda on the 5 sub-pages.

The issue I have is that on the first 2 location pages, I can select the main agenda events module as a sub agenda, but on location events module 3-5, this main events module does not show up in the list of available agenda's.
The list stays empty.

I tried clearing cach etc. but the result is the same.

Anybody an idea what could be the cause of this?
(DNN 6.2.9 & Events 6.1.4)

We are not hosting the site, so I currently cannot upgrade to DNN 7

---

Timo,

Are the events modules on those other pages being used as SubCalendars in another calendar? That could be the problem.

In the Stored Procedure "EventsMasterAvailableModules", try commenting out the 6-7 lines from the bottom (ModuleID Not In (select ModuleID from dbo.EventsMaster where SubEventID = @ModuleID) AND a.ModuleID Not In (select ModuleID from dbo.EventsMaster where ModuleID = a.ModuleID) AND) and see if that works.

That section of code prevents a "Master" calendar from ever being used as a Subcalendar and vice-versa.

Ok, I found it, thanks for your guidance.

I did some queries and found this:

Find all Events Modules on this installation:

QUERY:
    SELECT        Modules.ModuleID, TabModules.TabID, DesktopModules.friendlyname, tabmodules.ModuleTitle
    FROM            DesktopModules INNER JOIN
                             ModuleDefinitions ON DesktopModules.DesktopModuleID = ModuleDefinitions.DesktopModuleID INNER JOIN
                             Modules ON ModuleDefinitions.ModuleDefID = Modules.ModuleDefID INNER JOIN
                             TabModules ON Modules.ModuleID = TabModules.ModuleID

    WHERE DesktopModules.friendlyname like '%Events%'

RESULT:
    ModuleID    TabID    friendlyname    ModuleTitle
    801            199        Events            Agenda KA
    810            202        Events            Agenda TH
    815            207        Events            Agenda G
    875            239        Events            Agenda M
    876            240        Events            Agenda KK
    1272        1353    Events            Schoolbrede agenda

Event Master-SubModule Query:

SELECT * FROM EventsMaster

RESULT:
    MasterID    ModuleID    SubEventID
    2            815            1272
    3            801            1272
    9            801            1279
    11            875            1279
    12            810            1279
    13            1272        1279
    15            815            1279


After some time I realised that there is a non existing Sub agenda in the EventsMaster table here (1279).
Something went wrong when this module was deleted (there used to be 2 main agendas).
I'm guessing deleting an Events module does not remove it from the EventsMaster table as a sub calendar?
As the module does not show the non existing sub calendar modules in the list of linked module, you don't see any feedback in the interface..

This was my (now obvious) solution:

EXECUTED:
    SELECT * FROM EventsMaster WHERE SubEventID = 1279
   
Fixed.

Thanks, Timo

 

---