X-Cart forums - Upgrading to 5.3.4.5 causes error

X-Cart forums (https://forum.x-cart.com/index.php)

- General questions (X-Cart 5) (https://forum.x-cart.com/forumdisplay.php?f=66)

- - Upgrading to 5.3.4.5 causes error (https://forum.x-cart.com/showthread.php?t=75985)

Upgrading to 5.3.4.5 causes error

Hello,

I'm trying to upgrade X-Cart to 5.3.4.5.

My current version is 5.3.2.3, which then asks me to update to 5.3.2.13, then 5.3.4.5.

I've tried to upgrade multiple times now and always get stuck here at the end. Here's the error:

Code:

Deploying store [step 13 of 13], please wait...



Run the "Upgrade_PostRebuildActions" plugin... 

...Invoke actions for XC\ProductVariants

...Hooks 49/66, Items 0/430 [0%]...



An error occurred in your store.

ERROR: "0" (code N/A)

An exception occurred while executing 'UPDATE xc_product_variants SET variant_id = ? WHERE id = ?' with params ["a7c13520c3b10bcae5ccab17dab5480f-nwcc", 36]: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'variant_id' at row 1

Any ideas what to do or how I can finish this upgrade? Thanks!

Re: Upgrading to 5.3.4.5 causes error

Hello!

I see where it may happen (the productVariants533migrate() function in the v5.3.3.0 upgrade hook), but I'm not sure why it may happen - there is a check that limits variant identifiers to the max length allowed in the database.

You are better to contact our support staff - they can check this right on your server:
https://secure.x-cart.com/

Re: Upgrading to 5.3.4.5 causes error

Thanks for the information. I have a ticket in so hopefully that gets answered soon.