Disappearing Text Box

econcepts...thank you! This specifically did not work, but following through on the link you posted I reviewed the entries against what was in my db and found what others found...that the entry:

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

was missing the '); on the end within the db. Added it, and all is well!

Ty much for sticking w/ this thread!! Not I can apply to all my products!

tcustomgolf:

econcepts...thank you! This specifically did not work, but following through on the link you posted I reviewed the entries against what was in my db and found what others found...that the entry:

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

was missing the '); on the end within the db. Added it, and all is well!

Ty much for sticking w/ this thread!! Not I can apply to all my products!

No problem at all. I had a few people come to me recently that had the same problem and needed to get it fixed. After what seemed like an eternity of looking for an answer, it hit me that reading the thread Ajeh posted a long time back (I had to go find it again) that there were a few items in the DB that were deleted. After looking at them and seeing a few had to do directly with attributes in question, it made sense to run the patch and viola.

Hope this helps others in the future. I pulled my hair out to figure this problem out.

Out of nowhere my text boxes are missing.

The title tag is there. Just not the text box.
I checked the stylesheet.
That wasnt it.
I backed up to a prior tpl_products_info_display

Link to same problem
http://www.allforyourwedding.com/index.php?main_page=product_info&products_id=1535

if its this database change you have been talking about. Perhaps you could walk me through how to check/change

Still banging my head against the wall on this one?

Would upgrading help?

I tried uploading the SQl patch that was listed but it still did not help.
:frusty::frusty::frusty::frusty::frusty::frusty:

Still having this issue

http://www.allforyourwedding.com/index.php?main_page=product_info&products_id=1535

Anyone???

I am also having difficulty adding a text box attribute to product in a client's store. I tested adding the text attribute to a product in a clean install on my test server and it worked fine. But on the client's site, the text box doesn't show up at all. So, I'm guessing it's some add-on interfering with the text box. I noticed two things comparing the working site with the non:

1. When I preview the attribute via the attribute controller and look at the source code for where the text box should be, I see the following in the working site:

<tr>
<td class="main" align="left" valign="top">File Name:</td>
<td class="main" align="left" valign="top" width="75%"><input type="text" name ="id[txt_21]" size="32" maxlength="32" value="" />
</td></tr>
```and this in the non-working site:

2. The other thing I noticed is in the Attribute Controller itself. In the working version there was an option value of "TEXT" listed under the Attribute whereas the value "TEXT" was missing from the non working version.

While writing this message, I did some investigating into the databases themselves and found that the non-working version was missing an entry in the table: products_options_values that had an id of 0 and a name of "TEXT". Simply adding that record to the products_options_values table solved the problem.

Hope this helps!

Thanks for the update that you were missing the default Option Value for the TEXT from your products_options_values table and that adding it was able to correct the problems with TEXT attributes on your screen ... :smile:

Could someone write a sql statement for those of us who dont really go in and make modifications to the database.

Something that i can drop in the sql patch section that would accomplish:

While writing this message, I did some investigating into the databases themselves and found that the non-working version was missing an entry in the table: products_options_values that had an id of 0 and a name of "TEXT". Simply adding that record to the products_options_values table solved the problem.

Thanks

If you are really missing from the products_options_values the TEXT setting and have double and tripple checked ...

You can use the following to add this back in via the Tools ... Install SQL Patches ...

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

NOTE: if you have multiple languages this will require additional work ...

Ajeh:

If you are really missing from the products_options_values the TEXT setting and have double and tripple checked ...

You can use the following to add this back in via the Tools ... Install SQL Patches ...

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

> 
> NOTE: if you have multiple languages this will require additional work ...

I just had to do this on a store... *(but WHY would the TEXT option disappear in the first place??)*.

With several stores, ALL sharing same add-ons, only one had this problem... strange...:dontgetit

Someone might have cleaned out the table: products_options_values

And by default, this one entry is suppose to be in there to manage TEXT attributes ... :smile:

Ajeh:

Someone might have cleaned out the table: products_options_values

Someone... ? Perhaps my alter-ego, as I'm the only one who takes a chainsaw to the back-end stuff! :D

Just wanted to chime in and say that this just happened to me... I added the SQL statement (thanks!) and it is back. :clap:

FYI - I have about 42 attributes in this store, but text was never used until now, and then it was not there when I did want to use it. :huh:

Nothing was different about any of my other attributes, so I am not sure that any back-end oops is the problem. :dontgetit

I have quite a few mods, but in looking through the thread I am guessing that we (who are missing the text attribute) must have SOME kind of mod (or something) in common... :unsure:

Thanks to everyone who added to this info, it got my shop back to being ready for sales after a quick forum search! :hug: