Attributes name editor: cant select option type

[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

[gjh42]

That would really require looking at your database to see exactly what you have. Are you seeing in phpMyAdmin, when you have selected the right db, the zen_products_options_types table name in the list in the left column?

[Ajeh]

NOTE: If you are using the Zen Cart Admin, Tools ... Install SQL Patches ... you do not need to add those prefixes as they are handled for you ...

[voluntaryist.only]

yes, I can see that see image attached,

thanks,

ed
Attachment 9922

[gjh42]

Oops, thanks for the clarification! I hadn't dealt with Install SQL Patches in a while and was thinking that it needed the TABLE_WHAT_EVER constants to handle the prefixes if any. So it does automatically detect all table names and converts them to the correct prefix.


So just paste exactly what Ajeh posted into Install SQL Patches. Sorry for the confusion.

[voluntaryist.only]

YIPEE! what a STAR you are !!
Attachment 9924

thanks very, very, much, it was driving round the bend!!


woohoo!! go you!!


very gratefully yours,

ed