Non-threaded

Forums » Bugs & Problems » Read Thread

Post reports about problems or bugs in here.
This bug was closed 7/29/2012: Fixed

commenting error

13 years ago

DUUUUUDES, what the hell is wrong with the website? everywhere i go, i see errors! Now i got an error when i tried commenting on a storygame.

the full error text :

 

=========

 

Server Error in '/' Application.


Cannot insert the value NULL into column 'Featured_Indicator', table 'ChooseYourStory.dbo.Story_Comments'; column does not allow nulls. INSERT fails.
The statement has been terminated.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'Featured_Indicator', table 'ChooseYourStory.dbo.Story_Comments'; column does not allow nulls. INSERT fails.
The statement has been terminated.

Source Error:



Line 35: 			anonEmail = AnonymousEmail.Text;
Line 36: 		}
Line 37: 		State.AddComment(State.Score, username, anonName, anonEmail, CommentText.Text);
Line 38: 		
Line 39: 		ChooseYourStory.Legacy.LegacyLogger.FinishGame(State.StoryId);

Source File: c:\Websites\ChooseYourStory\ChooseYourStory.com\Story\Viewer\Comment.aspx    Line: 37

Stack Trace:



[SqlException (0x80131904): Cannot insert the value NULL into column 'Featured_Indicator', table 'ChooseYourStory.dbo.Story_Comments'; column does not allow nulls. INSERT fails.
The statement has been terminated.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +404
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +412
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1363
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +6312253
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +6313986
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +538
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +689
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +327
   ChooseYourStory.Stories.StoryState.AddComment(Int32 scoreValue, String username, String anonymousUsername, String anonymousEmail, String commentText) in c:\BuildMasterAgent\_AGTTMP\_A4\_S11\SRC\ChooseYourStory\Stories\StoryState_Ending.cs:69
   ASP.story_viewer_comment_aspx.AddComment_Click(Object sender, EventArgs e) in c:\Websites\ChooseYourStory\ChooseYourStory.com\Story\Viewer\Comment.aspx:37
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +154
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3691

WHAT DID I DO WRONG THIS TIME???

commenting error

13 years ago

Probably has something to do with the new "featured comments" feature.

commenting error

13 years ago

Yeah, this one is just that Alex created a new field on the table for comments and he probably unchecked the equivalent of "allow nulls" and then forgot to pass that field a value when you leave a comment. Hopefully he sees this quickly.

commenting error

13 years ago

Something like that! Forgot to change the Add Comment method.  Easy fix.