Installing Nopcommerce to existing database

Hi,

following posts about installing nop commerce 3.6 to an existing database:

https://www.nopcommerce.com/boards/t/12962/installing-nopcommerce-on-test-server-with-an-existing-database.aspx

and

https://www.nopcommerce.com/boards/t/12174/connecting-the-new-instance-of-nopcommerce20-to-existing-database.aspx

where the advice was to do this :

nstall nopCommerce to any new empty database. After it's done you'll have \Add_Data\Settings.txt file. Just open it and update your connection string so it points to your old database. Restart the application. After it's done your old database will be used
posted by a.m. Posted: September 29, 2011 at 6:22 AM

So I created a new database on my hosters backpanel (smarterASP). I tried to install my instance using the new empty database and I get this error:

Setup failed: Introducing FOREIGN KEY constraint 'WebShop_Product_WebshopOwner' on table 'Td_WebShop_Product_Mapping' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints. Could not create constraint or index. See previous errors.

there is no way it works. When I use my actual database with data, I got the error of an existing database:

Setup failed: An error occurred while updating the entries. See the inner exception for details.

what should I do? I would really need to get it working

many thanks in advance,

Mani2 wrote:

it seems that you have some custom plugins as well and when it tried to create table from plugin it throws this errors.

so i think first you need to fix the custom plugin installation on existing system then you need to try with fresh installation with blank db.

Or you can move the custom plugins temporary for nopcommerce installation and after installation you can apply the old database connection string in appdata\setting.txt and move the plugin back and install it or just add plugin systemname in appdata\installedplugin.txt files so it don't tried to create the table from plugin on custom plugin installation time


I Hope it help

Hi Vipul,

thanks for your quick reply. But How can I easily disable the plugins in Visual studio when deploying?

kind regards