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 ?!
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 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 ?!
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:
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?
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".