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

[dedj]

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 &nbsp; 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 -&gt; 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 |_&nbsp; 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 &nbsp;( 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 &nbsp;&nbsp; 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 &nbsp;::&nbsp; 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 &nbsp;::&nbsp; 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'),

What do you reckon I should do? I would really like to have the attribute required for text to work.

thanks
Dejan

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.

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

Think ... Think ... Think ...

I remember!!!

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

[dedj]

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

[SirBuck]

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

Think ... Think ... Think ...

I remember!!!

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!

[Ajeh]

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

[mrblaq]

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

Think ... Think ... Think ...

I remember!!!

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.

[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?

[oavs]

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

[Ajeh]

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 ...

[oavs]

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

[CarolineBogart]

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

THANK YOU for this SQL.