Requiring some text (attribute) when placing order...

[rebekah]

I'm hoping someone can help me figure out why you can add an item to the cart without first typing some required text. I thought I set up the attributes correctly but it's not working.

Here's link to the product on our site I'm referring to...

http://www.thewindcutter.com/shop/in...roducts_id=464

The "Camcorder Brand & Model Number" and the "Measurement of camcorder's mic area (width x height)" are the two I'm trying to require but I can add the product to the cart without filling these fields in first.

Anyone have any idea what the problem is?

Thanks!
Rebekah

[schoolboy]

When you add the text attribute to a product, I think the last ATTRIBUTE FLAGS box on the right (the bright red one) selects "required" status for text. Make sure you select YES radio button in that red box before you click insert button.

[rebekah]

Thanks for the reply. That's already enabled.

[Ajeh]

There is a bug caused by an add-on that is related to the TEXT attribute that I cannot recall off the top of my head that would break the require on this ...

Think ... think ... think ... where are all our smart helpers ...

[rebekah]

Are you maybe referring to this?

http://www.zen-cart.com/forum/showpo...8&postcount=10

I don't have Google Site Map add-on, though. Should I still run this SQL Patch that you posted there?

Thanks for your help.

Rebekah

[Ajeh]

That's the one and there is something about Image Handler in there as well ...

I do not use either, but they appear to cause a problem in how they construct things ...

Be sure to make proper backups before making changes ...

[rebekah]

Thanks, Linda. This seems to have fixed it. I tested it and had to go back and fill in the required text, yea!

In case anyone else needs this...

1. Go to Tools | Database Backup MYSQL and backup your database. Database Backup MYSQL is an add-on for backing up your database. If you don't have it, get it here:

Backup MYSQL Plugin

(Of course, if you know how, you can also use phpMyAdmin to do your backup.)

2. After you backup, go to Tools | Install SQL Patches

3. Paste in the following code (make sure you have no extra spaces at the end)...

INSERT INTO `configuration` VALUES ('', 'Product option type Select', 'PRODUCTS_OPTIONS_TYPE_SELECT', '0', 'The number representing the Select type of product option.', 0, NULL, '2007-03-19 17:57:39', '2007-03-19 17:57:39', NULL, NULL);
INSERT INTO `configuration` VALUES ('', 'Upload prefix', 'UPLOAD_PREFIX', 'upload_', 'Prefix used to differentiate between upload options and other options', 0, NULL, '2007-03-19 17:57:39', '2007-03-19 17:57:39', NULL, NULL);
INSERT INTO `configuration` VALUES ('', 'Text prefix', 'TEXT_PREFIX', 'txt_', 'Prefix used to differentiate between text option values and other option values', 0, NULL, '2007-03-19 17:57:39', '2007-03-19 17:57:39', NULL, NULL);
INSERT INTO `configuration` VALUES ('', 'Image Handler Version', 'IH_VERSION', '2.0', 'This is used by image handler to check if the database is up to date with uploaded image handler files.', 0, 100, NULL, '2007-06-06 16:47:03', NULL, 'zen_cfg_textarea_small(');

4. Click "Send" and hope nothing goes wrong!

5. After I clicked "Send" I was presented with a plain white page with the following text and thought for sure I just wrecked everything!

1062 Duplicate entry 'IH_VERSION' for key 2
in:
[INSERT INTO configuration VALUES ('', 'Image Handler Version', 'IH_VERSION', '2.0', 'This is used by image handler to check if the database is up to date with uploaded image handler files.', 0, 100, NULL, '2007-06-06 16:47:03', NULL, 'zen_cfg_textarea_small(');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

6. Instead of going back with the BACK button, I went to the Admin home page (I had to log-in again).

7. I went to my test product, tried to add it to the cart and Voila! "Sorry, you need to fill something in first!"

Hope this helps if anyone has this same problem.

Thanks again, Linda!

Very sincerely,
Rebekah

[pixeldiva]

Rebekah you're a life saver :-) I had exactly the same problem, luckily I found your post at the first try which saved me countless hours of trying to figure this out. Thank you for sharing!
Pixel Diva

[vooboo13]

This fixed my issue with the "Required" option not working. Well done!

[pizza392]

the text attribute doesn't work correctly on 1.39h
this bug has been found from 1.38, i wonder why it still be the problem on 1.39h?