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)
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)
... I have noticed that the Product Content Type appears wrong:
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 :-(
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.
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.
I followed your instructions, except that I copied
umbracoNode.uniqueID to the merchDetachedContentType.ContentTypeKey
(instead of umbracoNode.nodeObjectType)
Error listing products
After updating a website installation, I am getting the following error when I try and access the "Products" list in the Merchello section.
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:
I get this if I turn on "debug" mode in web.config:
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!!
... I have noticed that the Product Content Type appears wrong:
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 :-(
I'm having the same issue ON MY LIVE SITE.
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.
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.
Ah yes, sorry about that! You are correct.
is working on a reply...