Can't add option values

[jfenn]

Using 1.3.9h

I'm trying to add option values and keep getting an error. I can add option names just fine. What am I doing wrong?

[knuckle-101]

Using 1.3.9h

I'm trying to add option values and keep getting an error. I can add option names just fine. What am I doing wrong?

Option Names are the actual names you are going to use for the Option Values which it seems you already figured this out..

So to add Option Values to your Option Names you would do the following

1. Mouse Over Catalog then click on Attributes Controller then click on "Option Values" button

2. To add a Option Value to an Option Name see screenshot attached. The Option Name are the ones in the drop down box as shown in the image.

3. Choose your "Option Name" from the drop down box (example: Color) and inside the field next to it where it says "en:" add a name such as "Orange" (Without Quotations) add sort order number if only desired to, click "insert button"

4. Go to attribute controller and choose your product and start adding attributes.

Also other resource for information can be found at Tutorial URL https://www.zen-cart.com/tutorials/index.php?article=57

[knuckle-101]

Forgot to ask for the error you were seeing.

Can you show us the error your getting?

[jfenn]

Forgot to ask for the error you were seeing.

Can you show us the error your getting?

This is the error I get:

1062 Duplicate entry '1-1' for key 'PRIMARY'
in:
[insert into bop_products_options_values (products_options_values_id, language_id, products_options_values_name, products_options_values_sort_order) values ('1', '1', 'of 1', '0')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

[jfenn]

I should also add that I've set up a zen store before & don't understand why this isn't working for me.

All of my products are digital and will be downloaded right after payment.

I wanted my option names/values to be like:

Download 1 of 1

I had it set up like this before at another store but can't get it to do this here.

Thanks.

[jfenn]

Does anyone know how to help me set this up?

[knuckle-101]

Does anyone know how to help me set this up?

Edited*** I seen Ajeh Replying..

[Ajeh]

Go to phpMyAdmin and see if you have any records in the table:
products_options_values

If not, then click on SQL and run:

TRUNCATE products_options_values;

Next, in the SQL run:

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

See if this clears up the problem ...

NOTE: if your tables use database prefixes you will need to add it to the table name on these ...

[jfenn]

Go to phpMyAdmin and see if you have any records in the table:
products_options_values

If not, then click on SQL and run:


Next, in the SQL run:


See if this clears up the problem ...

NOTE: if your tables use database prefixes you will need to add it to the table name on these ...

Thanks to both of you!!!

Ajeh, I did what you said & now it works just fine

Thanks again!

[Ajeh]

Thanks for the update that this was able to correct the problem ...