Sign in Register
Copied to clipboard

Flag this post as spam?

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


  • Gordon Saxby 1444 posts 1855 karma points
    Feb 20, 2017 @ 09:58
    Gordon Saxby
    0

    Error listing products

    Merchello
    Umbraco 7

    After updating a website installation, I am getting the following error when I try and access the "Products" list in the Merchello section.

    Server error: Contact administrator, see log for full details.
Failed to search products

    As far as I can see, the error is not being reported into the error log.

    The products still appear to be there in the database and I have deleted / recreated the Merchello indexes.

    Using the search tools in Umbraco Examine Management works.

    Also, in the Chrome console, I get:

    POST https://mysite.com/umbraco/backoffice/Merchello/ProductApi/SearchProducts 500 (Internal Server Error)
(anonymous) @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:12
o @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:10
g @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:10
i @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:10
i @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:10
(anonymous) @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:10
$eval @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:10
$digest @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:10
$apply @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:10
(anonymous) @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:41
dispatch @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:1
r.handle @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:1
DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:8 ReferenceError: notificationsService is not defined
    at DependencyHandler.axd?s=L0FwcF9QbHVnaW5zL01lcmNoZWxsby9qcy9tZXJjaGVsbG8ubW9kZWxzLmpzOy9BcHBfUGx1Z2l…:455
    at o (DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:10)
    at DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:10
    at Object.$eval (DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:10)
    at Object.$digest (DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:10)
    at Object.$apply (DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:10)
    at j (DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:10)
    at r (DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:11)
    at XMLHttpRequest.w.onreadystatechange (DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:12)
    Copy Link
  • Gordon Saxby 1444 posts 1855 karma points
    Feb 21, 2017 @ 16:18
    Gordon Saxby
    0

    I get this if I turn on "debug" mode in web.config:

    POST https://mysite.com/umbraco/backoffice/Merchello/ProductApi/SearchProducts 500 (Internal Server Error)
(anonymous) @ angular.min.js?cdv=2024641876:106
o @ angular.min.js?cdv=2024641876:102
g @ angular.min.js?cdv=2024641876:100
i @ angular.min.js?cdv=2024641876:79
i @ angular.min.js?cdv=2024641876:79
(anonymous) @ angular.min.js?cdv=2024641876:80
$eval @ angular.min.js?cdv=2024641876:92
$digest @ angular.min.js?cdv=2024641876:90
$apply @ angular.min.js?cdv=2024641876:92
j @ angular.min.js?cdv=2024641876:101
r @ angular.min.js?cdv=2024641876:104
w.onreadystatechange @ angular.min.js?cdv=2024641876:106
angular.min.js?cdv=2024641876:63 ReferenceError: notificationsService is not defined
    at merchello.directives.js?cdv=2024641876:2222
    at o (angular.min.js?cdv=2024641876:80)
    at angular.min.js?cdv=2024641876:81
    at Object.$eval (angular.min.js?cdv=2024641876:92)
    at Object.$digest (angular.min.js?cdv=2024641876:90)
    at Object.$apply (angular.min.js?cdv=2024641876:92)
    at j (angular.min.js?cdv=2024641876:101)
    at r (angular.min.js?cdv=2024641876:104)
    at XMLHttpRequest.w.onreadystatechange (angular.min.js?cdv=2024641876:106)
    Copy Link
  • Gordon Saxby 1444 posts 1855 karma points
    Feb 21, 2017 @ 17:16
    Gordon Saxby
    0

    Umm, it seems like it is a database problem!?

    I copied the entire website from the live server to my local PC and ran that code against my dev database - and it worked.

    I then copied the live database locally and ran the site 9locally) against it - and it failed.

    Both local and live websites have the same versions of Merchello and FastTrack installed, as far as I can tell.

    Lucky this wasn't supposed to go "public" just yet!!

    Copy Link
  • Gordon Saxby 1444 posts 1855 karma points
    Feb 21, 2017 @ 18:11
    Gordon Saxby
    0

    ... I have noticed that the Product Content Type appears wrong:

    enter image description here

    I checked the value of "contentTypeKey" in the merchDetachedContentType table and updated it to the value from umbracoNode - but it doesn't appear to have worked :-(

    Copy Link
  • David Watermeier 1 post 71 karma points
    Feb 21, 2017 @ 20:10
    David Watermeier
    0

    I'm having the same issue ON MY LIVE SITE.

    Copy Link
  • Gordon Saxby 1444 posts 1855 karma points
    Feb 22, 2017 @ 00:17
    Gordon Saxby
    0

    Well, I partially fixed the issue by manually updating the database and then rebuilding the Merchello Product Examine index.

    Search the umbracoNode table for the product type (e.g. ftProduct) and copy the nodeObjectType id.

    Look in the merchDetachedContentType table for the Product Content Type details (I only have one). Replace the contentTypeKey with the value just found in umbracoNode.

    Then, rebuild the MerchelloProductIndexer index.

    I can now see all of my products again. However, the "Umbraco Content Type" and "Umbraco Alias" still don't appear on the Product Content Types screen.

    Copy Link
  • David Sheiles 67 posts 337 karma points
    Feb 26, 2017 @ 11:13
    David Sheiles
    0

    Thanks Gordon for pointing me in the right direction.

    I followed your instructions, except that I copied umbracoNode.uniqueID to the merchDetachedContentType.ContentTypeKey (instead of umbracoNode.nodeObjectType)

    I had to delete /Appdata/Temp/ and /AppData/umbraco.config and then I got my product listing back as well as the "Umbraco Content Type" and "Umbraco Alias" filled in with the correct details.

    Copy Link
  • Gordon Saxby 1444 posts 1855 karma points
    Mar 01, 2017 @ 08:56
    Gordon Saxby
    0

    I followed your instructions, except that I copied umbracoNode.uniqueID to the merchDetachedContentType.ContentTypeKey (instead of umbracoNode.nodeObjectType)

    Ah yes, sorry about that! You are correct.

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft