The web.config is still showing merchelloConfigurationStatus of 1.10.0 so I'm guessing Nuget install did not actually update anything other than the dlls.
I tried downloading the Merchello_2.1.0.zip file but that just contains GUID-named files.
merchNote is a table that was adding in version 1.13.1.
Do you have a table in your db named 'merchDetachedContentType' ... that would have been added at 1.12.0
Here is what I posted the other day to help someone get to 1.11.0.
Can you confirm all of these modifications have been made in your db - if so set your merchelloConfigurationStatus to 1.11.0 and give it a go - if not, can you let me know what is missing?
-- 1.9.0
CREATE TABLE [dbo].[merchOfferSettings](
[pk] [uniqueidentifier] NOT NULL DEFAULT ('newid()'),
[name] [nvarchar](255) NOT NULL,
[offerCode] [nvarchar](255) NOT NULL,
[offerProviderKey] [uniqueidentifier] NOT NULL,
[offerStartsDate] [datetime] NULL,
[offerEndsDate] [datetime] NULL,
[active] [bit] NOT NULL,
[configurationData] [ntext] NULL,
[updateDate] [datetime] NOT NULL DEFAULT (getdate()),
[createDate] [datetime] NOT NULL DEFAULT (getdate()),
CONSTRAINT [PK_merchOfferSettings] PRIMARY KEY CLUSTERED
(
[pk] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
CONSTRAINT [IX_merchOfferSettingsOfferCode] UNIQUE NONCLUSTERED
(
[offerCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[merchOfferRedeemed](
[pk] [uniqueidentifier] NOT NULL DEFAULT ('newid()'),
[offerSettingsKey] [uniqueidentifier] NULL,
[offerCode] [nvarchar](255) NOT NULL,
[offerProviderKey] [uniqueidentifier] NOT NULL,
[customerKey] [uniqueidentifier] NULL,
[invoiceKey] [uniqueidentifier] NOT NULL,
[redeemedDate] [datetime] NOT NULL,
[extendedData] [ntext] NULL,
[updateDate] [datetime] NOT NULL DEFAULT (getdate()),
[createDate] [datetime] NOT NULL DEFAULT (getdate()),
CONSTRAINT [PK_merchOfferRedeemed] PRIMARY KEY CLUSTERED
(
[pk] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
-- 1.10.0
ALTER TABLE [dbo].merchTaxMethod ADD productTaxMethod BIT DEFAULT 0 NOT NULL;
INSERT INTO [dbo].merchStoreSetting
(pk, name, [value], typeName, updateDate, createDate)
VALUES
(
'E322F6C7-9AD6-4338-ADAA-0C86353D8192',
'globalShippingIsTaxable',
'False',
'System.Boolean',
GETDATE(),
GETDATE()
)
-- 1.11.0
GO
INSERT INTO [dbo].merchTypeField
(pk, name, alias, updateDate, createDate)
VALUES
('A3C60219-2687-4044-A85C-CC7D6FFCA298', 'EntityCollection', 'EntityCollection', GETDATE(), GETDATE())
GO
CREATE TABLE [dbo].[merchEntityCollection](
[pk] [uniqueidentifier] NOT NULL DEFAULT ('newid()'),
[parentKey] [uniqueidentifier] NULL,
[entityTfKey] [uniqueidentifier] NOT NULL,
[name] [nvarchar](255) NOT NULL,
[sortOrder] [int] NOT NULL DEFAULT ('0'),
[providerKey] [uniqueidentifier] NOT NULL,
[updateDate] [datetime] NOT NULL DEFAULT (getdate()),
[createDate] [datetime] NOT NULL DEFAULT (getdate()),
CONSTRAINT [PK_merchEntityCollection] PRIMARY KEY CLUSTERED
(
[pk] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[merchEntityCollection] WITH CHECK ADD CONSTRAINT [FK_merchEntityCollection_merchEntityCollection] FOREIGN KEY([parentKey])
REFERENCES [dbo].[merchEntityCollection] ([pk])
GO
ALTER TABLE [dbo].[merchEntityCollection] CHECK CONSTRAINT [FK_merchEntityCollection_merchEntityCollection]
GO
CREATE TABLE [dbo].[merchInvoice2EntityCollection](
[invoiceKey] [uniqueidentifier] NOT NULL,
[entityCollectionKey] [uniqueidentifier] NOT NULL,
[updateDate] [datetime] NOT NULL DEFAULT (getdate()),
[createDate] [datetime] NOT NULL DEFAULT (getdate()),
CONSTRAINT [PK_merchInvoice2EntityCollection] PRIMARY KEY CLUSTERED
(
[invoiceKey] ASC,
[entityCollectionKey] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[merchInvoice2EntityCollection] WITH CHECK ADD CONSTRAINT [FK_merchInvoice2EntityCollection_merchEntityCollection] FOREIGN KEY([entityCollectionKey])
REFERENCES [dbo].[merchEntityCollection] ([pk])
GO
ALTER TABLE [dbo].[merchInvoice2EntityCollection] CHECK CONSTRAINT [FK_merchInvoice2EntityCollection_merchEntityCollection]
GO
ALTER TABLE [dbo].[merchInvoice2EntityCollection] WITH CHECK ADD CONSTRAINT [FK_merchInvoice2EntityCollection_merchInvoice] FOREIGN KEY([invoiceKey])
REFERENCES [dbo].[merchInvoice] ([pk])
GO
ALTER TABLE [dbo].[merchInvoice2EntityCollection] CHECK CONSTRAINT [FK_merchInvoice2EntityCollection_merchInvoice]
GO
CREATE TABLE [dbo].[merchProduct2EntityCollection](
[productKey] [uniqueidentifier] NOT NULL,
[entityCollectionKey] [uniqueidentifier] NOT NULL,
[updateDate] [datetime] NOT NULL DEFAULT (getdate()),
[createDate] [datetime] NOT NULL DEFAULT (getdate()),
CONSTRAINT [PK_merchProduct2EntityCollection] PRIMARY KEY CLUSTERED
(
[productKey] ASC,
[entityCollectionKey] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[merchProduct2EntityCollection] WITH CHECK ADD CONSTRAINT [FK_merchProduct2EnityCollection_merchProduct] FOREIGN KEY([productKey])
REFERENCES [dbo].[merchProduct] ([pk])
GO
ALTER TABLE [dbo].[merchProduct2EntityCollection] CHECK CONSTRAINT [FK_merchProduct2EnityCollection_merchProduct]
GO
ALTER TABLE [dbo].[merchProduct2EntityCollection] WITH CHECK ADD CONSTRAINT [FK_merchProduct2EntityCollection_merchEntityCollection] FOREIGN KEY([entityCollectionKey])
REFERENCES [dbo].[merchEntityCollection] ([pk])
GO
ALTER TABLE [dbo].[merchProduct2EntityCollection] CHECK CONSTRAINT [FK_merchProduct2EntityCollection_merchEntityCollection]
GO
CREATE TABLE [dbo].[merchCustomer2EntityCollection](
[customerKey] [uniqueidentifier] NOT NULL,
[entityCollectionKey] [uniqueidentifier] NOT NULL,
[updateDate] [datetime] NOT NULL,
[createDate] [datetime] NOT NULL,
CONSTRAINT [PK_merchCustomer2EntityCollection] PRIMARY KEY CLUSTERED
(
[customerKey] ASC,
[entityCollectionKey] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[merchCustomer2EntityCollection] ADD DEFAULT (getdate()) FOR [updateDate]
GO
ALTER TABLE [dbo].[merchCustomer2EntityCollection] ADD DEFAULT (getdate()) FOR [createDate]
GO
ALTER TABLE [dbo].[merchCustomer2EntityCollection] WITH CHECK ADD CONSTRAINT [FK_merchCustomer2EntityCollection_merchEntityCollection] FOREIGN KEY([entityCollectionKey])
REFERENCES [dbo].[merchEntityCollection] ([pk])
GO
ALTER TABLE [dbo].[merchCustomer2EntityCollection] CHECK CONSTRAINT [FK_merchCustomer2EntityCollection_merchEntityCollection]
GO
ALTER TABLE [dbo].[merchCustomer2EntityCollection] WITH CHECK ADD CONSTRAINT [FK_merchCustomer2EntityCollection_merchInvoice] FOREIGN KEY([customerKey])
REFERENCES [dbo].[merchCustomer] ([pk])
GO
ALTER TABLE [dbo].[merchCustomer2EntityCollection] CHECK CONSTRAINT [FK_merchCustomer2EntityCollection_merchInvoice]
GO
Did you also update the App_Plugins/Merchello files? These will not be replaced by the Merchello.Core NuGet library. There has been quite a bit of confusion around that in the past month -
Merchello's NuGet library is ONLY the binaries and is intended to be used similar to the UmbracoCms.Core package - not the UmbracoCms package which installs everything. We will likely have a Merchello package sometime after Umbraco 8.0.0 is released assuming the new package stuff that Umbraco is currently working on pans out as they are hoping it will.
Failed to instantiate remote logger. Returning default logger. Exception: System.NullReferenceException: Object reference not set to an instance of an object
This is a failing due to a reference in the Merchello.config file that I'm guessing you don't have.
I've finally got a potential opportunity to pick back up on an existing Merchello project and I'm looking at upgrading from 2.2 > 2.5. @Lesley has a valid question here and I am trying to work out from the upgrade instructions how it is even possible to follow them when the only downloadable artefacts are the Umbraco package so you can't actually copy over the bin files and App_Plugin files as instructed. Can you clarify this, please?
We quit bundling the change files since they were actually causing more issues for us - e.g. no matter what we wrote in the instructions someone would try to install the zip as a package in the back office or something and then get pretty snippy =)
The easiest way is to download Umbraco and install the Merchello package (into the new umbraco instance).
Copy the App_Plugins/Merchello and the bin/Merchello.*.dll(s) from new install into the site to be upgraded.
How to upgrade from 1.10.0 to 2.1.0?
I try to do it with this step:
But the site now gives the following error:
Invalid object name 'merchNote'.
The web.config is still showing merchelloConfigurationStatus of 1.10.0 so I'm guessing Nuget install did not actually update anything other than the dlls.
I tried downloading the Merchello_2.1.0.zip file but that just contains GUID-named files.
merchNote is a table that was adding in version 1.13.1.
Do you have a table in your db named 'merchDetachedContentType' ... that would have been added at 1.12.0
Here is what I posted the other day to help someone get to 1.11.0.
Can you confirm all of these modifications have been made in your db - if so set your merchelloConfigurationStatus to 1.11.0 and give it a go - if not, can you let me know what is missing?
I had the 1.9.0 and 1.10.0 changes but not the 1.11.0 changes.
Ran the 1.11.0 part of your SQL script and then tried uninstalling and reinstalling Merchello via Nuget.
Now get the following error when trying to access Merchello via back end
I also still don't have merchNote in the database, so it looks as though Nuget doesn't do anything in terms of updating the database
Looking in the error logs, I see the following Merchello errors which might explain why database is not being updated.
Hey Lesley,
Did you also update the App_Plugins/Merchello files? These will not be replaced by the Merchello.Core NuGet library. There has been quite a bit of confusion around that in the past month -
Merchello's NuGet library is ONLY the binaries and is intended to be used similar to the UmbracoCms.Core package - not the UmbracoCms package which installs everything. We will likely have a Merchello package sometime after Umbraco 8.0.0 is released assuming the new package stuff that Umbraco is currently working on pans out as they are hoping it will.
This is a failing due to a reference in the Merchello.config file that I'm guessing you don't have.
Hey Lesley,
Simon is having similar issues in this thread - https://our.umbraco.org/projects/collaboration/merchello/merchello/78817-upgrade-merchello-to-113#comment-252459
Where can I get a copy of the latest App_Plugins/Merchello files?
The 2.1.0 zip file only has GUID-named files. There is no App_Plugins folder.
Hey Rusty,
Hope you're well.
I've finally got a potential opportunity to pick back up on an existing Merchello project and I'm looking at upgrading from 2.2 > 2.5. @Lesley has a valid question here and I am trying to work out from the upgrade instructions how it is even possible to follow them when the only downloadable artefacts are the Umbraco package so you can't actually copy over the bin files and App_Plugin files as instructed. Can you clarify this, please?
Cheers, Simon
Hey Simon,
We quit bundling the change files since they were actually causing more issues for us - e.g. no matter what we wrote in the instructions someone would try to install the zip as a package in the back office or something and then get pretty snippy =)
The easiest way is to download Umbraco and install the Merchello package (into the new umbraco instance).
Copy the App_Plugins/Merchello and the bin/Merchello.*.dll(s) from new install into the site to be upgraded.
Thanks for the further details Rusty.
is working on a reply...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.