SQL 4.3 upgrade script doubled tables

Hi guys, after running the upgrade script to 4.3 & software migration to 4.3 anything seemed to be great.
But: Any table has a double entry added:
Old table:
sample.Product

New tables:
sample.Product AND
dbo.Product
Deleted all new dbo.xxx entries but they are restored automatically ?!

Any hints welcome!

Did you move database to a new SQL Server?   It sounds like the current SQL user account your are connecting with has a default schema set to  'dbo', where previously the database was created under schema named 'sample'

tomsen wrote:

Hi JonQuick, thanks for your replay.

First executed upgrade script on a test db, then (after success) on the live db.
Maybe something messed up there?

Am I right to say that sample.Product has the 'real' live data, and dbo.Product is empty table? Is nopCommerce showing the correct data? or empty data?

Jon




tomsen wrote:

Yes

Shows up almost fine. Only some locale strings are missing.

if you connect to SQL Server with SSMS using the same account that is in dataSettings.json

and execute this query, what is the result?

SELECT SCHEMA_NAME()

tomsen wrote:

SELECT SCHEMA_NAME() says "sample" which contains live-data.

Pls. have a look at the upgrade sql script 4.2 => 4.3:

--new column
IF EXISTS (SELECT 1 FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ShippingByWeightByTotalRecord]') and OBJECTPROPERTY(object_id, N'IsUserTable') = 1)
and NOT EXISTS (SELECT 1 FROM sys.columns WHERE object_id = object_id('[ShippingByWeightByTotalRecord]') AND NAME = 'TransitDays')
BEGIN
  ALTER TABLE [ShippingByWeightByTotalRecord]
  ADD TransitDays int NULL
END
GO

I added the transitdays with SSMS to keep the Shipping Plugin "working".

Ok, thats good.

I'm not sure what could be causing the creation of the dbo.  objects.  Any 3rd party plugins which create database objects?

tomsen wrote: