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

VM 3.0.7 - unable to save safe path

Started by stawebnice, April 19, 2015, 11:46:59 AM

Previous topic - Next topic

stawebnice

Hi,
When I try to save the safe path
/data/web/virtuals/XXXXX/virtual/www/subdom/czech-offroad/logs/vmfiles/  XXXXX is number

I get this error:
1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `kleu_virtuemart_products_cs_cz` CHANGE COLUMN `product_desc` `product_desc` VARCHAR(18400) NOT NULL DEFAULT '' AFTER `product_s_desc`

http://imtp.me/9dkc02lj3.p

please advise how to fix it

Milbo

Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

stawebnice

Hi Max,

Thanks, it worked perfectly. I added dblayoutstrict=0 to virtuemart.cfg file and then saved the configuration again and all tables were created and fixed and no errors appear now.


d0ublezer0

Ok, How about updates? When i update vm from 3.0.9 to 3.0.12 - seems like "product_desc" field type changed back to varchar (18400)

mojtabasko

Ok, How about updates? When i update vm from 3.0.9 to 3.0.12 - seems like "product_desc" field type changed back to varchar (18400)

GJC Web Design

life is never perfect...  change it back...
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

uhhm, this is a serious error, because it leads to lost data. But I changed only the reading of sql file and the handling updating of the engine. So the file was almost untouched since May 2015. The code is


else if(strpos($name,'desc')!==false) {
if(VmConfig::get('dblayoutstrict',true)){
$fields[$name] = 'varchar('.VmConfig::get('dbdescsize',19000).') '.$linedefault;
} else {
$fields[$name] = 'text '.$linedefaulttext;
}
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Milbo

Please test http://forum.virtuemart.net/index.php?topic=133113.0

- enhanced tableupdater, also correcting missing Primary Keys
- virtumart.cfg parser understands // inline comments
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/