No text input boxes for attributes in IE or Firefox

After reading and reading I can't find anything exactly the same but lots of similar threads. I think I've narrowed it down.

http://www.donhume.com/ZenCart/

After adding a TEXT option type with name "Belt Size", and adding it to a product, when viewing that product the text box doesn't show up. It's not the browser issue because it's the same in firefox. There is a search input box that works fine on the same page too. It seems to happen if the option value type is TEXT and there not being any option values, the code returns nothing on tpl_modules_attributes.tpl around Line 30.

Example: http://www.donhume.com/ZenCart/index.php?main_page=product_info&cPath=8&products_id=92

This code

<?php echo "\n" . $options_menu[$i]; ?>

Outputs nothing. I need the text box. Any suggestions or help would be appreciated!

The TEXT option name 'Belt Size' has no associated option_value values.
It has been successfully added to the product and can be edited. Publicly though, half the output comes out, and its not the second half containing the text box! $options_menu[$i] is coming back NULL.
Back to work. lol

What Option Type do you have set for your Option Name for Belt Size?

Hi Ajeh thanks for replying.

Option Type is 'Text'

Via phpMyAdmin check the table: products_options_types and browse it ...

Do you have one for Text?

Check the table: products_options_values

Do you have one for TEXT?
products_options_values_id language_id products_options_values_name products_options_values_sort_order
0 1 TEXT 0

Thanks for getting back. So guess what, my products_options_values_id is 1 and not 0. So I have:

1 1 Text 0

Do you think that's it?

By default, that should be a 0 ...

Can you sort on products_options_values_name and see how many are named as: TEXT

Sorry I thought I replied to this thread nights ago after you answered my question. I appreciate the help very much, and thank you. This is fantastic software and I plan to use a lot of it helping people setup their web stores. Thanks again!

For those of you searching the forums for a way to validate input on a text field, here is the code I used on \includes\fuctions\function_lookups.php around line 444 in function zen_get_attributes_valid.

(keep in mind I only have one text attribute option, so this would cause problems trying to validate other options text boxes)

if (($value < 24) OR ($value > 78) OR (!is_integer($value / 2 ))) {
$check_valid = false;

I'm trying to convert over from OSC and am stuck on one thing.
Attributes text field.

I have the text attribute assigned to a product, no problem but, as above, the actual text field is not rendering in FF or IF Mac and PC.

In English (?), can some one explain how to get the text field to render, please.

Thank you.

Edit - It's not showing on Safari (Mac) either.

What's OSC? Similiarly, I had this problem because I moved data from an old site into the new Zencart. For some reason a few key id's got screwed up and what Ajeh posted here fixed my problem.

As mentioned earlier in this thread did you check your products_options_values table for a TEXT option?

Does the rest of the page load fine? ie. javascript/css

Post a link :D

OSC - OSCommerce

The page loads fine, everything except the actual text box. The attribute name loads just not the actual text box.

basically, all I want to do is ad a text box for the customer to add 3 letters (for engraving).
If there is an easier, working way to do it please let me know!

I checked the products_options_values. There is a text option, i think, not really good with phpmyadmin.

It sounds like the exact same problem I was having though. When you find the "Text" option in the products_options_values table, make sure the products_options_values_id associated with it, is 0. Just as described in the post from Ajeh.

When I copied data over from another database I ended up a 1 instead of a 0 in that one field and that gave me these symptoms. Check that value!

Thanks for the reply.

I might be looking in the wrong place but ...
phpmyadmin > database > products_options_values
Then look for products_options_values_id where I have this:
products_options_values_id - type: int(11), null: No, default: 0

so I am assuming this is in fact correct.

Not sure if this makes any difference but I imported from a OSC database to zen which had attributes already. Then I added the text field.

As far as

products_options_values_id - type: int(11), null: No, default: 0

goes, it describes a field in your database but the check the ACTUAL VALUE for the products_options_values_id WHERE the products_options_values_name is 'Text' or 'TEXT'. The products_options_values_id should be 0 for the 'Text' option.

Do you know how to browse that in phpmyadmin? pm me i'll send u instructions np

I've PM'd you but in the meantime ...

For the products_options_values_name field I have:
products_options_values_name type:varchar(64) Collation: latin1_swedish_ci Null:No

Attributes and default do not have a value assigned.

And thanks to ElSlozzo, we all lived happily ever after!

The answer:
Via phpMyadmin, search the database for a products_options_values_id of 0. The products_options_values_name for the products_options_values_id of 0 is 'Text'.
If you don't have one, make one. Click insert, put in 0 for id, 1 (or other language id), Text, and 0 (or other sort order) in the new record for that table.

You could even do this, click browse the table, then click products_options_values_id to sort by that column name. If you do so and TEXT isn't your first record with an ID of 0 then go ahead and make one.

Hope this helps.

bigbadboy:

And thanks to ElSlozzo, we all lived happily ever after!

The answer:
Via phpMyadmin, search the database for a products_options_values_id of 0. The products_options_values_name for the products_options_values_id of 0 is 'Text'.
If you don't have one, make one. Click insert, put in 0 for id, 1 (or other language id), Text, and 0 (or other sort order) in the new record for that table.

You could even do this, click browse the table, then click products_options_values_id to sort by that column name. If you do so and TEXT isn't your first record with an ID of 0 then go ahead and make one.

Hope this helps.
Be sure to read the whole thread if you need to do this to make sure it applies to your situation.
I can't take all the credit. We'd all still be stuck if it wasn't for Ajeh!