Attributes name editor: cant select option type

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

[voluntaryist.only]

Hi, thanks for that, so i go to the sql insert in admin & just insert what is listed? I do have prefixes on all the database heading ie: "zen_products_options_types"

thanks.

ed

[gjh42]

Okay then, add that prefix to the table names in the statements and paste them into Install SQL Patches.

[voluntaryist.only]

Hi,
sorry to be a pest, like this:
INSERT INTO zen_products_options_types (products_options_types_id, products_options_types_name) VALUES (0, 'Dropdown');,
INSERT INTO zen_products_options_types (products_options_types_id, products_options_types_name) VALUES (1, 'Text');,
INSERT INTO zen_products_options_types (products_options_types_id, products_options_types_name) VALUES (2, 'Radio');,
INSERT INTO zen_products_options_types (products_options_types_id, products_options_types_name) VALUES (3, 'Checkbox');,
INSERT INTO zen_products_options_types (products_options_types_id, products_options_types_name) VALUES (4, 'File');,
INSERT INTO zen_products_options_types (products_options_types_id, products_options_types_name) VALUES (5, 'Read Only');

cheers,

ed

[voluntaryist.only]

.........

[gjh42]

Yes, like that.

[voluntaryist.only]

err, that did not work, i got this error:
Error Failed: 1
Error ERROR: Cannot execute because table zen_products_options_types does not exist. CHECK PREFIXES!
Warning Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

right at the top of the page on the left side. I know that there is a listing for the table, but, there is nothing in it, what should i do?

thanks,

ed