Author Topic: Next VM versions will have the same Default Value limit in Custom Fields?  (Read 3430 times)

Kintaro Oe

  • Beginner
  • *
  • Posts: 14
  • VirtueMart Version: 2.6
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

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9372
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
the custom_value is customfield_value and is set to "text" by default for vm3
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9372
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
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.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Kintaro Oe

  • Beginner
  • *
  • Posts: 14
  • VirtueMart Version: 2.6
Thank you Milbo!  :)

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

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9372
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
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
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

wearewebit

  • Beginner
  • *
  • Posts: 18
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

  • Jr. Member
  • **
  • Posts: 133
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

  • Jr. Member
  • **
  • Posts: 133
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

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9372
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
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.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

d0ublezer0

  • Jr. Member
  • **
  • Posts: 133
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

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9372
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
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.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

jankoo

  • Beginner
  • *
  • Posts: 40
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

  • Jr. Member
  • **
  • Posts: 133
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

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9372
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Please test vm3.2.3
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 26357
  • Always on vacation
    • Jenkin Hill Internet
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.
Kelvyn

Jenkin Hill Internet,
Keswick, Lake District

Unsolicited PMs/emails will be ignored.

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Currently using VM3.2.4 on Joomla 3.8.1 PHP 7.0.23

Testing VM3.2.5 on J!3.8.1