Attributes name editor: cant select option type

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.

Reload your admin files

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

do you see all of the Option Types in there? :unsure:

no-they're not there

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? :unsure:
ahhh good question. I don't see them in phpmyadmin. I don't have much experience in databases like this though...

That would break things pretty well ... :eek:

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

Ajeh:

That would break things pretty well ... :eek:

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? :blink: please outline method, thanks. is it a sql insert via admin back office or via mysql & if so how, thanks in advance.:smile:

regards,

ed

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.

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

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

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

.........

Yes, like that.

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

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?

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

yes, I can see that see image attached,

thanks,

ed
[Attachment no longer available]

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.

YIPEE! what a STAR you are !! :clap:
[Attachment no longer available]

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

woohoo!! go you!!

very gratefully yours,

ed
:smile: