VirtueMart Forum

Hello, but there is a limit to add custom fields to a product? you can increase it?

[attachment cleanup by admin]

I have this same problem.  I need to add more custom fields to a product than VM is allowing me to do.  Why is there a limit?  I need this limit removed ASAP.  Please advise when this limit is removed.

if its just a simple "color" dropdown.

You can use my plugin
http://www.kaizenmediaworks.com/virtuemart-2-0-custom-field-dropbox-plugin

It will add many into a single custom

Hi Banquet,

I will take a look at your plugin, but in case it doesn't solve the problem completely, can you remove the limit from the base? 

Thanks,
Chuck

Hi Banquet,

I tried the plugin, but it does not allow me to add price adjustments in the product admin as described on the website with |+5.  What am I doing wrong? 

Also, can the limit to the number of Customs Fields be removed from the base?

Regards,
Chuck

Quote from: cas on February 20, 2013, 04:04:05 AM
Hi Banquet,

I tried the plugin, but it does not allow me to add price adjustments in the product admin as described on the website with |+5.  What am I doing wrong? 

Also, can the limit to the number of Customs Fields be removed from the base?

Regards,
Chuck

Thats the ONLY cart variant custom field I use on my site

Red,Blue|+5,Green,Yellow|+5


what is the limit?

how many? I will tell milbo about this

For the plug-in: In the product admin, in the "Drop Box Selection separated by commas" field, it's not allowing me to type anything into the field to add the "|+5".  It allows me to delete characters, but I cannot type any new characters into that field.  I tried it with Firefox 17.0.2 and IE8.   

In the VM base: why is there any limit to the number of Custom Fields a product can have?  Can the limit be removed all together?  With furniture products, there are lots of fabric and leather choices.

Thanks,
Chuck

Any update on this?

I am not aware of any limit. And your limit cas is a completly different thing than Grisu is talking about.

Hi Milbo,

What limit is Grisu talking about, if not the limit on the number of Custom Fields that can be added to a product? 

I was adding custom fields to a product and when it reached 130 custom fields it would not save the product anymore.   When I add another custom field to the product and press the save button, it exits the product and goes to the main VirtueMart control panel.   Can you help?   

Chuck

Quote from: cas on March 01, 2013, 23:51:54 PM
Hi Milbo,

What limit is Grisu talking about, if not the limit on the number of Custom Fields that can be added to a product? 

I was adding custom fields to a product and when it reached 130 custom fields it would not save the product anymore.   When I add another custom field to the product and press the save button, it exits the product and goes to the main VirtueMart control panel.   Can you help?   

Chuck

is this with ONLY 1 product?


try cloning the product and adding more


also try optimizing the DB

Yes, just one product.   Try adding 130 plus custom fields to one product to see the problem. 

I tried cloning the product and it did not allow adding more Custom Fields to the cloned product.  In fact, for the clone product it got this new error when I tried saving the product: "Invalid Token save"

How should I optimizing the DB? 

Quote from: cas on March 03, 2013, 00:44:41 AM
Yes, just one product.   Try adding 130 plus custom fields to one product to see the problem. 

I tried cloning the product and it did not allow adding more Custom Fields to the cloned product.  In fact, for the clone product it got this new error when I tried saving the product: "Invalid Token save"

How should I optimizing the DB? 

The standard way would be to log into phpmyadmin  and "optimize tables"

I use  akeebah admin toools" 
https://www.akeebabackup.com/products/admin-tools.html

It has a 1 click backend button to do this.

ALSO:

go into extensions manager and check your database
There might be some errors

Hi Banquet,

There are no errors in the extension manager.  I optimized the tables, but it still does not allow adding the 132nd Custom Field to the product. 

The good news is that I was able to get your plug-in to work!  The instructions say to press the product Save button to enable editing, but that didn't enable editing the custom field.  But when I pressed Save & Close, and then reopened the product, it allowed me to edit the custom field. 

So now I have a workaround by using your plug-in, but it would still be good to see why the VM base only allows 131 custom fields per product.  Did anyone on the VM team try to duplicate this problem by adding 132 custom fields to a product?   

Thanks,
Chuck

cas,
the reason I created my plugin is because I do not want to load 130 table rows of custom fields for a product.

I agree.  Your plug-in is the way to go for regular text drop-down fields, so thanks for creating it!  But what do I do when my customer wants to use images for his furniture fabrics and leather selections?  My plan was to enter one product complete with all the 200 plus custom field images and then just clone it for all the other products.   I know I could just create a separate page with all the color choices, and then have the user remember their choice when ordering the product by selecting the color name from a drop-down list, which is how his current VM1 site works, but this is error prone, so I was hoping with VM2 to use the custom field images for a better user experience.  This is why I still need this limit problem solved.   

By the way, in the admin for custom fields, the ordering still does not work. 

Thanks,
Chuck

Quote from: cas on March 04, 2013, 06:02:07 AM
I agree.  Your plug-in is the way to go for regular text drop-down fields, so thanks for creating it!  But what do I do when my customer wants to use images for his furniture fabrics and leather selections?  My plan was to enter one product complete with all the 200 plus custom field images and then just clone it for all the other products.   I know I could just create a separate page with all the color choices, and then have the user remember their choice when ordering the product by selecting the color name from a drop-down list, which is how his current VM1 site works, but this is error prone, so I was hoping with VM2 to use the custom field images for a better user experience.  This is why I still need this limit problem solved.   

By the way, in the admin for custom fields, the ordering still does not work. 

Thanks,
Chuck

ordering of custom fields works for me

In the admin for Product I can change the order of the Custom Fields by dragging & dropping, but in the Custom Fields admin itself, when I try to change the order of the custom fields, it does not save the order for me.   Does that work for you? 

Quote from: cas on March 05, 2013, 01:15:43 AM
In the admin for Product I can change the order of the Custom Fields by dragging & dropping, but in the Custom Fields admin itself, when I try to change the order of the custom fields, it does not save the order for me.   Does that work for you? 

O , no it does not

FYI, here is the link to the custom field admin ordering issue back in Oct 2012:  http://forum.virtuemart.net/index.php?topic=109255

As for this issue with the custom field limit of 131, please let me know when it's resolved so I can finish the website for my customer.  Thanks.

Any update on when this will be fixed?

Banquet,

Does your Drop Box plug-in have a character limit for the Drop Box Selection field?   I am not able to enter all the characters I need to enter.

Chuck 

Hi Banquet,

Any update on this character size limit to the Drop Box plug-in "Drop Box Selections" field?  I can only enter about 10 items in the "Drop Box Selections" field before it reaches a character limit.  My customer is waiting to load all his products and go live with his new site until this size limit is resolved.

Thanks,
Chuck 

Quote from: cas on March 12, 2013, 19:03:41 PM
Hi Banquet,

Any update on this character size limit to the Drop Box plug-in "Drop Box Selections" field?  I can only enter about 10 items in the "Drop Box Selections" field before it reaches a character limit.  My customer is waiting to load all his products and go live with his new site until this size limit is resolved.

Thanks,
Chuck 

look here
http://www.kaizenmediaworks.com/images/files/custom-field.png


do you see all the characters I use?

sounds like a DB problem for you or something.

Here is a real drop down list I need to use on the furniture website for leather choices.  See if you can add this list to one drop box without it getting cut off:

