Hi,

We're experiencing a problem that has been going on for a long time now. I finally got around to looking into it, and the DNN EventLog table is being filled with an exception message from the Active Forums module.

The quick explanation is, that whenever someone views a forum's overview page (listing all its topics), 3 exception messages are logged to the database. The consequence is that the logs fill up pretty quickly and cause problems. All the exception messages indicate that an operation on a date was invalid. I've pasted in the log message further below.

I've tried changing the date format in the forum settings, but that doesn't have any impact. The dates seem to be displayed fine on the page, so I'm not sure which dates are actually causing the errors. If it is of any interest, we've set the forum time zone to GMT+1. The log message includes the URL that causes the error, but this is just one example, it seems all the forum overview pages cause identical errors.



AssemblyVersion
5.1.1


PortalID
0


PortalName
Zombie Pandemic - Community


UserID
177


UserName
georgosu


ActiveTabID
65


ActiveTabName
Forum


RawURL
/Forum/tabid/65/aff/1/aft/354/afv/topic/Default.aspx


AbsoluteURL
/Default.aspx


AbsoluteURLReferrer
http://blog.zombiepandemic.com/Foru...fault.aspx


UserAgent
Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US) AppleWebKit/532.5 (KHTML, like Gecko) Chrome/4.1.249.1064 Safari/532.5


DefaultDataProvider
DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider


ExceptionGUID
4d692d39-56a1-4b07-9dd2-1c336757027c


InnerException
The added or subtracted value results in an un-representable DateTime. Parameter name: value


FileName



FileLineNumber
0


FileColumnNumber
0


Method
System.DateTime.AddTicks


StackTrace



Message

System.ArgumentOutOfRangeException: The added or subtracted value results in an un-representable DateTime.
Parameter name: value
at System.DateTime.AddTicks(Int64 value)
at System.DateTime.Add(Double value, Int32 scale)
at Active.Modules.Forums.Utilities.GetDate(DateTime DisplayDate, Int32 MID)



Source




Best regards.

I had DNN 5.1.1 for a while on my site and it was very buggy. I am sure upgrading to most recent stable version will be the suggested route.

Thanks for replying and for the suggestion. I will be upgrading DNN in a week or so, and if that fixes this issue as a side effect - great.

It does sound likely that it is a bug in Active Forums and not DNN though, as the stack trace indicates Active.Modules.Forums.Utilities.GetDate method as the place of origin for the exceptions. Either way, if something in DNN is causing a bad value being added to a date, then ideally the Active Forums module still handled that gracefully.

Best regards.

Hi Thomas,

Make sure you figured out the right upgrade path from DNN511 to DNN542 because I am not too sure you can (or should) do this in one step. I'd test this first in a test environment if I were you.