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

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

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

what do you see in that database table?

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?

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

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.

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.

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