Disappearing Text Box

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

[econcepts]

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.

[milobloom]

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/ind...oducts_id=1535

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

[milobloom]

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.

[milobloom]

Still having this issue

http://www.allforyourwedding.com/ind...oducts_id=1535


Anyone???

[earmsby]

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:

<tr>
<td class="main" align="left" valign="top">File Name:</td>
<td class="main" align="left" valign="top" width="75%"></td></tr>

So, it seems as though the text box is not getting written at all and it's not simply a question of a stylesheet rendering it incorrectly.

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!

[Ajeh]

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

[milobloom]

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

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

[schoolboy]

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