TEXT field attribute not showing

Hi Ajeh

The problem was caused by the software i was using to restore the database. I just recently started using this software for updates and did'nt pick up the problem it was causing straight away.
When i discovered the issue on my site, i then continued to use the software db tool to try and fix it, thinking it was perhaps the result of a mod installation, or template alteration on my part. That's why, despite doing db restores, the problem persisted. :dontgetit
I've stopped using the software, because every time it connects (yip, it only had to connect) to the db it removes that code you gave me.
I've notified the creators of the 3rd party software to have a look at it.

Once again, many thanks
Warren

Thanks for the update and letting the 3rd party software folks know ...

Good luck on this! :smile:

I know its an old thread but I have wasted hours on this issue and this post finally fixed it for me. So thanks Ajeh. ... I have also used some custom scripts to import products and attributes and this line must have been removed from the DB... so this simple fix fixed my missing File Upload field. Thanks a lot. :D

Ajeh:

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

Thanks for posting the update of what fixed your TEXT attributes ... it is always a real help to others ... :smile:

It seems as though this issue popped back up in 1.3.9d. Any ideas how to fix it?

Here is the page it happens on:

http://healthnewsweb.com/index.php?main_page=product_info&cPath=5&products_id=182

When I click add to cart without the required drop down selected, when the page reloads I have no text boxes. If I go back one page and refresh the page, everything is fine.

Any ideas?

I cannot reproduce this in v1.3.9d nor v1.3.9f ...

What happens if you switch to the Classic Template?

Just because it is an oddity ... what happens if you remove from the Option Names for your TEXT the:
-->

During upgrade did you install any other mods (or upgrade any current ones)?

If I recall, this could become a problem after installing some mods that remove core database features in zen ... specifically relating to removal of configuration values equal to "0" (zero).

Am I thinking properly Ajeh?

That could be the case ... there is something with I believe on of the add ons that had an error in the sql that altered something incorrectly and broke the attributes ...

I am trying to remember if it specifically broke the TEXT attributes ... :unsure:

I do know the fix is posted on the forum somewhere ... just have not had time to hunt that one down ...

It should be on one of my posts, if I am not mistaken ...

This post talks about some Attribute issues that were damaged with an add on ... but I am not sure if it is related ...
http://www.zen-cart.com/forum/showthread.php?t=69217&highlight=TEXT

Here is some code I found that I used in the past to correct a similar issue with another store. Some if it may apply ... other portions (Image Handler) may not (if not installed).

Maybe this will help:

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

To determine if these values are missing from the store (before you run the query) I ran this:

SELECT * FROM configuration WHERE configuration_group_id = 0;