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