I have been running version 1.8 for quite a while successfully. Now I am attempting to upgrade from 1.8 to 2.2.
1.8 to 1.9
1. I backed up my 1.8 version SQL Server database
2. I downloaded nopCommerce_1.90_NoSource
3. I opened nopCommerce_upgrade.sql in SQL Server Management Studio query window and executed.
4. I opened nopCommerce_1.90_NoSource using WebMatrix and clicked on run (localhost - I did not upload 1.9 files to my hosted site).
Version 1.9 opened in localhost successfully, but my actual site gets error now (Invalid column name 'Extension'. I assume this is because I did not upload 1.9 files to web server.
I have some questions before I continue.
Question 1: Do I need to upload all 1.9 files to Web server and then go through upgrade procedure for 2.0, 2.1, and 2.2? Or can I upgrade using SQL upgrade scripts for 2.0, 2.1 and 2.2 and, then, upload only the 2.2 aspx files, etc to Web server.
Question 2: When I go from 1.9 install/upgrade to 2.0, I got the following message. Why did this happen and how can it be prevented?
nopCommerce installation
To complete this wizard you must know some information regarding your database server ("connection string"). Please contact your ISP if necessary. If you're installing on a local machine or server you might need information from your System Admin.
Setup failed: System.Data.Entity.Infrastructure.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'Rtl', table 'nauticalyarnstore.dbo.Language'; column does not allow nulls. INSERT fails. 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() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() 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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues) at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) --- End of inner exception stack trace --- at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) at System.Data.EntityClient.EntityAdapter.Update(IEntityStateManager entityCache) at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options) at System.Data.Entity.Internal.InternalContext.SaveChanges() --- End of inner exception stack trace --- at System.Data.Entity.Internal.InternalContext.SaveChanges() at System.Data.Entity.Internal.LazyInternalContext.SaveChanges() at System.Data.Entity.DbContext.SaveChanges() at Nop.Data.EfRepository`1.Insert(T entity) in F:\Own\NopCommerce\Sources\src\Libraries\Nop.Data\EfRepository.cs:line 37 at Nop.Services.Installation.InstallationService.InstallLanguagesAndResources() in F:\Own\NopCommerce\Sources\src\Libraries\Nop.Services\Installation\InstallationService.cs:line 443 at Nop.Services.Installation.InstallationService.InstallData(String defaultUserEmail, String defaultUserPassword, Boolean installSampleData) in F:\Own\NopCommerce\Sources\src\Libraries\Nop.Services\Installation\InstallationService.cs:line 9049 at Nop.Web.Controllers.InstallController.Index(InstallModel model) in F:\Own\NopCommerce\Sources\src\Presentation\Nop.Web\Controllers\InstallController.cs:line 378