Adding Text Field Attribute

**LinusIT** · 26 Jan 2011, 11:48 AM

Hi

I'm trying to add a text field for a certain product but I just can't get it working, I have setup alot of other attributes without any problems.

Go into Product Options, type in a description and order and choose Text, click add.

Go into Options Values and what I've just added in Option Names doesn't appear in the drop down menu. I can't add a value.

I've tried going into the attribute controller and adding that option name but this doesn't work, I guess it needs a value before it can be added.

I'm using 1.3.9h, Please help.

**Ajeh** · 26 Jan 2011, 07:57 PM

Go to phpMyAdmin and browse in your datbase the table:
products_options_values

do you have a record for:

Code:

products_options_values_id 	language_id 	products_options_values_name 	products_options_values_sort_order
0 	1 	TEXT 	0

**LinusIT** · 26 Jan 2011, 09:17 PM

Hi

I've checked and there's no such data in that table.

What next

**Ajeh** · 27 Jan 2011, 12:26 AM

If you do not have that in the table, then ...

Go to the Tools ... Install SQL Patches ... and enter:

Code:

INSERT INTO products_options_values (products_options_values_id, language_id, products_options_values_name) VALUES (0, 1, 'TEXT');

NOTE: if you get an error, then you were mistaken in this being missing from the table ...

**LinusIT** · 27 Jan 2011, 09:18 AM

I applied the SQL via phpMyAdmin and then went into store admin, added the product attribute without any problems. Thanks.

**Ajeh** · 27 Jan 2011, 03:04 PM

Thanks for the update that you were missing the TEXT Attribute setting in the products_options_values table and were able to add it back in to fix things ...