Attribute name length...

We need a way to increase the attribute name length from 32 to upwards of 200. I have searched around and found very little information on the subject so i figured i would make a thread. We are using the attributes so a user can flag any number of 15 potential reasons there device could have gone bad for a product called "warranty". Any help would be most appreciated.

jordan

I am guessing that you are referring to either or both of:
products_options_name in the products_options table

NOTE: there is a Comment field for the Option Names if that helps

or to the:
products_options_values_name in the products_options_values table

You would then have to also update the orders_products_attributes table for the field:
products_option

Be sure to check orders from start to finish to ensure nothing is cut off ...

For my first venture into editing SQL on here that went surprisingly well. Thanks Linda.

For anyone interested in having extremely long attribute values try:

ALTER TABLE products_options_values CHANGE products_options_values_name products_options_values_name VARCHAR( 255 );

you can replace 255 with any value between 1-255. NOTE: Text will not automatically wrap so you have to count characters and use "<br>" in your attrib/values.

jordan

Hi there

I;ve used this trick, however it's not doing it for me.
In the admin panel, I still can't change the Option names to what I want...

I might have to get into the actual SQL tables...bummer

The Zen Cart Admin cannot change your field length beyond what it is already defined as ...

This is the database itself and you can make those changes via phpMyAdmin ...