In order.php part of the "option name" gets chopped off

[PB2009]

When customer's order is listed in order.php, the "Option Name" portion is getting chopped off if it exceeds 32 characters (30 w/out spaces added). I have changed the product option names under >Catalog>option names, "Display Size" to be MORE than 32 (40 & 50), and the "Maximum length" to be either 64 or 350.

Customer's 'text' emails come out fine with all the text intact; admin emails (in html) are also chopped off in exactly same place as in order.php.

Does anyone know where the switch is to stop this from chopping off??

FYI, I am running v1.3.8a newly installed, no live customers yet.

Sorry if this has been addressed elsewhere, I have found nothing after 3 hours of searching the forums (although I was able to find answers to other issues---hooray for me, eh? ).

Thanks in advance for any pointers.

[Ajeh]

When you say the Option Name size, are you referring to the "physical" size of the Option Name, such as "Color" or "Size", being too small?

[PB2009]

When you say the Option Name size, are you referring to the "physical" size of the Option Name, such as "Color" or "Size", being too small?

Here is an example below (keep in mind this ONLY occurs in ADMIN/ORDERS and on ADMIN's html email of customer's order...the customer's plain-text email doesn't get chopped off.):

OPTION NAME (should say):
"Email address where you would like your report sent:" [then customer's response]

(chopped off version displayed):
"Email address where you would li:" [then customer's response]

--The actual text-box, when filled in by customer, does not get chopped off, no matter how big it is.

This occurs whether the option type is text, radio, or checkbox.

I cannot locate where to change this value so that the html will display properly.

**And thank you so much for your time!**

[Ajeh]

What is happening is you increased at some point the size of the field:
products_options_name

in the table:
products_options

but you did not complete the process and increase the size in the table:
orders_products_attributes

for the field:
products_options

The Orders tables have fields to hold the data as it existed when the Product was purchased ... so, you need to make matching changes to the various tables so that the fields are able to hold the values that one table may hold as well as manage any additional needs between the Catalog and the Admin ...

[PB2009]

Oohhhhhhh, I see.

Ajeh, Thanks SO much. You are right that I made changes to size in one of the tables (was so long ago I had forgotten). This seems to be working, so far as I have tested. I will continue testing later and report back if I find any other problems with this.

In the meantime, if you think of any other tables that are affected by a customer's order, please let me know.

[Ajeh]

In the meantime, if you think of any other tables that are affected by a customer's order, please let me know.

There are a lot of tables affected by changes to other tables ... this is too vague to just "guess" at ...

One way to check is to look in the:
/zc_install/sql/mysql_zencart.sql

file or do an export on your database tables structure and do some searches for similar tables/fields ...

For example, the Order tables start with the name:
orders_

If you look at the fields in those tables you can probably pair up the tables/fields that match from the Catalog to complete an order ...

Then, there are other tables involved such as the:
address_book

where the fields for customer information on the customers, delivery and shipping are built ...

If a change were made to the address_book to increase the size of fields then the same would need to be done to the:
orders

table so that it could hold the new size or data etc.