Select, Grade 1-Empire Aloe Vera, Grade 1-Empire Black, Grade 1-Empire Butternut, Grade 1-Empire Chocolate, Grade 1-Empire Clay, Grade 1-Empire Cream, Grade 1-Empire Honey, Grade 1-Empire Plum, Grade 1-Empire Polar, Grade 1-Empire Smoke, Grade 1-Fashion Almond, Grade 1-Fashion Black, Grade 1-Fashion Caramel, Grade 1-Fashion Off White, Grade 1-Fashion Red, Grade 1-Fashion Ripple, Grade 1-Fashion Sandstone, Grade 2-America Brandy |+250.00, Grade 2-America Chianti |+250.00, Grade 2-America Hazelnut |+250.00, Grade 2-America Merlot |+250.00, Grade 2-America Vintage |+250.00, Grade 2-Dream Black |+250.00, Grade 2-Dream Celery |+250.00, Grade 2-Dream Coffee |+250.00, Grade 2-Dream Espresso |+250.00, Grade 2-Dream Iceberg |+250.00, Grade 2-Dream Latte |+250.00, Grade 2-Oxford Blue |+250.00, Grade 2-Dream Oyster |+250.00, Grade 2-Dream Straw |+250.00, Grade 2-Dream White |+250.00, Grade 2-Dream Wine |+250.00, Grade 2-Guanaco Aztec |+250.00, Grade 2-Guanaco Black |+250.00, Grade 2-Guanaco Caramel |+250.00, Grade 2-Guanaco Dark Brown |+250.00, Grade 2-Guanaco Granite |+250.00, Grade 2-Guanaco Grey |+250.00, Grade 2-Guanaco Marmo |+250.00, Grade 2-Guanaco Merlot |+250.00, Grade 2-Guanaco Sangria |+250.00, Grade 2-Guanaco West |+250.00, Grade 2-Navajo Blue |+250.00, Grade 2-Navajo Bordeaux |+250.00, Grade 2-Navajo Butter |+250.00, Grade 2-Navajo Caramel |+250.00, Grade 2-Navajo Dark Brown |+250.00, Grade 2-Navajo Honey |+250.00, Grade 2-Navajo Hunter |+250.00, Grade 2-Navajo Ivory |+250.00, Grade 2-Navajo Mushroom |+250.00, Grade 2-Navajo Onyx |+250.00, Grade 2-Navajo Palomino |+250.00, Grade 2-Navajo Pecan |+250.00, Grade 2-Navajo Strawberry |+250.00, Grade 3-Classico Burlington Ranch |+500.00, Grade 3-Classico Capri Chocolate |+500.00, Grade 3-Classico Capri Harness |+500.00, Grade 3-Classico Longhorn Ranch |+500.00, Grade 3-Durango Bacio |+500.00, Grade 3-Durango Cohiba |+500.00, Grade 3-Durango Mahagony |+500.00, Grade 3-Durango Tobacco |+500.00, Grade 3-Eugene Beige |+500, Grade 3-Eugene Brick |+500, Grade 3-Eugene Charlotte |+500, Grade 3-Eugene Tumble |+500, Grade 3-Europa Coffee |+500.00, Grade 3-Europa Ebony |+500.00, Grade 3-Europa Vanilla |+500.00, Grade 3-Sensations Aubergine |+500.00, Grade 3-Sensations Black |+500.00, Grade 3-Sensations Brandy |+500.00, Grade 3-Sensations Chestnut |+500.00, Grade 3-Sensations Cream |+500.00, Grade 3-Sensations Dark Brown |+500.00, Grade 3-Sensations Espresso |+500.00, Grade 3-Sensations Light Brown |+500.00, Grade 3-Sensations Olive |+500.00, Grade 3-Sensations Red |+500.00, Grade 3-Sensations Saddle |+500.00, Grade 3-Sensations Sky Blue |+500.00, Grade 3-Sensations Tango |+500.00, Grade 3-Sensations Tuscany |+500.00, Grade 3-Softy Bianco |+500.00, Grade 3-Softy Black |+500.00, Grade 3-Softy Brandy |+500.00, Grade 3-Softy Buckskin |+500.00, Grade 3-Softy Chestnut |+500.00, Grade 3-Softy Chocolate |+500.00, Grade 3-Softy Grey |+500.00, Grade 3-Softy Java |+500.00, Grade 3-Softy Mica |+500.00, Grade 3-Softy Mint |+500.00, Grade 3-Softy Red |+500.00, Grade 3-Softy Swiss Coffee |+500.00, Grade 3-Softy Winter White |+500.00, Grade 3-Stardust Copper |+500.00, Grade 3-Stardust Mineral |+500.00, Grade 3-Stardust Mink |+500.00, Grade 3-Stardust Pearl |+500.00, 4-Brighton Bridle |+750.00, Grade 4-Brighton Chocolate |+750.00, Grade 4-Brighton Giacomo |+750.00, Grade 4-Brighton Hero |+750.00, Grade 4-Brighton Honey |+750.00, Grade 4-Brighton Tobassco |+750.00, Grade 4-Impressions Black Sky |+750.00, Grade 4-Impressions Chocolate |+750.00, Grade 4-Impressions Claret |+750.00, Grade 4-Impressions Liquor |+750.00, Grade 4-Impressions Sabbia |+750.00, Grade 4-Impressions Walnut |+750.00, Grade 4-Santa Fe Bazzana Polo |+750.00, Grade 4-Santa Fe Brompton Chocolate |+750.00, Grade 4-Santa Fe Tri-Tone Red Brown |+750.00, Grade 4-Santa Fe Village Antique |+750, Grade 5-Bella Vista Bark |+1000.00, Grade 5-Bella Vista Bench |+1000.00, Grade 5-Bella Vista Black |+1000.00, Grade 5-Bella Vista Ebony |+1000.00, Grade 5-Bella Vista Moss |+1000.00, Grade 5-Bella Vista Sequoia |+1000.00, Grade 5-Bella Vista Slate |+1000.00, Grade 5-Bella Fiore Autumn |+1000.00, Grade 5-Bella Fiore Black |+1000.00, Grade 5-Bella Fiore Briar |+1000.00, Grade 5-Bella Fiore Brownstone |+1000.00, Grade 5-Bella Fiore Buttermilk |+1000.00, Grade 5-Bella Fiore Cranberry |+1000.00, Grade 5-Bella Fiore Earth |+1000.00, Grade 5-Bella Fiore Linen |+1000.00, Grade 5-Bella Fiore Mink |+1000.00, Grade 5-Bella Fiore Sea |+1000.00, Grade 5-Bella Fiore Terracotta |+1000.00, Grade 5-Edinburg Butterscotch |+1000.00, Grade 5-Edinburg Chestnut |+1000.00, Grade 5-Edinburg Loam |+1000.00, Grade 5-Edinburg Loft |+1000.00, Grade 5-Edinburg Red |+1000.00, Grade 5-Edinburg Sandbank |+1000.00, Grade 5-Edinburg Wheat |+1000.00, Grade 5-Edinburg Woodland |+1000.00, Grade 5-Palazzo Brown |+1000.00, Grade 5-Palazzo Caffe |+1000.00, Grade 5-Palazzo Champagne |+1000.00, Grade 5-Palazzo Parquet |+1000.00, Grade 5-Palazzo Walnut |+1000.00, Grade 5-Praire Bison Antelope |+1000.00, Grade 5-Praire Bison Black |+1000.00, Grade 5-Praire Bison Chocolate |+1000.00, Grade 5 Praire Bison Cognac |+1000.00, Grade 5-Praire Bison Creme |+1000.00, Grade 5-Praire Bison Oxbood |+1000.00, Grade 5-Praire Bison Saddle |+1000.00, Grade 5-Praire Bison Tobacco |+1000.00, Grade 5-Rowdy Bison Tan |+1000.00

5300 characters

that field has a max character length of 255

I know the DB can be changed, but when you upgrade, its going to drop the rest of the characters

When I checked the DB table xxx_virtuemart_product_customfields for the field "custom_param", where these attributes are stored, it's defined as varchar(12800), not 255.  That's good news!  So then when I manually pasted all the attributes into the "custom_param" field in the DB, it saves all the attributes just fine, and the website displays all the attributes in the drop down just fine.  Then I went into the product admin and the plug-in Drop Box Selection field now has all the attributes in it, and when I saved the product, the attributes all remained in the DB.   All great news!   So then when I tried to create a new Drop Box attribute, the Drop Box Selection field is still limiting the number of characters.   So can you check the plug-in to see what's limiting the Drop Box Selection field?

cas, I am working on this

this will be fixed. Its in the plugin

Great! Thanks!  Let me know when it's fixed and I'll test it out. 

drop.php

function plgVmOnProductEdit($field, $product, &$row,&$retValue) {
      if ($field->custom_element != $this->_name) return '';
      $this->parseCustomParams($field);
      $html ='
         <fieldset>
            <legend>'. JText::_('VMCUSTOM_DROP_BOX') .'</legend>
            <table class="admintable">
               '.VmHTML::row('input','VMCUSTOM_DROP_STRING_NAME','custom_param['.$row.'][custom_drop_name]',$field->custom_drop_name).'
               '.VmHTML::row('textarea','VMCUSTOM_DROP_STRING','custom_param['.$row.'][custom_drop]',$field->custom_drop).'
            </table>
         </fieldset>';
      $retValue .= $html;

      return true ;
   }


in the 2nd   VmHTML::row
change 'input'
to 'textarea'

[attachment cleanup by admin]

Perfect!  Thanks! 

Pro that works perfect thanks. Not sure if this is happening to anyone else but, when I add it to a product I see a white textarea but not text, the text I had created is underneath the box, To solve this just click save and it will magically appear in the textarea box. It impressed a client LOL

Quote from: Grisu74 on January 23, 2013, 15:26:42 PM
Hello, but there is a limit to add custom fields to a product? you can increase it?

I've solved the problem with customfields limitation. Basically there is limit of 131 customfields, then "Invalid Token save" error is occured.
The reason is maximum variables limitation of a POST request. You can change the php.ini variable "max_input_vars" (it may not be there, just add it). Set it to 2000 (1000 is default) and you could add more.

I also had to make more php.ini changes:

php_admin_value max_input_vars 2000
php_value suhosin.request.max_array_index_length 128
php_value suhosin.post.max_array_index_length 128
php_value suhosin.request.max_vars 2000
php_value suhosin.post.max_vars 2000

   
I have the same problem with a limit. Could you explain more what file to change the settings? where is it located? Thank you

Quote from: AntiCZ on June 06, 2013, 16:28:58 PM
I also had to make more php.ini changes:

