Attributes not working.... Read most of the threads but cant figure out why?

HI,

Most of the times I am able to figure out how Zencart works but this attributes thing is not working for me. I read the tutorial also but no help. Below is what is happening. Any help would be appreciated.

So, I have a product and I want to add attribute "Color"

I went to Catalog> Option name manager and put an option "Color". See the screenshot.

Now I go to "Option Values" to add the "Red" to it. Now when I put "Red" in "Option Value" field and leave the sort order blank and click on "Insert" I get the below error.

I do not know what is the problem. Even when I put any value in the "Sort Order" field or I do not put any value, I still get the same error.
"Global Settings" ON or OFF, I get the same error.

I want to add this attribute "Color" to a specific product rather than to a category. So I believe I will have to do this with "Global Settings" ON but the issue is that I simply can not add any value eg. "Red" in this case.

Any help will be appreciated. My site is http://FlyHighBuy.com

The first column when adding an option value is prefilled with a number
Next to it is a drop down menu where you select the "Option Name"
Next to it is an entry block where you enter the "Option value name" (Red)
Then insert

Is this what you are doing??

Exactly. That's exactly what I am doing and I get error of which I have attached the screenshot in the first/original post.

When you reply - scroll up and read posting tips
Provide the information

• The version I am using is 1.3.9.h
• No, my site has not been upgraded. I installed 1.3.9h and working on it since. Will think of moving to 1.5.
• I have installed "RSS Feed", "TY Package Tracker", "USPS Auto Fill Config", "Add Tracking ID", "Super Order",
• I installed it through my hosting company "GoDaddy"
• I have installed the template "all_business" by Picaflor Azul

I do not know when this problem started. Right now I am adding every product but it has become a dauting task so I have to have attributes set up.

If you do not have any attributes successfully assigned currently you could try using phpmyadmin and selecting the products_options_values table and emptying it

Then try to create one

NOTE: if you try to remake the table:
products_options_values

make sure that you run both:

#
# Table structure for table 'products_options_values'
#

DROP TABLE IF EXISTS products_options_values;
CREATE TABLE products_options_values (
  products_options_values_id int(11) NOT NULL default '0',
  language_id int(11) NOT NULL default '1',
  products_options_values_name varchar(64) NOT NULL default '',
  products_options_values_sort_order int(11) NOT NULL default '0',
  PRIMARY KEY (products_options_values_id,language_id),
  KEY idx_products_options_values_name_zen (products_options_values_name),
  KEY idx_products_options_values_sort_order_zen (products_options_values_sort_order)
) ENGINE=MyISAM;

and add the TEXT Option Value with:

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

Thanks Kobra. Your solution worked. Thanks Ajeh for your caution :)

Now I can add the attributes. Actually 1 was assigned to zip files and thus "id 1" was not being assigned to the attribute "Color".
Now another issue. I go to "Attributes Controller" and select the product from "Categories". Then I go and click on "Color" from the "Option Name" field. That pops various colors that I have added. I select the colors that I want and then click on "Insert". After 4 or 5 seconds it brings me back to the main admin page. Now, I go to the product to which I have added the attribute and I see that there is nothing added there. I tried it so many times but nothing. Any idea what I am missing here or what could be the issue. Below is the screen shot of what I am doing.

My site is http://FlyHighBuy.com and the link for the product that I am adding the attributes to is http://flyhighbuy.com/index.php?main_page=product_info&cPath=55_59_61&products_id=681

Any help?

I guess no help yet.
I have tried many times but couldnt found whats wrong.

Still hoping for some help.

Want to know if "Sort Order" option has to do something with this?

I select the colors that I want and then click on "Insert".
Colors
You must assign them one at a time

Did that too but still dont work. Really cant figure out what is the problem.
I was trying to put something as a download product also but again its not working. Why? because attributes assigning is not working.

I can not replicate this issue on a stock install of v1.3.9h

Might try reloading all the admin files

Yeah, but reloading admin files will lose me my modules. Will it or not?

Yeah, but reloading admin files will lose me my modules
If so then this would pinpoint the issue to one of the mods