"Attribute Required for Text" - what would make it stop working?

I've recently run into a problem that is a showstopper for me. Basically none of my "Attribute required for text" fields are validating - people can add the items to their shopping cart without filling in the fields. They used to work, but no longer do and I'm not quite sure what the triggering event was that made them stop working.

My cart can be found here

If I knew what file had the actual validation logic I can try and look through it, but I haven't been able to determine which file it is or what fields I'm looking for.

There are two people on this board I've run across who have the same issue, but I haven't been able to determine what our common element is.

Thanks.

shopping_cart class or the functions_lookups manage this ...

Sounds like you may have something blocked or out of date ...

Thanks for the reply. This is what I've tried so far in my trouble-shooting:1. It looked like the field in question is called "attributes_required" and I did a search on that field using the developer tools. The field was referenced in 4 Admin files and 2 Catalog files:

admin/attributes_controller.php
**admin/includes/functions/general.php
****admin/includes/languages/english/attributes_controller.php
****admin/options_values_manager.php
**includes/classes/shopping_cart.php
**includes/functions/functions_lookups.php

**
2. I installed a fresh ZenCart in another domain in another directory and compared the files I had with the fresh install. They were identical.
3. I had previously run some SQL's on the zen_products_attributes table to update some prices, so I figured I'd double-check in phpMyAdmin that nothing got screwed up. The 'attributes_required' field in that table looked good, and the correct fields looked like they had a '1' in them. Also, the Admin UI correctly shows the setting of that field.Any other trouble-shooting tips or hints on what I could look at?

I'd really have to see the database and site to know what would be preventing this from working ...

There are no problems that we are aware of in the current release ...

I also ran into the same problem after restoring my database. Have you got any feed back on this ??

I have took the database table before the last backup and I restored the tables, but encountering the same issue.

Yes, actually I did find the solution in this thread:
http://www.zen-cart.com/forum/showthread.php?t=57828

Hope it works for you!

No, this is not the solution.

Switch to Classic Template ... does it work?

What add-ons are you using?

What version of Zen Cart?

Clean install or an Upgrade?

How did you install?

How did you upgrade?

Has this ever worked for you?

Switch to Classic Template ... does it work? No change

What add-ons are you using? Store Credit, Invoice,

What version of Zen Cart? 1.3.7

Clean install or an Upgrade? Clean Install, was working before, nothing been added or removed.

How did you install? copying via ftp. The cart was working fine.

How did you upgrade? Not applicable

Has this ever worked for you? Yes

The system was working like a dream. I wanted to add a price on monthly hosting package and it is then that I got this error

There was something really dumb the other day ... where a setting was missing from someone's database that was causing this ...

Think ... Think ... Think ... :frusty:

I remember!!! :clap:

Google Site map is one possibility where it wipes out some settings ...

The other is that any of these are missing from the configuration table ...

In the Tools ... Insert SQL Patch ... enter these:

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

edited for buzz word: fix attributes required requiring requires for text is broken or stopped working

No Change. The folowing error when inserting the code:

1062 Duplicate entry 'PRODUCTS_OPTIONS_TYPE_SELECT' for key 2
in:
[INSERT INTO zen_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);]
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.

Search your configuration table and check that each of those configuration_keys exist with the proper configuration_value ...

On search of the tables I get the error:
I ALSO get this error adding the table.
This I have done from PHPmyAdmin
Error
SQL query:

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

MySQL said:

#1146 - Table 'cristalt_zc2.configuration' doesn't exists

Sounds like you are using table prefixes ...

Browse the configuration table of your database ... this might be called something like zen_configuration or fred_configuration ...

Search for the configuration_key
PRODUCTS_OPTIONS_TYPE_SELECT
UPLOAD_PREFIX
TEXT_PREFIX

What configuration_values are these set to?

Hi Ajeh,

I am also having a similar problem on one of my sites too.

I have tired the other steps to fix this but a no go so far, here are the key and values for what you asked for

PRODUCTS_OPTIONS_TYPE_SELECT Has: 0
UPLOAD_PREFIX Has: upload_
TEXT_PREFIX Has: txt_

Hope you can help, if I find a solution I will post back.

Thanks

So I found my fix..funny isn't it always after you post the problem you understand it more!

So here was the fix for me

In IH_VERSION the settings were:

Image Handler Version IH_VERSION 2.0 This is used by image handler to check if the data... 0 100 NULL 2007-06-06 16:47:03 NULL zen_cfg_textarea_small(

I was missing '); on the end there for some reason.

So I just edited that section in phpmyadmin and now it works great!

Just had to read your sql patch and compare it to my settings, Thanks!

I hope that helps some other people out there.

Ajeh:

Sounds like you are using table prefixes ...

Browse the configuration table of your database ... this might be called something like zen_configuration or fred_configuration ...

Search for the configuration_key
PRODUCTS_OPTIONS_TYPE_SELECT === 0
UPLOAD_PREFIX === upload_
TEXT_PREFIX === txt_

What configuration_values are these set to?

As above

Cristaltech,

What do you have for set_function?

Also do you have IH_VERSION and if so what do you have for set_function?

You should be able to look at the sql patch that Ajeh posted and see if it matches up.

The dates shouldn't matter.

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

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

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

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

Hope that helps you more.

CrystalKoi:

So here was the fix for me

In IH_VERSION the settings were:

Image Handler Version IH_VERSION 2.0 This is used by image handler to check if the data... 0 100 NULL 2007-06-06 16:47:03 NULL zen_cfg_textarea_small(

I was missing '); on the end there for some reason.

So I just edited that section in phpmyadmin and now it works great!

Thanks for posting that discovery ... very helpful to know ...

I had the same problem and it seems to fixed after installing the code Ajeh provided. I don't have Google Site map, but have a slew of other add-ons, not sure which is the culprit.

I have Super Orders 1.x (not new 2.0)
Quick Updates
Email Archive

And a few I commissioned for my site, not publicly released:
Monthly Reports
Email Updated Order (re-emails order after it has been edited)