Events List View Not Showing Any Events - Events

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

Home All Forums

1
2
3
4
5

Events List View Not Showing Any Events

1/8/2017 7:44 PM

Gerald Ncube

Joined: 11/27/2006

Posts: 26

Events List View Not Showing Any Events

This is a strange case of the events module working fine in calendar and week views. However one changes to the list view no events are listed event though there is a good number of events on the calendar. If you navigate to the events calendar on my site the default view has been set as calendar month view http://wmrtc.org.uk/training/calendar this works fine giving a list of courses that are running within the displayed month.

On changing to list view a blank table is displayed when using repeater or table view. http://wmrtc.org.uk/training/calendar/ModuleID/435/mctl/EventList

There is no error message to debug and find why the event list is returning no results.

My current portal settings are as below:

Product:

DNN Platform

Version:

8.0.3

Host GUID:

30060CD5-5A9B-4C9C-8189-6B954410FA4A

CAS Permissions:

ReflectionPermission, WebPermission, AspNetHostingPermission

Data Provider:

SqlDataProvider

Caching Provider:

FileBasedCachingProvider

Logging Provider:

DBLoggingProvider

HTML Editor Provider:

DNNConnect.CKE

Friendy URL Provider:

DNNFriendlyUrl

Friendly URLs Enabled:

True

Friendly URL Type:

advanced

Scheduler Mode:

TIMER_METHOD

Web Farm Enabled:

False

jQuery Version:

1.9.1

jQuery UI Version:

1.10.3

OS Version:

Microsoft Windows NT 6.2.9200.0

Web Server Version:

Microsoft-IIS/8.0

.NET Framework Version:

4.0.30319.36366

Database Version:

11.0.5582.0

Service Pack:

SP2

Product Edition:

Web Edition (64-bit)

Software Platform:

Microsoft SQL Server 2012 - 11.0.5582.0 (X64) Feb 27 2015 18:10:15 Copyright (c) Microsoft Corporation Web Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1)

I have searched the forum and one thread seems to be similar to my challenge.

http://www.dnnsoftware.com/forums/forumid/20/threadid/532970/scope/posts

This thread has not been replied to, but I notice the error has been fixed for this user.

1/9/2017 2:18 PM

David Jamell

www.JamellDigital.com
Joined: 1/5/2006

Posts: 291

Re: Events List View Not Showing Any Events Modified By David Jamell on 1/9/2017 2:19:49 PM

Hi Gerald,

From the Events repository on GitHub, I used the information from this issue:

https://github.com/DNNCommunity/DNN.Events/issues/39

Specifically add the following right before the "End" statement in the EventsGetByRange Stored Procedure:

order by E.EventTimeBegin

This fixed the problem for me, and should be added in the next version.

Page 1 of 1

Events List View Not Showing Any 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:

No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
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.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

DNN Corp. (DotNetNuke)