Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForumForumerror: Value cannot be null.error: Value cannot be null.
Previous
 
Next
New Post
7/28/2008 1:29 PM
 

My forums have succumbed to a user timing out and then finishing the post.

My DotNetNuke Database resides on sql2005 express edition.

I do not see a 'Forum_Posts' table where I could delete the errant post.

I've searched these forums and am unable to find step-by-step for deleting a post with the null value.

Can i get a point in the right direction or step-by-step in order to delete this single post?

Thanks in advance.

 
New Post
7/28/2008 3:58 PM
 

It must be there, about in that table all posts are stored.  perhaps it have something in front about a objectQualifier like dnn_Forums_Posts.

 
New Post
7/28/2008 4:33 PM
 

After digging around the 'DotNetNuke' database, I could not find any tables under SQL Express 2005 that had anything do with DNN.  I was about to delete one section of my forums and move forward and then stumbled across the HOST > SQL tool while logged in as the 'SuperUser' account.

The following two SQL queries fixed the broken post

Select * from Forum_Posts
Where UserID = 0

This displayed the single post that effectively broke the forum due to the timeout thingy I've been reading about.  I went to the user account section of the portal and found the correct UserID to be '17' and used the following query to update the errant post.  Additionally, I made note of the errant PostID, '137'.

Update Forum_Posts
Set UserID = 17
Where PostID = 137

All fixed!

 
New Post
7/28/2008 4:40 PM
 

I was about to give up and then I found the SQL tool under the HOST menu.  Needed to be logged in as the SuperUser account to find it.

The following query displayed the errant post:

SELECT * from Forum_Posts
WHERE UserID = 0

Note: The PostID for this post is 137 and I knew the UserID for the user who posted was 17.

The following query fixed the errant post:

UPDATE Forum_Posts
SET UserID = 17
WHERE PostID = 137

My hats off to whomever included that nifty little SQL tool in the menu.  It saved the day.

 

 
New Post
7/28/2008 6:11 PM
 

For mauell modify the database you need Microsoft SQL Management Studio (Express = free Version).  Without this tool you can't access databases directly. 

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForumForumerror: Value cannot be null.error: Value cannot be null.


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out