I[b] am using the new version of nopCommerce Framework i.e ver.1.10. When I try to add a new product variant under a product it gives me the following error:[/b]
T[color=red]he INSERT statement conflicted with the FOREIGN KEY constraint "FK_Nop_ProductVariant_Nop_LowStockActivity". The conflict occurred in database "RedBellStore", table "dbo.Nop_LowStockActivity", column 'LowStockActivityID'. The statement has been terminated. [/color]
System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Nop_ProductVariant_Nop_LowStockActivity". The conflict occurred in database "RedBellStore", table "dbo.Nop_LowStockActivity", column 'LowStockActivityID'. 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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteNonQuery(DbCommand command) at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteNonQuery(DbCommand command) at NopSolutions.NopCommerce.DataAccess.Products.SQLProductVariantProvider.InsertProductVariant(Int32 ProductID, String Name, String SKU, String Description, String AdminComment, String ManufacturerPartNumber, Boolean IsDownload, Int32 DownloadID, Boolean IsShipEnabled, Boolean IsFreeShipping, Boolean IsTaxExempt, Int32 TaxCategoryID, Int32 StockQuantity, Int32 MinStockQuantity, Int32 LowStockActivityID, Int32 WarehouseId, Boolean DisableBuyButton, Boolean RequiresTextOption, String TextOptionPrompt, Decimal Price, Decimal OldPrice, Decimal Weight, Decimal Length, Decimal Width, Decimal Height, Int32 PictureID, Boolean Published, Boolean Deleted, Int32 DisplayOrder, DateTime CreatedOn, DateTime UpdatedOn) in D:\Work\Own\NopCommerce\Solution\NopCommerce\Nop.DataAccess.SqlServer\Products\SQLProductVariantProvider.cs:line 181 at NopSolutions.NopCommerce.Common.Products.ProductVariantManager.InsertProductVariant(Int32 ProductID, String Name, String SKU, String Description, String AdminComment, String ManufacturerPartNumber, Boolean IsDownload, Int32 DownloadID, Boolean IsShipEnabled, Boolean IsFreeShipping, Boolean IsTaxExempt, Int32 TaxCategoryID, Int32 StockQuantity, Int32 MinStockQuantity, LowStockActivityEnum LowStockActivity, Int32 WarehouseId, Boolean DisableBuyButton, Boolean RequiresTextOption, String TextOptionPrompt, Decimal Price, Decimal OldPrice, Decimal Weight, Decimal Length, Decimal Width, Decimal Height, Int32 PictureID, Boolean Published, Boolean Deleted, Int32 DisplayOrder, DateTime CreatedOn, DateTime UpdatedOn) in D:\Work\Own\NopCommerce\Solution\NopCommerce\Nop.Common\Products\ProductVariantManager.cs:line 310 at NopSolutions.NopCommerce.Web.Administration.Administration_ProductVariantAdd.SaveButton_Click(Object sender, EventArgs e) in c:\NopCommerce\NopCommerceWeb\Administration\ProductVariantAdd.aspx.cs:line 122
Any help by the moderators or users of the site would be greatly appreciated.
Thanks!