Attribute Required for Text flag not working

[michaelchu]

Having the same problem, tried the fix, got these errors:
Failed: 3
ERROR: Cannot insert configuration_key "PRODUCTS_OPTIONS_TYPE_SELECT" because it already exists
ERROR: Cannot insert configuration_key "UPLOAD_PREFIX" because it already exists
ERROR: Cannot insert configuration_key "TEXT_PREFIX" because it already exists

ZC v1.3.9.
IH3

Still doesn't work, help!

[toddlamp]

I am running 1.5.0 and am having the same issues. I tried the fix located earlier in this thread and received:

Error Failed: 3
Error ERROR: Cannot insert configuration_key "PRODUCTS_OPTIONS_TYPE_SELECT" because it already exists
Error ERROR: Cannot insert configuration_key "UPLOAD_PREFIX" because it already exists
Error ERROR: Cannot insert configuration_key "TEXT_PREFIX" because it already exists
Warning Note: 3 statements ignored. See "upgrade_exceptions" table for additional details.

I am still allowed to add products of a particular attribute name with "not required" selected. Are my attributes setup wrong? For example I have a product that comes in two colors; black and white. I have an attribute value black and white (both are marked as required) and a third, default, attribute value of "-----------" not marked as required. I am looking to have Zen Cart prohibit the "----------" value from being added into the cart to make sure that the user selects a specific color.

I would appreciate any help on this, thanks.

Todd

[Ajeh]

Set the Black and White to Not Required ...

Set the --------- to Required and Display Only

Now the customer has to pick Black or White or they cannot add it to the cart ...

[toddlamp]

Set the Black and White to Not Required ...

Set the --------- to Required and Display Only

Now the customer has to pick Black or White or they cannot add it to the cart ...

Typical, I was doing it wrong the whole time. Thank you, thank you, thank you. Works perfectly.

Todd

[swguy]

Following up on the original post with fix suggestions:

a) Have a separate "uninstall" utility.

b) If you want to use the code shown above to cleanup before your install SQL, just qualify it by doing the deletes "where configuration_id != 0", e.g.

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Fual Slimbox';
DELETE FROM configuration WHERE configuration_group_id = @t4 AND configuration_group_id != 0;
DELETE FROM configuration_group WHERE configuration_group_id = @t4 AND configuration_group_id != 0;