VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: websmith on January 29, 2016, 04:29:15 AM

Title: Is it possible to make product description hold more characters
Post by: websmith on January 29, 2016, 04:29:15 AM
JM 3.4.8
VM 3.0.12

Ive searched but cant seem to find a way to expand the product description field to hold long descriptions greater than 18k characters. Is this possible? and where would I make the edit?

Thank you
Title: Re: Is it possible to make product description hold more characters
Post by: jjk on January 31, 2016, 14:49:41 PM
Quote from: websmith on January 29, 2016, 04:29:15 AM
JM 3.4.8
VM 3.0.12

Ive searched but cant seem to find a way to expand the product description field to hold long descriptions greater than 18k characters. Is this possible? and where would I make the edit?

You might find useful information if you search for: product_desc 18400
Title: Re: Is it possible to make product description hold more characters
Post by: Studio 42 on February 01, 2016, 22:36:12 PM
DO NOT CHANGE IT !

Virtuemart force on update to use the original limitation, so any char more get removed when you update Virtuemart.
If you need more text, add a product customfield type editor, or if you need more, you can do a simple plugin for this using a new table to store. ( This is a slower solution but have no limit )
Title: Re: Is it possible to make product description hold more characters
Post by: Milbo on February 04, 2016, 20:39:45 PM
This is just wrong Patrick, since many years we have the virtuemart.cfg file to keep configurations, which are important for installation and updates.

Please read here http://docs.virtuemart.net/manual/general-concepts/206-hidden-configurations.html

use dblayoutstrict with false and you get text instead of varchar
Title: Re: Is it possible to make product description hold more characters
Post by: Studio 42 on February 04, 2016, 22:50:57 PM
Hi Max,
In table updater, this revert the changes if you don't pay attention, or not ?
Title: Re: Is it possible to make product description hold more characters
Post by: Milbo on February 04, 2016, 22:55:09 PM
No, the tableupdater reads the values from the config, when there is no config, then from the file.
Title: Re: Is it possible to make product description hold more characters
Post by: Studio 42 on February 04, 2016, 23:08:54 PM
SO the solution for this case is to create a virtuemart.cfg file with only one line
dblayoutstrict=0
If i have understand correctly ?
So the table updater do not update product table on next update with the varchar 18400 for description.
Title: Re: Is it possible to make product description hold more characters
Post by: Milbo on February 05, 2016, 00:09:42 AM
http://docs.virtuemart.net/manual/general-concepts/206-hidden-configurations.html

HOW TO USE A HIDDEN CONFIGURATION PARAMETER?

open the virtuemart.cfg (at /administrator/components/com_virtuemart/virtuemart.cfg)
Preset any value used in VmConfig::get('myvalue','default').
In the example, change the line myvalue=default to myvalue=mydefaultvalue
Save the file
Enter the virtuemart backend:
For VirtueMart 3: store the configuration file once. The configuration file is load first and overwritten by the form and you should keep all settings.
For VirtueMart 2: you must use the button in tools "udpate config by file". Be aware that you loose your settings then.