php_admin_value max_input_vars 2000
php_value suhosin.request.max_array_index_length 128
php_value suhosin.post.max_array_index_length 128
php_value suhosin.request.max_vars 2000
php_value suhosin.post.max_vars 2000

You can set it in php.ini on the server or in .htaccess or via php funtion ini_set();

Hi Guys

Please which of the php script parameters do i need to append to get this to work.

I am having the same issues.

Please help me, I am stuck

Thanks

Was there any fix to this?

I tried the php.ini additions, didn't work. I tried changing the _virtuemart_product_customfields - customfield_value    varchar(2500)  to varchar(4000)
That did nothing. Not sure if I did that correct.

So any other solution for having more custom fields data? It probably is stopping saving at about 2500 characters. VirtueMart 3.0.18

Thanks

Just update, the new vm3.2 has "text" instead of varchar, so "unlimited" space :-)

Unfortunately the problem still persists in v3.2.2. Saving custom fields just takes me back to dashboard, assuming at about the 2500 character mark.

Anything else I can try, maybe directly on the database to change it? I've tried to pay a few coders but they just wasted my time.

I have just installed VM3.2.3Rev9574  (from SVN) and varchar(4095) is used for custom_value

(https://image.ibb.co/f3mfkv/cust.jpg)

Yep mines the same as below, this under virtuemart_customs

But just won't save. I tried 6095 as well, made no different so maybe this issue isn't the varchar limit?

I'm also up against this as well. I have a custom field with a large number of values and once I add over a certain amount of values (80+) the product simply refuses to save. I've tried all the php.ini / .htaccess suggestions from here and elsewhere. None of them make a difference. I'm working on a full upgrade of a website, but this bug has now completely stalled my progress as I can't make any modifications to the products affected as they simply won't save. This was never an issue in VM1. Can't say I'm a fan of the whole custom fields approach at all. Any help on offer would be appreciated.

 @iskye81 check your server php resources. See   http://forum.virtuemart.net/index.php?topic=126888

Adding this to php.ini didn't fix ot for me

php_admin_value max_input_vars 2000
php_value suhosin.request.max_array_index_length 128
php_value suhosin.post.max_array_index_length 128
php_value suhosin.request.max_vars 2000
php_value suhosin.post.max_vars 2000


Adding these to htaccess doesn't work, results in 500 server error.

php_value upload_max_filesize 64M
php_value post_max_size 96
php_value max_execution_time 180
php_value max_input_time 600
php_value max_input_vars 2000
php_value request.max_array_index_length 128
php_value post.max_array_index_length 128
php_value request.max_vars 2000
php_value post.max_vars 2000

Quote from: jenkinhill on June 08, 2017, 13:01:23 PM
I have just installed VM3.2.3Rev9574  (from SVN) and varchar(4095) is used for custom_value

(https://image.ibb.co/f3mfkv/cust.jpg)

custom_value is not the customfield_value. The custom table holds the prototypes. But we need a lot space for the product customfields.

OK, wrong table.  customfield_value is still varchar(2500) in VM3.2.3.9577 - the latest one I am testing.

(https://image.ibb.co/bzdtxk/custval.jpg)

Or have I got that one wrong?

Quote from: jenkinhill on June 14, 2017, 18:21:07 PM
@iskye81 check your server php resources. See   http://forum.virtuemart.net/index.php?topic=126888

As I already mentioned this doesn't work. I have the same issues as kona333, i.e. adding the lines to php.ini does nothing and adding them to .htaccess results in a server error.

Quote from: jenkinhill on June 15, 2017, 22:45:48 PM
OK, wrong table.  customfield_value is still varchar(2500) in VM3.2.3.9577 - the latest one I am testing.

(https://image.ibb.co/bzdtxk/custval.jpg)

Or have I got that one wrong?

You are right. Yes it must be that way. The customfield_value is mainly used for VALUES, like a size. So it planned to use it as key. At the moment we have just a group by, but also ordering.

But the customfield_params are text now. As I maybe mentioned before, the textfields must be ported to use a param for the content. I could write this within 20 minutes. That is easy. The problem is the Backwardcompatibility.

I could add it next release (vm3.2.5) for a silver http://extensions.virtuemart.net/support/virtuemart-supporter-membership-silver-detail

Does this mean there's no way around this issue at the moment?

Quote from: Milbo on June 23, 2017, 13:09:33 PM
I could add it next release (vm3.2.5) for a silver http://extensions.virtuemart.net/support/virtuemart-supporter-membership-silver-detail