No Attribute Option Types...

[Alex Clarke]

I've just applied various attributes to certain products on my site. Everything went well and the attributes are displayed in a drop down list box on the product page.

However, I would like to change this drop down box to radio buttons. I know this can be done as I have done it before. But, when I attempt to select a different 'option type' from the Attributes Manager no other options are displayed (a blank drop down box appears)!

Anyone else had a similar problem?

[Ajeh]

To change the Option Type ...

You would edit the Option Name and change it there from dropdown to radiobutton ...

Note: All Products with Attributes using this Option Name would switch from dropdown to radiobuttons ...

[Alex Clarke]

Another lightning response! :)

Maybe my last post was not clear. When I try to change the attribute option type I am presented with an empty drop down box. Normally it would say; textbox, dropdown, radio, checkbox, etc... But it is totally empty! :|

[Ajeh]

And what did we do with our Option Name Option Type table ... did we lose it?

Look in phpMyAdmin ...

Find your database and find the table: products_options_types

Browse it ... there should be 6 records in there ...

How many do you have?

[Alex Clarke]

No records there!! That probably explains it.

I'll install a fresh database and copy the tabel over. That should be ok, right?

By the way... just wanted to say keep up the good work with development. :)

I'll be sure to buy you people some coffee soon... might even get you a coffee machine! ;)

[Ajeh]

Hang on ... hang on ...

We may be able to fix this table ... give me a minute ...

[Ajeh]

In your Zen Cart Admin ...

Run this via the Tools ... Insert 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)
) TYPE=MyISAM COMMENT='Track products_options_types'; 

Then run this:

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

NOTE: via the Insert SQL Patches ... do NOT change anything regardless of table prefixes etc. it will be done automatically for you ...

[Alex Clarke]

I've just copied the table from a fresh install and it's worked fine. Is that ok or should I have followed your steps outlined above?

[Ajeh]

My post is what you would get if you did a fresh install ...

That is what is in the /zc_install/mysql_zencart.sql file and I just grabbed the structure and data for it ...

So ... go test it out ... does it work?

[Alex Clarke]

Already tested and it works a treat! :)

Not really sure why/how the data was lost form the table. But it's back now... with a little of your advice.

Thanks for the help.