Text Being Truncated when Sent

[Mort-lemur]

Hi,

 

I have a small problem on a 2.2 Rc2a site that uses option Types V2.

 

On one of the items I have an option as a Text Area where people can add custom text that they want adding to the product.

 

In admin panel / catalog / products attributes i have set the size of this text area to 500 characters and can confirm via phpmyadmin that the field length is set to 500.

 

However, although a customer can type lots of text in this box, only the first 32 characters are sent through with the order.

 

Any Ideas what i need to change in the database to allow longer text entries to be sent?

 

Many thanks

[Mort-lemur]

Could it be due to the fact that the field is set to an "int" which restricts the field length?

 

Im at a loss on this one.....

[♥kymation]

Check the products_options_values field in the orders_products_attributes table. Stock osC sets that to Varchar 32. Change it to Varchar 500 if you have MySQL 5.x, otherwise change it to Text.

 

It's been a long time since I've done this, so please excuse me if my memory got this bit wrong.

 

Regards

Jim

[Mort-lemur]

Thanks Jim,

 

Worked a treat, you are a star :)