nopCommerce 3.50 released

infinito62 wrote:
Please upload it to some file sharing server (e.g. mediafire) and share a link here

a.m. wrote:
Hi Andrei,
I just posted in PM the link.
Please tell me if it's ok

infinito62 wrote:
This error is caused by the following SQL command in the upgrade script:

UPDATE [ShipmentItem]
SET [WarehouseId] = (SELECT p.[WarehouseId] FROM [Product] p
INNER JOIN [OrderItem] oi ON p.[Id] = oi.[ProductId]
WHERE [oi].[Id] = [ShipmentItem].[OrderItemId])
GO

Your database is "corrupted" some way. You have two shipment (ID 2629 and 2630) which referenced non existing order items.

So you can fix it the following way:

UPDATE [ShipmentItem]
SET [WarehouseId] = COALESCE((SELECT p.[WarehouseId] FROM [Product] p
INNER JOIN [OrderItem] oi ON p.[Id] = oi.[ProductId]
WHERE [oi].[Id] = [ShipmentItem].[OrderItemId]), 0)
GO

...or you can simply re-download the upgrade script and run it one more time. Thanks for reporting

Thanks Andrei, now it works fine

Thanks Andrei, much appreciated.

With reference to my post in the Forums in August, I see that you can now include topics in the Main Menu easily.  But I currently do not see how you can add topics as dropdown menu options off a 'parent' topic.

Has this functionality been included?  If so, how do I get it to work?

Regards, and thanks again for all your efforts.

David.

great news for new year :D

Hi Guys,

We would like to share with you our detailed overview of the most popular features in the latest 3.50 nopCommerce release.
We hope you will find our latest post "What's new in nopCommerce 3.50" useful.

Nop-Templates.com Team

When will NC 3.50 be available in Azure?

ckoch1979 wrote:
This work item is planned for version 3.60

Sorry, my question was not precise.

When will NC 3.50 be available in the Web Gallery (Apps) in Azure?