I'm trying to create a new product via the CMS. From store manager -> Product Administration -> New Product. After entering the product info and clicking save I got this error. I don't even see a checkbox for anything like IsDeleted. Any help is appreciated:
Cannot insert the value NULL into column 'IsDeleted', table 'CCG.dbo.ws_Product'; 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 'IsDeleted', table 'CCG.dbo.ws_Product'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException (0x80131904): Cannot insert the value NULL into column 'IsDeleted', table 'CCG.dbo.ws_Product'; 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) +6387741
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +6389442
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
mojoPortal.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, Int32 commandTimeout, SqlParameter[] commandParameters) +238
mojoPortal.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +20
WebStore.Data.DBProduct.Add(Guid guid, Guid storeGuid, Guid taxClassGuid, String modelNumber, Byte status, Byte fullfillmentType, Decimal weight, Int32 quantityOnHand, String imageFileName, Byte[] imageFileBytes, DateTime created, Guid createdBy, DateTime lastModified, Guid lastModifedBy, String url, String name, String description, String teaser, Boolean showInProductList, Boolean enableRating, String metaDescription, String metaKeywords, Int32 sortRank1, Int32 sortRank2, String teaserFile, String teaserFileLink, String compiledMeta) +2928
WebStore.Business.Product.Create() +1239
WebStore.Business.Product.Save() +244
WebStore.UI.AdminProductEditPage.Save() +2065
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +154
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3707