Moving nopCommerce

Hello,

I just inherited the project of moving our installation of nopCommerce to a new host. As I have never used nopCommerce - not to mention ASP - I was wondering if anyone could give me some tips as to how to move our installation of the product. I can't figure out how to tell what version we're running, so I can't even tell what the requirements of it are. Our current installation is located at http://store.bpimedical.com, if that helps you. Thanks for your help.

- Sean

Not sure if this is the best answer, but I'm guessing it goes like this:

Backup the current Database.
Create a New database on the new server (with the same name),
and do a Restore using the backup file you created.

Copy all the files in the Root directory from the old site.
Create a new Website (using the same domain name) with your new web hoster.

Move all those files into that newly created root directory.
r-click that root directory folder, Security tab, and add the user "Network Services"
giving it Write, Read, and Modify permisions.

Modify the \NopCommerceStore\ConnectionStrings.config file and change the server name:

connectionString="Data Source=New Server Name; . . .

Then cross your fingers. It may work or you might get a few errors at first.
Post any errors here.

Thanks.

Here's the first and hopefully last error I've encountered:

Server Error in '/' Application.
Could not find stored procedure 'Nop_SettingLoadAll'.
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: Could not find stored procedure 'Nop_SettingLoadAll'.

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): Could not find stored procedure 'Nop_SettingLoadAll'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950522
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4856715
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1121
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
   System.Data.SqlClient.SqlDataReader.get_MetaData() +83
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +293
   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.ExecuteReader(CommandBehavior behavior, String method) +141
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
   System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +10
   Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteReader(DbCommand command, CommandBehavior cmdBehavior) +223
   Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteReader(DbCommand command) +244
   NopSolutions.NopCommerce.DataAccess.Configuration.Settings.SQLSettingProvider.GetAllSettings() in C:\Sites\BPI\Libraries\Nop.DataAccess.SqlServer\Configuration\Settings\SQLSettingProvider.cs:129
   NopSolutions.NopCommerce.BusinessLogic.Configuration.Settings.SettingManager.GetAllSettings() in C:\Sites\BPI\Libraries\Nop.BusinessLogic\Configuration\Settings\SettingManager.cs:111
   NopSolutions.NopCommerce.BusinessLogic.Configuration.Settings.SettingManager.GetSettingByName(String Name) in C:\Sites\BPI\Libraries\Nop.BusinessLogic\Configuration\Settings\SettingManager.cs:338
   NopSolutions.NopCommerce.BusinessLogic.Configuration.Settings.SettingManager.GetSettingValue(String Name) in C:\Sites\BPI\Libraries\Nop.BusinessLogic\Configuration\Settings\SettingManager.cs:306
   NopSolutions.NopCommerce.BusinessLogic.Configuration.Settings.SettingManager.GetSettingValueBoolean(String Name, Boolean DefaultValue) in C:\Sites\BPI\Libraries\Nop.BusinessLogic\Configuration\Settings\SettingManager.cs:239
   NopSolutions.NopCommerce.BusinessLogic.Configuration.Settings.SettingManager.GetSettingValueBoolean(String Name) in C:\Sites\BPI\Libraries\Nop.BusinessLogic\Configuration\Settings\SettingManager.cs:228
   NopSolutions.NopCommerce.BusinessLogic.Directory.LanguageManager.get_CacheEnabled() in C:\Sites\BPI\Libraries\Nop.BusinessLogic\Directory\LanguageManager.cs:197
   NopSolutions.NopCommerce.BusinessLogic.Directory.LanguageManager.GetAllLanguages(Boolean showHidden) in C:\Sites\BPI\Libraries\Nop.BusinessLogic\Directory\LanguageManager.cs:105
   NopSolutions.NopCommerce.BusinessLogic.NopContext.get_WorkingLanguage() in C:\Sites\BPI\Libraries\Nop.BusinessLogic\NopContext.cs:337
   NopSolutions.NopCommerce.HttpModules.MembershipHttpModule.Application_BeginRequest(Object sender, EventArgs e) in C:\Sites\BPI\Libraries\Nop.HttpModules.MembershipModule\MembershipHttpModule.cs:138
   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.5446; ASP.NET Version:2.0.50727.5420

Thanks.

bpiSean wrote:
https://www.nopcommerce.com/boards/search.aspx?searchterms=could+not+find+stored+procedure+%27nop_settingloadall%27&adv=false&fid=0&w=0&l=0