Register   Login
     
  Latest Posts  
JQuery Error in IE6
by rodneyjoyce on 12/02/2008 9:10 AM
RE: Language Packs?
by sschneider on 12/02/2008 8:38 AM
SUMMARY tag
by adski on 12/02/2008 7:55 AM
RE: Integration with UserProfile StoryFeed
by aviavia on 12/02/2008 7:43 AM
RE: Integration with UserProfile StoryFeed
by aviavia on 12/02/2008 7:41 AM
RE: Cache issue?
by jlatulippe on 12/02/2008 4:43 AM
RE: Cache issue?
by smcculloch on 12/02/2008 3:37 AM
RE: Cache issue?
by jlatulippe on 12/02/2008 3:35 AM
RE: Location Search
by rodneyjoyce on 12/02/2008 2:25 AM
RE: Lightbox not working on 2.04?
by wallacea on 12/02/2008 12:31 AM
  Forums  
Subject: NewsArticles 5.6.3 Comments
Prev Next
You are not authorized to post a reply.

Author Messages
stipe kUser is Offline
Gold Membership
Nuke Wiz
Nuke Wiz
Posts:178

5/01/2008 9:00 PM  

Gday

I have this error appearing when trying to add comments. They used to work, but something has obviously broken it:

Error: News is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Cannot insert the value NULL into column 'CommentID', table 'vjesnik.dbo.DnnForge_NewsArticles_Comment'; column does not allow nulls. INSERT fails. The statement has been terminated. ---> System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'CommentID', table 'vjesnik.dbo.DnnForge_NewsArticles_Comment'; column does not allow nulls. INSERT fails. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DnnForge.NewsArticles.SqlDataProvider.AddComment(Int32 articleID, Int32 userID, String comment, String remoteAddress, Int32 type, String trackbackUrl, String trackbackTitle, String trackbackBlogName, String trackbackExcerpt, String anonymousName, String anonymousEmail, String anonymousURL, Boolean notifyMe) at DnnForge.NewsArticles.CommentController.AddComment(CommentInfo objComment) at DnnForge.NewsArticles.ucPostComment.cmdPostComment_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---

Any ideas?

Cheers

Scott McCullochUser is Offline
Administrators
Nuke Master
Nuke Master
Posts:12549


5/02/2008 6:00 AM  
Did you move tables/data from elsewhere? The comment table should have a primary key and autonumber on the CommentID, make sure this is set if you have moved data accross.

Scott McCulloch
Site Administrator
You are not authorized to post a reply.
Forums > General > Bugs & Problems > NewsArticles 5.6.3 Comments



ActiveForums 3.7