TEXT field attribute not showing

Hi,

I have fiddled with this every way I can and can't seem to fix.

I have a product that is using a drop box to select a size range and then I need a text field for them to enter their actual window size. I have set this up in attributes for the product:

http://www.ecomaster.com.au/zencartissue.cfm

but here is what the product listing looks like (no text field showing):

http://www.ecomaster.com.au/shop/index.php?main_page=product_info&cPath=6&products_id=34

I would really appreciate any suggestions.

Kind regards,

jo

How did you make the Option Name for the TEXT attribute?

Hi Linda,

In the ‘Option Name’ panel, I added the Option Name as ‘Window reveal size’ and then chose ‘Text’ from the Option Type dropdown list.

Then, I went back to the Attribute Controller and chose the product and then scrolled down to ADDING NEW ATTRIBUTES, selected ‘window reveal size [TEXT]’ and then in the Opt ion Value list chose TEXT [RESERVED FOR TEXT/FILES ONLY ATTRIBUTES].

I’m guessing now that I’ve done this incorrectly?

Thanks for your assistance.

Kind regards,

jo

If you switch to Classic Template does this fix it?

Hi Linda,

I have never done that before - I can try - is it hard or will it wreck anything?

Thanks,

jo

The templates are designed that you can switch between them and back ... it just tells the code to call a different set of files ...

Tools ... Template Selection ...

Click Edit and pick Classic from the dropdown ...

NOTE: backups of your database are always a smart move before making changes that you are unfamiliar with ...

Hi Linda,

Yes, it is there when I view the listing in classic template. This means my template is wrong I guess?

Thanks,

jo

Unfortunately ... you have a bad template or override file ... :cry:

Good news is something like Beyond Compare from scootersoftware.com that could be used to compare your site to a clean zip of Zen Cart ...

Then you can compare your template to the template_default files and any other overrides ...

More than likely it is something to do with the tpl_ file or the /pages files ...

Hi Linda,

thanks for the baaaaadd news... eeccht!

Can you tell me the name of the file you think this bit is on? I have a clean copy of zencart so I can maybe take a look and it will be EASY to fix - fingers crossed!

Much appreciated.

jo

tpl_product_info_display.php

is the first place to check ...

Turn back on your template ...

Look in your template overrides, does that file exist? If so, rename to:
tpl_product_info_display.php_HIDE

Does it work now on your template but with our default template running?

Hi Linda,

Do you mean 'tpl_product_info_display.php' - I can't find tpl_product_info_default.php.

thanks,

jo

Yes, tpl_product_info_display.php ... must of missed the coffee cup ... :blink:

Hi Jo + Linda,

I don't know if you ever found what was causing your disappearing text box issue, but I was experiencing exactly the same thing.

I found a workaround, which potentially could be a bug in ZC but here's how I did it...

Option Name Manager - create a new dropdown attribute

Option Values Manager - add a single value to the attribute you've just created (any text will do as a value)

Attribute Controller - add your new dropdown attribute name AND its value to the product you want the textbox to appear on

On the public side product info page you should now see the new attribute as a checked radio button.

Back to the Option Name Manager, change your new attribute from Dropdown to Text and click Update.

Ta-da! Your text attribute box now appears on the public product info page. At this stage, though, I've noticed the attribute name isn't appearing on the shopping cart screen when a customer adds the product to the basket. May be an issue for you if you use more than one text attribute on a product.

Hope this helps.

Chris

Hmmm, so much for my fix.

Sure enough, the text box appears on the info page but so far I've found two further issues...

1. the option name doesn't appear in the shopping cart and
2. when you actually confirm the order, you run in to an SQL error (1366 Incorrect decimal value '' for column 'options_values_price' in the zen_orders_products_attributes table). The order is then saved but without the attribute info.

Back to the drawing board, I guess...

Any luck with the mysterious disappearing text field option?
I'm almost completely convinced I can use ZC on a big project except for this issue.

bigbadboy:

Any luck with the mysterious disappearing text field option?
I'm almost completely convinced I can use ZC on a big project except for this issue.

This only occurs in certain circumstances where you install a third party mod (after a clean install) and that mod deletes a few records from the DB.

The problem stems from a database issue that occurs on some installs of third party mods. Some of them inadvertently deleted a few records from the db, and that is the cause of the problem. To correct the mysterious disappearing text box on zen cart run the following lines of code from within your Admin (SQL Patches) area.

If you get "duplicate" error messages just disregard. It means that a line or two of those being inserted was already present (which is ok) in the db.

Run this and you should see the boxes stay put on the page now.

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

This concept was pulled form an old post by Ajeh found here:
http://www.zen-cart.com/forum/showpost.php?p=408898&postcount=10

I have the same problem all of a sardine! I've tried everything (except whats needed!) to fix this, without any luck. I'm really at my wits end. :down:
To attemp fix:
I have fiddled with the templates, alternating etc etc
done a database restore from an older backup.
Unistalled some 3rd party mods.
Tried the previous suggestions in this thread.
I just cant figure this out!

I also noticed that if i create new attribute options (text) in Admin it does not appear in the options for adding them to the product. So i cant even add new ones to products.

Please have a look here
http://www.thissideup.co.za/store/amber-corner-lounge-suite-p-300.html

-- Step 1 ------------------------------------------------------

[L] Measurements [cm]

Any help would be seriously appreciated as currently this thing prevents some quite afew products from being ordered.

Many thanks
Warren

Can you look at the database table products_options_values and brows to see if you have a products_options_values_id for 0 ...

This is needed for TEXT attributes to work as this is their products_options_values_id ...

If you do not have an products_options_values_id of 0 that is set for TEXT, you need to add that back in with:

INSERT INTO products_options_values (products_options_values_id, language_id, products_options_values_name) VALUES (0, 1, 'TEXT');

:D Thank you Ajeh! Thank you - very much. That's sorted it right out. :bigups: Phew!

Thanks for the update that you were missing the TEXT entry in the products_options_values table that works with the TEXT input for these settings ... :smile: