Attributes: Option Name Has Blank Drop Down List for "Option Type"

[Dianne]

I am setting up attributes and have been able to successfully add the Option Name (in this case "Amount"). However, when I go to select the Option TYPE (which should be a choice from a drop-down to include checkbox, radio button, etc.), the drop down list is blank.

There is nothing listed, it's just a slim, blank column that drops down when clicked.

Can you help me determine what could be missing? Perhaps a file?

Thanks for anything you can share.

Dianne

[Ajeh]

If you were to peek, via phpMyAdmin, at your database table:
products_options_types


what do you see in that database table?

[Dianne]

I am attaching a screen shot of what I see because I am not a programmer so I am not sure what you wanted me to notice.



Thanks for your help with this. What was I to see in the database table?

[Ajeh]

Sounds like you are missing the Option Types ... this can be fixed with running in your Zen Cart Admin the Tools ... Install SQL Patches:

DROP TABLE IF EXISTS products_options_types;
CREATE TABLE products_options_types (
  products_options_types_id int(11) NOT NULL default '0',
  products_options_types_name varchar(32) default NULL,
  PRIMARY KEY  (products_options_types_id)
) ENGINE=MyISAM COMMENT='Track products_options_types';

then run:

INSERT INTO products_options_types (products_options_types_id, products_options_types_name) VALUES (0, 'Dropdown');
INSERT INTO products_options_types (products_options_types_id, products_options_types_name) VALUES (1, 'Text');
INSERT INTO products_options_types (products_options_types_id, products_options_types_name) VALUES (2, 'Radio');
INSERT INTO products_options_types (products_options_types_id, products_options_types_name) VALUES (3, 'Checkbox');
INSERT INTO products_options_types (products_options_types_id, products_options_types_name) VALUES (4, 'File');
INSERT INTO products_options_types (products_options_types_id, products_options_types_name) VALUES (5, 'Read Only');

Now see if that fixes the problem ...

[Dianne]

Thank you! I will do that.

I'll back-up everything first and then I'll report back my results.

Watch for my post tomorrow morning.

[Dianne]

It worked! Thank you. I have this same problem on another site as well, so now I can repair that one, too.

The drop down menu for "Option Type" is showing with all the choices that should be there.

[Ajeh]

Thanks for the update that this is now working for you ...