VirtueMart Forum

VirtueMart 2 + 3 + 4 => Product creation => Topic started by: sanchitrasiya on January 28, 2014, 17:45:22 PM

Title: Increase character limit for virtuemart custom field type editor
Post by: sanchitrasiya on January 28, 2014, 17:45:22 PM
Hi,

How can I increase the character count for virtuemart custom field type editor? It does not take more than 8000 characters.

Please let me know.

Thanks
Title: Re: Increase character limit for virtuemart custom field type editor
Post by: sanchitrasiya on January 29, 2014, 08:54:47 AM
Hi,

I found a solution to this. The database table has a limit to characters. So to change this, you would need to alter the database table- <db_prefix>_virtuemart_product_customfields.

Edit the field/column named 'custom_value' and set the limit. By default it is 8000. You may increase it according to your requirements. However, if you are not sure of the maximum length as what to type in, you may change the datatype of this field/column to mediumtext and keep the Length/Values field blank. If I am not wrong, this would automatically adjust the length according to the content.

PS- Not sure about the last statement above.

Hope this helps!

Thanks
sanchit@cctech.co.in
Title: Re: Increase character limit for virtuemart custom field type editor
Post by: ipapaiacovou on October 15, 2014, 12:28:35 PM
How can I access to this table? database table- <db_prefix>_virtuemart_product_customfields
Sorry I am new to joomla
Title: Re: Increase character limit for virtuemart custom field type editor
Post by: sanchitrasiya on October 15, 2014, 12:35:44 PM
You can access it through PhpMyAdmin in cPanel. Login to your PhpMyAdmin & browse for the Joomla database.

You can find your database name & the tables prefix by visiting your Joomla control panel > Site > Global Configuration > Server, under Database Settings.

Hope that helps.

./Sanchit
Title: Re: Increase character limit for virtuemart custom field type editor
Post by: ipapaiacovou on October 18, 2014, 00:03:32 AM
I tried to change it to mediatext but nothing is happening.  I also increased the 8000 but it doesn't save it
Title: Re: Increase character limit for virtuemart custom field type editor
Post by: sanchitrasiya on October 18, 2014, 06:47:01 AM
I am not sure what is going wrong there.

You may post in your Support Query here- http://www.geeksscript.com/requests.html

./Sanchit