Hi,

during upgrade of the avtive forums module on our test site I got the attached SQL error. I somehow cannot see the fourms information though the page looks ok ? I can see and operate the control panel and settings for the module though I dont see the forums information? -attached screen shots

Is there some setrting Im missing to make it show again ? or could this be relating to the SQL error? everything was fine and the data was still there even after I updated to v04.01.19-STD-PA. After I trien installing ActiveForums-04.02.07-ENT-PA.zip thats when I get this problem.

I followed these upgrade instructions.

1. Create a backup of your site and database.
2. If you are using an older version, Install ActiveForums-3.7.8-DNN45-PA, ensure that all content remains.
3. Install ActiveForums-04.01.19-STD-PA, do not add it to a page.
4. Install AFImport_01.00.08
5. Create a new, empty page.
6. Add the AFImport module to the page.
7. Follow the instructions / steps.
8. Check the forums page and make sure that all content/settings remain.
9. Install the latest version of Active Forums. (4.2.7)


Thanks

Please see this post...
http://www.activemodules.com/active...-too-long/
You may need to run the script that I attached in my reply on that thread.

I ran the script and now the forums appear, though only when logged in as host to the site.

When I tried to access the forums as a user, it hangs forever, and when I check the event viewer in DNN I see this-attached


Thanks

I can't make out the text in that screenshot. Can you copy and paste it?

ModuleId: 1668 ModuleDefId: 206 FriendlyName: NTForums ModuleControlSource: DesktopModules/ActiveForums/ActiveForums.ascx AssemblyVersion: 04.09.05 PortalID: 0 PortalName: Sharp Partners UserID: 2832 UserName: jacksonk ActiveTabID: 400 ActiveTabName: Forums RawURL: /Default.aspx?tabid=400&def=ErrorMessage AbsoluteURL: /Default.aspx AbsoluteURLReferrer: http://www.sharp-partners.net/Sharp...fault.aspx UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.2; WOW64; GTB6.6; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729) DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider ExceptionGUID: 449552d3-6427-4adf-b2e4-57fffd0c22e1 InnerException: String was not recognized as a valid DateTime. FileName: FileLineNumber: 0 FileColumnNumber: 0 Method: System.DateTimeParse.Parse StackTrace: Message: DotNetNuke.Services.Exceptions.ModuleLoadException: String was not recognized as a valid DateTime. ---> System.FormatException: String was not recognized as a valid DateTime. at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles) at Active.Modules.Forums.UserController.Profiles_Get(Int32 SiteId, Int32 InstanceId, Int32 UserId) at Active.Modules.Forums.UserController.FillProfile(Int32 SiteId, Int32 ModuleId, User u) at Active.Modules.Forums.UserController.DNNGetCurrentUser(Int32 SiteId, Int32 ModuleId) at Active.Modules.Forums.UserController.GetUser(Int32 SiteId, Int32 ModuleId) at Active.Modules.Forums.SettingsBase.get_ForumUser() at Active.Modules.Forums.Classic.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace --- Source: Server Name: NJSAWEBD01

Have you imported users into your forums previously?

I dont think so, but I only recently got involved wth this site so Im not realy sure. Is there some relation for this problem? thanks

I need some reply with a solution or status please ?

thanks

This error was resolved via the Help Desk.

The error was being caused by a missing value in the DateLastActivity column of the activeforums_UserProfiles table.