Image Upload in 4.2

2 months ago
I have a new issue that I hope readers can assist with.
Now that I have the cart working with images I note that the Product SEO Friendly Name are muddled.
e.g. friendly name /celtic-pouch returns product "Checkered Stripe Tee"
Looks like its in UrlRecord where the EntityId is the ProductId

Before I go editing records I hope someone can confirm I'm in the right place.
2 months ago
[email protected] wrote:
Looks like its in UrlRecord where the EntityId is the ProductId


Yes, friendly name is in UrlRecord table, where EntityId is ProductId and EntityName is equal 'Product'.
2 months ago
I discovered that in the Public facing site if I clicked on a category from the dropdown menu nothing happens but if I drill down through sub categories those work. I noted in UrlRecord that the Category Casual-Wear had entityId 1 whereas it is actually 35, in fact many of the categories appear to bear the wrong EntityId. Not sure how this has come about but again before I go meddling I just wanted to double check that I'm about to edit the right thing. Can someone please confirm that EntityId with EntityName Category should relate to Category.Id?
2 months ago
yes, exactly, and to confirm 100%


SELECT TOP 1 *
FROM Category cat
INNER JOIN UrlRecord rec
ON cat.Id = rec.EntityId
AND rec.EntityName = 'Category'
2 months ago
Sorted, with all my messing about it was easier to simply delete all categories in UrlRecord and replace. It would seem when my Original Categories were deleted that it did not cascade to related records.  Now sorted and many thanks for the help af1Racing. BTW from your avatar it would seem we are fellow motorcycle enthusiasts.
2 months ago
Glad you got it sorted.  And yes, that's me a long time ago when I was young and fearless.  Pity about Norton, we love their bikes.
2 months ago
The nopCommerce project I'm working on is for a Harley-Davidson dealer and when I'm not at the PC I run motorcycle tours McTours European Motorcycle Tours though none at present and most this year are now cancelled. Still hoping to run the Italy, Albania, Macedonia, Greece tour late August into September. Hopefully, the virus threat will be much reduced by then.
1 month ago
Did anyone here run into the same problem I did regarding NopCommerce 4.2 not automatically generating all the different sized images, naming accordingly ("_125.jpeg" etc) and putting in the thumbs folder?   It only works in Visual Studio 2019 (IIS Express), but auto-generation does not work on Windows Server 2012R2 (IIS 8.5).  
Normally, if you create images in the images folder with the proper naming convention ("001245_0.jpeg") & map the image in the appropriate tables, all the thumbnails will automatically be generated.  But this does not work in IIS!  Driving me bonkers! (it worked just fine in NC4.0 and 4.1)