I installed Yet Another Forum v1.9.1.8 on my server, then I created a board/forum with moderate turned on. Everything was fine but yesterday the front page could not be accessed with the following error log since:
Quote:
Thread information:
Thread ID: 1
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at System.DBNull.System.IConvertible.ToDateTime(IFormatProvider provider)
at System.Convert.ToDateTime(Object value)
at ASP.pages_forum_ascx.__DataBind__control10(Object sender, EventArgs e) in e:\WebDocs\Apps\Forum\pages\forum.ascx:line 76
According to the error log, I looked up the code of page/forum.ascx file and found the LastPosted Date caused this problem. That Last Posted Date was called from the Active Discussion topic section on the front page. I opened the database and found a new topic in the topic table with null value in the LastPosted column. When I added a date time in that column, my forum came back again.
Curiously I went to my forum, and created a new topic in the forum. I got a message said since this is a moderated forum, my post could not be seen till the moderator approves. And after a few, the forum crashed again. I am not sure why this happened, but I doubt there was a bug in the code during moderate mode. If I turn off the moderate, so far, not such crash thing happened. Please help, since we need the forum to be moderated at this moment.
By the way, right now we only have one forum/category setup. And I will give out the URL if anyone is interested on taking a look. Thanks