Author Topic: VM 3.0.7 - unable to save safe path  (Read 2057 times)

stawebnice

  • Jr. Member
  • **
  • Posts: 234
  • What does not kill you, makes you stronger...
    • StaWEBnice - www stránky, seo optimalizace a copywriting
  • Skype Name: peta_ze_sklepa
  • VirtueMart Version: 3.2.14
VM 3.0.7 - unable to save safe path
« 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

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9853
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: VM 3.0.7 - unable to save safe path
« Reply #1 on: April 19, 2015, 13:16:44 pm »
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

stawebnice

  • Jr. Member
  • **
  • Posts: 234
  • What does not kill you, makes you stronger...
    • StaWEBnice - www stránky, seo optimalizace a copywriting
  • Skype Name: peta_ze_sklepa
  • VirtueMart Version: 3.2.14
Re: VM 3.0.7 - unable to save safe path
« Reply #2 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.


d0ublezer0

  • Jr. Member
  • **
  • Posts: 191
Re: VM 3.0.7 - unable to save safe path
« Reply #3 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)

mojtabasko

  • Beginner
  • *
  • Posts: 1
  • A beginner
    • لوازم جانبی موبایل
Re: VM 3.0.7 - unable to save safe path
« Reply #4 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)

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 8936
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.4.2
Re: VM 3.0.7 - unable to save safe path
« Reply #5 on: January 29, 2016, 11:06:43 am »
life is never perfect...  change it back...
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 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
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9853
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: VM 3.0.7 - unable to save safe path
« Reply #6 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;
}
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9853
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: VM 3.0.7 - unable to save safe path
« Reply #7 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
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/