Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

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 ForumsEventsEventsCannot connect sub calendarsCannot connect sub calendars
Previous
 
Next
New Post
2/15/2012 9:31 AM
 

I have been having problems connecting sub calendars within a web portal. I have 3 Event calendars 1 on the home page that should display a list of the other 2 calendars with events. When I go to sub-calendar settings there are no available calendars.

also noticed that when posting recurring events this is what it generates:

Start Date/Time: Wednesday, February 15, 2012 9:30 AM (UTC -05:00) Eastern Time (US & Canada)
End Date/Time: Wednesday, February 29, 2012 10:00 AM (UTC -05:00) Eastern Time (US & Canada)
Recurring Event: Recurring Event Every 1 days until 1/1/0001 (total 15 events)
Importance: Normal Priority


Also noticed that "edit" and "edit series" don't share the changes. when you go to "edit series" and you edit the start date time, the end date time, and recurring date it will not replace the start and end dates, you actually have to go "edit" to change those date. 

When a conflict is true will make the event calendar no available.

I am running DNN6.1.3 and Calendar 5.2.2

I hope this was helpful.


 
New Post
2/15/2012 12:53 PM
Accepted Answer 

Could you let me know when you did the upgrade to Events 5.2.2, because this fix should be included?

Run this SQL in the Host/SQL dialogue.

Cheers
Rogter

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


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
2/15/2012 2:18 PM
 

I am sorry I cannot tell you exactly when I updated Events to 5.2.2 but I did double check the extension Version and that's what it is 5.2.2 it could have been a couple of weeks more or less. I have been working on this prototype nonstop for 2 months.

The script you forwarded did fix the sub calendar connection.

Thank you,

 
New Post
2/15/2012 9:15 PM
 
I was having the same problem so I upgraded from 5.1 to 5.2.2 and now I was able to choose a sub calendar and thought every was good but when I went back to the page with the sub calendar all of the events were removed from the sub calendar. It looks like the events were moved to the main calendar instead of remaining as they set up.

Did you have the same problem?
Any ideas as how to fix this?
 
New Post
2/15/2012 9:43 PM
 
Actually mine is working nicely, I am not a genius on this but I can tell you that I have all three choices checked under SubCalendar Settings so I can pick what ever calendar into any calendar. I hope this helps.
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsEventsEventsCannot connect sub calendarsCannot connect sub calendars


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.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out