Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsEventsEventsIssue sharing eventsIssue sharing events
Previous
 
Next
New Post
11/20/2014 8:02 AM
 

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

 
New Post
11/20/2014 11:21 AM
 
Hi Timo,

I can try and take a look at this (sorry this isn't a return to normal working). If you can give me access so I can run some SQL queries I'll try to have a look at the stored procedures and see if there is something wrong.

Webmaster @ the domain in my profile.

Thanks
Roger

DNN MVP
Events - Get the latest version - Upgrade now!!
Feedback 6.4.2 - Now available - Give it a go!
Find us on Codeplex - DNN Events, DNN Feedback
Requirements/Bugs - Please submit them on Codeplex
 
New Post
11/21/2014 2:34 PM
 
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.
 
New Post
11/25/2014 4:01 AM
 
Mike Riley wrote:
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 thought I had email notification on..
Apparently not.. :-)
I will see if I can try what Mike suggested first and get back.
(As this client hosts somewhere else, I have no direct access to the SQL server unfortunately)

 
New Post
12/3/2014 8:14 AM
 

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

 

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsEventsEventsIssue sharing eventsIssue sharing events


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.

Content Layout

Subscribe to DNN Digest

DNN Digest is our monthly email newsletter. It highlights news and content from around the DNN ecosystem, such as new modules and themes, messages from leadership, blog posts and notable tweets. Keep your finger on the pulse of the ecosystem by subscribing.  

What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out