Next VM versions will have the same Default Value limit in Custom Fields?

[Kintaro Oe]

hi,

is there a reason to have a 255 characters limit in the fields "Default" on custom fields?

Next VM versions will free up this limit?

Some infos and request here:
http://forum.virtuemart.net/index.php?topic=102843.0

Regards

p.s. if this is not the request area, where can I post requests?

[Milbo]

the custom_value is customfield_value and is set to "text" by default for vm3

[Milbo]

I just noticed that I did only increased the size of field in the product_customfields, but not the customfields. I set 8k now, like in the product_customfields and in vm3 20k in customs and text in product customfields ( the custom just sets the standard).

if someone needs more, there is a plugin internal table which can be defined by yourself.

[Kintaro Oe]

Thank you Milbo! 

p.s. is there a safe way to increase the size in VM 2.6.x?

[Milbo]

I changed it already, it will be in the next vm2.6.8. But I am not sure when we release it. There are only some minor fixes. Maybe there is a release in 1-2 weeks. If you want it directly, please compensate our time http://extensions.virtuemart.net/support/virtuemart-supporter-membership-detail

[wearewebit]

hi, I am using virtuemart 3.0.12 and I created a custom field. I put text into the editor but unfortunately is cut. how have you resolved? many thanks in advance

[d0ublezer0]

clearly installed vm3

table #_virtuemart_customs


table #_virtuemart_product_customfields

if someone needs more, there is a plugin internal table which can be defined by yourself.

Which plugin do you mean? Where i can find them?
So, if i change field type to text - it is safe for update?

[d0ublezer0]

I changed the table field type to "text"
The new text value  of the custom field (approx 7000 chars) was saved without cropping.
I updated virtuemart from 3.2.0 to 3.2.1, and saw:
AlterTable CHANGE fp1hy_virtuemart_product_customfields.customfield_value
And got the following in the database:
Customfield_value varchar (2500)
Accordingly, the problem of updating is not solved.
What to do?

[Milbo]

The problem appears for people who use the customfield "texteditor"?

I wonder why someone wants to write so much data there. The field is mean for small data, like keywords, tags, attributes, but not whole descriptions. I even would like to downsize it (better for performance). When the problem comes due the textfield, then I should rewrite the textfield to use the params to keep the description. Because the params field is set to text and has "unlimited" space.

[d0ublezer0]

Hi, Milbo!
In most cases, a large field size is required to store characteristics in a table format.
In order to display tabs on the product page:
Description, specs, reviews, etc.
Processing all specification values ​​as separate units is often impossible - they are too different and too many. Our suppliers do not offer structured data for automatic processing.
We have to copy descriptions and characteristics from their sites manually.
All this is because a large slow text field is cheaper than a lot of fast little ones.

[Milbo]

The thing is, I could rewrite the customfield with the editor, to store the text in a param. It would also make more sense for this customfield, actually. for me it was just a string customfield, without any "string logic" (variants and so), but with editor.

[jankoo]

hi.
im not sure if i understand well. you increased the limit for field type textarea but not for editor?
if yes.. why? i need to display long infos about products (specification tables, files for download etc. ) in the custom field editor.. and its always cut.
why we cant do this?

in few stores i changed the limit in the db but its not a real solution as update override it..
please make some update safe solution. increase the editor limit in default. or let us to choose a limit in admin.

im waiting to solve this issue long time..

thanks a lot

[d0ublezer0]

jankoo
I think it's about that a $product contains a huge amount of data
Try to make a var_dump($product) and see what's in it.
If for a detailed page this is not so important, then imagine how large fields will affect the output as a product category?
After that, most people also start screaming about why virtuemart is so slow ...

But, i understand you. And i have same goal and problems, as you..

[Milbo]

Please test vm3.2.3

[jenkinhill]

http://forum.virtuemart.net/index.php?topic=137816.0

http://dev.virtuemart.net/projects/virtuemart/files  for experienced users.

Once VM3.2.4 is finalised that will replace 3.2.2 in the downloads section as the "official" stable version.