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;

[Trademagic]

Scott,

I am at a loss. I tested with

SELECT * FROM configuration WHERE configuration_group_id =0

and received Failed!: notification. I then inserted the recommended fix


INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Product option type Select', 'PRODUCTS_OPTIONS_TYPE_SELECT', '0', 'The number representing the Select type of product option.', 0, NULL, now(), now(), NULL, NULL);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Upload prefix', 'UPLOAD_PREFIX', 'upload_', 'Prefix used to differentiate between upload options and other options', 0, NULL, now(), now(), NULL, NULL);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Text prefix', 'TEXT_PREFIX', 'txt_', 'Prefix used to differentiate between text option values and other option values', 0, NULL, now(), now(), NULL, NULL);

and got three statements processed.

I retested with the first test code and still got failed notification.

I have 1.5.1 and have google analytics, TyTracker and Super Orders, Autoresponder+, Return Authorization, and Ty Package Tracker installed. The database seems to function flawlessly, to an amateur eye. I was recommended to this thread and told I probably had this problem. I have had trouble editing attributes in an order as the last attribute won't select, it is a fixed field in the edit orders window.

Marc

Any recommendations to test if I am ok? Sorry for my imperfect understanding.

[mc12345678]

Scott,

I am at a loss. I tested with

SELECT * FROM configuration WHERE configuration_group_id =0

and received Failed!: notification. I then inserted the recommended fix


INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Product option type Select', 'PRODUCTS_OPTIONS_TYPE_SELECT', '0', 'The number representing the Select type of product option.', 0, NULL, now(), now(), NULL, NULL);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Upload prefix', 'UPLOAD_PREFIX', 'upload_', 'Prefix used to differentiate between upload options and other options', 0, NULL, now(), now(), NULL, NULL);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Text prefix', 'TEXT_PREFIX', 'txt_', 'Prefix used to differentiate between text option values and other option values', 0, NULL, now(), now(), NULL, NULL);

and got three statements processed.

I retested with the first test code and still got failed notification.

I have 1.5.1 and have google analytics, TyTracker and Super Orders, Autoresponder+, Return Authorization, and Ty Package Tracker installed. The database seems to function flawlessly, to an amateur eye. I was recommended to this thread and told I probably had this problem. I have had trouble editing attributes in an order as the last attribute won't select, it is a fixed field in the edit orders window.

Marc

Any recommendations to test if I am ok? Sorry for my imperfect understanding.

After doing all this, have you gone back to see if the original problem has been resolved?
It would seem, that whether this issue was the source of your problem or not, the fact that the three statements processed successfully indicates that they were in fact missing from your cart database. The failed message appears to be a result of trying to run the select sql query from the admin panel's install SQL patch utility. Select statements for the specific purpose of displaying information generally do not work in that area, but will handle variable assignments such as discussed at the beginning of this thread.

Btw, my suggestion, if this issue you are having continues it should probably taken to a thread other than this one. Again, it looks like your cart had the problem related to this thread and it is now fixed. (Could verify by running the three sql statements again to see if an error message is now generated or use mySQLadmin to run the select query being sure to substitute any table prefix as applicable.)

[Trademagic]

Hey MC,

You get around sailor! Thanks for your response. I tried to reenter the three statements,

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.

then checked the edit orders failure of before and it is fixed. It is due to all of you being so brilliant that I am surviving this endeavor. My deep thanks, and hopes that this beast of a site will take some orders soon.

I owe a couple of donations.

Marc

[mc12345678]

Hey MC,

You get around sailor! Thanks for your response.

I'm sure you mean that in an appropriate way. :)

Very welcome and happy holidays.

[swguy]

Quick update: I saw a system (1.5.1) just today that still had this problem. So don't assume you don't have it unless you have checked

http://YOUR-SITE/your-admin-page/con...tion.php?gID=0

and verified that you have the expected three entries.