Database Upgrade Error / V1.5.1 to V1.5.5 / Data too long for column

**Brent** · 25 Mar 2018, 10:01 AM

Hi,

My 1.5.5 site is already built so I'm now just importing my live database and running a database upgrade. When doing so I get the following error:

[24-Mar-2018 23:50:36 UTC] MySQL error 1406 encountered during zc_install:
Data too long for column 'shipping_method' at row 5748
ALTER TABLE zen_orders MODIFY shipping_method VARCHAR(255) NOT NULL DEFAULT '';

Any advice on how to fix this please?

Brent

**Brent** · 25 Mar 2018, 10:23 AM

OK I ran the following and it seems to have worked the second time. Looking in phpMyAdmin the table has been updated.

PHP Code:


ALTER TABLE orders MODIFY shipping_method VARCHAR(255) NOT NULL DEFAULT '';

**mc12345678** · 26 Mar 2018, 06:07 AM

Originally Posted by Brent

OK I ran the following and it seems to have worked the second time. Looking in phpMyAdmin the table has been updated.

PHP Code:


ALTER TABLE orders MODIFY shipping_method VARCHAR(255) NOT NULL DEFAULT '';

Umm, but if the above query were to be run specifically against this database knowing the information from both posts, then the query should have been as entered in phpmyadmin:

PHP Code:


ALTER TABLE zen_orders MODIFY shipping_method VARCHAR(255) NOT NULL DEFAULT '';

Adding the prefix of zen_ to the table name as reported from the first post.

Therefore, question whether the verification of the update was correct and if the action really took place. (or, that there was a slight mistake in posting, not sure which or what elese it may have been.)

**Brent** · 26 Mar 2018, 07:08 AM

Originally Posted by mc12345678

Therefore, question whether the verification of the update was correct and if the action really took place. (or, that there was a slight mistake in posting, not sure which or what elese it may have been.)

The post was correct but I could have been more explicit. Apologies.

I ran the query via my cart so I didn't need the prefix. The problem was reproducible though as I ran the upgrade a further 6 times trying to solve my issue with Image Handler 5 and every time this table failed to update. I then fixed via either phpMyAdmin or my cart.

I may need to run the upgrade again as I'm still stuck with IH so could give further feedback if needed.