News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

Virtuemart 3 Crops Customfield Editor Content [Report BUG ]

Started by The Godfather, March 10, 2016, 23:55:50 PM

Previous topic - Next topic

The Godfather

Hi

I want to have a long description about my product in custom tab, but it only shows a little of the text and causes to destroy custom tab template in product page.

I tried to solve this problem by Database modification but i couldn't( then i restored it to default ) . please see the example:

http://goo.gl/JaUAHQ

please see custom tab. I wanted to copy all the text of description ( توصیف ) to custom tab, but it only shows some of it ( First, I copied exact html code of product to custom field editor, but when i saved it, editor crops most of codes and didn't close most of tag, so i deleted the unused html code which caused template to be scrambled. ( please see: http://www.awesomescreenshot.com/0e05opsua6 )
if you didn't understand what i'm saying because of my bad English, please do the exact thing that I'm saying:
Please do what i'm saying.

Please copy the entire code of description of a long text ( for example my product page ) ,paste it to the editor of custom tab, Now save it.
Now, Please see this customfield which should show your text. ( for example i've got a tab named Custom tab, and when i copied all exact html codes or even a simple long text, all my customtab template fall apart and template does not show well. ) :
if you do the things that i said, you will see the exact issue that i got. I hope that i could tell you what the real problem is.
I test this problem even on another template and another site but this problem still stays on.

VirtueMart 3.0.12
PHP Built On    Linux
Database Version    5.5.31-log
Database Collation    utf8_general_ci
PHP Version    5.6.19
Web Server    Apache
WebServer to PHP Interface    cgi-fcgi
Joomla! Version    Joomla! 3.4.8 Stable [ Ember ] 24-December-2015 19:30 GMT
Joomla! Platform Version    Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
User Agent    Mozilla/5.0 (Windows NT 6.2; WOW64; rv:45.0) Gecko/20100101 Firefox/45.0

can you please help me?
So Much thanks, in advance.

Studio 42

The customfield max char is not so long as the long description. SO if you try to insert a long text this is trimed.
A solution, is to declare 2 time the customfield or more and split the text.

Milbo

or to use the hidden config for a less performant table layout.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

The Godfather

Isn't there anyway to make it like description tab long?
Even if I purchase extra services ( Developing for 0.5 hour ), is it possible to make it alright ?
Thanks

Quoteor to use the hidden config for a less performant table layout.
How is it possible? thanks

jenkinhill

Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

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

The Godfather


Studio 42

Quote from: Milbo on March 11, 2016, 09:44:33 AM
or to use the hidden config for a less performant table layout.
It's not less performant to use Text vs varchar, only when you do an order by a Text field, It's slow.
See here http://nicj.net/mysql-text-vs-varchar-performance/ and don't check old test from 2006 !

The Godfather

Please someone help me fix this problem, Even if I need to purchase something like developing support or anything else. Just please someone do it and tell me how much may i pay to get it done.
Thanks.

Studio 42

The customfield table is "optimized" for most needs.
In your case, change the varchar customfield_value column to text type in mysql and you can then use longer strings.
Else use my other solution. Add multiple customfields and split your text.

The Godfather

QuoteIn your case, change the varchar customfield_value column to text type in mysql and you can then use longer strings.
You're the best, man.
So much thanks. I almost was being killed because of heart attack that this problem caused ...

Changing datatype of customfield_value doesn't make any trouble later?

The Godfather

For anyone who want to do the same i did:
Go to phpmyadmin>sql> enter this:

alter table (Your DB Prefix)_virtuemart_product_customfields
modify column customfield_value text not null;

Milbo

This will be reset when you do your next update, this is not an update safe solution. You must use the config!
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Studio 42

The Godfather
the setting is dblayoutstrict.
you need to add in file virtuemart.cfg a line
dblayoutstrict=0
else you loose your changes, next time

Max,
Why you don't use text but var_char, have you do some speed test about  this ?

Milbo

Patrick, nice post
http://nicj.net/mysql-text-vs-varchar-performance/

So I have to reconsider the use of varchar, seems if there "too many" entries, then system becomes slow.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Studio 42

It seems that more the database grow, better is to use text.
The only problem is when you need to use order by.