HELPPPPP! with TextArea for attributes product option types

[pipper0419]

I am currently running OS V2.2 RC2a. I have just installed the Product Attributes - Option type Feature (contribution: http://www.oscommerce.com/community/contributions,160) and I am having problems with the Text attribution option. The contribution installed fine and now I am able to change the products options type for each attribute... but I am having a problem with the textarea and text options. Every time I try to change a product option type to a textarea or just text and go back to my shopping cart (refresh the screen) and try to enter in text into that text area field, click buy now, the textarea option type keeps subtracting from the total price of the product in my cart!!!! I really don't understand why the textarea is being giving a value because I have the product attribute for textarea set to 0.00. But if I do not put anything in the textarea field in my cart and add the product to my cart, then the price of the product comes out correctly. Can anyone help me with this. Any help is appreciated.

Thanks

[ogg]

I am currently running OS V2.2 RC2a. I have just installed the Product Attributes - Option type Feature (contribution: http://www.oscommerce.com/community/contributions,160) and I am having problems with the Text attribution option. The contribution installed fine and now I am able to change the products options type for each attribute... but I am having a problem with the textarea and text options. Every time I try to change a product option type to a textarea or just text and go back to my shopping cart (refresh the screen) and try to enter in text into that text area field, click buy now, the textarea option type keeps subtracting from the total price of the product in my cart!!!! I really don't understand why the textarea is being giving a value because I have the product attribute for textarea set to 0.00. But if I do not put anything in the textarea field in my cart and add the product to my cart, then the price of the product comes out correctly. Can anyone help me with this. Any help is appreciated.

Thanks

 

 

I had this same problem too. It took me ages to figure it out.

 

In the admin section under "Products Attributes" there's a note that says "The Text and Textarea 'Option value'... is fixed to ID 0.". This is the cause of the problem. You probably changed this value somehow. You can't change it back in the admin, you have to do it in the database.

 

You need to go into your database and change the textarea options_values_id to back to 0. Do the same with all the other textareas your having problems with too.

 

This is how I did it:

First go to the "product_options" table and find out what "products_options_id" your textarea is using and remember that number. Then go to the "products_attributes" table and find the "options_id" (the number you remembered). Now change the "options_values_id" to 0. (Note: you don't change the number you remembered. options_values_id is different to options_id)