VirtueMart Forum

VirtueMart 2 + 3 + 4 => Product creation => Topic started by: fritschle on August 30, 2013, 07:10:23 AM

Title: Maxed out custom field - color list
Post by: fritschle on August 30, 2013, 07:10:23 AM
I have an issue and can't seem to find an answer to it on here.  I have a list of colors for a product.  When I went in to add a few more colors to my cart variant list, I clicked in the default box and went to add my few more colors.  I hit a limit.  I still have a few more to add. Is this a character limit, a max option limit?  How do I get around this?

Thanks.
Title: Re: Maxed out custom field - color list
Post by: Maxim Pishnyak on August 30, 2013, 07:14:53 AM
Could you post here a screen shot of your issue?
Title: Re: Maxed out custom field - color list
Post by: fritschle on August 30, 2013, 07:35:55 AM
Here you go.  Hopefully this will clear up what I was talking about.

The full list of items in the box is:
Select;Black;Brown;Burgundy;Carolina Blue;Cherry;Clear Coat;Crimson;Dark Mahogany;Ebony;Flame Tempered;Gold;Gray;Green;Hunter Green;Mahogany;Navy;Natural (Unfinished);Neon Green;Neon Orange;Neon Yellow;Orange;Pink;Purple;Red;Royal;Silver;White Wash;Yellow

[attachment cleanup by admin]
Title: Re: Maxed out custom field - color list
Post by: Maxim Pishnyak on August 30, 2013, 07:47:49 AM
Are you sure that this is the only method to work with cart variants? Check video tutorials in my signature.

Also you could check Product Options Custom Field Dropbox Plugin (from moderator of 3rd party forum section). This free plugin has much higher list limit.
Title: Re: Maxed out custom field - color list
Post by: fritschle on August 30, 2013, 10:28:27 AM
First off.  Why are you asking me a question related to your videos?  I don't have time to watch every video in your list.  If there is one that would help, let me know what it is and I'll gladly watch it.

Secondly.  I didn't know there was a limit.  I have a number of products already in that use this color list and I'd prefer not to have to completely change each product to the extent of removing and adding back 30+ custom fields. 

I would think that there should be a way to just change the limit on this field.
Title: Re: Maxed out custom field - color list
Post by: balai on August 30, 2013, 11:22:20 AM
Hi

The answer is yes there a limit that field has limit of 255 characters

You have 2 options:
1) Go to your database through your phpmyadmin and find the table 'virtuemart_customs ' there go to the table's structure and change the 'custom_value' field from char to varchar and its length from 255 to something higher e.g. 1024

2) To use this plugin: http://breakdesigns.net/extensions/customfields-for-all
It has no limit to the the number of values that can be used and also is suitable for color customfields
Afaik. this is going to be released the next days
Title: Re: Maxed out custom field - color list
Post by: Maxim Pishnyak on August 30, 2013, 17:20:31 PM
Quote from: balai on August 30, 2013, 11:22:20 AM
1) Go to your database through your phpmyadmin and find the table 'virtuemart_customs ' there go to the table's structure and change the 'custom_value' field from char to varchar and its length from 255 to something higher e.g. 1024
Next VM update could 'restore' original custom field limit.
Title: Re: Maxed out custom field - color list
Post by: Kintaro Oe on June 19, 2014, 17:29:57 PM
is there a reason to limit this field to only 255 chars? :(
Title: Re: Maxed out custom field - color list
Post by: GJC Web Design on June 19, 2014, 17:46:28 PM
probably not - it is just a figure - the smaller the figure the less usage of mysql resources -- 255 is a common figure chosen