Missing attribute options

Hi - I would very much appreciate some help, I have searched for my problem and tried a few tips on here but not had any luck so far.

The problem is I do not have a choice of any attribute option types so all my attibutes are defaulted to drop down boxes:

I have traced this problem down to a mssing or damaged zen_product_options_types table (I think) as I do not have any data there at all.

How do I go about fixing this ? I am unsure what information this table should contain and how it got deleted in the first place?

thanks, Ben

Is this a fresh install for your Cart? Have you done any customization and/or uploaded new products yet?

Hi, thanks for the reply - yes I have customised the site and everthing is looking and working great apart from this little issue - Not sure why it is missing, I can only guess I must have accidentally cleared the values somehow - that will teach me! - now how to get them back :D?

Is there an easy way without a fresh install?

thanks

thanks for the help: Nooot (borat style :cool:)

Will running without this data be ok? not found a solution yet.

Check what is in the table products_options_types ...

If you do not have the various values you can build it with:

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)
) TYPE=MyISAM COMMENT='Track products_options_types';

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');

Also check the products_options_values table for:

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

Warning: always backup your database before attempting to fix things you have broken ...

Thanks for helping me and so many others out!, coffee bought :)

Thanks very much for the support ... we always can use another cup of coffee to help the coding move along ... it keeps the eyes open longer ... :eek:

Good luck with your shop and for letting us know that this helped you out ...