VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: tselis on July 01, 2014, 19:34:24 PM

Title: Need to keep this setting after update
Post by: tselis on July 01, 2014, 19:34:24 PM
hi, any time that i update virtuemart the setting in the photo is changed to VARCHAR so i am losing may data of my site. i need to keep it as LONGTEXT, some applications could change this setting also. i need to do it non changeable.

[attachment cleanup by admin]
Title: Re: Need to keep this setting after update
Post by: GJC Web Design on July 01, 2014, 22:45:24 PM
it will change cos updates normally refresh the tables etc .. sql is sql - if the script runs it will change - there is no lock I know of that will just lock the type.

you need to backup (as u should on every update) - reset to longtext and reimport just that column -
Title: Re: Need to keep this setting after update
Post by: tselis on July 08, 2014, 06:19:25 AM
thank you! ;)
Title: Re: Need to keep this setting after update
Post by: Milbo on July 10, 2014, 19:27:13 PM
ahh no.
First, you really do not need longtext. You could store the Lord of the Rings in it. text is absolutly adequate (you can already store the hobbit in it).

Second, there is an hidden option, which you can set in your virtuemart.cfg file.
dblayoutstrict=1

go to the tools, use "update config by file", be aware that you will lose some config settings, it is then reset to the values of the file.

This process is in enhanced in vm3, there you just enter in the file and store the config, done.
Title: Re: Need to keep this setting after update
Post by: Rikard on October 13, 2017, 15:35:22 PM
I have the same problem, my long description texts are truncated. The strange thing is that one of the languages isn't truncated, only the rest of them are. Anyway, I have updated my "/administrator/components/com_virtuemart/virtuemart.cfg" to dblayoutstrict=0 from (#dblayoutstrict) but my product category texts are still truncated. Is there anything else I need to do?

I'm running joomla 3.8.1 and VM 3.2.4 and php 7.1.10

Thanks,
Title: Re: Need to keep this setting after update
Post by: jenkinhill on October 13, 2017, 16:36:34 PM
That's a 3 year old thread for a much older VM version.

Check if your template is a problem - test with Protostar.