X-Cart forums - X-Cart 5.2.3: upgrade issue fix for the users running MySQL v.5.6

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

- News and Announcements (https://forum.x-cart.com/forumdisplay.php?f=28)

- - X-Cart 5.2.3: upgrade issue fix for the users running MySQL v.5.6 (https://forum.x-cart.com/showthread.php?t=71712)

Re: X-Cart 5.2.3: upgrade issue fix for the users running MySQL v.5.6

Quote:

Originally Posted by kevinrm

[02-Apr-2015 12:00:42] Error (code: 0): An exception occurred while executing 'ALTER TABLE xc_order_items ADD CONSTRAINT FK_FC5C8B059A1887DC FOREIGN KEY (subscription_id) REFERENCES xc_subscription (id)':

This seems to be due to a column definition that is incompatible with the new version of Doctrine ORM library: http://kb.x-cart.com/display/XDD/Updating+modules+from+5.1+to+5.2+branch

I don't see the "subscription_id" field among standard X-Cart 5 fields, so I guess this is a custom module added by you.

Please follow the instructions and make sure that you fixed both the points:
- "uinteger" column type is deprecated and should be replaced with the "integer" one having {"unsigned": true} in its options
- if your module adds new integer/string columns to existing database tables, these fields should be declared as "nullable=true"

If you had "uinteger" fields, you should apply the Database/pre-upgrade hook fix too.

-------

UPDATE: I've just realized that this may be a field of the X-Payments Subscriptions module. Do you have the module?

Quote:

Originally Posted by kevinrm

[01-Apr-2015 18:49:55] Error (code: 0): An exception occurred while executing 'ALTER TABLE xc_template_patches ADD version VARCHAR(32) DEFAULT NULL':

SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'version'

I'm not sure about this problem and haven't seen it before. Perhaps it happens because of an incomplete upgrade. You can try the soft reset function and check if this is caused by a custom module, or not.

Re: X-Cart 5.2.3: upgrade issue fix for the users running MySQL v.5.6

Hello,

I do not have any custom modules, everything is stock and this is a development installation, but I do have X-Payments Subscriptions module installed.

X-Cart team got my system back up through a ticket, fortunately.

The current problem I am having is whenever I upgrade or add a new module, my Safari browser continuously reloads the page over and over rapidly for each step of the upgrade process, even to the point of causing my computer to overheat and kick on the fan. When I manually stop the loading, it then jumps to the next step and does that over again until I get to the very end.

Re: X-Cart 5.2.3: upgrade issue fix for the users running MySQL v.5.6

Hello @kevinrm ,

As I see, our support team has already upgraded the store for you. Happy to know that your store is up again.

As for the problem with failed upgrade, there is indeed a problem that caused by incorrectly updated modules. We sent a newsletter to each X-Cart 5 developer, so they would check their modules and adjust them if needed. Here is an instruction about updating modules in case somebody needs it:
http://kb.x-cart.com/display/XDD/Updating+modules+from+5.1+to+5.2+branch

Re: X-Cart 5.2.3: upgrade issue fix for the users running MySQL v.5.6

Quote:

Originally Posted by tony_sologubov

I am having the same failure (step 5 of 12) on a brand new install of XCART

Re: X-Cart 5.2.3: upgrade issue fix for the users running MySQL v.5.6

Quote:

Originally Posted by eblieb

I am having the same failure (step 5 of 12) on a brand new install of XCART

Please, find my answer here:
http://forum.x-cart.com/showthread.php?t=71929