> Forums > Active Forums > Community Support > AF: String was not recognized as a valid DateTime.
Last Post 19 Jan 2011 02:48 PM by John Henley. 4 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
John Henley
Customers
John Henley
Post Count:408

--
19 Jan 2011 01:43 PM
    • Active Forums Version: 4.4.0
    • DotNetNuke Version: 5.5.1
    Have a user who is generating this error.  Any ideas?

    AssemblyVersion
    : 5.5.1
    PortalID: 0
    PortalName: LawsonGuru.com
    UserID: 761
    UserName: Edofin
    ActiveTabID: 1
    ActiveTabName: Home
    RawURL: /Home.aspx
    AbsoluteURL: /Default.aspx
    AbsoluteURLReferrer: http://www.lawsonguru.com/Home.aspx
    UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.13) Gecko/20101203 Firefox/3.6.13 ( .NET CLR 3.5.30729; .NET4.0E)
    DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
    ExceptionGUID: 8172f880-5811-44e4-bfe5-f1bde0b2d9b6
    InnerException: String was not recognized as a valid DateTime.
    FileName:
    FileLineNumber: 0
    FileColumnNumber: 0
    Method: System.DateTime.Parse
    StackTrace:
    Message: DotNetNuke.Services.Exceptions.PageLoadException: String was not recognized as a valid DateTime. ---> System.FormatException: String was not recognized as a valid DateTime. at System.DateTime.Parse(String s) at Active.Modules.Forums.UserController.Profiles_Get(Int32 SiteId, Int32 InstanceId, Int32 UserId) at Active.Modules.Forums.UserController.DNNGetCurrentUser(Int32 SiteId, Int32 ModuleId) at Active.Modules.Forums.UserController.GetUser(Int32 SiteId, Int32 ModuleId) at Active.Modules.Forums.WhatsNew.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---
    Source:
    Server Name: LAWGURU64
    Will Morgenweck Forum Admin
    DotNetNuke Staff
    Will Morgenweck
    Post Count:7672

    --
    19 Jan 2011 01:49 PM
    Check the activeforums_UserProfile table and make sure there is a valid entry for the DateLastActivity for that user.
    Will Morgenweck
    Director of Product Management
    DotNetNuke Corp.
    John Henley
    Customers
    John Henley
    Post Count:408

    --
    19 Jan 2011 02:41 PM
    DateLastActivity is NULL
    DateLastPost is NULL
    TopicCount is 1

    (I have 31 users who have DateLastActivity is NULL and TopicCount > 0)
    Will Morgenweck Forum Admin
    DotNetNuke Staff
    Will Morgenweck
    Post Count:7672

    --
    19 Jan 2011 02:44 PM
    I'm guessing this probably came about because of some of the beta installs, because the upgrade scripts check and update those rows.

    Set DateLastActivity to the same value as DateCreated and you will be fine.
    Will Morgenweck
    Director of Product Management
    DotNetNuke Corp.
    John Henley
    Customers
    John Henley
    Post Count:408

    --
    19 Jan 2011 02:48 PM
    Thanks for the quick replies.
    For the masses, this is the query I used to update
    update activeforums_UserProfiles
    SET DateLastActivity = DateCreated
    WHERE TopicCount > 0 AND DateLastActivity is null
    You are not authorized to post a reply.
    > Forums > Active Forums > Community Support > AF: String was not recognized as a valid DateTime.
    test
    Copyright 2012 by DotNetNuke Corporation / Terms of Use / Privacy