Attributes name editor: cant select option type

[peolit]

Hi all. I'm using v1.3.9h and need to set real basic attributes like 'pick a color'.

However, I in the Names editor, I'm unable to pick the option type- where there should be options such as 'dropdown box, radio buttons, etc..' I just have an empty dropdown with no values in it to pick.

Has anyone encountered this problem or know how I would fix it?

I suspect this is the reason that my attributes aren't showing up on my product pages.

[kobra]

Reload your admin files

[Ajeh]

If you look at your database in phpMyAdmin at the table:
products_options_types

do you see all of the Option Types in there?

[peolit]

no-they're not there

[Ajeh]

That would break things pretty well ...

Backup your database ...

You can rebuild that table with:

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

[voluntaryist.only]

That would break things pretty well ...

Backup your database ...

You can rebuild that table with:

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

how exactly can I do this? please outline method, thanks. is it a sql insert via admin back office or via mysql & if so how, thanks in advance.

regards,

ed

[gjh42]

You can copy & paste those statements into ZC admin > Tools > Install SQL Patches, if you don't have prefixes on your database tables. (If you do have prefixes, change the table name appropriately, like zen_products_options_types.) (The field names will not change.)

Or you can go to your hosting control panel, which should have a page for phpMyAdmin, and do the same.

[peolit]

If you look at your database in phpMyAdmin at the table:
products_options_types

do you see all of the Option Types in there?

ahhh good question. I don't see them in phpmyadmin. I don't have much experience in databases like this though...