Hi all,
After copying my database tables & view using the import/export wizard in sql and scripting out my stored procedures to run against my hosted database. I am now getting similar sort of errors but on different tables and at different links. Its like the pages keep passing null values into tables.
- I can't even get to the shopping cart now, it fails at the product level.
- The search still isn't working at all.
Anymore idea before i install my database from scratch which could do without.
I Get this error by clicking on the product then clicking 'Add to cart'.
###################################################################################################
Server Error in '/' Application.
--------------------------------------------------------------------------------
Cannot insert the value NULL into column 'LogID', table 'klmotors_klm.dbo.Nop_Log'; 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 'LogID', table 'klmotors_klm.dbo.Nop_Log'; 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 'LogID', table 'klmotors_klm.dbo.Nop_Log'; column does not allow nulls. INSERT fails.
The statement has been terminated.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2030802
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5009584
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
System.Data.SqlClient.SqlDataReader.get_MetaData() +86
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +311
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +10
System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues) +8118684
System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) +267
[UpdateException: An error occurred while updating the entries. See the inner exception for details.]
System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) +389
System.Data.EntityClient.EntityAdapter.Update(IEntityStateManager entityCache) +163
System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options) +609
System.Data.Objects.ObjectContext.SaveChanges() +15
NopSolutions.NopCommerce.BusinessLogic.Audit.LogManager.InsertLog(LogTypeEnum logType, Int32 severity, String message, Exception exception, String IPAddress, Int32 customerId, String pageUrl) in F:\Own\nopDownloads\downloads\nopCommerce_1.80_Source\Libraries\Nop.BusinessLogic\Audit\LogManager.cs:182
NopSolutions.NopCommerce.BusinessLogic.Audit.LogManager.InsertLog(LogTypeEnum logType, String message, Exception exception) in F:\Own\nopDownloads\downloads\nopCommerce_1.80_Source\Libraries\Nop.BusinessLogic\Audit\LogManager.cs:122
NopSolutions.NopCommerce.Web.Templates.Products.OneVariant.OnCommand(Object source, CommandEventArgs e) in F:\Own\nopDownloads\downloads\nopCommerce_1.80_Source\NopCommerceStore\Templates\Products\OneVariant.ascx.cs:356
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +167
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1
I Get this error by clicking directly on the 'Add to cart' button without clicking on the product.
###################################################################################################
Server Error in '/' Application.
--------------------------------------------------------------------------------
Cannot insert the value NULL into column 'ShoppingCartItemID', table 'klmotors_klm.dbo.Nop_ShoppingCartItem'; 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 'ShoppingCartItemID', table 'klmotors_klm.dbo.Nop_ShoppingCartItem'; 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 'ShoppingCartItemID', table 'klmotors_klm.dbo.Nop_ShoppingCartItem'; column does not allow nulls. INSERT fails.
The statement has been terminated.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2030802
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5009584
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
System.Data.SqlClient.SqlDataReader.get_MetaData() +86
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +311
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +10
System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues) +8118684
System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) +267
[UpdateException: An error occurred while updating the entries. See the inner exception for details.]
System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) +389
System.Data.EntityClient.EntityAdapter.Update(IEntityStateManager entityCache) +163
System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options) +609
System.Data.Objects.ObjectContext.SaveChanges() +15
NopSolutions.NopCommerce.BusinessLogic.Orders.ShoppingCartManager.InsertShoppingCartItem(ShoppingCartTypeEnum shoppingCartType, Guid customerSessionGuid, Int32 productVariantId, String attributesXml, Decimal customerEnteredPrice, Int32 quantity, DateTime createdOn, DateTime updatedOn) in F:\Own\nopDownloads\downloads\nopCommerce_1.80_Source\Libraries\Nop.BusinessLogic\Orders\ShoppingCartManager.cs:167
NopSolutions.NopCommerce.BusinessLogic.Orders.ShoppingCartManager.AddToCart(ShoppingCartTypeEnum shoppingCartType, Int32 productVariantId, String selectedAttributes, Decimal customerEnteredPrice, Int32 quantity) in F:\Own\nopDownloads\downloads\nopCommerce_1.80_Source\Libraries\Nop.BusinessLogic\Orders\ShoppingCartManager.cs:1175
NopSolutions.NopCommerce.Web.Modules.ProductBox1Control.btnAddToCart_Click(Object sender, CommandEventArgs e) in F:\Own\nopDownloads\downloads\nopCommerce_1.80_Source\NopCommerceStore\Modules\ProductBox1.ascx.cs:121
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +167
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1
Cheers
Mark