Having trouble adding new attributes

[In2Deep]

I get a #1146 - Table 'xxx.products_options_values_to_products_options' doesn't exist error on on both of those.

[Ajeh]

It really sounds like you have bad or incomplete data ...

Go to the Catalog ... Option Name Manager ... and find #3945 and #3946 and edit them and change their names to something like:
Options 45
Options 46

to match their numbers ...

Go to the Catalog ... Option Value Manager ... and try to add Option Values for your:
Options 45

then try to add Option Values for your:
Options 46

Now go to the Attributes Controller ...

Do you see the Option Name:
Options 45 [Radio] [#3945]

in the list? And If so, if you click on it, do you new see Option Values in the list?


Do you see the Option Name:
Options 46 [Radio] [#3946]

in the list? And If so, if you click on it, do you new see Option Values in the list?

[In2Deep]

I've named them Options 45 & 46 like you suggested but don't see them in the Option Value Manager.

[Ajeh]

If you go to the Option Name Manager and click on the DELETE for these Option Names ...

Do you get at the top of the page:

Option Name: Test Option Name
This option has no products linked to it - it is safe to delete it.
Caution: All Option Values will be deleted for this Option Name.

Or does it list Products?

NOTE: Just click CANCEL to get out of the DELETE

[In2Deep]

Yes, it says there are no products linked to it and it is safe to delete.

Option Name: Options 46
This option has no products linked to it - it is safe to delete it.
Caution: All Option Values will be deleted for this Option Name.

[Ajeh]

It sounds like the Option Name(s) are not setup completely with proper Option Values or that you have bad data in the database tables ...

Do you import data or enter everything in your Zen Cart Admin ...

[In2Deep]

All of the prior data was imported and then tweaked as needed. These last two I was trying to add from scratch and haven't been able to get anywhere with it.

[Ajeh]

You would be best trying to add a new Option Name (something easily recognizable from the others) ... then add the Option Values for it ... then try to add the Attributes to a Product using the new Option Name and Option Values ...

If that works, you can then get rid of the broken ones and rename the new Option Name to what you want it to read ...

[In2Deep]

I can't add a new option name to the database, when I go to add it, it isn't showing up in the option value manager.

[Ajeh]

Go to phpMyAdmin ...

Check the table:
products_options

How many records do you have?

Go to the Last Page of the table:
products_options

when you browse it ...

What do you see for the fields:
products_options_id
language_id
products_options_name
products_options_sort_order
products_options_type
products_options_length

of the New Option Name that you just added?