VirtueMart Forum

VirtueMart 2 + 3 + 4 => Product creation => Topic started by: Peguschwein on April 23, 2013, 15:14:20 PM

Title: stockable variants with >100 Variants
Post by: Peguschwein on April 23, 2013, 15:14:20 PM
Hello
I have a Problem with product stockable variants
at about 100 child products I can not save the custom fields
database > jos_virtuemart_product_customfields > custom_param > varchar(12800)    
I think it is the database field length is too short

there is a solution ?

Title: Re: stockable variants with >100 Variants
Post by: annabunting on April 23, 2013, 16:02:46 PM
I have the same problem. Have not found a solution =(
Title: Re: stockable variants with >100 Variants
Post by: balai on April 23, 2013, 16:44:08 PM
Hi

I suppose that it is related to server limitations.
Try to increase the following variables in your  php.ini
post_max_size
memory_limit
Title: Re: stockable variants with >100 Variants
Post by: Peguschwein on April 24, 2013, 08:31:36 AM
I tested again
it must be due to the field length custom_param > varchar(12800)

the string beginn with ~ 50 character and end with ~ 100 character, this results in 12'650 characters
per variants  ~ 125 character results ca 100 variants

I have prducts with
80 Chils = ok
100 child = ok
~ > 100 child = not ok

can the field custom_param > varchar(20'000) expanded

best regaards
Pegu