Forums / Setting Up Categories, Products, Attributes / "Attribute Required for Text" - what would make it stop working?

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

Views: 20,927

Results 21 to 40 of 52
7 Sep 2007, 2:46 PM
#21
dedj avatar

dedj

Zen Follower

Join Date:
Jan 2007
Posts:
129
Plugin Contributions:
0

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

To be honest, I can't remember if I've tried to install google sitemap a long time ago.

But since I'm having problems that " Attribute required for text " doesnt work.
I noticed that I also had the IH_VERSION 2.0 was missing ');

I wasnt sure where to find this string in the database so I seached for it as: zen_cfg_textarea_small

I then found 25hits, i edited and added the symbols that was missing on IH_VERSION so it now has the ');

BUT! I also noticed that the rest of the 24 hits don't have the '); either!

Pasting/quoting my result just below, observe this isnt code even it says so. Its search results.

      672 Image Handler Version IH_VERSION 2.0 This is used by image handler to check if the data... 0 100 NULL 2007-08-30 14:34:57 NULL zen_cfg_textarea_small('); 
      224 Product Listing Ascending Sort Order PRODUCT_LIST_SORT_ORDER_ASCENDING + What do you want to use to indicate Sort Order Asc... 8 40 NULL 2007-01-28 23:38:31 NULL zen_cfg_textarea_small( 
      225 Product Listing Descending Sort Order PRODUCT_LIST_SORT_ORDER_DESCENDING - What do you want to use to indicate Sort Order Des... 8 41 NULL 2007-01-28 23:38:31 NULL zen_cfg_textarea_small( 
      254 Convert currencies for Text emails CURRENCIES_TRANSLATIONS £,£:€,€:&Skr;,Skr What currency conversions do you need for Text ema... 12 120 2007-01-29 00:51:27 2003-11-21 00:00:00 NULL zen_cfg_textarea_small( 
      397 Bread Crumbs Navigation Separator BREAD_CRUMBS_SEPARATOR  ::  Enter the separator symbol to appear between the N... 19 3 NULL 2003-11-21 22:16:36 NULL zen_cfg_textarea_small( 
      399 Bestsellers - Number Padding BEST_SELLERS_FILLER   What do you want to Pad the numbers with?<br />Def... 19 5 NULL 2003-11-21 22:16:36 NULL zen_cfg_textarea_small( 
      412 Categories Separator between the Category Name and... CATEGORIES_SEPARATOR -> What separator do you want between the Category na... 19 25 NULL 2003-11-21 22:16:36 NULL zen_cfg_textarea_small( 
      413 Categories Separator between the Category Name and... CATEGORIES_SEPARATOR_SUBS |_  What separator do you want between the Category na... 19 26 NULL 2004-03-25 22:16:36 NULL zen_cfg_textarea_small( 
      414 Categories Count Prefix CATEGORIES_COUNT_PREFIX  ( What do you want to Prefix the count with?<br />De... 19 27 NULL 2003-01-21 22:16:36 NULL zen_cfg_textarea_small( 
      415 Categories Count Suffix CATEGORIES_COUNT_SUFFIX ) What do you want as a Suffix to the count?<br />De... 19 28 NULL 2003-01-21 22:16:36 NULL zen_cfg_textarea_small( 
      416 Categories SubCategories Indent CATEGORIES_SUBCATEGORIES_INDENT    What do you want to use as the subcategories inden... 19 29 NULL 2004-06-24 22:16:36 NULL zen_cfg_textarea_small( 
      533 EZ-Pages Header Link Separator EZPAGES_SEPARATOR_HEADER  ::  EZ-Pages Header Link Separator<br />Default = &amp... 30 20 NULL 2007-01-28 23:38:31 NULL zen_cfg_textarea_small( 
      534 EZ-Pages Footer Link Separator EZPAGES_SEPARATOR_FOOTER  ::  EZ-Pages Footer Link Separator<br />Default = &amp... 30 21 NULL 2007-01-28 23:38:31 NULL zen_cfg_textarea_small( 
      537 EZ-Pages Pages to disable headers EZPAGES_DISABLE_HEADER_DISPLAY_LIST   EZ-Pages "pages" on which to NOT display the norma... 30 40 NULL 2007-01-28 23:38:31 NULL zen_cfg_textarea_small( 
      538 EZ-Pages Pages to disable footers EZPAGES_DISABLE_FOOTER_DISPLAY_LIST   EZ-Pages "pages" on which to NOT display the norma... 30 41 NULL 2007-01-28 23:38:31 NULL zen_cfg_textarea_small( 
      539 EZ-Pages Pages to disable left-column EZPAGES_DISABLE_LEFTCOLUMN_DISPLAY_LIST   EZ-Pages "pages" on which to NOT display the norma... 30 42 NULL 2007-01-28 23:38:31 NULL zen_cfg_textarea_small( 
      540 EZ-Pages Pages to disable right-column EZPAGES_DISABLE_RIGHTCOLUMN_DISPLAY_LIST   EZ-Pages "pages" on which to NOT display the norma... 30 43 NULL 2007-01-28 23:38:31 NULL zen_cfg_textarea_small( 
      547 IH small image background SMALL_IMAGE_BACKGROUND 255:255:255 If converted from an uploaded image with transpare... 4 102 NULL 2007-02-22 15:00:40 NULL zen_cfg_textarea_small( 
      665 IH small image compression quality SMALL_IMAGE_QUALITY 85 Specify the desired image quality for small jpg im... 4 103 NULL 2007-08-30 14:34:57 NULL zen_cfg_textarea_small( 
      553 IH medium image background MEDIUM_IMAGE_BACKGROUND 255:255:255 If converted from an uploaded image with transpare... 4 108 NULL 2007-02-22 15:00:40 NULL zen_cfg_textarea_small( 
      669 IH medium image compression quality MEDIUM_IMAGE_QUALITY 85 Specify the desired image quality for medium jpg i... 4 107 NULL 2007-08-30 14:34:57 NULL zen_cfg_textarea_small( 
      559 IH large image background LARGE_IMAGE_BACKGROUND 255:255:255 If converted from an uploaded image with transpare... 4 114 NULL 2007-02-22 15:00:40 NULL zen_cfg_textarea_small( 
      671 IH large image compression quality LARGE_IMAGE_QUALITY 85 Specify the desired image quality for large jpg im... 4 109 NULL 2007-08-30 14:34:57 NULL zen_cfg_textarea_small( 
      562 IH large image maximum width LARGE_IMAGE_MAX_WIDTH 750 Specify a maximum width for your large images. If ... 4 117 NULL 2007-02-22 15:00:40 NULL zen_cfg_textarea_small( 
      563 IH large image maximum height LARGE_IMAGE_MAX_HEIGHT 550 Specify a maximum height for your large images. If... 4 118 NULL 2007-02-22 15:00:40 NULL zen_cfg_textarea_small( 
 
```Do you reckon I should add '); to all of those other 24?

I'm a bit worried, I searched the database again but this time searchstring zen_cfg_

I recieved 343 search results in table configuration.
and I recieved 139 search results in table product_type_layout.
I just glanced in product_type_layout and I'm not sure if its missing a closure lite ');

Back to the 343 search results: I will only paste a couple of lines so you see how they look, some seems to have some kind of closure while some other doesnt.
pasted search results:
  3 Country STORE_COUNTRY 203 The country my store is located in <br /><br /><st... 1 6 NULL 2007-01-28 23:38:30 zen_get_country_name zen_cfg_pull_down_country_list( 
  4 Zone STORE_ZONE 192 The zone my store is located in 1 7 2007-02-03 22:44:46 2007-01-28 23:38:30 zen_cfg_get_zone_name zen_cfg_pull_down_zone_list( 
  5 Expected Sort Order EXPECTED_PRODUCTS_SORT desc This is the sort order used in the expected produc... 1 8 NULL 2007-01-28 23:38:30 NULL zen_cfg_select_option(array('asc', 'desc'),  
  6 Expected Sort Field EXPECTED_PRODUCTS_FIELD date_expected The column to sort by in the expected products box... 1 9 NULL 2007-01-28 23:38:30 NULL zen_cfg_select_option(array('products_name', 'date... 
  7 Switch To Default Language Currency USE_DEFAULT_LANGUAGE_CURRENCY false Automatically switch to the language's currency wh... 1 10 2007-01-29 03:18:51 2007-01-28 23:38:30 NULL zen_cfg_select_option(array('true', 'false'),  
  8 Language Selector LANGUAGE_DEFAULT_SELECTOR Default Should the default language be based on the Store ... 1 11 NULL 2007-01-28 23:38:30 NULL zen_cfg_select_option(array('Default', 'Browser'),... 
  9 Use Search-Engine Safe URLs (still in development) SEARCH_ENGINE_FRIENDLY_URLS false Use search-engine safe urls for all site links 6 12 NULL 2007-01-28 23:38:30 NULL zen_cfg_select_option(array('true', 'false'),  
  10 Display Cart After Adding Product DISPLAY_CART true Display the shopping cart after adding a product (... 1 14 NULL 2007-01-28 23:38:30 NULL zen_cfg_select_option(array('true', 'false'),  
  11 Default Search Operator ADVANCED_SEARCH_DEFAULT_OPERATOR and Default search operators 1 17 NULL 2007-01-28 23:38:30 NULL zen_cfg_select_option(array('and', 'or'),  
  12 Store Address and Phone STORE_NAME_ADDRESS Humpty Dumpty gatan 12 11 11 11 1 varejag ... This is the Store Name, Address and Phone used on ... 1 18 2007-08-01 11:51:35 2007-01-28 23:38:30 NULL zen_cfg_textarea( 
  13 Show Category Counts SHOW_COUNTS true Count recursively how many products are in each ca... 1 19 NULL 2007-01-28 23:38:30 NULL zen_cfg_select_option(array('true', 'false'),  
  15 Display Prices with Tax DISPLAY_PRICE_WITH_TAX true Display prices with tax included (true) or add the... 1 21 2007-01-29 12:19:24 2007-01-28 23:38:30 NULL zen_cfg_select_option(array('true', 'false'),  
  16 Display Prices with Tax in Admin DISPLAY_PRICE_WITH_TAX_ADMIN true Display prices with tax included (true) or add the... 1 21 2007-01-29 00:17:10 2007-01-28 23:38:30 NULL zen_cfg_select_option(array('true', 'false'),  
  17 Basis of Product Tax STORE_PRODUCT_TAX_BASIS Shipping On what basis is Product Tax calculated. Options a... 1 21 2007-02-03 22:48:30 2007-01-28 23:38:30 NULL zen_cfg_select_option(array('Shipping', 'Billing',... 
  18 Basis of Shipping Tax STORE_SHIPPING_TAX_BASIS Shipping On what basis is Shipping Tax calculated. Options ... 1 21 2007-02-03 22:48:32 2007-01-28 23:38:30 NULL zen_cfg_select_option(array('Shipping', 'Billing',... 
  19 Sales Tax Display Status STORE_TAX_DISPLAY_STATUS 0 Always show Sales Tax even when amount is $0.00?<b... 1 21 2007-01-29 12:19:19 2007-01-28 23:38:30 NULL zen_cfg_select_option(array('0', '1'),  
  22 Show if version update available SHOW_VERSION_UPDATE_IN_HEADER true Automatically check to see if a new version of Zen... 1 44 NULL 2007-01-28 23:38:30 NULL zen_cfg_select_option(array('true', 'false'),  
  23 Store Status STORE_STATUS 0 What is your Store Status<br />0= Normal Store<br ... 1 25 2007-02-03 22:50:16 2007-01-28 23:38:30 NULL zen_cfg_select_option(array('0', '1', '2'),  
  24 Server Uptime DISPLAY_SERVER_UPTIME false Displaying Server uptime can cause entries in erro... 1 46 2007-02-04 01:03:53 0001-01-01 00:00:00   zen_cfg_select_option(array('true', 'false'), 
  25 Missing Page Check MISSING_PAGE_CHECK On Zen Cart can check for missing pages in the URL an... 1 48 2007-01-29 00:19:26 0001-01-01 00:00:00   zen_cfg_select_option(array('On', 'Off', 'Page Not... 
  26 cURL Proxy Status CURL_PROXY_REQUIRED False Does your host require that you use a proxy for cU... 1 50 NULL 2007-01-28 23:38:30 NULL zen_cfg_select_option(array('True', 'False'),  
  28 HTML Editor HTML_EDITOR_PREFERENCE HTMLAREA Please select the HTML/Rich-Text editor you wish t... 1 110 2007-01-29 00:23:27 2007-01-28 23:38:30 NULL zen_cfg_pull_down_htmleditors( 
  29 Enable phpBB linkage? PHPBB_LINKS_ENABLED false Should Zen Cart synchronize new account informatio... 1 120 NULL 2007-01-28 23:38:30 NULL zen_cfg_select_option(array('true', 'false'), 
  30 Show Category Counts - Admin SHOW_COUNTS_ADMIN true Show Category Counts in Admin? 1 19 NULL 2007-01-28 23:38:30 NULL zen_cfg_select_option(array('true', 'false'),  
  57 Manufacturers List - Verify Product Exist PRODUCTS_MANUFACTURERS_STATUS 0 Verify that at least 1 product exists and is activ... 3 7 2007-02-04 01:05:25 2007-01-28 23:38:30 NULL zen_cfg_select_option(array('0', '1'),  
  86 New Product Listing - Limited to ... SHOW_NEW_PRODUCTS_LIMIT 30 Limit the New Product Listing to<br />0= All Produ... 3 40 2007-09-04 13:29:36 2007-01-28 23:38:30 NULL zen_cfg_select_option(array('0', '1', '7', '14', '... 
  90 Allowed Filename Extensions for uploading UPLOAD_FILENAME_EXTENSIONS jpg,jpeg,gif,png,eps,cdr,ai,pdf,tif,tiff,bmp,zip List the permissible filetypes (filename extension... 3 61 NULL 2007-01-28 23:38:30 NULL zen_cfg_textarea( 
  101 Calculate Image Size CONFIG_CALCULATE_IMAGE_SIZE true Calculate the size of images? 4 7 2007-02-22 02:05:27 2007-01-28 23:38:30 NULL zen_cfg_select_option(array('true', 'false'),  

thanks
Dejan

> **CrystalKoi:**
>
> 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:**
>
> 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:
> ```php
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(');
7 Sep 2007, 4:08 PM
#22
dedj avatar

dedj

Zen Follower

Join Date:
Jan 2007
Posts:
129
Plugin Contributions:
0

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

it worked for me to add ');

but i'm just wondered about all those commands in database without closure.

let me know if I need to worry about anything or if everything is in order.

thanks

19 Nov 2007, 11:13 PM
#23
sirbuck avatar

sirbuck

Zen Follower

Join Date:
Jan 2007
Location:
Carlsbad, CA
Posts:
161
Plugin Contributions:
0

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

Ajeh:

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



AWESOME!  Thank you Ajeh!

-Buck

20 Nov 2007, 3:39 AM
#24
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

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

You are most welcome ... thanks for letting us know that this solution worked for you as well ... :smile:

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

19 Jan 2008, 7:39 AM
#25
mrblaq avatar

mrblaq

New Zenner

Join Date:
Dec 2007
Posts:
21
Plugin Contributions:
0

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

Ajeh:

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



Thank you very much for that tip.  This resolved a problem I was having after running the Google Analytics installation SQL.  It very haphazardly removes some key static strings that make the attributes system work.
4 Feb 2008, 5:04 PM
#26
yellow1912 avatar

yellow1912

Totally Zenned

Join Date:
Oct 2006
Posts:
5,422
Plugin Contributions:
0

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

Ajeh, I'm using 1.3.8a (upgraded from 1.3.7) and the setting above are still missing from database. Did we miss something in the upgrade process?

I no longer provide installation support on forum for all my modules. However, if there are real bugs with the modules please feel free to contact me

23 Apr 2008, 2:16 PM
#27
oavs avatar

oavs

Totally Zenned

Join Date:
Jan 2006
Location:
Downunder - QLD - Gold Coast
Posts:
921
Plugin Contributions:
0

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

yellow1912:

Ajeh, I'm using 1.3.8a (upgraded from 1.3.7) and the setting above are still missing from database. Did we miss something in the upgrade process?

Ajeh, Ajeh, Ajeh, Ajeh, Ajeh,

I need the same answer please. I also have 1.3.8a and I do not want to stuff it up by installing redundant code.

I have two attributes

  1. text field > its a required
  2. File upload > required

It only validates for text and not for the file upload.

Will the above code safe to use for 1.3.8a ?
Do you have any other suggestion please as I really need it to get it going tomorrow .

Thanks for your kind help and support Ajeh, and do realise must be horrible for you to repeat the same answers again and again and again...then again we love you for ever and ever and ever :-)

Downunder QLD

26 Apr 2008, 5:21 AM
#28
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

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

File Upload Option Name Type does not have a validation on it, at this time ...

You would require customization to the code to get this type of validation to work ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

26 Apr 2008, 9:51 AM
#29
oavs avatar

oavs

Totally Zenned

Join Date:
Jan 2006
Location:
Downunder - QLD - Gold Coast
Posts:
921
Plugin Contributions:
0

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

:-( may be in 1.3.8b ? pretty please?

Downunder QLD

27 May 2008, 9:33 PM
#30
carolinebogart avatar

carolinebogart

New Zenner

Join Date:
Apr 2007
Location:
Manchester, NH
Posts:
52
Plugin Contributions:
0

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

I just sent you a Starbucks treat (a PayPal donation).

THANK YOU for this SQL.

:clap:

2 Mar 2009, 12:04 AM
#31
techiant avatar

techiant

New Zenner

Join Date:
Oct 2008
Posts:
82
Plugin Contributions:
0

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

Ajeh:

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


Thanks Ajah. This has helped resolve the problem we were having (at [http://case-badges.com/](http://case-badges.com/) ).

We have v 1.3.8a. Lots of add-ons and heavily customized.

Thought it was one of the customizations we have made that required image upload based on a specific radio selection, but this appears not to be the case.

Cannot specifically point out which add-on destroyed the DB entries without digging in any further. 

As much as we all love our contributors, some need to be a little more cautious, especially when updating the database tables. Of course we, the developers also have the responsibility to thoroughly test the add-ons before going live with them.

Thanks.

**Case Badges** by Techiant

2 Mar 2009, 8:48 PM
#32
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

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

Thanks for the update that this solved your issues ...

Also, be sure to peek at the threads for;

Known Bug Fixes v1.3.8 ...
http://www.zen-cart.com/forum/showthread.php?p=659717#post659717

USPS Patch for current version ...
http://www.zen-cart.com/forum/showthread.php?t=97461

Security Patches ...
http://www.zen-cart.com/forum/showthread.php?t=108428

Good luck with your shop! :cool:

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

7 Mar 2009, 10:25 PM
#33
nedward avatar

nedward

New Zenner

Join Date:
Mar 2007
Posts:
90
Plugin Contributions:
0

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

SirBuck:

AWESOME! Thank you Ajeh!

Also, this worked for me.
I just installed Simple SEO URL mod and then noticed that my text required had disappeared.
So many thanks for the fix.
Steven:clap:

7 Mar 2009, 10:36 PM
#34
yellow1912 avatar

yellow1912

Totally Zenned

Join Date:
Oct 2006
Posts:
5,422
Plugin Contributions:
0

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

Nedward:

Also, this worked for me.
I just installed Simple SEO URL mod and then noticed that my text required had disappeared.
So many thanks for the fix.
Steven:clap:
I dont see how SSU can affect this in any way though, since it does not touch the fields mentioned above at all.

The only mod I know so far that messed it up is IH2.

I no longer provide installation support on forum for all my modules. However, if there are real bugs with the modules please feel free to contact me

16 Mar 2009, 5:55 PM
#35
dlg_ie avatar

dlg_ie

New Zenner

Join Date:
Oct 2008
Posts:
30
Plugin Contributions:
0

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

many thanks for this solution, which also solved my problem. I don't know which mod caused it because I installed a few and only later noticed the problem.

I only had to add my DB prefix in front of "configuration" in the SQL code.

Regards,

Denis

27 Jul 2009, 9:20 PM
#36
dewluca avatar

dewluca

New Zenner

Join Date:
Nov 2008
Posts:
9
Plugin Contributions:
0

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

I'm not using either the Google Sitemaps addon or Image Handler 2, but I'm having the same problem: some of my items have one or more required text fields, but zen cart lets the items be ordered without anything in these fields. No error message appears.

Does the fix above apply even without the mentioned addons?

I'm pretty sure this used to work fine for me. The only things I've added recently are the security patch for 1.3.8, and Quick Updater. I also have Easy Populate, but I'm pretty sure the required fields were working fine after I added that.

Any other ideas?
Thanks.

P.S.
The cart I'm setting up is at:
http://beadsnmorejewelry.com

Most of the items with the required text fields are in the Bracelets>Name, Spirit, Mommy Bracelets section.

27 Jul 2009, 11:17 PM
#37
dewluca avatar

dewluca

New Zenner

Join Date:
Nov 2008
Posts:
9
Plugin Contributions:
0

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

Okay, I got brave.
After backing up my database and while I was still in phpMyAdmin, I looked at the zen_configuration table to verify that the lines that the fix suggests I modify indeed were not there. As I looked at the table I noticed some odd numbering of the config IDs that suggests that one of my addons might have overridden some lower config IDs, but I'm really not sure.

In any case, I went ahead and entered the first three INSERT commands (listed in #31 above) in the SQL query box in phpMyAdmin and made the modification of the configuration file name. Bravely pressed "Go" and Voila! It seems to have worked!

One question though . . . I didn't include the fourth INSERT command (re Image Handler) because I haven't installed the ImageHandler2 addon that many of the posts believed was the problem . . . or is that statement referring to some more generic version of an Image Handler??? Should I insert it anyway??

Thanks for everyone who has helped with this issue . . . I didn't realize addons could be so dangerous!

9 Oct 2009, 8:47 AM
#38
slobadog avatar

slobadog

New Zenner

Join Date:
Mar 2006
Posts:
89
Plugin Contributions:
0

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

Thankyou once again Ajeh, this patch has fixed the same problem in my project with v1.3.8a, the "required" text is still not showing but that should be pretty easy to fix now.

8 Jan 2010, 1:47 PM
#39
gtalwar avatar

gtalwar

New Zenner

Join Date:
May 2008
Posts:
7
Plugin Contributions:
0

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

I installed the SQL patch and set a TEXT box as required, now when I try adding a product without updating the TEXT box, The product is not added and I don't get any message either, it just says shopping cart is empty, However when I update the required TEXT box the product is added.

Can some one help me in getting the "required variable message" to work again

URL http://silkoptions.com/plain-top-dupioni-curtains-46-x-100-p-85.html

The TEXT filed with required option is "Width"

8 Jan 2010, 2:26 PM
#40
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

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

And if you turn off the SEO/rewrites does it work?

How about if you switch to the Classic Template?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!