Database corruption in forum

[gmoon]

The last post by Tazza disappeared and nobody can post to the forum topic anymore, because of corruption in a database table. Here is a link to the forum topic:
http://www.skidsteerforum.com/DesktopDefault.aspx?tabid=54&frmView=ShowPost&PostID=45856

This error happens when I try to post:

Server Error in '/' Application.

---

Cannot insert the value NULL into column 'PinnedDate', table 'BobcatDNN.dbo.AdverFRM_Posts'; column does not allow nulls. INSERT fails. Cannot insert the value NULL into column 'TotalPosts', table 'BobcatDNN.dbo.AdverFRM_Forums'; column does not allow nulls. UPDATE fails. The statement has been terminated. The statement has been terminated.

 

[gmoon]

Ok, I changed 3 things in my profile:
1) HTML edit mode
2) different date format
3) show new posts first
When I reversed (2) and (3) back to the defaults, the missing post shows, and I could post with a problem. Thus, I suggest avoiding changing the display order of posts and/or default date format. Using IE 9 with HTML edit mode, and rest of profile settings at default, everything works fine. I'm happy

 

[owensge]

Ok, I changed 3 things in my profile:
1) HTML edit mode
2) different date format
3) show new posts first
When I reversed (2) and (3) back to the defaults, the missing post shows, and I could post with a problem. Thus, I suggest avoiding changing the display order of posts and/or default date format. Using IE 9 with HTML edit mode, and rest of profile settings at default, everything works fine. I'm happy

Okay good to hear that.