Adding Attributes

[John250]

Hi. to everyone from a new zenner.
Can anyone help with this query please :-
In an attempt to add attributes via Admin.Catalog.Option Name Manager.
I'm confronted with the following :-

1146 Table 'web177-yeso9355.products_options_types' doesn't exist
in:
[select products_options_types_id, products_options_types_name from products_options_types order by products_options_types_id]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Answers in words of one syllable would be a great help as I'm a novice !

[brazun]

That table SHOULD exist unless there's something else wrong somewhere....

In phpmyadmin you could try executing the following SQL:

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`)
)

In your hosting account control panel you should have a link for phpmyadmin (probably at the bottom of the screen you get when you click mysql databases.

Once running mysqladmin you need to select the database (there may only be one) and then click the SQL tab. You can paste the above text into the box and click Go.

Sam

[Ajeh]

You may also want to add the Option Name Types to that table after it is built:

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