Hi there,

I tried to upgrade to v3 but am now receiving the following error on all pages (apart from Admin which now says 403 Forbidden):

Server Error in '/' Application.

Invalid column name 'LanguageId'.
Invalid column name 'CurrencyId'.
Invalid column name 'TaxDisplayTypeId'.
Invalid column name 'VatNumber'.
Invalid column name 'VatNumberStatusId'.
Invalid column name 'SelectedPaymentMethodSystemName'.
Invalid column name 'CheckoutAttributes'.
Invalid column name 'DiscountCouponCode'.
Invalid column name 'GiftCardCouponCodes'.
Invalid column name 'UseRewardPointsDuringCheckout'.
Invalid column name 'TimeZoneId'.

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: Invalid column name 'LanguageId'.
Invalid column name 'CurrencyId'.
Invalid column name 'TaxDisplayTypeId'.
Invalid column name 'VatNumber'.
Invalid column name 'VatNumberStatusId'.
Invalid column name 'SelectedPaymentMethodSystemName'.
Invalid column name 'CheckoutAttributes'.
Invalid column name 'DiscountCouponCode'.
Invalid column name 'GiftCardCouponCodes'.
Invalid column name 'UseRewardPointsDuringCheckout'.
Invalid column name 'TimeZoneId'.

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): Invalid column name 'LanguageId'.
Invalid column name 'CurrencyId'.
Invalid column name 'TaxDisplayTypeId'.
Invalid column name 'VatNumber'.
Invalid column name 'VatNumberStatusId'.
Invalid column name 'SelectedPaymentMethodSystemName'.
Invalid column name 'CheckoutAttributes'.
Invalid column name 'DiscountCouponCode'.
Invalid column name 'GiftCardCouponCodes'.
Invalid column name 'UseRewardPointsDuringCheckout'.
Invalid column name 'TimeZoneId'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +388
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +688
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4403
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +82
   System.Data.SqlClient.SqlDataReader.get_MetaData() +135
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +6665229
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite) +6667096
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +577
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +107
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +288
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +180
   System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) +689

[EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details.]
   System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) +11010074
   System.Data.Objects.Internal.ObjectQueryExecutionPlan.Execute(ObjectContext context, ObjectParameterCollection parameterValues) +10639161
   System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) +10666429
   System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator() +51
   System.Linq.Enumerable.FirstOrDefault(IEnumerable`1 source) +220
   System.Linq.Queryable.FirstOrDefault(IQueryable`1 source) +330
   Nop.Services.Customers.CustomerService.GetCustomerByGuid(Guid customerGuid) +705
   Nop.Web.Framework.WebWorkContext.GetCurrentCustomer() +633
   Nop.Web.MvcApplication.SetWorkingCulture() +494
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +80
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +165

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.17929


Could you please help me identify what went wrong? the scripts ran successfully with no errors. I'm running MsSQL 2008r2 on a windows server 2008r2

Many thanks,

Paul.