Cannot Define Attributes for Products

[Daisy606]

Version: v1.3.9h
Clean install, no addons, not very customized! I'm very new to this and am just finding my feet.

I am just getting round to adding product attributes to my products. I will be, mostly, using drop downs and text boxes.

I have added an Option Name - 'Text required' and I do not need to edit that.

I don't know if this is relevant, but, when I go to the 'Attributes Controller' I see my categories in the drop down menu and all my sub categories are marked with an asterisk.

When I choose the product to add the attribute to I select the attribute, press insert and all I get is 'No Attributes Defined for Product'.

Last week I had a go adding a text box and I could. When I tried to add a dropdown box I got the error '1062 Duplicate entry '1-1' for key 1'. I found this thread and followed it: http://www.zen-cart.com/forum/showthread.php?t=169035

Any help would be appreciated.

[Daisy606]

Version: v1.3.9h
Clean install, no addons, not very customized! I'm very new to this and am just finding my feet.

I am just getting round to adding product attributes to my products. I will be, mostly, using drop downs and text boxes.

I have added an Option Name - 'Text required' and I do not need to edit that.

I don't know if this is relevant, but, when I go to the 'Attributes Controller' I see my categories in the drop down menu and all my sub categories are marked with an asterisk.

When I choose the product to add the attribute to I select the attribute, press insert and all I get is 'No Attributes Defined for Product'.

Last week I had a go adding a text box and I could. When I tried to add a dropdown box I got the error '1062 Duplicate entry '1-1' for key 1'. I found this thread and followed it: http://www.zen-cart.com/forum/showthread.php?t=169035

Any help would be appreciated.

Just to add:

I have added a text box in 'Option Name Manager'. I have gone into 'Attribute Controller' and get the message in a yellow bar at the top of the screen saying: 'No Option Values have been defined'

[Ajeh]

If you go into phpMyAdmin and browse the table:
products_options_values

Do you have a setting for:
products_options_values_id 0
language_id 1
products_options_values_name TEXT
products_options_values_sort_order 0

Do you have any add ons?

[Daisy606]

I have two database set up, zc1 and zc2.

When I first tried to install zencart I had issues and my host provider's support set up databases and I do not know which one is my shop.

Is there any way I can find out?

[Ajeh]

Look at your two configure.php files on the server:
/includes/configure.php
/adin/includes/configure.php

and that will tell you the database that you are using ...

[Daisy606]

Thanks, I have figured out my database.

Now there is no 'products_options_values' just 'zen_products_options_values'.

Is that what you mean?

[Ajeh]

That is the table ... the zen_ means you are using Database Prefixes on the database tables ...

[Daisy606]

I already have dropdown boxes there...

[Ajeh]

You need to have one record with the settings I posted ... this is a built in setting ...

If you browse the table and do not find one you need to run the following in your Tools ... Install SQL Patches ...

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

Also check the table:
products_options_types

in your case this will be:
zen_products_options_types

and see what records show up there for the Option Name types ...

[Daisy606]

Ok,

Product Option Types: