November Happy Hour will be moved to Thursday December 5th.
AI OnAI Off
Crashing carts after Episerver.Commerce minor version upgrade
For anyone facing the same issue we tested small in development and then did the full update on all carts in the database using theese 3 queries.
The actuall update statement within transaction for testing/safety
BEGIN TRANSACTION
UPDATE SerializableCart
SET [Data] = REPLACE([Data], 'Version=13.30.0.0', 'Version=13.37.0.0')
WHERE [Data] LIKE '%Version=13.30.0.0%'
--COMMIT TRANSACTION
ROLLBACK TRANSACTION
2 listing queries to verify that the versions had migrated over.
SELECT * FROM SerializableCart
WHERE [Data] LIKE '%Version=13.37.0.0%'
SELECT * FROM SerializableCart
WHERE [Data] LIKE '%Version=13.30.0.0%'
Jun 27, 2024 9:01
Hi,
When upgrading our commerce site from version 13.30 to 13.37 all preexisting carts stopped beeing able to load and result in a crash. While investigating the cause we notice that the version number that the cart was created in was saved in the SerializableCart and is most likely the reason why it crash. The error we recieve is "Could not load file or assembly 'Mediachase.Commerce, Version=13.30.0.0, Culture=neutral...". This error and crash also happens when trying to list all carts in the Commerce "Order Manager" and the old carts are not listed. Same in the old commerce manager. We have tried accessing the carts programaticly to remove them that way but get the same error/crash when loading them wherever and however we try. We are thinking that we might be able to update the version number in the database as the version number is the only difference. But we want more input on how to solve this before we start editing the database.
/Best regards Erik,