Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

Maximum ASP
  Ads  
Iron Speed Designer is a software development tool for building database, reporting, and forms applications for .NET without hand-coding.
 


  Sponsors  

Meet Our Sponsors

CrystalTech Web Hosting™
Webhost4life, specialists in DNN hosting
Mad Development is a full service interactive agency focusing on the merge of design, technology, e-commerce, and affiliate marketing by providing total website solutions.
SteadyRain
DataSprings - Great Ideas. Always Flowing.
R2integrated - formerly bi4ce
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  Forum Module [L...  error: Value cannot be null.
Previous Previous
 
Next Next
New Post 7/28/2008 11:29 AM
User is offline Mark Hudy
5 posts
10th Ranked


error: Value cannot be null. 

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 1:58 PM
User is offline Matthias Schlomann
1494 posts
www.taunusstein.org
6th Ranked








Re: error: Value cannot be null. 

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.


Regards
Matthias
www.moonlightradio.net
Chat with me via MSN
 
New Post 7/28/2008 2:33 PM
User is offline Mark Hudy
5 posts
10th Ranked


Re: error: Value cannot be null. 

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 2:40 PM
User is offline Mark Hudy
5 posts
10th Ranked


Re: error: Value cannot be null. 

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 4:11 PM
User is offline Matthias Schlomann
1494 posts
www.taunusstein.org
6th Ranked








Re: error: Value cannot be null. 

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


Regards
Matthias
www.moonlightradio.net
Chat with me via MSN
 
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  Forum Module [L...  error: Value cannot be null.
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

 


Cygnusoft Custom Software
Cygnusoft has been providing cutting-edge custom software solutions for 20 years. Cygnusoft is also a leading start-up incubator, helping our partners build successful new businesses.
www.cygnusoft.com
Digicon: DotNetNuke design and development
Digicon is based in Brisbane, Queensland, Australia
digicon.com.au
Live Visitor Tracking & Live Chat For DotNetNuke
Track your visitors in real time and add live chat for sales & support. Free Trial.
www.whoson.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP