Product Options Values Length

[patski]

I have a text attribute that is set with a length of 80 chrs, however although the entry accepts this when the order is received the entry is truncated to 64 chrs.

I've had a look in the database table orders_products_attributes (v 1.2.6) and see that products_options_values has a 64 chr limit which seems to be the problem. Can I increase this limit eg 128 without causing a problem elsewhere?

[Ajeh]

In older versions you have to manual change the field length in a couple of tables ...

Are you able to upgrade?

If not, in v1.3.x we changed the table fields to:

ALTER TABLE customers_basket_attributes CHANGE products_options_value_text products_options_value_text BLOB NULL DEFAULT NULL;
ALTER TABLE orders_products_attributes CHANGE products_options_values products_options_values BLOB NOT NULL; 

NOTE: This would have to be tested to assure that this is enough of a change in your version ... I am pretty sure that is all you will need ... I think ...

[patski]

Thanks Linda that did the trick and for anyone else reading this has worked for v 1.2.6.

[Ajeh]

Thanks for the update that this was able to work in older versions of Zen Cart for larger Option Value TEXT lengths ...

[patski]

You're welcome! One other tip - I removed the <nobr> that was wrapping the attribute option value in tpl_checkout_confirmation.php around line 110 so that long message values wrap rather than push the page out.

[TecBrat]

You're welcome! One other tip - I removed the <nobr> that was wrapping the attribute option value in tpl_checkout_confirmation.php around line 110 so that long message values wrap rather than push the page out.

Thank you to both Linda and Patski.

I had already changed the varchar on Table: orders_products_attributes / products_options_values to TEXT before I read this thread, so before I excuted the SQL you provided, I changed the BLOB to TEXT. It worked, as did the removal of <nobr></nobr>

Thanks again.
TecBrat.

[bettysue]

I am trying to lengthen the field length in the option names. I have searched in the db, plus tried the statement above, which generated a phpmyadmin error message about my syntax

help...please

betty

[Ajeh]

In phpMyAdmin ...

Display the structure of:
products_options

Click edit on:
products_options_names

Change the Length/Values from 32 to 64 or the size you need up to 255

Then, display the structure of:
orders_products_attributes

Click edit on:
products_options

Change the Length/Values from 32 to 64 or the size you need up to 255

[bettysue]

thank you Ajeh!!

Once this client is up to v1.35 will I do it the same way or by using your statements above??

again, thank you

Betty

(also I know I've already asked this twice but with no replies. How do I get the downloaded files to show up in sales? I figure it's attributes so I would run it buy you. Please feel free to delete this part if you prefer.)

[bettysue]

Well....darn it Ajeh - it ended up not working the way I thought it would It is the
option name that I need longer in the db.

betty