Running nop 2.1 on local machines and have been trying to move it to godaddy but cannot get it to recognize my DB.
I can run the installer on godaddy and get the base nop store functioning. When I try to import my existing local DB into the new DB on godaddy I get errors (already exists).
Can anyone guide me on how I can accomplish this?
For reference my previous post is here:
https://www.nopcommerce.com/boards/t/11777/21-not-detecting-settingstxt-and-will-only-load-the-nopcommerce-installation-page-please-help.aspx
I am not a programmer or a DB expert so ANY help would be greatly appreciated.
Thanks
Import existing 2.1 DB into new install of 2.1 DB
- 25
- 143
- 2011/3/7
- United States
This is the error I am getting:
Cannot insert the value NULL into column 'Id', table 'pcmedicplus21.dbo.Customer'; 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 'Id', table 'pcmedicplus21.dbo.Customer'; 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 'Id', table 'pcmedicplus21.dbo.Customer'; column does not allow nulls. INSERT fails.
The statement has been terminated.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2062078
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5050204
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) +8158468
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.Entity.Internal.InternalContext.SaveChanges() +120
[DbUpdateException: An error occurred while updating the entries. See the inner exception for details.]
System.Data.Entity.Internal.InternalContext.SaveChanges() +206
System.Data.Entity.Internal.LazyInternalContext.SaveChanges() +24
System.Data.Entity.DbContext.SaveChanges() +20
Nop.Data.EfRepository`1.Insert(T entity) in F:\Own\NopCommerce\Sources\src\Libraries\Nop.Data\EfRepository.cs:37
Nop.Services.Customers.CustomerService.InsertGuestCustomer() in F:\Own\NopCommerce\Sources\src\Libraries\Nop.Services\Customers\CustomerService.cs:627
Nop.Web.Framework.WebWorkContext.GetCurrentCustomer() in F:\Own\NopCommerce\Sources\src\Presentation\Nop.Web.Framework\WebWorkContext.cs:121
Nop.Web.Framework.WebWorkContext.get_CurrentCustomer() in F:\Own\NopCommerce\Sources\src\Presentation\Nop.Web.Framework\WebWorkContext.cs:189
Nop.Web.MvcApplication.SetWorkingCulture() in F:\Own\NopCommerce\Sources\src\Presentation\Nop.Web\Global.asax.cs:172
Nop.Web.MvcApplication.Application_AuthenticateRequest(Object sender, EventArgs e) in F:\Own\NopCommerce\Sources\src\Presentation\Nop.Web\Global.asax.cs:122
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +148
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75
Cannot insert the value NULL into column 'Id', table 'pcmedicplus21.dbo.Customer'; 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 'Id', table 'pcmedicplus21.dbo.Customer'; 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 'Id', table 'pcmedicplus21.dbo.Customer'; column does not allow nulls. INSERT fails.
The statement has been terminated.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2062078
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5050204
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) +8158468
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.Entity.Internal.InternalContext.SaveChanges() +120
[DbUpdateException: An error occurred while updating the entries. See the inner exception for details.]
System.Data.Entity.Internal.InternalContext.SaveChanges() +206
System.Data.Entity.Internal.LazyInternalContext.SaveChanges() +24
System.Data.Entity.DbContext.SaveChanges() +20
Nop.Data.EfRepository`1.Insert(T entity) in F:\Own\NopCommerce\Sources\src\Libraries\Nop.Data\EfRepository.cs:37
Nop.Services.Customers.CustomerService.InsertGuestCustomer() in F:\Own\NopCommerce\Sources\src\Libraries\Nop.Services\Customers\CustomerService.cs:627
Nop.Web.Framework.WebWorkContext.GetCurrentCustomer() in F:\Own\NopCommerce\Sources\src\Presentation\Nop.Web.Framework\WebWorkContext.cs:121
Nop.Web.Framework.WebWorkContext.get_CurrentCustomer() in F:\Own\NopCommerce\Sources\src\Presentation\Nop.Web.Framework\WebWorkContext.cs:189
Nop.Web.MvcApplication.SetWorkingCulture() in F:\Own\NopCommerce\Sources\src\Presentation\Nop.Web\Global.asax.cs:172
Nop.Web.MvcApplication.Application_AuthenticateRequest(Object sender, EventArgs e) in F:\Own\NopCommerce\Sources\src\Presentation\Nop.Web\Global.asax.cs:122
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +148
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75