Author Topic: VM3.0.17.2 MySQL error 1118 after update tables  (Read 1172 times)

0Drax0

  • Beginner
  • *
  • Posts: 2
VM3.0.17.2 MySQL error 1118 after update tables
« on: July 21, 2016, 11:19:51 am »
After update from 3.0.6.2 and while running update tables in the db tool I get the following error:

1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `#__virtuemart_products_nl_nl` CHANGE COLUMN `customtitle` `customtitle` VARCHAR(255) NOT NULL DEFAULT '' AFTER `metakey`

Site seems to be working fine, but I have not tested all functionality in depth yet.


Jumbo!

  • 3rd party VirtueMart Developer
  • Full Member
  • *
  • Posts: 690
  • Full-stack Web Developer
    • www.virtueplanet.com
  • VirtueMart Version: Always latest
Re: VM3.0.17.2 MySQL error 1118 after update tables
« Reply #1 on: July 21, 2016, 12:16:25 pm »
How many products do you have in the site?

0Drax0

  • Beginner
  • *
  • Posts: 2
Re: VM3.0.17.2 MySQL error 1118 after update tables
« Reply #2 on: July 21, 2016, 13:02:31 pm »
1810 products

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10070
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: VM3.0.17.2 MySQL error 1118 after update tables
« Reply #3 on: July 21, 2016, 19:56:12 pm »
It has nothing todo with it. Please use directly the 3.0.17.4 http://dev.virtuemart.net/projects/virtuemart/files and just execute the tool "update tables,..."
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/