VirtueMart Forum

VirtueMart 2 + 3 => Virtuemart Development and bug reports => Topic started by: stawebnice on April 19, 2015, 11:46:59 am

Title: VM 3.0.7 - unable to save safe path
Post by: stawebnice on April 19, 2015, 11:46:59 am
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
Title: Re: VM 3.0.7 - unable to save safe path
Post by: Milbo on April 19, 2015, 13:16:44 pm
http://forum.virtuemart.net/index.php?topic=128956.0

and dblayoutstrict=0
Title: Re: VM 3.0.7 - unable to save safe path
Post by: stawebnice on April 19, 2015, 21:33:12 pm
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.

Title: Re: VM 3.0.7 - unable to save safe path
Post by: d0ublezer0 on January 26, 2016, 19:20:35 pm
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)
Title: Re: VM 3.0.7 - unable to save safe path
Post by: mojtabasko on January 28, 2016, 14:50:45 pm
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)
Title: Re: VM 3.0.7 - unable to save safe path
Post by: GJC Web Design on January 29, 2016, 11:06:43 am
life is never perfect...  change it back...
Title: Re: VM 3.0.7 - unable to save safe path
Post by: Milbo on February 05, 2016, 00:40:24 am
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

Code: [Select]
else if(strpos($name,'desc')!==false) {
if(VmConfig::get('dblayoutstrict',true)){
$fields[$name] = 'varchar('.VmConfig::get('dbdescsize',19000).') '.$linedefault;
} else {
$fields[$name] = 'text '.$linedefaulttext;
}
Title: Re: VM 3.0.7 - unable to save safe path
Post by: Milbo on February 10, 2016, 00:15:56 am
Please test http://forum.virtuemart.net/index.php?topic=133113.0

- enhanced tableupdater, also correcting missing Primary Keys
- virtumart.cfg parser understands // inline comments