YAFLogo

Will Chen
  • Will Chen
  • 65% (Friendly)
  • YAF Camper Topic Starter
15 years ago
Boy, I've been owrking on moving YAF to GoDaddy on and off for nearly a week and I'm having major issues. I finally got the site loaded up and the data moved into the new database but I'm receiving the below error when trying to post a message. Any ideas?

System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'Flags', table 'frugaldb.dbo.yaf_Topic'; column does not allow nulls. INSERT fails.

Cannot insert the value NULL into column 'TopicID', table 'frugaldb.dbo.yaf_Message'; column does not allow nulls. INSERT fails.

The statement has been terminated.

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.ExecuteReader(CommandBehavior behavior, String method)

at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)

at YAF.Classes.Data.DBAccess.GetDatasetBasic(SqlCommand cmd, Boolean transaction)

at YAF.Classes.Data.DBAccess.GetData(SqlCommand cmd, Boolean transaction)

at YAF.Classes.Data.DB.topic_save(Object forumID, Object subject, Object message, Object userID, Object priority, Object pollID, Object userName, Object ip, Object posted, Object blogPostID, Object flags, Int64& messageID)

at YAF.Pages.postmessage.PostReplyHandleNewPost()

at YAF.Pages.postmessage.PostReply_Click(Object sender, EventArgs e)

at System.Web.UI.WebControls.Button.OnClick(EventArgs e)

at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)

at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)

at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)

at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


Visit www.frugalguitarist.com  for detailed reviews of under-the-radar gear and guides to the best bargains on the net.

Sponsor
Will Chen
  • Will Chen
  • 65% (Friendly)
  • YAF Camper Topic Starter
15 years ago
Never mind. Some Identity and default settings weren't copied correctly. Problem solved.
Visit www.frugalguitarist.com  for detailed reviews of under-the-radar gear and guides to the best bargains on the net.

Jaben
  • Jaben
  • 100% (Exalted)
  • YAF Developer
15 years ago
Glad you got it working... Copying DBs can be tricky. I'm working to improve the situation in future versions.