Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Lesley 107 posts 349 karma points
    Jul 28, 2016 @ 23:12
    Lesley
    0

    How to upgrade from 1.10.0 to 2.1.0?

    I try to do it with this step:

    • upgrade Umbraco from 7.2 to last Umbraco 7.4.3
    • ran Nuget "Install-Package Merchello.Core"

    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.

  • Rusty Swayne 1655 posts 4993 karma points c-trib
    Jul 29, 2016 @ 00:04
    Rusty Swayne
    0

    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
    
  • Lesley 107 posts 349 karma points
    Jul 29, 2016 @ 01:20
    Lesley
    0

    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

    enter image description here

    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

  • Lesley 107 posts 349 karma points
    Jul 29, 2016 @ 02:47
    Lesley
    0

    Looking in the error logs, I see the following Merchello errors which might explain why database is not being updated.

    2016-07-29 14:43:45,394 [P17336/D2/T1] INFO Merchello.Web.UmbracoApplicationEventHandler - Attempting to initialize Merchello 2016-07-29 14:43:45,416 [P17336/D2/T1] INFO Merchello.Web.WebBootManager - Verifying Merchello Database is present. 2016-07-29 14:43:45,758 [P17336/D2/T1] WARN Merchello.Web.WebBootManager - Failed to instantiate remote logger. Returning default logger. Exception: System.NullReferenceException: Object reference not set to an instance of an object. at Merchello.Web.Pluggable.PluggableObjectHelper.GetInstance[T](String configurationAlias, Object[] ctrArgValues) at Merchello.Web.WebBootManager.GetMultiLogger() 2016-07-29 14:43:45,767 [P17336/D2/T1] INFO Merchello.Core.CoreBootManager - Initializing Merchello GatewayResolver 2016-07-29 14:43:45,768 [P17336/D2/T1] INFO Umbraco.Core.PluginManager - Starting resolution types of Merchello.Core.Gateways.GatewayProviderBase 2016-07-29 14:43:45,771 [P17336/D2/T1] INFO Umbraco.Core.PluginManager - Completed resolution of types of Merchello.Core.Gateways.GatewayProviderBase, found 0 (took 2ms) 2016-07-29 14:43:45,848 [P17336/D2/T1] INFO Umbraco.Core.PluginManager - Starting resolution types of Merchello.Core.Observation.ITrigger 2016-07-29 14:43:45,851 [P17336/D2/T1] INFO Umbraco.Core.PluginManager - Completed resolution of types of Merchello.Core.Observation.ITrigger, found 0 (took 2ms) 2016-07-29 14:43:45,859 [P17336/D2/T1] INFO Umbraco.Core.PluginManager - Starting resolution types of Merchello.Core.Observation.IMonitor 2016-07-29 14:43:45,966 [P17336/D2/T1] INFO Umbraco.Core.PluginManager - Completed resolution of types of Merchello.Core.Observation.IMonitor, found 0 (took 107ms) 2016-07-29 14:43:45,967 [P17336/D2/T1] ERROR Merchello.Web.UmbracoApplicationEventHandler - Initialization of Merchello failed System.MissingMethodException: Method not found: 'Void Merchello.Core.Observation.MonitorForAttribute..ctor(System.String, System.Type, System.String)'. at System.ModuleHandle.ResolveMethod(RuntimeModule module, Int32 methodToken, IntPtr* typeInstArgs, Int32 typeInstCount, IntPtr* methodInstArgs, Int32 methodInstCount) at System.ModuleHandle.ResolveMethodHandleInternalCore(RuntimeModule module, Int32 methodToken, IntPtr[] typeInstantiationContext, Int32 typeInstCount, IntPtr[] methodInstantiationContext, Int32 methodInstCount) at System.ModuleHandle.ResolveMethodHandleInternal(RuntimeModule module, Int32 methodToken, RuntimeTypeHandle[] typeInstantiationContext, RuntimeTypeHandle[] methodInstantiationContext) at System.Reflection.CustomAttribute.FilterCustomAttributeRecord(CustomAttributeRecord caRecord, MetadataImport scope, Assembly& lastAptcaOkAssembly, RuntimeModule decoratedModule, MetadataToken decoratedToken, RuntimeType attributeFilterType, Boolean mustBeInheritable, Object[] attributes, IList derivedAttributes, RuntimeType& attributeType, IRuntimeMethodInfo& ctor, Boolean& ctorHasParameters, Boolean& isVarArg) at System.Reflection.CustomAttribute.GetCustomAttributes(RuntimeModule decoratedModule, Int32 decoratedMetadataToken, Int32 pcaCount, RuntimeType attributeFilterType, Boolean mustBeInheritable, IList derivedAttributes, Boolean isDecoratedTargetSecurityTransparent) at System.Reflection.CustomAttribute.GetCustomAttributes(RuntimeType type, RuntimeType caType, Boolean inherit) at Umbraco.Core.TypeExtensions.GetCustomAttributes[T](Type type, Boolean inherited) at Umbraco.Core.TypeFinder.

  • Rusty Swayne 1655 posts 4993 karma points c-trib
    Jul 29, 2016 @ 14:33
    Rusty Swayne
    0

    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.

     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.

  • Rusty Swayne 1655 posts 4993 karma points c-trib
    Jul 29, 2016 @ 15:12
  • Lesley 107 posts 349 karma points
    Jul 31, 2016 @ 20:50
    Lesley
    0

    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.

  • Simon Dingley 1470 posts 3427 karma points c-trib
    May 11, 2017 @ 11:28
    Simon Dingley
    0

    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

  • Rusty Swayne 1655 posts 4993 karma points c-trib
    May 13, 2017 @ 15:28
    Rusty Swayne
    1

    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.

  • Simon Dingley 1470 posts 3427 karma points c-trib
    May 14, 2017 @ 06:34
    Simon Dingley
    0

    Thanks for the further details Rusty.

Please Sign in or register to post replies

Write your reply to:

Draft