News:

Looking for documentation? Take a look on our wiki

Main Menu

Need to keep this setting after update

Started by tselis, July 01, 2014, 19:34:24 PM

Previous topic - Next topic

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 -
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation


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.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

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.
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