Missing attribute options

[Zek]

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

[noisebug]

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

[Zek]

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 ?

Is there an easy way without a fresh install?

thanks

[Zek]

thanks for the help: Nooot (borat style )

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

[Ajeh]

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

[Zek]

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

[Ajeh]

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

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