Forums / Upgrading from 1.2 to 1.3.x / 1170 BLOB/TEXT column - error

1170 BLOB/TEXT column - error

Locked

Started by jeking on 6 Sep 2007, 8:56 PM · Views: 3,459

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
6 Sep 2007, 8:56 PM
#1
jeking avatar

jeking

Totally Zenned

Join Date:
Oct 2005
Location:
Chicago, IL USA
Posts:
1,592
Plugin Contributions:
0

1170 BLOB/TEXT column - error

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);]

Jim
Wheaton Website Services

6 Sep 2007, 9:16 PM
#2
jeking avatar

jeking

Totally Zenned

Join Date:
Oct 2005
Location:
Chicago, IL USA
Posts:
1,592
Plugin Contributions:
0

Re: 1170 BLOB/TEXT column - error

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.

Jim
Wheaton Website Services

6 Sep 2007, 9:23 PM
#3
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,511
Plugin Contributions:
176

Re: 1170 BLOB/TEXT column - error

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_nameB[/B]);

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.