Having trouble adding new attributes

17 Jul 2012, 23:59

#1

Zen Follower

Join Date:: Jul 2011
Posts:: 214
Plugin Contributions:: 0

Having trouble adding new attributes

I've gone through the tutorial here: http://www.zen-cart.com/content.php?99

The issue I'm having is the Option Value not showing up. I've created a new Option Name in the attribute controller. When you select the Option Name, the Option Value box doesn't populate so therefore you can't hit the Insert button. (Please see picture)

What am I doing wrong?

18 Jul 2012, 00:58

#2

ajeh

Oba-san

Join Date:: Sep 2003
Posts:: 62,757
Plugin Contributions:: 1

Re: Having trouble adding new attributes

What is the Option Name type?

18 Jul 2012, 02:42

#3

in2deep

Zen Follower

Join Date:: Jul 2011
Posts:: 214
Plugin Contributions:: 0

Re: Having trouble adding new attributes

Radio button.

18 Jul 2012, 03:02

#4

ajeh

Oba-san

Join Date:: Sep 2003
Posts:: 62,757
Plugin Contributions:: 1

Re: Having trouble adding new attributes

Click Reply and answer the questions ...

What Option Values are set up for that Option Name?

18 Jul 2012, 05:19

#5

in2deep

Zen Follower

Join Date:: Jul 2011
Posts:: 214
Plugin Contributions:: 0

Re: Having trouble adding new attributes

13 oz Glossy Vinyl

18 Jul 2012, 12:58

#6

ajeh

Oba-san

Join Date:: Sep 2003
Posts:: 62,757
Plugin Contributions:: 1

Re: Having trouble adding new attributes

If you go to the Option Name Manager, what is the number next to the Option Name?

If you go to the Attributes Controller, what is the number next to the Option Name? (I cannot read it in the image)

Have you added any add ons that touch Admin files?

Does this issue affect all Option Names or just this one?

18 Jul 2012, 18:24

#7

in2deep

Zen Follower

Join Date:: Jul 2011
Posts:: 214
Plugin Contributions:: 0

Re: Having trouble adding new attributes

The number next to the option name is 3946

here is a close up of the box.

It's only doing this for new attributes I am trying to add. The option value shows up on existing entries.

18 Jul 2012, 18:29

#8

ajeh

Oba-san

Join Date:: Sep 2003
Posts:: 62,757
Plugin Contributions:: 1

Re: Having trouble adding new attributes

When you click Reply, can you please answer the questions ...

If you click on 3945, do you see Option Values?

If you click on 1117, do you see Option Values?

18 Jul 2012, 19:50

#9

in2deep

Zen Follower

Join Date:: Jul 2011
Posts:: 214
Plugin Contributions:: 0

Re: Having trouble adding new attributes

No when you click on 3945.

Yes when you click on 1117.

19 Jul 2012, 04:51

#10

ajeh

Oba-san

Join Date:: Sep 2003
Posts:: 62,757
Plugin Contributions:: 1

Re: Having trouble adding new attributes

Go to phpMyAdmin and browse your database and look at the table:

Click SQL and enter:

SELECT *
FROM products_options_values_to_products_options
WHERE products_options_id = 3945

How many records are found? If some are found, what type of data records do you see?

If you found some values for:
products_options_values_id

Browse the table:
products_options_values

Do you find those values in this table for the:
products_options_values_id

If so, what type of data records do you see?

Click SQL and enter:

SELECT *
FROM products_options_values_to_products_options
WHERE products_options_id = 3946

How many records are found? If some are found, what type of data records do you see?

If you found some values for:
products_options_values_id

Browse the table:
products_options_values

Do you find those values in this table for the:
products_options_values_id

If so, what type of data records do you see?

19 Jul 2012, 19:07

#11

in2deep

Zen Follower

Join Date:: Jul 2011
Posts:: 214
Plugin Contributions:: 0

Re: Having trouble adding new attributes

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

19 Jul 2012, 22:18

#12

ajeh

Oba-san

Join Date:: Sep 2003
Posts:: 62,757
Plugin Contributions:: 1

Re: Having trouble adding new attributes

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?

20 Jul 2012, 05:23

#13

in2deep

Zen Follower

Join Date:: Jul 2011
Posts:: 214
Plugin Contributions:: 0

Re: Having trouble adding new attributes

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

20 Jul 2012, 12:54

#14

ajeh

Oba-san

Join Date:: Sep 2003
Posts:: 62,757
Plugin Contributions:: 1

Re: Having trouble adding new attributes

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

20 Jul 2012, 18:54

#15

in2deep

Zen Follower

Join Date:: Jul 2011
Posts:: 214
Plugin Contributions:: 0

Re: Having trouble adding new attributes

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.

20 Jul 2012, 21:54

#16

ajeh

Oba-san

Join Date:: Sep 2003
Posts:: 62,757
Plugin Contributions:: 1

Re: Having trouble adding new attributes

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 ...

21 Jul 2012, 01:02

#17

in2deep

Zen Follower

Join Date:: Jul 2011
Posts:: 214
Plugin Contributions:: 0

Re: Having trouble adding new attributes

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.

21 Jul 2012, 01:29

#18

ajeh

Oba-san

Join Date:: Sep 2003
Posts:: 62,757
Plugin Contributions:: 1

Re: Having trouble adding new attributes

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 ...

23 Jul 2012, 20:38

#19

in2deep

Zen Follower

Join Date:: Jul 2011
Posts:: 214
Plugin Contributions:: 0

Re: Having trouble adding new attributes

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.

23 Jul 2012, 22:43

#20

ajeh

Oba-san

Join Date:: Sep 2003
Posts:: 62,757
Plugin Contributions:: 1

Re: Having trouble adding new attributes

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?