Problem increasing Option Value Length - Please Help

[Sam74]

I'm tried increasing the maximum Option Value Length from 64 to 255 characters. I did this by doing the following:

1. In phpMyAdmin I navigated to the structure of znc_products_options_values
2. Changed products_options_values_names to varchar(255) from varchar(64)

This did indeed allow me to enter Option Values up to 255!! Great I thought....

But now when I go to the Attribute Controller to edit an option for a specific product I get the following error message:

Attribute Option and Option Value Do NOT Match - Attribute was not changed - Quantity : TEXT

Editing any attribute with a value less than 64 characters still works just fine.

I'm guessing I missed a an entry in the database that needs to be changed. I'm using ZenCart v1.3.9h and would greatly appreciate any help in this matter!!

Thanks,

Sam

[Ajeh]

On the Option Name, what is the Option Type that you are having issues with?

[Sam74]

Thank you so much for chiming in Ajeh!!!

The Option Type is Radio.

[Ajeh]

I changed my database:
1. In phpMyAdmin I navigated to the structure of znc_products_options_values
2. Changed products_options_values_names to varchar(255) from varchar(64)

I then tried working with Attributes Controller to add/edit Attributes with the longer names and have no problems ...

Do you have a click for click of what you are doing to reproduce the problem?

[Sam74]

As I started doing a click-for-click recreation to share with you... I stumbled upon something. It appears that the problem is not with the length of the entry, but with the contents themselves! Here is an example...

2 Bottles for <strong>$47.90</strong> / $23.95ea <span style="color:white; background-color:green;">##Save $8.00 </span>

This is over 64 characters and fails when I try to edit a specific product's entry in the Attribute Controller.

However if I remove the span tags and just use regular text it works fine. The problem appears to be due to the span tag...ugh The strong tag works fine.

The customer I have wants to have the formatting that is contained within those span tags.

Any suggestions? I'm at a loss.

[Ajeh]

You need to make a new class for the span tag and use it with single quotes:

2 Bottles for <strong>$47.90</strong> / $23.95ea <span class='mygreen'>##Save $8.00 </span>

Or you can try with single quotes:

2 Bottles for <strong>$47.90</strong> / $23.95ea <span style='color:white; background-color:green;'>##Save $8.00 </span>

[Sam74]

Single Quotes!!!!!!! LOL.

It's people like you Ajeh that make the world a better place

I appreciate your help in resolving this issue and making me a happy camper!!!!!!


Regards,

Sam

[Ajeh]

Thanks for the update that this worked for you ...

[ShockRaver]

this helped me to, works great....

thx