Need to keep this setting after update

[tselis]

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]

[GJC Web Design]

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 -

[tselis]

thank you!

[Milbo]

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.

[Rikard]

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,

[jenkinhill]

That's a 3 year old thread for a much older VM version.

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