Within product feature tabs, when I make entries it seems to only allow a small amount of characters.
How can one extend the number of characters allowed for a product’s feature tabs?
Thanks in advance…Jefferson
Hi @Tribal,
Can you please share the link to store
Regards,
—
Valentin
[color=#808080][size=2]part of hungryweb.net[/size][/color]
[quote name='Tribal' timestamp='1412795635' post='193677']
Within product feature tabs, when I make entries it seems to only allow a small amount of characters.
How can one extend the number of characters allowed for a product's feature tabs?
Thanks in advance…Jefferson
[/quote]
As far as I can see, the amount of characters is not limited:
Instant Demo - CS-Cart Multi-Vendor Demo Try Free for 15 days
Please specify the theme you use
I am using the “Out-of-the-box” Responsive theme, saved under a new name, with only basic color changes.
I am using tabs… and created a Feature for products.
When editing a product, I select to add that feature.
That feature's input field is exactly where characters input are being clipped.
How are images, attachments, media… included on these forums?
Sure would like to enclose a screen cature.
Please advise…thanks! Jefferson
According to the database structure, a Feature Variant can be up to 255 characters.
If you just want to see a larger text field, so you can see all 255 characters, then you need to edit the forms.less file:
“/design/backend/css/lib/twitterbootstrap/forms.less”.
I changed the width of the textarea starting at line 94 to this (made everything easier to view in the backend):
input,
textarea,
.uneditable-input {
width: -moz-available; // plus 12px padding and 2px border
}
Thank you… although, it seems the description variant allows for many more characters than the Feature Variant.
How may we extend the 255 char limit on the Feature Variant… and have it retained throughout future CS updates?
Thanks!! Jefferson
There must be a way we can extend the 255 char limit on the Feature Variant… and have it retained throughout future CS updates…please… does anyone know exactly how to do this?
Thanks!! Jefferson
[quote name='Tribal' timestamp='1412968384' post='193902']
There must be a way we can extend the 255 char limit on the Feature Variant… and have it retained throughout future CS updates…please… does anyone know exactly how to do this?
Thanks!! Jefferson
[/quote]
You can run the following SQL query:
ALTER TABLE `cscart_product_feature_variant_descriptions` CHANGE `variant` `variant` TEXT NOT NULL DEFAULT '';
If CS-Cart team does not change the structure of this table in the feature releases, you will not face any issues with the upgrades.
P.S. Do not forget to make a backup of the cscart_product_feature_variant_descriptions table before making any actions.
I ran the query…so… EXACTLY where and HOW do I extend the variant field?
What EXACT entry do I need to put where?
Just running the query does not seem to do anything, and the variant field still cuts of characters exactly the same as before.
Thanks… Jefferson
Please see the attached captures.
Exactly what must go in what fields?
You changed the type to TEXT when you ran the query.
See: MySQL :: MySQL 8.0 Reference Manual :: 11.3.4 The BLOB and TEXT Types
There is probably something in the template that is truncating your input.
[quote name='Tribal' timestamp='1413231059' post='194063']
I ran the query…so… EXACTLY where and HOW do I extend the variant field?
What EXACT entry do I need to put where?
Just running the query does not seem to do anything, and the variant field still cuts of characters exactly the same as before.
Thanks… Jefferson
[/quote]
Yes, the field type was changed. If it still does not work, additional examination is required.
Also changed cscart_product_feature_variant_descriptions …description field to longtext…
still truncates as shown in previous attachments.
Still unresolved… Jefferson
I also i have this same problem
[quote name='Tribal' timestamp='1412968384' post='193902'] There must be a way we can extend the 255 char limit on the Feature Variant… and have it retained throughout future CS updates…please… does anyone know exactly how to do this? Thanks!! Jefferson [/quote]
Also can't change the VARCHAR to TEXT due to the DB schema…
Were you able to find a solution Jefferson?