We have had a bunch of design work done to our site on a dev server. In order to test it out before going live, I took the new code and pointed it at the live site's DB. It worked fine, except that it still looked like the old site (b/c the Theme, Content Page, Display Page, etc. are stored in the DB). So far, so good.
I made a copy of the DB and pointed the new code to the replicated DB. I would then go in and manually change the theme info. However, I'm now getting the error below.
Can anyone tell me how to fix this problem or how to solve this problem properly? I really want the new code on the old DB during go-live so that I don't lose order or product info. I can't use DataPort either b/c I don't have that kind of access to the live server.
The error is below:
Code: Select all
Server Error in '/' Application.
Cannot insert the value NULL into column 'UserId', table 'Moustafa_shukr_co_uk_n.dbo.ac_Users'; 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 'UserId', table 'Moustafa_shukr_co_uk_n.dbo.ac_Users'; 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 'UserId', table 'Moustafa_shukr_co_uk_n.dbo.ac_Users'; column does not allow nulls. INSERT fails.
The statement has been terminated.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950890
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
System.Data.SqlClient.SqlDataReader.get_MetaData() +83
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
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.ExecuteScalar() +139
CommerceBuilder.Data.Database.a(DbCommand A_0) +90
CommerceBuilder.Data.Database.ExecuteScalar(DbCommand command) +83
CommerceBuilder.Users.User.BaseSave() +2690
CommerceBuilder.Users.User.Save() +1166
CommerceBuilder.Users.UserDataSource.a(String A_0) +504
CommerceBuilder.Users.UserDataSource.LoadForUserName(String userName, Boolean createMissing) +194
CommerceBuilder.Common.Token.InitUserContext(HttpContext context) +632
CommerceBuilder.Services.c.b(Object A_0, EventArgs A_1) +74
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +68
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75
Version Information: Microsoft .NET Framework Version:2.0.50727.3623; ASP.NET Version:2.0.50727.3618Moustafa
