1170 BLOB/TEXT column - error

[jeking]

I'm upgrading my DB from 1.2.7 to 1.3.0 and got this error. I'm not sure how to fix it.

1170 BLOB/TEXT column 'products_options_values_name' used in key specification without a key length
in:
[ALTER TABLE zen_products_options_values ADD INDEX idx_products_options_values_name_zen (products_options_values_name);]

[jeking]

I went back and clicked on recheck and it worked and finished the upgrade. I can't explain it, but it seems to be okay now.

[DrByte]

You must have changed your products_options_name field from the default varchar(64) to blob type.

To keep it as a blob and have the upgrader not croak, you'll need to edit line 63 of the mysql_upgrade_zencart_1302_to_135.sql file from this:

ALTER TABLE products_options_values ADD INDEX idx_products_options_values_name_zen (products_options_values_name);

to this:

ALTER TABLE products_options_values ADD INDEX idx_products_options_values_name_zen (products_options_values_name(50));

... and then resume upgrading starting with the 1302-to-135 step