Copied to clipboard

Flag this post as spam?

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


  • Gaitano Boeraeve 17 posts 56 karma points
    Sep 28, 2015 @ 10:47
    Gaitano Boeraeve
    0

    Umbraco 7.2.8 + Merchello 1.12.0: Failed to retreive data for product key

    I updated both my Merchello-webshop-in-progress (from v1.8) and Umbraco last weekend. Umbraco is on 7.2.8 now, Merchello on 1.12.0

    I'm encountering issues in the backend now when I try to edit my products from the merchello tab (see below)

    Failed to retreive data for product key a0cb5847-5330-4fdd-802d-8da2179646e8
    
    Object reference not set to an instance of an object.
    
    EXCEPTION DETAILS:
    
    System.NullReferenceException: Object reference not set to an instance of an object.
    STACKTRACE:
    
    at Merchello.Web.WebApi.JsonCamelCaseFormatter.OnActionExecuted(HttpActionExecutedContext httpActionExecutedContext)
       at System.Web.Http.Filters.ActionFilterAttribute.CallOnActionExecuted(HttpActionContext actionContext, HttpResponseMessage response, Exception exception)
       at System.Web.Http.Filters.ActionFilterAttribute.<>c__DisplayClass2.<System.Web.Http.Filters.IActionFilter.ExecuteActionFilterAsync>b__1(CatchInfo`1 info)
       at System.Threading.Tasks.TaskHelpersExtensions.<>c__DisplayClass4`1.<Catch>b__3()
       at System.Threading.Tasks.TaskHelpersExtensions.CatchImpl[TResult](Task task, Func`1 continuation, CancellationToken cancellationToken)
    

    When I go to my product pages, where I had a SKU selected using the merchello product picker I get the same error and the selected product can't be shown. I can perfectly re-pick that product, save the page, en the front-end keeps working. But re-entering the page gives te same error.

    However everything still keeps works fine in the front-end (product page)

    I searched in the DB and find a merchProduct with pk 'a0cb5847-5330-4fdd-802d-8da2179646e8' and merhProductVariant with productkey 'a0cb5847-5330-4fdd-802d-8da2179646e8'

    What could be wrong?

  • Rusty Swayne 1655 posts 4993 karma points c-trib
    Sep 28, 2015 @ 15:51
    Rusty Swayne
    0

    @Gaitano - I'm guessing the product index (Examine) needs to be rebuild as there were quite a few new additions relating to IProductContent.

  • Gaitano Boeraeve 17 posts 56 karma points
    Dec 16, 2015 @ 15:05
    Gaitano Boeraeve
    0

    Never really gave feedback about this issue I had:

    Rebuilding Examine didn't do much, while it normally finishes quite fast it kept on tying and never finished rebuilding index. The problem was due to missing tables.

    When updating from an old version of Merchello something probably went wrong when executing the SQL scripts for 1.12. The two new tables DetachedContentType and VariantDetachedContent were missing in my database.

    I solved this by changing the merchello versionnumber in web.config to 1.11 and ran the application. This time the migration got executed and everything was working again.

    Rebuilding examine indexes worked like a charm now.

  • Rusty Swayne 1655 posts 4993 karma points c-trib
    Dec 17, 2015 @ 17:32
    Rusty Swayne
    0

    Thanks Gaitano - what version number were you upgrading from?

  • Gaitano Boeraeve 17 posts 56 karma points
    Dec 18, 2015 @ 14:38
    Gaitano Boeraeve
    0

    From 1.8.0 to 1.12 (i see in my git log), don't ask me about the steps in between. I upgraded to latest Umbraco first.

Please Sign in or register to post replies

Write your reply to:

Draft