Author Topic: limit to add custom fields  (Read 18031 times)

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9937
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: limit to add custom fields
« Reply #45 on: June 15, 2017, 18:26:20 pm »
I have just installed VM3.2.3Rev9574  (from SVN) and varchar(4095) is used for custom_value



custom_value is not the customfield_value. The custom table holds the prototypes. But we need a lot space for the product customfields.
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: 27530
  • Always on vacation
    • Jenkin Hill Internet
Re: limit to add custom fields
« Reply #46 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.



Or have I got that one wrong?
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

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

Currently using VM 3.6.3.10163 on Joomla 3.9.12 PHP 7.0.33

iskye81

  • Beginner
  • *
  • Posts: 26
Re: limit to add custom fields
« Reply #47 on: June 22, 2017, 13:59:03 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.

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9937
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: limit to add custom fields
« Reply #48 on: June 23, 2017, 13:09:33 pm »
OK, wrong table.  customfield_value is still varchar(2500) in VM3.2.3.9577 - the latest one I am testing.



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
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

iskye81

  • Beginner
  • *
  • Posts: 26
Re: limit to add custom fields
« Reply #49 on: June 27, 2017, 14:38:40 pm »
Does this mean there's no way around this issue at the moment?

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 27530
  • Always on vacation
    • Jenkin Hill Internet
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

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

Currently using VM 3.6.3.10163 on Joomla 3.9.12 PHP 7.0.33